///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 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); } }