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