/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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();
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Page_Load(object sender, EventArgs e)
{
try
{
//---Common Code ----------------------------------------------------------------- //
FormSession.FillSession("Employees", pageDiv);
//---Common Code ----------------------------------------------------------------- //
if (!IsPostBack)
{
pnlMain.Attributes.Add("onkeypress", "javascript:return DefaultButton(event,'" + btnIDSearch.ClientID + "');");
if (!FormSession.getPerm(new string[] { "IMng", "UMng", "IEmp", "UEmp", "ICon", "UCon" }))
{
Response.Redirect(@"~/Login.aspx");
}
if (Request.QueryString["ac"] != null)
{
string ac = Request.QueryString["ac"].ToString();
ViewState["ac"] = ac;
if (ac == "View")
{
//if (!FormSession.getPerm("UMng")) { btnSave.Enabled = false; btnIDSearch.Enabled = false; }
string iEmpID = Request.QueryString["EmpID"].ToString();
divContract.Visible = true;
divSection.Visible = true;
DataItemEnabled(false);
Fillddl();
btnIDSearch.Enabled = btnUploadDoc.Enabled = false;
if (Request.QueryString["EmpID"] != null)
{
DataTable EmpDT = DBFun.FetchData("SELECT * FROM EmployeeMaster WHERE EmpID = '" + iEmpID + "' ");
FillGrdDocs(EmpDT.Rows[0]["EmpNationalID"].ToString());
if (!DBFun.IsNullOrEmpty(EmpDT))
{
ddlEmpType.SelectedIndex = ddlEmpType.Items.IndexOf(ddlEmpType.Items.FindByValue(EmpDT.Rows[0]["EmpType"].ToString()));
FillFromDT(EmpDT);
}
}
}
}
}
if (IsPostBack)
{
EmpImage.PopulateImage(txtEmpNationalID.Text);
}
}
catch (Exception e1) { DBFun.InsertError(FormSession.PageName, "PageLoad"); }
}
protected void fileUpload()
{
if (EmpImage.HasFile)
{
_image = Path.GetFileName(EmpImage.FileName);
string path = Path.Combine(Server.MapPath("~/Images/"), _image);;
try
{
EmpImage.SaveAs(path);
}
catch
{
throw new Exception();
}
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void DataItemEnabled(bool status)
{
txtEmpIdentity.Enabled = status;
txtEmpNameAr.Enabled = status;
txtEmpNameEn.Enabled = status;
ddlNatID.Enabled = status;
CalBirthDate.setEnabled(status);
txtEmpNationalID.Enabled = status;
txtJobTitleAr.Enabled = status;
txtJobTitleEn.Enabled = status;
ddlBloodGroup.Enabled = status;
ddlCompID.Enabled = status;
ddlSecID.Enabled = status;
CalHireDate.setEnabled(status);
rdlGender.Enabled = status;
txtMobile.Enabled = status;
txtEmail.Enabled = status;
EmpImage.EnabledImage(status);
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void FillFromDT(DataTable DT)
{
txtEmpIdentity.Text = DT.Rows[0]["EmpID"].ToString();
txtEmpNameAr.Text = DT.Rows[0]["EmpNameAr"].ToString();
txtEmpNameEn.Text = DT.Rows[0]["EmpNameEn"].ToString();
txtJobTitleAr.Text = DT.Rows[0]["EmpJobTitleAr"].ToString();
txtJobTitleEn.Text = DT.Rows[0]["EmpJobTitleEn"].ToString();
txtEmpNationalID.Text = DT.Rows[0]["EmpNationalID"].ToString();
txtMobile.Text = DT.Rows[0]["EmpMobileNo"].ToString();
txtEmail.Text = DT.Rows[0]["EmpEmailID"].ToString();
CalBirthDate.setDBDate(DT.Rows[0]["EmpBirthDate"], "S");
CalHireDate.setDBDate(DT.Rows[0]["EmpHireDate"], "S");
ddlNatID.SelectedIndex = ddlNatID.Items.IndexOf(ddlNatID.Items.FindByValue(DT.Rows[0]["NatID"].ToString()));
ddlBloodGroup.SelectedIndex = ddlBloodGroup.Items.IndexOf(ddlBloodGroup.Items.FindByValue(DT.Rows[0]["EmpBloodGroup"].ToString()));
if (DT.Rows[0]["CompID"] != DBNull.Value)
{
ddlCompID.SelectedIndex = ddlCompID.Items.IndexOf(ddlCompID.Items.FindByValue(DT.Rows[0]["CompID"].ToString()));
}
if (DT.Rows[0]["SecID"] != DBNull.Value)
{
ddlSecID.SelectedIndex = ddlSecID.Items.IndexOf(ddlSecID.Items.FindByValue(DT.Rows[0]["SecID"].ToString()));
}
if (DT.Rows[0]["EmpGender"] != DBNull.Value)
{
rdlGender.SelectedIndex = rdlGender.Items.IndexOf(rdlGender.Items.FindByValue(DT.Rows[0]["EmpGender"].ToString()));
}
if ((DT.Rows[0]["image"] == DBNull.Value) || (DT.Rows[0]["ImageLength"].ToString() == "0"))
{
EmpImage.ClearImage();
}
else
{
EmpImage.setImage(DT.Rows[0]["EmpNationalID"].ToString());
}
FillGrdDocs(txtEmpNationalID.Text);
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
ValidatorCollection ValidatorColl = Page.Validators;
for (int k = 0; k < ValidatorColl.Count; k++)
{
if (!ValidatorColl[k].IsValid && !String.IsNullOrEmpty(ValidatorColl[k].ErrorMessage))
{
vsSave.ShowSummary = true; return;
}
vsSave.ShowSummary = false;
}
return;
}
try
{
if ((btnSave.Text == "Save") || (btnSave.Text == "حفظ"))
{
if (ddlEmpType.SelectedValue == "Emp" || ddlEmpType.SelectedValue == "Con")
{
txtIDSearch.Text = txtEmpIdentity.Text = FindMaxID();
}
dt = DBFun.FetchData("select EmpID from EmployeeMaster where EmpID = '" + txtEmpIdentity.Text.Trim() + "'");
if (!DBFun.IsNullOrEmpty(dt))
{
MessageFun.ShowMsg(this, MessageFun.TypeMsg.Error, General.Msg("Employee ID already exists,Please enter different ID", "رقم الموظف موجود مسبقا,من فضلك اختر رقما آخر"));
}
else
{
if (Request.QueryString["ac"] != null)
{
FillPropeties();
SqlClass.Insert(ProClass);
string empid = txtEmpIdentity.Text;
ClearUI();
//if (ddlEmpType.SelectedValue == "Emp" || ddlEmpType.SelectedValue == "Con") { SqlClass.Booked_Delete(txtIDSearch.Text); }
txtIDSearch.Text = "";
MessageFun.ShowMsg(this, MessageFun.TypeMsg.Success, General.Msg(MainNameEn + " data added successfully, EmployeeID is '" + empid + "'", "تمت إضافة بيانات " + MainName2Ar + " بنجاح, رقم الموظف هو '" + empid + "'"));
if (ddlEmpType.SelectedValue == "Emp" || ddlEmpType.SelectedValue == "Con")
{
txtIDSearch.Text = FindMaxID();
}
}
}
}
if ((btnSave.Text == "Update") || (btnSave.Text == "تعديل"))
{
dt = DBFun.FetchData("select * from EmployeeMaster where EmpID = '" + txtEmpIdentity.Text.Trim() + "'");
if (DBFun.IsNullOrEmpty(dt))
{
MessageFun.ShowMsg(this, MessageFun.TypeMsg.Error, General.Msg("This ID No part of " + GetNameType(Request.QueryString["ac"].ToString()) + " ,Please enter different ID", "هذا الرقم لا يوجد ضمن " + GetNameType(Request.QueryString["ac"].ToString()) + " ,من فضلك اختر رقما آخر"));
}
else
{
if (Request.QueryString["ac"] != null)
{
FillPropeties();
SqlClass.Update(ProClass);
ClearUI();
txtIDSearch.Text = "";
MessageFun.ShowMsg(this, MessageFun.TypeMsg.Success, General.Msg(MainNameEn + " data updated successfully", "تم تعديل بيانات " + MainName2Ar + " بنجاح"));
}
}
}
ButtonAction("00", true);
DataItemEnabled(false);
EmpImage.PopulateImage(txtEmpNationalID.Text);
}
catch (Exception Ex)
{
DBFun.InsertError(FormSession.PageName, "btnSave");
EmpImage.PopulateImage(txtEmpNationalID.Text);
MessageFun.ShowAdminMsg(this, Ex.Message);
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Page_Load(object sender, EventArgs e)
{
try
{
//---Common Code ----------------------------------------------------------------- //
FormSession.FillSession("Employees", pageDiv);
//---Common Code ----------------------------------------------------------------- //
if (!IsPostBack)
{
pnlMain.Attributes.Add("onkeypress", "javascript:return DefaultButton(event,'" + btnIDSearch.ClientID + "');");
if (!FormSession.getPerm(new string[] { "IMng", "UMng", "IEmp", "UEmp", "ICon", "UCon" }))
{
Response.Redirect(@"~/Login.aspx");
}
if (Request.QueryString["ac"] != null)
{
string ac = Request.QueryString["ac"].ToString();
ViewState["ac"] = ac;
if (ac == "IMng")
{
if (!FormSession.getPerm("IMng"))
{
btnSave.Enabled = false; btnIDSearch.Enabled = false;
}
btnSave.Text = General.Msg("Save", "حفظ");
MainMasterPage.ShowTitel(General.Msg("Add Aramco Employee", "إضافة موظف أرامكو"));
ddlEmpType.SelectedIndex = ddlEmpType.Items.IndexOf(ddlEmpType.Items.FindByValue("Mng"));
divContract.Visible = false;
rfvCompID.Enabled = false;
divSection.Visible = false;
rfvSecID.Enabled = false;
}
if (ac == "UMng")
{
if (!FormSession.getPerm("UMng"))
{
btnSave.Enabled = false; btnIDSearch.Enabled = false;
}
btnSave.Text = General.Msg("Update", "تعديل");
MainMasterPage.ShowTitel(General.Msg("Update Aramco Employee", "تعديل موظف أرامكو"));
ddlEmpType.SelectedIndex = ddlEmpType.Items.IndexOf(ddlEmpType.Items.FindByValue("Mng"));
divContract.Visible = false;
rfvCompID.Enabled = false;
divSection.Visible = false;
rfvSecID.Enabled = false;
}
if (ac == "IEmp")
{
if (!FormSession.getPerm("IEmp"))
{
btnSave.Enabled = false; btnIDSearch.Enabled = false;
}
btnSave.Text = General.Msg("Save", "حفظ");
MainMasterPage.ShowTitel(General.Msg("Add Third party Employee", "إضافة موظف جهات خارجية "));
ddlEmpType.SelectedIndex = ddlEmpType.Items.IndexOf(ddlEmpType.Items.FindByValue("Emp"));
divContract.Visible = false;
rfvCompID.Enabled = false;
divSection.Visible = true;
rfvSecID.Enabled = true;
txtIDSearch.Text = FindMaxID();
}
if (ac == "UEmp")
{
if (!FormSession.getPerm("UEmp"))
{
btnSave.Enabled = false; btnIDSearch.Enabled = false;
}
btnSave.Text = General.Msg("Update", "تعديل");
MainMasterPage.ShowTitel(General.Msg("Update Third party Employee", "تعديل موظف جهات خارجية "));
ddlEmpType.SelectedIndex = ddlEmpType.Items.IndexOf(ddlEmpType.Items.FindByValue("Emp"));
divContract.Visible = false;
rfvCompID.Enabled = false;
divSection.Visible = true;
rfvSecID.Enabled = true;
}
if (ac == "ICon")
{
if (!FormSession.getPerm("ICon"))
{
btnSave.Enabled = false; btnIDSearch.Enabled = false;
}
btnSave.Text = General.Msg("Save", "حفظ");
MainMasterPage.ShowTitel(General.Msg("Add Contractor", "إضافة متعاقد"));
ddlEmpType.SelectedIndex = ddlEmpType.Items.IndexOf(ddlEmpType.Items.FindByValue("Con"));
divContract.Visible = true;
rfvCompID.Enabled = true;
divSection.Visible = false;
rfvSecID.Enabled = false;
txtIDSearch.Text = FindMaxID();
}
if (ac == "UCon")
{
if (!FormSession.getPerm("UCon"))
{
btnSave.Enabled = false; btnIDSearch.Enabled = false;
}
btnSave.Text = General.Msg("Update", "تعديل");
MainMasterPage.ShowTitel(General.Msg("Update Contractor", "تعديل متعاقد"));
ddlEmpType.SelectedIndex = ddlEmpType.Items.IndexOf(ddlEmpType.Items.FindByValue("Con"));
divContract.Visible = true;
rfvCompID.Enabled = true;
divSection.Visible = false;
rfvSecID.Enabled = false;
}
}
EmpImage.EnabledImage(false);
Fillddl();
}
if (IsPostBack)
{
EmpImage.PopulateImage(txtEmpNationalID.Text);
}
}
catch (Exception e1) { DBFun.InsertError(FormSession.PageName, "PageLoad"); }
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void FillPropeties()
{
try
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
ProClass.DateType = FormSession.DateType;
ProClass.EmpID = txtEmpIdentity.Text;
ProClass.EmpType = ddlEmpType.SelectedValue;
ProClass.EmpNameEn = txtEmpNameEn.Text;
ProClass.EmpNameAr = txtEmpNameAr.Text;
ProClass.EmpBirthDate = CalBirthDate.getDate();
ProClass.EmpJobTitleAr = txtJobTitleAr.Text;
ProClass.EmpJobTitleEn = txtJobTitleEn.Text;
ProClass.EmpNationalID = txtEmpNationalID.Text;
ProClass.EmpHireDate = CalHireDate.getDate();
ProClass.EmpMobileNo = txtMobile.Text;
ProClass.EmpEmailID = txtEmail.Text;
if (ddlNatID.SelectedIndex > 0)
{
ProClass.NatID = ddlNatID.SelectedValue;
}
if (ddlBloodGroup.SelectedIndex > 0)
{
ProClass.EmpBloodGroup = ddlBloodGroup.SelectedValue;
}
if (ddlCompID.SelectedIndex > 0)
{
ProClass.CompID = ddlCompID.SelectedValue;
}
if (ddlSecID.SelectedIndex > 0)
{
ProClass.SecID = ddlSecID.SelectedValue;
}
if (rdlGender.SelectedIndex > -1)
{
ProClass.EmpGender = Convert.ToChar(rdlGender.SelectedValue);
}
ProClass.TransactionBy = FormSession.LoginUsr;
ProClass.TransactionDate = DateTime.Now.ToShortDateString();
//////////////////////////////////////////////
Byte[] pImage = new Byte[0];
string pImageContentType = "";
int pImageLength = 0;
EmpImage.GetImage(out pImage, out pImageContentType, out pImageLength);
if (pImageLength != 0)
{
ProClass.EmpImage = CryptoImage.EncryptBytes(pImage);
}
else
{
ProClass.EmpImage = pImage;
}
ProClass.EmpImageContentType = pImageContentType;
ProClass.EmpImageLength = pImageLength;
//////////////////////////////////////////////
}
catch (Exception Ex)
{
DBFun.InsertError(FormSession.PageName, "FillPropeties");
MessageFun.ShowAdminMsg(this, Ex.Message);
}
}
