/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void ClearUI()
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
int returnValue = DBFun.ExecuteData("DELETE FROM TempImage WHERE Type = 'Employee' AND EmpID='" + txtEmpNationalID.Text + "'");
txtEmpIdentity.Text = "";
txtEmpNameAr.Text = "";
txtEmpNameEn.Text = "";
txtJobTitleAr.Text = "";
txtJobTitleEn.Text = "";
txtEmpNationalID.Text = "";
txtMobile.Text = "";
txtEmail.Text = "";
CalBirthDate.ClearDate();
CalHireDate.ClearDate();
ddlNatID.SelectedIndex = -1;
ddlBloodGroup.SelectedIndex = -1;
ddlCompID.SelectedIndex = -1;
ddlSecID.SelectedIndex = -1;
rdlGender.SelectedIndex = 0;
EmpImage.ClearImage();
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void ClearUI()
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
int returnValue = DBFun.ExecuteData("DELETE FROM TempImage WHERE Type = 'Visitors' AND EmpID='" + txtVisIdentityNo.Text + "'");
txtVisCardID.Text = "";
txtVisIdentityNo.Text = "";
txtVisNameAr.Text = "";
txtVisNameEn.Text = "";
txtVisMobileNo.Text = "";
calStartDate.ClearDate();
calExpiryDate.ClearDate();
for (int i = 1; i < 10; i++)
{
chkbRegion.Items.FindByValue("Region" + i.ToString()).Selected = false;
}
txtDescription.Text = "";
ddlTmpID.SelectedIndex = -1;
VisImage.ClearImage();
divCardCount.Visible = false;
txtVisIdentityNo.Enabled = false;
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void GetImage(out byte[] pImage, out string pImageContentType, out int pImageLength)
{
pImage = new Byte[0];
pImageContentType = "";
pImageLength = 0;
string fileName = FindID() + ".jpeg";
string path = Server.MapPath(FindTempImagePath()) + fileName;
bool available = System.IO.File.Exists(path);
try
{
dt = DBFun.FetchData("SELECT * FROM TempImage WHERE Type = '" + Type + "' AND EmpID='" + FindID() + "'");
if (DBFun.IsNullOrEmpty(dt))
{
if (available)
{
try
{
int len = System.IO.Path.GetFullPath(path).Length;
byte[] imageData = new Byte[100000];
System.IO.FileStream newFile = new System.IO.FileStream(path, System.IO.FileMode.Open);
newFile.Read(imageData, 0, imageData.Length);
pImage = (byte[])imageData;
pImageContentType = "image/pjpeg";
pImageLength = imageData.Length;
}
catch (Exception e1) { System.IO.File.Delete(path); }
}
else
{
DataTable imgdt = DBFun.FetchData(FindQuery());
if (!DBFun.IsNullOrEmpty(imgdt))
{
if (!IsEncryption)
{
pImage = (Byte[])imgdt.Rows[0]["Image"];
}
else
{
pImage = CryptoImage.DecryptBytes((Byte[])imgdt.Rows[0]["Image"]);
}
pImageContentType = imgdt.Rows[0]["ImageType"].ToString();
pImageLength = Convert.ToInt32(imgdt.Rows[0]["ImageLen"]);
}
}
}
else
{
pImage = (Byte[])dt.Rows[0]["photo"];
pImageContentType = dt.Rows[0]["PhotoType"].ToString();
pImageLength = Convert.ToInt32(dt.Rows[0]["PhotoLength"]);
}
int returnValue = DBFun.ExecuteData("DELETE FROM TempImage WHERE Type = '" + Type + "' AND EmpID='" + FindID() + "'");
}
catch (Exception e2)
{
int returnValue = DBFun.ExecuteData("DELETE FROM TempImage WHERE Type = '" + Type + "' AND EmpID='" + FindID() + "'");
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void ClearImage()
{
int returnValue = DBFun.ExecuteData("DELETE FROM TempImage WHERE Type = '" + Type + "' AND EmpID='" + FindID() + "'");
imgPhoto.ImageUrl = EmptyImage();
}
