public frm_HolderSearch(string HolderClass, bool isDelegate, PresentHolderCertsWithDelegate DelegateData, ref List <PresentHolderCertsWithDelegate> CertList) { InitializeComponent(); _Holder_Class = HolderClass; _isDelegate = isDelegate; _CertList = CertList; _Delagate_Data = DelegateData; }
private void btn_AddCerts_Click(object sender, EventArgs e) { PresentHolderCertsWithDelegate DelData = new PresentHolderCertsWithDelegate(0, string.Empty, string.Empty , string.Empty, string.Empty, string.Empty, 0, false, string.Empty, string.Empty, DateTime.MinValue , string.Empty, DateTime.MinValue, string.Empty, string.Empty, "Delegated", "توكيل", "Holder", SharedParam.CurrentUser.UserID); frm_HolderSearch frm = new frm_HolderSearch(CurrentHolderClass, false, DelData, ref HolderCertsList); frm.ShowDialog(); dgvCerts.DataSource = null; dgvCerts.DataSource = HolderCertsList; dgv_ApplyStyle(); }
void LoadReceptionData(string EntryNo) { string strsql = "SELECT TOP 1 * FROM [dbo].[v_DlgReception] WHERE [Entry_doc_no]=@Entry "; DataTable dt_Reception = Db.GetDataAsDataTable(strsql, "reception", "Entry", EntryNo); if (dt_Reception != null) { DataRow RecDR = dt_Reception.Rows[0]; txt_Q_HolderName.Text = RecDR["holder_name"].ToString(); txt_Q_ShareQty.Text = RecDR["share_qty"].ToString(); txt_H_HolderName.Text = RecDR["holder_name"].ToString(); txt_H_CertNo.Text = RecDR["Cert_No"].ToString(); txt_H_ShareQty.Text = RecDR["share_qty"].ToString(); txt_H_IdType.Text = RecDR["id_type_name"].ToString(); txt_H_IdNo.Text = RecDR["id_no"].ToString(); txt_H_IdDate.Text = (Utility.IsValidDate(RecDR["id_date"].ToString()) ? DateTime.Parse(RecDR["id_date"].ToString()).ToString("dd/MM/yyyy") : RecDR["id_date"].ToString()); txt_H_IdPlace.Text = RecDR["id_place"].ToString(); txt_H_IdTypeId.Text = RecDR["id_type"].ToString(); txt_H_CardNo.Text = RecDR["entry_card_no"].ToString(); // Get Reception Details strsql = "SELECT * FROM [dbo].[v_DlgReception_Details] WHERE [Entry_doc_no]=@Entry AND holder_class=@holderclass order by reception_type desc"; DataTable dt_ReceptionDetails = Db.GetDataAsDataTable(strsql, "DlgReceptionDetails", "Entry", EntryNo, "holderclass", CurrentHolderClass); if (dt_ReceptionDetails != null) { DataRow RecDetDR = dt_ReceptionDetails.Rows[0]; CurrentDelegateClass = RecDetDR["holder_class"].ToString(); txt_H_DlgName.Text = RecDetDR["Dlg_Name"].ToString(); txt_H_DlgNo.Text = RecDetDR["Dlg_no"].ToString(); txt_H_DlgDate.Text = (Utility.IsValidDate(RecDetDR["Dlg_date"].ToString())?DateTime.Parse(RecDetDR["Dlg_date"].ToString()).ToString("dd/MM/yyyy"): RecDetDR["Dlg_date"].ToString()); txt_H_ApprovedNo.Text = RecDetDR["Approved_no"].ToString(); txt_H_ApprovedDate.Text = (Utility.IsValidDate(RecDetDR["Dlg_date"].ToString()) ? DateTime.Parse(RecDetDR["Approved_date"].ToString()).ToString("dd/MM/yyyy") : RecDetDR["Approved_date"].ToString()); txt_H_ApprovedOrg.Text = RecDetDR["Approved_org"].ToString(); // build Cert List ... HolderCertsList = new List <PresentHolderCertsWithDelegate>(); //HolderCertsList.Clear(); foreach (DataRow dr in dt_ReceptionDetails.Rows) { PresentHolderCertsWithDelegate tmp = new PresentHolderCertsWithDelegate( (int)dr["share_qty"], dr["cert_no"].ToString(), dr["holder_name"].ToString(), dr["holder_class_name"].ToString() , dr["holder_class"].ToString(), dr["CertRowId"].ToString(), (int)dr["Entry_doc_no"], (bool)dr["Delagate"] , dr["Dlg_no"].ToString(), dr["Dlg_Name"].ToString(), (DateTime)dr["Dlg_date"], dr["Approved_no"].ToString() , (DateTime)dr["Approved_date"], dr["Approved_org"].ToString(), dr["note"].ToString(), dr["Delegate_Type"].ToString() , dr["Delegate_Type_Name"].ToString(), dr["reception_type"].ToString(), dr["userid"].ToString()); HolderCertsList.Add(tmp); } dgvCerts.DataSource = null; dgvCerts.DataSource = HolderCertsList; dgv_ApplyStyle(); } } }
private void AddCertsToList() { int shares = 0; string CertNo = string.Empty; string HolderName = string.Empty; string ClassName = string.Empty; string ClassId = string.Empty; string RowId = string.Empty; for (int i = 0; i < dgvCerts.Rows.Count; ++i) { if (!DBNull.Equals(dgvCerts["select", i].Value, null) && Boolean.Parse(dgvCerts["select", i].Value.ToString()) == true) { shares = (int)dgvCerts["share_qty", i].Value; CertNo = dgvCerts["cert_no", i].Value.ToString(); HolderName = dgvCerts["holder_name", i].Value.ToString(); ClassName = dgvCerts["class_name", i].Value.ToString(); ClassId = dgvCerts["holder_class", i].Value.ToString(); RowId = dgvCerts["rowid", i].Value.ToString(); if (shares > 0 && dgvCerts["status", i].Value.ToString() == "0") { PresentHolderCertsWithDelegate tmp = new PresentHolderCertsWithDelegate(shares, CertNo, HolderName, ClassName, ClassId, RowId, 0 , _Delagate_Data.IsDelagated, _Delagate_Data.DlgNo, _Delagate_Data.DlgName, _Delagate_Data.DlgDate, _Delagate_Data.ApprovedNo , _Delagate_Data.ApprovedDate, _Delagate_Data.ApprovedOrg, _Delagate_Data.Note, _Delagate_Data.Delegate_Type , _Delagate_Data.Delegate_Type_Name, _Delagate_Data.Reception_Type, SharedParam.CurrentUser.UserID); if (!object.ReferenceEquals(_CertList, null)) { PresentHolderCertsWithDelegate tmp2 = _CertList.Find(t => t.CertNo == CertNo); if (tmp2 == null) { _CertList.Add(tmp); } } else { _CertList = new List <PresentHolderCertsWithDelegate>(); _CertList.Add(tmp); } } } } }
private void btn_AddCerts_Click(object sender, EventArgs e) { if (CheckDelegationRequiredData()) { PresentHolderCertsWithDelegate DelData = new PresentHolderCertsWithDelegate(0, string.Empty, string.Empty , string.Empty, string.Empty, string.Empty, 0, true, txt_H_DlgNo.Text, txt_H_DlgName.Text, DateTime.Parse(txt_H_DlgDate.Text) , txt_H_ApprovedNo.Text, DateTime.Parse(txt_H_ApprovedDate.Text), txt_H_ApprovedOrg.Text, txt_H_Note.Text , coDelegateType.SelectedValue.ToString(), coDelegateType.Text, "HolderDelagate", SharedParam.CurrentUser.UserID); if (object.ReferenceEquals(HolderCertsList, null)) { HolderCertsList = new List <PresentHolderCertsWithDelegate>(); } frm_HolderSearch frm = new frm_HolderSearch(CurrentHolderClass, true, DelData, ref HolderCertsList); frm.ShowDialog(); dgvCerts.DataSource = null; dgvCerts.DataSource = HolderCertsList; dgv_ApplyStyle(); } }
private void btn_Q_Next_Click(object sender, EventArgs e) { ArrangePanels("pnl_Holder"); CurrentStepName = "Holder"; btn_H_Prev.Enabled = true; txt_H_CertNo.Text = txt_Q_CertNo.Text; txt_H_HolderName.Text = txt_Q_HolderName.Text; txt_H_ShareQty.Text = txt_Q_ShareQty.Text; DataTable dt; if (CurrentHolderNo > 0) { dt = Db.GetDataAsDataTableFromSP("sp_GetHoldersByHolderNo", "HolderCerts", "HolderNo", CurrentHolderNo.ToString() , "HolderClass", CurrentHolderClass, "Status", "0"); } else { dt = Db.GetDataAsDataTableFromSP("sp_GetHoldersByCert", "Holders", "CertNo", txt_Q_CertNo.Text, "HolderClass", CurrentHolderClass, "status", "0"); } if (dt != null) { HolderCertsList = new List <PresentHolderCertsWithDelegate>(); foreach (DataRow HolderCertDataRow in dt.Rows) { PresentHolderCertsWithDelegate PHCert = new PresentHolderCertsWithDelegate((int)HolderCertDataRow["share_qty"], HolderCertDataRow["cert_no"].ToString() , HolderCertDataRow["holder_name"].ToString(), HolderCertDataRow["class_name"].ToString() , HolderCertDataRow["holder_class"].ToString(), HolderCertDataRow["rowid"].ToString(), 0 , false, "000", string.Empty, DateTime.MinValue, "000", DateTime.MinValue, string.Empty , string.Empty, "Delegated", "توكيل", "Holder", SharedParam.CurrentUser.UserID); CertsCount += 1; TotalShares += (int)HolderCertDataRow["share_qty"]; HolderCertsList.Add(PHCert); } dgvCerts.DataSource = HolderCertsList; txtTotalCerts.Text = CertsCount.ToString("N0"); txtTotalShares.Text = TotalShares.ToString("N0"); dgv_ApplyStyle(); } }
private void btnAddAgentCerts_Click(object sender, EventArgs e) { //if (CheckDelegationRequiredData()) //{ PresentHolderCertsWithDelegate DelData = new PresentHolderCertsWithDelegate(0, string.Empty, string.Empty , string.Empty, string.Empty, string.Empty, 0, false, string.Empty, string.Empty, DateTime.MinValue , string.Empty, DateTime.MinValue, string.Empty, string.Empty, coDelegateType.SelectedValue.ToString() , string.Empty, "Holder", SharedParam.CurrentUser.UserID); if (object.ReferenceEquals(HolderCertsList, null)) { HolderCertsList = new List <PresentHolderCertsWithDelegate>(); } frm_HolderSearch frm = new frm_HolderSearch(CurrentHolderClass, true, DelData, ref HolderCertsList); frm.ShowDialog(); dgvCerts.DataSource = null; dgvCerts.DataSource = HolderCertsList; dgv_ApplyStyle(); //} }