Issues with jQuery Dialog Widget


I have been working with this jQuery Dialog widget for few days and just this morning got stuck into some weird issues. It look very long time to solve and thus I thought I can share those experience with you guys:

My problem was, I wanted to have a jQuery modal dialog form in my aspx page which will help me add some data. So, I took the first step by going to jQuery site and grabbing the source for jQuery modal form with css and javascript given in their site.

http://jqueryui.com/dialog/#modal-form

Now, first thing you’ll notice that their code has a form tag inside the dialog div, which surely you don’t want since you already have a form tag. So, I have removed it.

When I tried the code first the dialog opened after click of a button but no… the page posted back suddenly!

so, when you click the button to open your jquery modal dialog form, the page posted back right after opening the form. It’s because they have used a button inside their code!

<button id=”create-user”>Create new user</button>

//JavaScript

$(“#create-user”)
.button()
.click(function () {
$(“#mydialog”).dialog(“open”);
});

They have failed to notice that if this is used in ASPX page then the page will post back. There is few solution, one of which is to add a ‘return false;’ in the above function, like:

$(“#create-user”)
.button()
.click(function () {
$(“#mydialog”).dialog(“open”);
return false;
});

Or, you can change the button to a input type button, i.e. simple HTML button.

First problem solved.

Next one came right after: I wanted to submit the modal form but it was not working. No matter what I do my jquery modal form is not getting submitted. I have added a ASPX button which is also not getting posted back. I have added a HTML input type submit which has cause similar output.

So, I have tried to post the form back in the following way:

//Try 1

$(“#myForm”).submit();

//try 2

document.getElementById(“myForm”).submit();

//try 3

$(“form:first”).submit();

//try 4

$(“form[name=’myForm’]”).submit();

Aha! Now the form is getting submitted but … not the values! In my modal jquery form I have few ASPX fields like textbox, check box, hidden element all of whose values are showing as blank string in the PostBack.

This was really a nightmare to me. I had no clue why this is not getting posted back. After googling a lot I came around a solution which  told me the cause: “When you use jQuery UI’s Dialog plugin to bring up a div as a dialog, it usually pulls the div out of the form to do this and then ASP.Net elements don’t work” says Ken (http://www.keysolutions.com/blogs/kenyee.nsf/d6plinks/KKYE-7XPVS6)

Then I have tried the solution he gave, i.e. to append the dialog to the form through JavaScript.

//Either you need to call this

$(“#mydialog”).parent().appendTo($(“#myForm”));

//Or you can have it in the dialog.open method

$(“#mydialog”).dialog({
bgiframe: true,
autoOpen: false,
height: 400,
width: 350,
modal: true,

open: function (type, data) {
$(this).parent().appendTo($(“#myForm”));
},
close: function () {
allFields.val(“”).removeClass(“ui-state-error”);
}
});

Note: Watch out for the following function:

close: function () {
allFields.val(“”).removeClass(“ui-state-error”);
}

If you call the close function before submit then you’ll not see any values in the post back because they will get wiped up when allFields.val(“”) is called. So, you need be wise when calling this close method.

when I have tried this my jquery modal form was showing up properly and I was also able to submit it with values. But unfortunately I came to another bummer!

Strangely my jquery dialog form was opening up but it was getting show under the overlay. Yes, you read it correct. The dialog was opening beneath the masked overlay. So, there was no way to control it with normal jQuery dialog. You just have to use tab to navigate through elements and submit. TAB, ESC keys were working but not the mouse controller!

I clearly understood that the issue is with the CSS z-index property. Somehow, my jquery modal form’s z-index was lower than the masked overlay and I have to increase the z-index to bring it to front.

So I have added  a inline CSS to my DIV containing the dialog like below:

<div id=”mydialog” title=”My Dialog” style=”z-index: 99999″>

But, this didn’t work. I have used IE developer tools and found that the parent of this dialog is still not having a greater z-index. So I have used the following and it did work. I had to change the open function for the dialog:

$(“#mydialog”).dialog({

bgiframe: true,

autoOpen: false,

height: 400,

width: 350,

modal: true,

open: function (type, data) {

$(this).parent().appendTo($(“#myForm”));

$(this).parent().css(‘z-index’, ‘999999’); //Increase the z-index here

},

close: function () {

allFields.val(“”).removeClass(“ui-state-error”);

}

});

Hopefully this post will help someone in need and save some time 🙂

<div id=”mydialog” title=”Create a new Role” style=”z-index: 99999″>

Advertisements

Save and retrieve files into Oracle database through C# asp.net


First create the table:

CREATE TABLE “TBL_FILES”
( “FILE_ID” NUMBER(10,0) NOT NULL PRIMARY KEY,
“FILE_NAME” VARCHAR2(255 BYTE) NOT NULL,
“FILE_TYPE” VARCHAR2(255 BYTE) NOT NULL,
“FILE_LENGTH” VARCHAR2(50 BYTE) NOT NULL,
“FL_CONTENT_TYPE” VARCHAR2(1000 BYTE) NOT NULL,
“FILE_DATA” BLOB
)

Now, code to load / save files into this table:

Assuming you know how to create File input types in your page and get into the Post Back method, following is how I used to save the files:

if (null != Request.Files && Request.Files.Count > 0)
{
string[] _uploadedFiles = new string[Request.Files.Count];

HttpFileCollection fileCollection = Request.Files;

for (int i = 0; i < fileCollection.Count; i++)
{
HttpPostedFile uploadfile = fileCollection[i];

string fileName = Path.GetFileName(uploadfile.FileName);

//Valiation on Content type

if (string.IsNullOrEmpty(uploadfile.FileName))
continue;

if (false == FileUtilities.isValidExtention(uploadfile.FileName.Substring(uploadfile.FileName.IndexOf(‘.’))))
{ ErrorMessage.Text = “Invalid extension”; return; }

string _mimetype = FileUtilities.getMimeFromFile(uploadfile);

if (false == FileUtilities.isValidMimeType(_mimetype))
{ ErrorMessage.Text = “Invalid File Type”; return; }

//Validation on Length

if (uploadfile.ContentLength > 1048576)
{
ErrorMessage.Text = String.Format(“File size {0} KB exceeds mamximum limit 1 MB (1024 KB)”,
uploadfile.ContentLength / 1024); return;
}

if (uploadfile.ContentLength > 0)
{
string _path = Server.MapPath(“~/UploadFiles/”) + fileName;
uploadfile.SaveAs(_path);

clsFile _objFile = new clsFile();

_objFile.FileName = fileName;
_objFile.FileType = uploadfile.FileName.Substring(uploadfile.FileName.IndexOf(‘.’) + 1);
_objFile.FileServerPath = _path;
_objFile.FileLength = Convert.ToString(uploadfile.ContentLength);
_objFile.FileMimeType = _mimetype;

SaveFile(_objFile);
}

uploadfile.InputStream.Close();
uploadfile = null;
}
}

Here is the clsFile class:

public class clsFile
{
public int FileId { get; set; }
public string FileName { get; set; }
public string FileType { get; set; }
public string FileLength { get; set; }
public string FileMimeType { get; set; }
public string FileServerPath { get; set; }
}

Notice that I am not reading the file content and adding into the clsFile object which was created.

Following are the methods from FileUtilities  class:

[DllImport(“urlmon.dll”, CharSet = CharSet.Unicode, ExactSpelling = true, SetLastError = false)]
static extern int FindMimeFromData(IntPtr pBC,
[MarshalAs(UnmanagedType.LPWStr)] string pwzUrl,
[MarshalAs(UnmanagedType.LPArray, ArraySubType = UnmanagedType.I1, SizeParamIndex = 3)] byte[] pBuffer,
int cbSize,
[MarshalAs(UnmanagedType.LPWStr)] string pwzMimeProposed,
int dwMimeFlags, out IntPtr ppwzMimeOut, int dwReserved);

public static string getMimeFromFile(HttpPostedFile file)
{
IntPtr mimeout;

int MaxContent = (int)file.ContentLength;
if (MaxContent > 4096) MaxContent = 4096;

byte[] buf = new byte[MaxContent];
file.InputStream.Read(buf, 0, MaxContent);
int result = FindMimeFromData(IntPtr.Zero, file.FileName, buf, MaxContent, null, 0, out mimeout, 0);

if (result != 0)
{
Marshal.FreeCoTaskMem(mimeout);
return “”;
}

string mime = Marshal.PtrToStringUni(mimeout);
Marshal.FreeCoTaskMem(mimeout);

return mime.ToLower();
}

//Method to check if the Extension of the uploaded file is valid based on my requirement

//We will do Mime Type checking as well to make it more secured.

public static bool isValidExtention(string _etnx)
{
string[] acceptedExtensions = new string[] { “.docx”, “.doc”, “.txt”, “rtf”, “.pdf”, “.msg” };
return (acceptedExtensions.Contains(_etnx.ToLower())) ? true : false; ;
}

//Method to check if the Mime types of the uploaded file is valid based on my requirement

public static bool isValidMimeType(string _mimetype)
{
string[] acceptedExtensions = new string[] { “text/rtf”,
“application/doc”,
“appl/text”,
“application/vnd.msword”,
“application/vnd.ms-word”,
“application/winword”,
“application/word”,
“application/msword”,
“application/x-msw6”,
“application/x-msword”,
“application/pdf”,
“application/x-pdf”,
“application/vnd.openxmlformats-officedocument.wordprocessingml.document”,
“application/vnd.openxmlformats-officedocument.wordprocessingml.template”,
“application/vnd.openxmlformats-officedocument.wordprocessingml.document”,
“application/octet-stream”,
“text/plain”,
“application/vnd.ms-outlook”};

return (acceptedExtensions.Contains(_mimetype.ToLower())) ? true : false;
}

//Method to read file content

public static byte[] ReadFile(string sPath)
{
//Initialize byte array with a null value initially.
byte[] data = null;

//Use FileInfo object to get file size.
FileInfo fInfo = new FileInfo(sPath);
long numBytes = fInfo.Length;

//Open FileStream to read file
FileStream fStream = new FileStream(sPath, FileMode.Open, FileAccess.Read);

//Use BinaryReader to read file stream into byte array.
BinaryReader br = new BinaryReader(fStream);

//When you use BinaryReader, you need to supply number of bytes to read from file.
//In this case we want to read entire file. So supplying total number of bytes.
data = br.ReadBytes((int)numBytes);

br.Close();
fStream.Close();

return data;
}

By this time all your files are uploaded in the server. It’s time to put them into database.

public void SaveFile(clsFile _attach)
{

try
{
FileInfo _fI = new FileInfo(_attach.FileServerPath);

if (_fI.Exists)
{

//Add details in Parameter collection
#region Param
OracleParameter _param;
ArrayList _paramList = new ArrayList();

_param = new OracleParameter(“PARAM_FILENAME”, OracleType.VarChar);
_param.Value = _attach.FileName;
_paramList.Add(_param);

_param = null;
_param = new OracleParameter(“PARAM_FILETYPE”, OracleType.VarChar);
_param.Value = _attach.FileType;
_paramList.Add(_param);

_param = null;
_param = new OracleParameter(“PARAM_FILELENGTH”, OracleType.VarChar);
_param.Value = Convert.ToString(_attach.FileLength);
_paramList.Add(_param);

_param = null;
_param = new OracleParameter(“PARAM_FL_CT_TYPE”, OracleType.VarChar);
_param.Value = _attach.FileMimeType;
_paramList.Add(_param);

byte[] blob = FileUtilities.ReadFile(_attach.FileServerPath);
_param = null;
_param = new OracleParameter(“PARAM_FILE_DATA”, OracleType.Blob);
_param.Value = blob;
_paramList.Add(_param);

_param = null;
_param = new OracleParameter(“v_result”, OracleType.Number);
_param.Value = DBNull.Value;
_param.Direction = ParameterDirection.Output;
_paramList.Add(_param);

_param = null;
_param = new OracleParameter(“v_error_details”, OracleType.VarChar);
_param.Value = DBNull.Value;
_param.Size = 1000;
_param.Direction = ParameterDirection.Output;
_paramList.Add(_param);

#endregion

//I hope you already have a Data handling class to communicate with Oracle database. 

//OracleDBUtil.CallStoredProcedureWithOutput is my procedure which takes 2 argument, 1st the procedure name

//and 2nd the parameter list

//It will return an array list of output parameters so that we can check the value later to determine successful save

object _retObj = OracleDBUtil.CallStoredProcedureWithOutput(“PROC_SAVE_FILE”, _paramList);

int _result = -1;
string _resultDetails = “”;

if (_retObj.GetType().Equals(typeof(ArrayList)))
{
foreach (object _obj in ((ArrayList)_retObj))
{
if (_obj.GetType().Equals(typeof(OracleParameter)))
{
OracleParameter _oraParam = (OracleParameter)_obj;

if (_oraParam.ParameterName.Equals(“v_result”))
{
_result = Convert.ToInt32(_oraParam.Value);

}
else if (_oraParam.ParameterName.Equals(“v_error_details”))
{
_resultDetails = Convert.ToString(_oraParam.Value);
}
}
}
}
else
{
throw new Exception(“Return list not proper type : ” + Convert.ToString(_retObj.GetType()));
}

if (_result != 1)
throw new Exception(“Exception while saving: ” + _resultDetails);
}
}
catch (Exception _exp)
{
throw _exp;
}

}

So we are all set in C# part. Following is my Oracle Stored procedure to do the saving of the given file in database table:

CREATE OR REPLACE PROCEDURE “PROC_SAVE_FILE”
(
PARAM_FILENAME VARCHAR2,
PARAM_FILETYPE VARCHAR2,
PARAM_FILELENGTH VARCHAR2,
PARAM_FL_CT_TYPE VARCHAR2,
PARAM_FILE_DATA BLOB,
v_result OUT NUMBER,
v_error_details OUT varchar2
) IS

BEGIN

INSERT INTO TBL_FILES
(
FILE_ID,
FILE_NAME,
FILE_TYPE,
FILE_LENGTH,
FL_CONTENT_TYPE,
FILE_DATA
)
VALUES
(
seq_file_id.nextval,
PARAM_FILENAME,
PARAM_FILETYPE,
PARAM_FILELENGTH,
PARAM_FL_CT_TYPE,
PARAM_FILE_DATA
);

v_result:=1;
EXCEPTION

WHEN OTHERS THEN
v_result:=-1;
v_error_details:= SQLERRM;

END PROC_SAVE_FILE;

/

Now, we have saved the files successfully. You might want to retrieve file from Oracle database also. For this please follow this:

public void GetFilesFromDatabase(int _id)
{
try
{

//Here I assume that you already have a method which returns a datatable after executing a query in the database.

//OracleDBUtil.GetDataTableFromQuery is such a method which I have in my project
DataTable _d = OracleDBUtil.GetDataTableFromQuery( String.Format(@”SELECT * FROM TBL_FILES WHERE FILE_ID = {0}”, _id));

if (null != _d && _d.Rows.Count == 1)
{
Response.Clear();
Response.Buffer = true;
string strFileToSave = Convert.ToString(_d.Rows[0][“FILE_NAME”]);//Convert.ToBase64String
byte[] FileData = (byte[])(_d.Rows[0][“FILE_DATA”]);

Response.ContentType = Convert.ToString(_d.Rows[0][“FL_CONTENT_TYPE”]);
Response.AddHeader(“content-disposition”,
String.Format(“attachment;filename={0}”, strFileToSave));

Response.Charset = “”;
Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.BinaryWrite(FileData);

Response.End();
}
else
{
Response.Write(“File Not found”);
}
}
catch (Exception ex)
{
Response.Write(ex.StackTrace);
}
}

I hope you’ll be now able to do it on your own. Let me know if any help is needed 🙂