/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void Fillddl() { DataTable CompDT = DBFun.FetchData("SELECT * FROM Companies "); if (!DBFun.IsNullOrEmpty(CompDT)) { FormCtrl.PopulateDDL(ddlCompID, CompDT, "CompName" + FormSession.Language, "CompID", General.Msg("-Select Company-", "-اختر الشركة-")); } DataTable SecDT = DBFun.FetchData("SELECT * FROM SectionsExternal "); if (!DBFun.IsNullOrEmpty(SecDT)) { FormCtrl.PopulateDDL(ddlSecID, SecDT, "SecName" + FormSession.Language, "SecID", General.Msg("-Select Sections External-", "-اختر الجهة الخارجية-")); } dt = DBFun.FetchData("SELECT DISTINCT IsID,IsNameEn,IsNameAr FROM CardInfoView"); if (!DBFun.IsNullOrEmpty(dt)) { FormCtrl.PopulateDDL(ddlIssue, dt, "IsName" + General.Lang(), "IsID", General.Msg("-Select Issue-", "-اختر الإصدار-")); } dt = DBFun.FetchData("SELECT DISTINCT CreatedBy FROM CardInfoView WHERE CreatedBy IS NOT NULL "); if (!DBFun.IsNullOrEmpty(dt)) { FormCtrl.PopulateDDL(ddlCreatedBy, dt, "CreatedBy", "CreatedBy", General.Msg("-Select Created By-", "-اختر إنشاء بواسطة-")); } dt = DBFun.FetchData("SELECT DISTINCT PrintedBy FROM CardInfoView WHERE PrintedBy IS NOT NULL "); if (!DBFun.IsNullOrEmpty(dt)) { FormCtrl.PopulateDDL(ddlPrintedBy, dt, "PrintedBy", "PrintedBy", General.Msg("-Select Printed By-", "-اختر طباعة بواسطة-")); } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void EmpID_ServerValidate(Object source, ServerValidateEventArgs e) { try { if (source.Equals(cvEmpID)) { if (string.IsNullOrEmpty(txtEmpID.Text)) { General.ValidMsg(this, ref cvEmpID, false, "Employee ID is required!", "رقم الموظف مطلوب !"); e.IsValid = false; return; } else { if (ViewState["CommandName"].ToString() == "Add") { dt = DBFun.FetchData(MainQuery + " AND EmpID = '" + txtEmpID.Text + "'"); if (!DBFun.IsNullOrEmpty(dt)) { MessageFun.ValidMsg(this, ref cvEmpID, true, General.Msg("The Employee ID already exists", "رقم الموظف موجود مسبقا")); e.IsValid = false; return; } } } } } catch { e.IsValid = false; } }
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void PopulateUI(string pID) { try { dt = DBFun.FetchData("SELECT * FROM IssueState WHERE IsID = " + pID + ""); if (DBFun.IsNullOrEmpty(dt)) { return; } DataRow dr = (DataRow)dt.Rows[0]; txtIssueNameEn.Text = dt.Rows[0]["IsNameEn"].ToString(); txtIssueNameAr.Text = dt.Rows[0]["IsNameAr"].ToString(); txtIssuedescription.Text = dt.Rows[0]["IsDescription"].ToString(); rdlIsRepeat.SelectedIndex = rdlIsRepeat.Items.IndexOf(rdlIsRepeat.Items.FindByValue(dt.Rows[0]["IsRepeat"].ToString())); rdlIsCondition.SelectedIndex = rdlIsCondition.Items.IndexOf(rdlIsCondition.Items.FindByValue(dt.Rows[0]["ISCondition"].ToString())); rdlIsCondition_SelectedIndexChanged(null, null); DataTable Condt = DBFun.FetchData("SELECT * FROM IssueConditions WHERE IsID = " + pID + ""); if (DBFun.IsNullOrEmpty(Condt)) { return; } for (int i = 0; i < Condt.Rows.Count; i++) { cblConditions.Items.Add(Condt.Rows[i]["ConditionName"].ToString()); } } catch (Exception Ex) { MessageFun.ShowAdminMsg(this, Ex.Message); } }
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void PopulateMainData(string pID) { try { dt = DBFun.FetchData(MainQuery + " AND DepID = " + pID + ""); if (DBFun.IsNullOrEmpty(dt)) { return; } txtDepID.Text = dt.Rows[0]["DepID"].ToString(); txtDepNameAr.Text = dt.Rows[0]["DepNameAr"].ToString(); txtDepNameEn.Text = dt.Rows[0]["DepNameEn"].ToString(); ddlParentID.SelectedIndex = ddlParentID.Items.IndexOf(ddlParentID.Items.FindByValue(dt.Rows[0]["DepParentID"].ToString())); txtDepDesc.Text = dt.Rows[0]["DepDesc"].ToString(); if (dt.Rows[0]["DepStatus"] != DBNull.Value) { chkDepStatus.Checked = Convert.ToBoolean(dt.Rows[0]["DepStatus"]); } ButtonMainAction(true, "11100"); //FillSubGrid(SubQuery + " AND DepID = " + txtDepID.Text); //ButtonSubAction(true,"10000"); } catch (Exception Ex) { } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public bool GetEmpEMail(string pEmpID, out string pEmpEmail, out string pLang) { pLang = "En"; pEmpEmail = ""; try { bool isValid = true; dt = DBFun.FetchData("SELECT EmpEmailID,Language FROM EmployeeMaster WHERE EmpID = '" + pEmpID + "'"); if (!DBFun.IsNullOrEmpty(dt)) { if (dt.Rows[0]["Language"] != DBNull.Value) { pLang = dt.Rows[0]["Language"].ToString(); } if (dt.Rows[0]["EmpEmailID"] != DBNull.Value) { pEmpEmail = dt.Rows[0]["EmpEmailID"].ToString(); } else { isValid = false; } return(isValid); } else { return(false); } } catch (Exception e1) { return(false); } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void btnEditReport_Click(object sender, EventArgs e) { try { if (lstReport.SelectedIndex < 0) { return; } //ShowMsg("Please Select Report to edit it", "رجاء حدد تقرير للتعديل"); string RepID = lstReport.SelectedValue; DataTable RepDT = DBFun.FetchData(" SELECT * FROM Report WHERE RepID = '" + RepID + "'"); if (!DBFun.IsNullOrEmpty(RepDT)) { string repStr = RepDT.Rows[0]["RepTemp" + FormSession.Language].ToString(); if (string.IsNullOrEmpty(repStr)) { return; } StiReport report = new StiReport(); report.LoadFromString(repStr); report.Dictionary.Databases.Clear(); report.Dictionary.Databases.Add(new StiSqlDatabase("Connection", General.ConnString)); report.Dictionary.Synchronize(); report.Compile(); StiWebDesigner1.Design(report); ////this.InvokeRefreshPreview(); } } catch (Exception ex) { } }
/*#############################################################################################################################*/ /*#############################################################################################################################*/ #region Report Events protected void btnSetAsDefault_Click(object sender, EventArgs e) { try { if (lstReport.SelectedIndex < 0) { return; } string RepID = lstReport.SelectedValue; DataTable RepDT = DBFun.FetchData(" SELECT * FROM Report WHERE RepID = '" + RepID + "'"); if (!DBFun.IsNullOrEmpty(RepDT)) { string repStr = RepDT.Rows[0]["RepTempDef" + FormSession.Language].ToString(); ProClass.RepID = RepID; ProClass.RepTemp = repStr; ProClass.Lang = FormSession.Language; ProClass.ModifiedBy = FormSession.LoginUsr; SqlClass.UpdateTemplate(ProClass); } } catch (Exception e1) { } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// private void FillPrintedBy(string RgpID) { string Q = ""; if (RgpID == "4") { Q = "SELECT DISTINCT PrintedBy FROM CardInfoView WHERE PrintedBy IS NOT NULL"; } else if (RgpID == "5") { Q = "SELECT DISTINCT PrintedBy FROM StickerInfoView WHERE PrintedBy IS NOT NULL"; } else if (RgpID == "6") { Q = "SELECT DISTINCT PrintedBy FROM VisitorsCardInfoView WHERE PrintedBy IS NOT NULL"; } ddlPrintedBy.Items.Clear(); DataTable DT = new DataTable(); DT = DBFun.FetchData(Q); if (!DBFun.IsNullOrEmpty(DT)) { FormCtrl.PopulateDDL(ddlPrintedBy, DT, "PrintedBy", "PrintedBy", General.Msg("-Select Printed By-", "-اختر طباعة بواسطة-")); rvPrintedBy.InitialValue = ddlPrintedBy.Items[0].Text; } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void FillGrid() { try { System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); StringBuilder query = new StringBuilder(); query.Append(" SELECT CardID,EmpID,StartDate,ExpiryDate,IsID,EmpType " + " , EmpName" + General.Lang() + " AS EmpName " + " , IsName" + General.Lang() + " AS IssueName " + " FROM CardInfoView " + " WHERE CardStatus = 1 AND IsApproved = 0 "); if (ddlEmployee.SelectedIndex > 0) { query.Append(" AND EmpID = '" + ddlEmployee.SelectedValue + "'"); } if (ddlEmpType.SelectedIndex > 0) { query.Append(" AND EmpType = '" + ddlEmpType.SelectedValue + "'"); } if (ddlIssue.SelectedIndex > 0) { query.Append(" AND IsID = '" + ddlIssue.SelectedValue + "'"); } dt = DBFun.FetchData(query.ToString()); if (!DBFun.IsNullOrEmpty(dt)) { grdData.DataSource = (DataTable)dt; grdData.DataBind(); divbtn.Visible = true; } else { FormCtrl.FillGridEmpty(ref grdData,20,"No cards for Approve","لا توجد بطاقات للموافقة عليها"); divbtn.Visible = false; } } catch (Exception Ex) { MessageFun.ShowAdminMsg(this, Ex.Message); } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void lstReportsGroups_SelectedIndexChanged(object sender, EventArgs e) { Clear(); lstReport.Items.Clear(); lblSelectedreport.Text = General.Msg("Please select Report", "من فضلك اختر التقرير"); StiWebViewerFx1.Report = null; btnEditReport.Enabled = btnSetAsDefault.Enabled = btnViewreport.Enabled = false; pnlDateFromTo.Visible = pnlEmployee.Visible = false; pnlCreatedBy.Visible = rvCreatedBy.Enabled = false; pnlPrintedBy.Visible = rvPrintedBy.Enabled = false; pnlIssue.Visible = rvIssue.Enabled = false; UpdatePanel1.Update(); if (lstReportsGroups.SelectedIndex > -1) { string RgpID = lstReportsGroups.SelectedValue; DataTable RepDT = DBFun.FetchData(" SELECT * FROM Report WHERE RgpID = " + RgpID + ""); if (!DBFun.IsNullOrEmpty(RepDT)) { FillReports(RgpID); FillCreatedBy(RgpID); FillPrintedBy(RgpID); FillCompany(); } } UpdatePanel1.Update(); }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void Search() { try { System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); StringBuilder QS = new StringBuilder(); QS.Append("SELECT *," + General.Msg("NatNameEn", "NatNameAr") + " AS NatName FROM BlackListInfoView WHERE 1=1 "); if (!string.IsNullOrEmpty(txtBlaIdentityNo.Text)) { QS.Append(" AND BlaIdentityNo LIKE '" + txtBlaIdentityNo.Text + "%'"); } if (!string.IsNullOrEmpty(txtBlaNameAr.Text)) { QS.Append(" AND BlaNameAr LIKE '" + txtBlaNameAr.Text + "%'"); } if (!string.IsNullOrEmpty(txtBlaNameEn.Text)) { QS.Append(" AND BlaNameEn LIKE '" + txtBlaNameEn.Text + "%'"); } dt = DBFun.FetchData(QS.ToString()); if (!DBFun.IsNullOrEmpty(dt)) { grdData.DataSource = (DataTable)dt; grdData.DataBind(); } else { FormCtrl.FillGridEmpty(ref grdData, 20, "No records found with the given search criterion", "لا توجد سجلات بحسب شروط البحث المحددة"); } } catch (Exception e1) { } }
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void btnDelete_Click(object sender, EventArgs e) { if (txtUsrLoginID.Text == "admin") { MessageFun.ShowMsg(this, MessageFun.TypeMsg.Error, General.Msg("You can not delete a User : system administrator", "لا يمكن حذف المستخدم : مدير النظام")); return; } if (txtUsrLoginID.Text == FormSession.LoginID) { MessageFun.ShowMsg(this, MessageFun.TypeMsg.Error, General.Msg("You can not delete the current user of the system", "لا يمكن حذف المستخدم الحالي للنظام")); return; } string Q = " SELECT LogTransactionBy FROM TransactionLog WHERE LogTransactionBy = '" + txtUsrLoginID.Text + "' "; dt = DBFun.FetchData(Q); if (!DBFun.IsNullOrEmpty(dt)) { MessageFun.ShowMsg(this, MessageFun.TypeMsg.Error, General.Msg("Deletion can not because of the presence of related records", "لا يمكن الحذف بسبب وجود سجلات مرتبطة")); } else { FillPropeties(); SqlClass.Delete(ProClass); MessageFun.ShowMsg(this, MessageFun.TypeMsg.Success, General.Msg("User deleted successfully", "تم حذف المستخدم بنجاح")); ClearItem(); Search(); } }
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public void FillGrid(string pRegVeh) { dt = DBFun.FetchData("SELECT StickerID,RegVehicle,EmpID,StartDate,ExpiryDate,TmpName AS StkTmpName " + " , EmpName" + General.Lang() + " AS FullName " + " , CompName" + General.Lang() + " AS Company " + " FROM StickerInfoView where RegVehicle ='" + pRegVeh + "' ORDER BY StickerID DESC"); if (!DBFun.IsNullOrEmpty(dt)) { DataRow dr1 = (DataRow)dt.Rows[0]; grdData.DataSource = (DataTable)dt; grdData.DataBind(); //hdnStickerID.Value = dr1["StickerID"].ToString(); } else { FormCtrl.FillGridEmpty(ref grdData, 20, "This Vehicle does not has Stickers", "هذه المركبة ليس لها ملصقات"); dt = new DataTable(); grdData.DataSource = (DataTable)dt; grdData.DataBind(); ClearUI(); } SetTmp("Stk"); }
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void PopulateUI(string pID) { try { dt = DBFun.FetchData(MainQuery + " WHERE RoleID = " + pID + ""); if (DBFun.IsNullOrEmpty(dt)) { return; } txtRoleNameAr.Text = dt.Rows[0]["RoleNameAr"].ToString(); txtRoleNameEn.Text = dt.Rows[0]["RoleNameEn"].ToString(); if (dt.Rows[0]["RoleNameEn"].ToString() == "admin" || dt.Rows[0]["RoleNameAr"].ToString() == "مدير النظام") { txtRoleNameEn.Enabled = false; txtRoleNameAr.Enabled = false; PermissionsCtl.EnablePermissions(false, true); } else { txtRoleNameEn.Enabled = true; txtRoleNameAr.Enabled = true; PermissionsCtl.EnablePermissions(true, true); } PermissionsCtl.PopulatePermissions(dt.Rows[0]["RolePermissions"].ToString(), dt.Rows[0]["RoleNameEn"].ToString()); } catch (Exception e1) { } }
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public void PopulateImage(string ID) { try { dt = (DataTable)DBFun.FetchData("SELECT * FROM TempImage WHERE Type = '" + Type + "' AND EmpID='" + ID + "'"); if (DBFun.IsNullOrEmpty(dt)) { if (imgPhoto.ImageUrl != EmptyImage()) { string ImagePath = FindTempImagePath() + ID + ".jpeg"; imgPhoto.ImageUrl = ImagePath; if (!File.Exists(ImagePath)) { setImage(ID); } return; } else { imgPhoto.ImageUrl = EmptyImage(); return; } } imgPhoto.ImageUrl = "~/Images/Pages/ReadImage.aspx?Type=" + Type + "Tmp&ID=" + ID + ""; } catch (Exception e1) { DBFun.InsertError("Image", "PopulateImage()"); } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public string FindCount(string pID) { try { string count = "0"; DataTable CountDT = DBFun.FetchData("SELECT COUNT(VisCardID) count FROM VisitorsCard WHERE isPrinted = 'True' AND VisIdentityNo = '" + pID + "'"); if (DBFun.IsNullOrEmpty(CountDT)) { } else { if (Convert.ToInt32(CountDT.Rows[0]["count"]) > 0) { count = CountDT.Rows[0]["count"].ToString(); } } return(count); } catch (Exception e1) { DBFun.InsertError(FormSession.PageName, "FindCount"); return("0"); } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public bool FindActiveCard(string pID) { try { bool isActive = false; DataTable DT = DBFun.FetchData("SELECT COUNT(VisCardID) count FROM VisitorsCard WHERE CardStatus = 2 AND ExpiryDate > GETDATE() AND VisIdentityNo = '" + pID + "'"); if (DBFun.IsNullOrEmpty(DT)) { } else { if (Convert.ToInt32(DT.Rows[0]["count"]) > 0) { isActive = true; } } return(isActive); } catch (Exception e1) { DBFun.InsertError(FormSession.PageName, "FindActiveCard"); return(false); } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void FillCondition() { if (ddlIssue.SelectedIndex > 0) { cblConditions.Items.Clear(); dt = DBFun.FetchData("SELECT ISCondition FROM IssueState WHERE ISCondition = '1' AND IsID = " + ddlIssue.SelectedValue); if (DBFun.IsNullOrEmpty(dt)) { divCondition1.Visible = false; divCondition2.Visible = false; return; } DataTable Condt = DBFun.FetchData("SELECT * FROM IssueConditions WHERE ConditionType = 'Card' AND IsID = " + ddlIssue.SelectedValue + ""); if (DBFun.IsNullOrEmpty(Condt)) { return; } for (int i = 0; i < Condt.Rows.Count; i++) { ListItem li = new ListItem(Condt.Rows[i]["ConditionName"].ToString(), Condt.Rows[i]["ConditionID"].ToString()); cblConditions.Items.Add(li); } divCondition1.Visible = true; divCondition2.Visible = true; } else { divCondition1.Visible = false; divCondition2.Visible = false; return; } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void IDSearch_ServerValidate(Object source, ServerValidateEventArgs e) { try { if (source.Equals(cvIDSearch)) { if (string.IsNullOrEmpty(txtIDSearch.Text)) { General.ValidMsg(this, ref cvIDSearch, false, "Employee identity is required", "رقم الموظف مطلوب"); e.IsValid = false; return; } else { if ((btnSave.Text == "Save") || (btnSave.Text == "حفظ")) { dt = DBFun.FetchData("SELECT * FROM EmployeeMaster WHERE EmpID = '" + txtIDSearch.Text.Trim() + "' "); if (!DBFun.IsNullOrEmpty(dt)) { General.ValidMsg(this, ref cvIDSearch, true, "Employee ID is already exists,Please enter different ID", "رقم الموظف مضاف مسبقاً ,من فضلك اختر رقما آخر"); e.IsValid = false; return; } } } } } catch { e.IsValid = false; } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void Fillddl() { DataTable NatDT = DBFun.FetchData("SELECT * FROM Nationality "); if (!DBFun.IsNullOrEmpty(NatDT)) { FormCtrl.PopulateDDL(ddlNatID, NatDT, "NatName" + FormSession.Language, "NatID", General.Msg("-Select Nationality-", "-اختر الجنسية-")); rfvddlNatID.InitialValue = ddlNatID.Items[0].Text; } DataTable CompDT = DBFun.FetchData("SELECT * FROM Companies"); if (!DBFun.IsNullOrEmpty(CompDT)) { FormCtrl.PopulateDDL(ddlCompID, CompDT, "CompName" + FormSession.Language, "CompID", General.Msg("-Select Company-", "-اختر الشركة-")); rfvCompID.InitialValue = ddlCompID.Items[0].Text; } DataTable SecDT = DBFun.FetchData("SELECT * FROM SectionsExternal"); if (!DBFun.IsNullOrEmpty(SecDT)) { FormCtrl.PopulateDDL(ddlSecID, SecDT, "SecName" + FormSession.Language, "SecID", General.Msg("-Select Sections-", "-اختر الجهة الخارجية-")); rfvSecID.InitialValue = ddlSecID.Items[0].Text; } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public void PopulateUI(string pID) { try { if ((btnSave.Text == "Update") || (btnSave.Text == "تعديل")) { DataTable myTableDT = DBFun.FetchData("SELECT * FROM EmployeeMaster WHERE EmpID = '" + pID + "' AND EmpType = '" + ddlEmpType.SelectedValue + "' "); if (DBFun.IsNullOrEmpty(myTableDT)) { ButtonAction("00", true); MessageFun.ShowMsg(this, vsSearch, cvShowMsg, MessageFun.TypeMsg.Warning, "vgSearch", General.Msg("This employee No part of " + GetNameType(Request.QueryString["ac"].ToString()), "الموظف غير موجود ضمن " + GetNameType(Request.QueryString["ac"].ToString()))); return; } FillFromDT(myTableDT); } txtEmpIdentity.Text = txtIDSearch.Text; ButtonAction("11", false); DataItemEnabled(true); } catch (Exception Ex) { DBFun.InsertError(FormSession.PageName, "PopulateUI"); MessageFun.ShowAdminMsg(this, Ex.Message); } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void UsrLoginID_ServerValidate(Object source, ServerValidateEventArgs e) { try { if (source.Equals(cvUsrLoginID)) { if (string.IsNullOrEmpty(txtUsrLoginID.Text)) { General.ValidMsg(this, ref cvUsrLoginID, false, "Login ID is required!", "اسم دخول المستخدم مطلوب !"); e.IsValid = false; return; } else { if (ViewState["CommandName"].ToString() == "Save") { dt = DBFun.FetchData(MainQuery + " WHERE UsrLoginID = '" + txtUsrLoginID.Text + "'"); if (!DBFun.IsNullOrEmpty(dt)) { MessageFun.ValidMsg(this, ref cvUsrLoginID, true, General.Msg("The Login ID already exists", "اسم الدخول موجود مسبقا")); e.IsValid = false; return; } } } } } catch { e.IsValid = false; } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void EmpID_ServerValidate(Object source, ServerValidateEventArgs e) { string sqlUpdate = ViewState["CommandName"].ToString() == "Edit" ? " AND EvrID != " + txtEvrID.Text : ""; try { if (ViewState["CommandName"].ToString() == "Add" || ViewState["CommandName"].ToString() == "Edit") { if (source.Equals(cvEmpID)) { if (!string.IsNullOrEmpty(txtEmpID.Text)) { dt = DBFun.FetchData("SELECT * FROM EmployeesInfoView WHERE EmpID = '" + txtEmpID.Text + "' "); if (!DBFun.IsNullOrEmpty(dt)) { MessageFun.ValidMsg(this, ref cvEmpID, true, General.Msg("Employee ID entered donot exists or not Active,Please enter different ID", "رقم الموظف غير موجود أو غير فعال ,من فضلك اختر رقما آخر")); e.IsValid = false; return; } } } } } catch { e.IsValid = false; } }
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void IdentityNo_ServerValidate(Object source, ServerValidateEventArgs e) { //string sqlUpdate = ViewState["CommandName"].ToString() == "Update" ? " AND BlaIdentityNo != " + txtBlaIdentityNo.Text : ""; try { if (ViewState["CommandName"].ToString() == "Save") { if (source.Equals(cvBlaIdentityNo)) { if (string.IsNullOrEmpty(txtBlaIdentityNo.Text)) { MessageFun.ValidMsg(this, ref cvBlaIdentityNo, false, General.Msg("Identity No. is required", "رقم الهوية مطلوب")); e.IsValid = false; return; } else { dt = DBFun.FetchData(MainQuery + " WHERE BlaIdentityNo = '" + txtBlaIdentityNo.Text + "'"); if (!DBFun.IsNullOrEmpty(dt)) { MessageFun.ValidMsg(this, ref cvBlaIdentityNo, true, General.Msg("Identity No. already exists", "رقم الهوية موجود مسبقا")); e.IsValid = false; return; } } } } } catch { e.IsValid = false; } }
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void PopulateData(string pID) { try { dt = DBFun.FetchData(MainQuery + " AND UsrLoginID = '" + pID + "'"); if (DBFun.IsNullOrEmpty(dt)) { return; } txtUsrLoginID.Text = dt.Rows[0]["UsrLoginID"].ToString(); txtUsrPassword.Attributes["value"] = dt.Rows[0]["UsrPassword"].ToString(); txtUsrFullName.Text = dt.Rows[0]["UsrFullName"].ToString(); calUsrStartDate.setDBDate(dt.Rows[0]["UsrStartDate"], "S"); calUsrExpiryDate.setDBDate(dt.Rows[0]["UsrExpiryDate"], "S"); ddlUsrStatus.SelectedIndex = ddlUsrStatus.Items.IndexOf(ddlUsrStatus.Items.FindByValue(Convert.ToInt16(dt.Rows[0]["UsrStatus"]).ToString())); ddlUsrLang.SelectedIndex = ddlUsrLang.Items.IndexOf(ddlUsrLang.Items.FindByValue(dt.Rows[0]["UsrLanguage"].ToString())); txtUsrEmail.Text = dt.Rows[0]["UsrEmailID"].ToString(); txtUsrDescription.Text = dt.Rows[0]["UsrDescription"].ToString(); PermCtl.PopulatePermissions(CryptorEngine.Decrypt(dt.Rows[0]["UsrPermission"].ToString(), true), txtUsrLoginID.Text); ButtonAction(true, "11100"); } catch (Exception Ex) { } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void TemplateValidate_ServerValidate(Object source, ServerValidateEventArgs e) { try { if (source.Equals(cvTemplate)) { DataTable Empdt = DBFun.FetchData("SELECT EmpType FROM EmployeeInfoView WHERE EmpID = '" + txtEmpID.Text + "'"); if (!DBFun.IsNullOrEmpty(Empdt)) { DataTable Tmpdt = DBFun.FetchData("SELECT TmpID FROM CardTemplate WHERE TmpType ='Card' AND EmpType = '" + Empdt.Rows[0]["EmpType"].ToString() + "'"); if (!DBFun.IsNullOrEmpty(Tmpdt)) { ddlTemplate.SelectedIndex = ddlTemplate.Items.IndexOf(ddlTemplate.Items.FindByValue(Tmpdt.Rows[0]["TmpID"].ToString())); } //if (Empdt.Rows[0]["EmpStatusAr"] != DBNull.Value) //{ // DataTable Rdt = DBFun.FetchData("SELECT TmpID FROM CardTemplate WHERE TmpType ='Card' AND EmpType = 'Re'"); // if (Empdt.Rows[0]["EmpStatusAr"].ToString() == "إنهاء التعيين") { ddlTemplate.SelectedIndex = ddlTemplate.Items.IndexOf(ddlTemplate.Items.FindByValue(Rdt.Rows[0]["TmpID"].ToString())); } //} if (ddlTemplate.SelectedIndex > -1) { e.IsValid = true; return; } } e.IsValid = false; } } catch { e.IsValid = false; } //ShowMsg("No card Template for this employee, please add the first card Template", "لا يوجد نموذج بطاقة لهذا الموظف,الرجاء إضافة النموذج أولا"); }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public bool GetUsrEMail(out string pLoginID, out string pLang) { pLang = "En"; pLoginID = ""; try { bool isValid = true; dt = DBFun.FetchData("SELECT UsrEmailID,UsrLanguage FROM AppUsers WHERE UsrLoginID = '" + pLoginID + "'"); if (!DBFun.IsNullOrEmpty(dt)) { if (dt.Rows[0]["UsrLanguage"] != DBNull.Value) { pLang = dt.Rows[0]["UsrLanguage"].ToString(); } if (dt.Rows[0]["UsrEmailID"] != DBNull.Value) { pLoginID = dt.Rows[0]["UsrEmailID"].ToString(); } else { isValid = false; } return(isValid); } else { return(false); } } catch (Exception e1) { return(false); } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public string FindMaxID() { string MaxID = "20000001"; DataTable MaxDT = DBFun.FetchData("SELECT E.MaxID FROM (SELECT MAX(CONVERT(INT,EmpID) + 1) MaxID FROM EmployeeMaster WHERE EmpType IN ('Emp','Con')) AS E"); if (DBFun.IsNullOrEmpty(MaxDT)) { } else { if (MaxDT.Rows[0]["MaxID"] != DBNull.Value) { MaxID = (Convert.ToInt64(MaxDT.Rows[0]["MaxID"].ToString())).ToString(); } else { } } bool isFound = true; while (isFound) { isFound = CheckFoundID(MaxID); if (isFound) { MaxID = (Convert.ToInt64(MaxID) + 1).ToString(); } } return(MaxID); }
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void Pass_ServerValidate(Object source, ServerValidateEventArgs e) { try { if (source.Equals(cvCurrentPass)) { if (string.IsNullOrEmpty(txtCurrentPass.Text)) { MessageFun.ValidMsg(this, ref cvCurrentPass, false, General.Msg("Current Password is required", "كلمة المرور الحالية مطلوبة")); e.IsValid = false; return; } else { dt = DBFun.FetchData("SELECT UsrPassword FROM AppUsers WHERE UsrLoginID = '" + FormSession.LoginID + "'"); if (!DBFun.IsNullOrEmpty(dt)) { if (dt.Rows[0][0].ToString() != txtCurrentPass.Text) { MessageFun.ValidMsg(this, ref cvCurrentPass, true, General.Msg("The Current password is incorrect", "كلمة المرور الحالية غير صحيحة")); e.IsValid = false; return; } } } } if (source.Equals(cvNewPass)) { if (string.IsNullOrEmpty(txtNewPass.Text)) { MessageFun.ValidMsg(this, ref cvNewPass, false, General.Msg("New Password is required", "كلمة المرور الجديدة مطلوبة")); e.IsValid = false; return; } } if (source.Equals(cvConfirmPass)) { if (string.IsNullOrEmpty(txtConfirmPass.Text)) { MessageFun.ValidMsg(this, ref cvConfirmPass, false, General.Msg("Confirm Password is required", " تأكيد كلمة المرور مطلوبة")); e.IsValid = false; return; } else { if (!string.IsNullOrEmpty(txtNewPass.Text) && txtNewPass.Text != txtConfirmPass.Text) { MessageFun.ValidMsg(this, ref cvConfirmPass, true, General.Msg("Password and Confirm Password must be same", "كلمة المرور وتأكيد كلمة المرور غير متطابقتين")); e.IsValid = false; return; } } } } catch { e.IsValid = false; } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// protected void PopulateUpdate(string EmpID) { try { string selectQ = " SELECT CardID,EmpID,EmpNameEn,EmpNameAr,IsID,IsNameEn,IsNameAr,StartDate,ExpiryDate,Description " + ",CreatedBy,CreatedDate,CardStatus,TmpID,CardCount " + " FROM CardInfoView " + " WHERE CardStatus = 0 AND EmpID = '" + EmpID + "' ORDER BY CardID DESC"; DataTable Empdt = DBFun.FetchData(selectQ); if (DBFun.IsNullOrEmpty(Empdt)) { return; } txtEmpID.Text = EmpID; txtEmpNameEn.Text = Empdt.Rows[0]["EmpNameEn"].ToString(); txtEmpNameAr.Text = Empdt.Rows[0]["EmpNameAr"].ToString(); ddlIssue.SelectedIndex = ddlIssue.Items.IndexOf(ddlIssue.Items.FindByValue(Empdt.Rows[0]["IsID"].ToString())); txtCardCount.Text = Empdt.Rows[0]["CardCount"].ToString(); DataTable Condt = DBFun.FetchData("SELECT * FROM CardCondition WHERE ConditionType = 'Card' AND CardID = " + Empdt.Rows[0]["CardID"].ToString() + ""); if (!DBFun.IsNullOrEmpty(Condt)) { divCondition1.Visible = true; divCondition2.Visible = true; for (int i = 0; i < Condt.Rows.Count; i++) { ListItem li = new ListItem(Condt.Rows[i]["ConditionName"].ToString(), Condt.Rows[i]["ConditionID"].ToString()); cblConditions.Items.Add(li); cblConditions.Items[i].Selected = Convert.ToBoolean(Condt.Rows[i]["ConditionStatus"]); } } else { divCondition1.Visible = false; divCondition2.Visible = false; } ddlTemplate.SelectedIndex = ddlTemplate.Items.IndexOf(ddlTemplate.Items.FindByValue(Empdt.Rows[0]["TmpID"].ToString())); ddlCardstatus.SelectedIndex = ddlCardstatus.Items.IndexOf(ddlCardstatus.Items.FindByValue(Empdt.Rows[0]["CardStatus"].ToString())); if (Empdt.Rows[0]["StartDate"] != DBNull.Value) { calStartDate.setDBDate(Empdt.Rows[0]["StartDate"], "S"); } if (Empdt.Rows[0]["ExpiryDate"] != DBNull.Value) { calEndDate.setDBDate(Empdt.Rows[0]["ExpiryDate"], "S"); } txtDescription.Text = Empdt.Rows[0]["Description"].ToString(); } catch (Exception Ex) { DBFun.InsertError(FormSession.PageName, "PopulateUI"); MessageFun.ShowAdminMsg(this, Ex.Message); } }