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