//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Page_Load(object sender, EventArgs e)
{
//--Common Code----------------------------------------------------------------- //
FormSession.FillSession("Users", pageDiv);
FormCtrl.RefreshGridEmpty(ref grdData, 20, "No Data Found", "لا توجد بيانات");
//--Common Code----------------------------------------------------------------- //
if (!string.IsNullOrEmpty(txtUsrPassword.Text))
{
ViewState["Pass"] = txtUsrPassword.Text;
}
if (ViewState["Pass"] != null)
{
txtUsrPassword.Attributes["value"] = ViewState["Pass"].ToString();
}
if (!IsPostBack)
{
btnAdd.Enabled = FormSession.PermUsr.Contains("I" + MainPer);
pnlSearch.Enabled = grdData.Enabled = FormSession.PermUsr.Contains("V" + MainPer);
FillGrid(MainQuery);
DataItemStatus(false);
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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;
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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 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 override void ProgressOperation_OperationError(object sender, ProErrorEventArgs e)
{
if (!FormCtrl.IsHandleCreated)
{
return;
}
FormCtrl.Invoke(new Action(() =>
{
#if DEBUG
string errorMsg = e.OptException.ToString();
#else
string errorMsg = e.OptException.Message;
#endif
if (MessageCtrl != null)
{
MessageCtrl.Text = MessageAppend ? MessageCtrl.Text.Insert(0, errorMsg + Environment.NewLine) : errorMsg;
}
var opt = sender as IProgressOperation;
opt.Msgs.Error = e.OptException.ToString();
opt.WriteLogFile();
MessageBoxEx.ShowError(e.OptException);
ChangeView?.Invoke(false);
RunningOpt = null;
}));
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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 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;
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void grdData_RowDataBound(object sender, GridViewRowEventArgs e)
{
FormCtrl.GridSelectedRow(this, this.grdData, e.Row);
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Image img = (Image)e.Row.FindControl("imgMacStatus");
try
{
String sIP = e.Row.Cells[0].Text;
Ping pIP = new Ping();
PingReply prIP;
prIP = pIP.Send(sIP);
Response.Buffer = false;
if (prIP.Status == IPStatus.Success)
{
img.ImageUrl = "~/Images/icon/BallGreen-icon.png";
}
else
{
img.ImageUrl = "~/Images/icon/BallRed-icon.png";
}
}
catch { img.ImageUrl = "~/Images/icon/BallRed-icon.png"; }
}
}
catch (Exception e1) { }
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
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 override void ProgressOperation_OperationError(object sender, ProErrorEventArgs e)
{
if (!FormCtrl.IsHandleCreated)
{
return;
}
FormCtrl.Invoke(new Action(() =>
{
#if DEBUG
string errorMsg = e.OptException.ToString();
#else
string errorMsg = e.OptException.Message;
#endif
if (MessageCtrl != null)
{
MessageCtrl.Text = MessageCtrl.Text.Insert(0, errorMsg + Environment.NewLine);
}
var opt = sender as IProgressOperation;
LogManager.WriteLog(opt, e.OptException.ToString());
MessageBox.Show(errorMsg, opt.Name, MessageBoxButtons.OK, MessageBoxIcon.Error);
ChangeViews(false);
RunningOpt = null;
}));
}
private void Language_Load(object sender, EventArgs e)
{
if (Global.IS_WOLFCOM)
{
this.HeaderPanel.BackgroundImage = Properties.Resources.topbar45;
this.btnCloseDlg.VIBlendTheme = VIBLEND_THEME.NERO;
}
this.SetLanguage();
this.cboLang.Items.Clear();
List <CultureInfo> appLanguages = LangCtrl.GetAppLanguages();
if (appLanguages.Count > 0)
{
foreach (CultureInfo appLanguage in appLanguages)
{
ListItem listItem = new ListItem()
{
Text = appLanguage.DisplayName,
Tag = appLanguage.Name
};
this.cboLang.Items.Add(listItem);
}
string[] strArrays = Global.DefaultLanguage.Split(new char[] { '|' });
FormCtrl.SetComboItem(this.cboLang, strArrays[1]);
this.btn_SetLanguage.Enabled = true;
}
}
private void btn_ResetSets_Click(object sender, EventArgs e)
{
this.mnu_NewSetFile.Visible = false;
FormCtrl.ClearForm(this);
this.InitTree();
this.ClearPanelCallback();
this.ResetDates();
}
protected override void ProgressOperation_ProgressAdd(object sender, EventArgs e)
{
FormCtrl.Invoke(new Action(() =>
{
ProgressBarCtrl.Position++;
Application.DoEvents();
}));
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void FillNatddl()
{
dt = DBFun.FetchData("SELECT * FROM Nationality");
if (!DBFun.IsNullOrEmpty(dt))
{
FormCtrl.PopulateDDL(ddlNatID, dt, "NatName" + General.Lang(), "NatID", General.Msg("-Select Nationality-", "-اختر الجنسية-"));
rvNatID.InitialValue = ddlNatID.Items[0].Text;
}
}
protected override void ProgressOperation_ProgressChanged(object sender, ProChangedEventArgs e)
{
FormCtrl.Invoke(new Action(() =>
{
ProgressBarCtrl.Properties.Maximum = e.MaxValue;
ProgressBarCtrl.Position = e.CurValue;
Application.DoEvents();
}));
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Fillddl()
{
DataTable TmpDT = DBFun.FetchData("SELECT * FROM CardTemplate WHERE TmpType = 'VCard'");
if (!DBFun.IsNullOrEmpty(TmpDT))
{
FormCtrl.PopulateDDL(ddlTmpID, TmpDT, "TmpName", "TmpID", General.Msg("-Select Template-", "-اختر النموذج-"));
rvTmpID.InitialValue = ddlTmpID.Items[0].Value;
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Fillddl()
{
dt = DBFun.FetchData("SELECT * FROM Department");
if (!DBFun.IsNullOrEmpty(dt))
{
FormCtrl.PopulateDDL(ddlDepID, dt, "DepName" + FormSession.Language, "DepID", General.Msg("-Select Department-","-اختر القسم-")); //+ General.Lang()
rvDepID.InitialValue = ddlDepID.Items[0].Text;
ddlDepID.SelectedIndex = 1;
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
StringBuilder QS = new StringBuilder();
QS.Append(" SELECT * FROM VisitorsCard WHERE 1 = 1 ");
if (!string.IsNullOrEmpty(txtVisCardID.Text))
{
QS.Append(" AND VisCardID = '" + txtVisCardID.Text + "'");
}
if (!string.IsNullOrEmpty(txtVisIdentityNo.Text))
{
QS.Append(" AND VisIdentityNo = '" + txtVisIdentityNo.Text + "'");
}
if (!string.IsNullOrEmpty(txtVisNameAr.Text))
{
QS.Append(" AND VisNameAr LIKE '%" + txtVisNameAr.Text + "%'");
}
if (!string.IsNullOrEmpty(txtVisNameEn.Text))
{
QS.Append(" AND VisNameEn LIKE '%" + txtVisNameEn.Text + "%'");
}
if (!string.IsNullOrEmpty(txtVisMobileNo.Text))
{
QS.Append(" AND VisMobileNo = '" + txtVisMobileNo.Text + "'");
}
if (ddlCardstatus.SelectedIndex > 0)
{
QS.Append(" AND CardStatus = '" + ddlCardstatus.SelectedValue + "'");
}
if (ddlCreatedBy.SelectedIndex > 0)
{
QS.Append(" AND CreatedBy = '" + ddlCreatedBy.SelectedValue + "'");
}
if (ddlPrintedBy.SelectedIndex > 0)
{
QS.Append(" AND PrintedBy = '" + ddlPrintedBy.SelectedValue + "'");
}
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 Fillddl()
{
rvUsrLoginIDSearch.Enabled = true;
ddlUsrLoginID.Items.Clear();
dt = DBFun.FetchData("SELECT * FROM AppUsers");
if (!DBFun.IsNullOrEmpty(dt))
{
FormCtrl.PopulateDDL(ddlUsrLoginID, dt, "UsrLoginID", "UsrLoginID", General.Msg("-Select " + MainNameEn + "-", "-اختر " + MainName2Ar + "-"));
rvUsrLoginIDSearch.InitialValue = ddlUsrLoginID.Items[0].Text;
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void FillCompany()
{
DataTable DT = new DataTable();
DT = DBFun.FetchData("SELECT * FROM Companies ");
if (!DBFun.IsNullOrEmpty(DT))
{
FormCtrl.PopulateDDL2(ddlCompID, DT, General.Msg("CompNameEn", "CompNameAr"), "CompID", General.Msg("-All Company-", "-كل الشركات-"));
}
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void FillDDL()
{
//string IsApproved = "-100";
//if (FormSession.PermUsr.Contains("ACrd")) { IsApproved = "0"; } else if (FormSession.PermUsr.Contains("SACrd")) {IsApproved = "1"; }
dt = DBFun.FetchData("SELECT DISTINCT EmpID,EmpNameEn,EmpNameAr FROM CardInfoView WHERE CardStatus = 1 AND IsApproved = 0 ");
if (!DBFun.IsNullOrEmpty(dt)) { FormCtrl.PopulateDDL(ddlEmployee, dt, "EmpName" + General.Lang(), "EmpID", General.Msg("-Select Employee-","-اختر الموظف-")); }
dt = (DataTable)DBFun.FetchData("SELECT DISTINCT IsID,IsNameEn,IsNameAr FROM CardInfoView WHERE CardStatus = 1 AND IsApproved = 0 ");
if (!DBFun.IsNullOrEmpty(dt)) { FormCtrl.PopulateDDL(ddlIssue, dt, "IsName" + General.Lang(), "IsID", General.Msg("-Select Issue-","-اختر الإصدار-")); }
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Fillddl()
{
rfvddlIssue.Enabled = true;
ddlIssue.Items.Clear();
dt = DBFun.FetchData("SELECT * FROM IssueState WHERE IsType = '" + CardType + "'");
if (!DBFun.IsNullOrEmpty(dt))
{
FormCtrl.PopulateDDL(ddlIssue, dt, "IsName" + General.Lang(), "IsID", General.Msg("-Select Issue-", "-اختر الإصدار-"));
rfvddlIssue.InitialValue = ddlIssue.Items[0].Text;
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void FillIssue()
{
DataTable DT = new DataTable();
DT = DBFun.FetchData("SELECT * FROM IssueState WHERE IsType = 'Card'");
if (!DBFun.IsNullOrEmpty(DT))
{
FormCtrl.PopulateDDL(ddlIssue, DT, General.Msg("IsNameEn", "IsNameAr"), "IsID", General.Msg("-Select Issue-", "-اختر الإصدار-"));
rvIssue.InitialValue = ddlIssue.Items[0].Text;
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Fillddl()
{
ddlRoleID.Items.Clear();
rvRoleID.Enabled = true;
dt = DBFun.FetchData(MainQuery);
if (!DBFun.IsNullOrEmpty(dt))
{
FormCtrl.PopulateDDL(ddlRoleID, dt, "RoleName" + General.Lang(), "RoleID", General.Msg("-Select " + MainNameEn + "-", "-اختر " + MainName2Ar + "-"));
rvRoleID.InitialValue = ddlRoleID.Items[0].Text;
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Page_Load(object sender, EventArgs e)
{
//--Common Code----------------------------------------------------------------- //
FormSession.FillSession("Machines", pageDiv);
FormCtrl.RefreshGridEmpty(ref grdData, 20, "No Data Found", "لا توجد بيانات");
//--Common Code----------------------------------------------------------------- //
if (!IsPostBack)
{
FillGrid(MainQuery);
}
}
protected override void ProgressOperation_OperationFinished(object sender, EventArgs e)
{
FormCtrl.Invoke(new Action(() =>
{
FormCtrl.FormClosing -= OptForm_Closing;
var opt = sender as IProgressOperation;
opt.WriteLogFile();
ChangeView?.Invoke(false);
MessageBoxEx.ShowInfo(FormCtrl, "全部处理完成！");
RunningOpt = null;
}));
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void FillGrid()
{
dt = DBFun.FetchData(MainQuery);
if (!DBFun.IsNullOrEmpty(dt))
{
grdData.DataSource = (DataTable)dt;
grdData.DataBind();
}
else
{
FormCtrl.FillGridEmpty(ref grdData, 20, "No Data Found", "لا توجد بيانات");
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void FillGrid(string Q)
{
dt = DBFun.FetchData(Q);
if (!DBFun.IsNullOrEmpty(dt) && FormSession.PermUsr.Contains("S" + MainPer))
{
grdData.DataSource = (DataTable)dt;
grdData.DataBind();
}
else
{
FormCtrl.FillGridEmpty(ref grdData, 20, "No Data Found", "لا توجد بيانات");
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
public void FillGrdDocs(string pID)
{
DataTable DocDT = DBFun.FetchData(" SELECT * FROM EmployeeDocs WHERE EmpID = '" + pID + "'");
if (!DBFun.IsNullOrEmpty(DocDT))
{
grdDocs.DataSource = (DataTable)DocDT;
grdDocs.DataBind();
}
else
{
FormCtrl.FillGridEmpty(ref grdDocs, 20, "No Document", "لا توجد مستندات");
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
protected void Fillddl()
{
ddlBlaIdentityNo.Items.Clear();
rvBlaIdentityNo.Enabled = true;
dt = DBFun.FetchData(MainQuery);
if (!DBFun.IsNullOrEmpty(dt))
{
FormCtrl.PopulateDDL(ddlBlaIdentityNo, dt, "BlaIdentityNo", "BlaIdentityNo", General.Msg("-Select Identity No.-", "-اختر رقم الهوية-"));
rvBlaIdentityNo.InitialValue = ddlBlaIdentityNo.Items[0].Text;
}
FillNatddl();
}
