public void CheckRegistration() { chkSupply.Enabled = true; chkContract.Enabled = true; chkService.Enabled = true; DataTable dt = new DataTable(); DataTable dtt; DataView dv; bool bSCheck; bool bCCheck; bool bHCheck; bool bRSCheck; bool bRCCheck; bool bRHCheck; int lCount = 0; dt = m_oRegister.GetRegTrans(Convert.ToInt32(txtVendorName.Tag)); dv = new DataView(dt); if (m_lRegTransId != 0) { dv.RowFilter = "StatusType = 'B' and RegTransID < " + m_lRegTransId; } else { dv.RowFilter = "StatusType = 'B'"; } dtt = new DataTable(); dtt = dv.ToTable(); for (lCount = 0; lCount < dtt.Rows.Count; lCount++) { if (Convert.ToBoolean(dtt.Rows[lCount]["Supply"].ToString()) == true) { chkSupply.Checked = false; chkSupply.Enabled = false; } if (Convert.ToBoolean(dtt.Rows[lCount]["Contract"].ToString()) == true) { chkContract.Checked = false; chkContract.Enabled = false; } if (Convert.ToBoolean(dtt.Rows[lCount]["Service"].ToString()) == true) { chkService.Checked = false; chkService.Enabled = false; } } dv = new DataView(dt); if (m_lRegTransId != 0) { dv.RowFilter = "StatusType = 'S' and RegTransID < " + m_lRegTransId; } else { dv.RowFilter = "StatusType = 'S'"; } dtt = new DataTable(); dtt = dv.ToTable(); bSCheck = false; bCCheck = false; bHCheck = false; for (lCount = 0; lCount < dtt.Rows.Count; lCount++) { if (Convert.ToBoolean(dtt.Rows[lCount]["Supply"].ToString()) == true & bSCheck == false) { dtpSFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["STDate"].ToString()).AddDays(1); bSCheck = true; } if (Convert.ToBoolean(dtt.Rows[lCount]["Contract"].ToString()) == true & bCCheck == false) { dtpCFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["CTDate"].ToString()).AddDays(1); bCCheck = true; } if (Convert.ToBoolean(dtt.Rows[lCount]["Service"].ToString()) == true & bHCheck == false) { dtpHFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["HTDate"].ToString()).AddDays(1); bHCheck = true; } } dv = new DataView(dt); if (m_lRegTransId != 0) { dv.RowFilter = "StatusType = 'R' and RegTransID < " + m_lRegTransId; } else { dv.RowFilter = "StatusType = 'R'"; } dtt = new DataTable(); dtt = dv.ToTable(); bRSCheck = false; bRCCheck = false; bRHCheck = false; for (lCount = 0; lCount < dtt.Rows.Count; lCount++) { if (Convert.ToBoolean(dtt.Rows[lCount]["Supply"].ToString()) == true & bRSCheck == false) { if (dtpSFDate.Properties.MinValue < Convert.ToDateTime(dtt.Rows[lCount]["STDate"].ToString()).AddDays(1)) { dtpSFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["STDate"].ToString()).AddDays(1); bRSCheck = true; } } if (Convert.ToBoolean(dtt.Rows[lCount]["Contract"].ToString()) == true & bRCCheck == false) { if (dtpCFDate.Properties.MinValue < Convert.ToDateTime(dtt.Rows[lCount]["CTDate"].ToString()).AddDays(1)) { dtpCFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["CTDate"].ToString()).AddDays(1); bRCCheck = true; } } if (Convert.ToBoolean(dtt.Rows[lCount]["Service"].ToString()) == true & bRHCheck == false) { if (dtpHFDate.Properties.MinValue < Convert.ToDateTime(dtt.Rows[lCount]["HTDate"].ToString()).AddDays(1)) { dtpHFDate.Properties.MinValue = Convert.ToDateTime(dtt.Rows[lCount]["HTDate"].ToString()).AddDays(1); bRHCheck = true; } } } if ((bSCheck == false & bRSCheck == false) | (bCCheck == false & bRCCheck == false) | (bHCheck == false & bRHCheck == false)) { DataTable dtM = new DataTable(); dtM = m_oRegister.GetRegistration(Convert.ToInt32(txtVendorName.Tag)); if (dtM.Rows.Count > 0) { if (Convert.ToBoolean(dtM.Rows[0]["Supply"].ToString()) == true) { if (bSCheck == false & bRSCheck == false) { dtpSFDate.Properties.MinValue = Convert.ToDateTime(dtM.Rows[0]["STDate"].ToString()).AddDays(1); } } if (Convert.ToBoolean(dtM.Rows[0]["Contract"].ToString()) == true) { if (bCCheck == false & bRCCheck == false) { dtpCFDate.Properties.MinValue = Convert.ToDateTime(dtM.Rows[0]["CTDate"].ToString()).AddDays(1); } } if (Convert.ToBoolean(dtM.Rows[0]["Service"].ToString()) == true) { if (bHCheck == false & bRHCheck == false) { dtpHFDate.Properties.MinValue = Convert.ToDateTime(dtM.Rows[0]["HTDate"].ToString()).AddDays(1); } } } } }
private void PopulateData() { DataTable dt; dt = new DataTable(); dt = m_oRegister.GetRegistration(m_lVendorId); if (dt.Rows.Count > 0) { m_lRegisterId = Convert.ToInt32(dt.Rows[0]["RegisterId"].ToString()); dtpDate.Value = Convert.ToDateTime(dt.Rows[0]["RegDate"].ToString()); m_dOldDate = Convert.ToDateTime(dt.Rows[0]["RegDate"].ToString()); txtRegNo.Text = dt.Rows[0]["RegNo"].ToString(); if (Convert.ToBoolean(dt.Rows[0]["Supply"].ToString()) == true) { chkSupply.Checked = true; dtpSFDate.Value = Convert.ToDateTime(dt.Rows[0]["SFDate"].ToString()); dtpSTDate.Value = Convert.ToDateTime(dt.Rows[0]["STDate"].ToString()); if (Convert.ToBoolean(dt.Rows[0]["SLifeTime"].ToString()) == true) { chkSLife.Checked = true; } //txtSGradeName.Text = dt.Rows[0]["SGrade"].ToString(); //txtSGradeName.Tag = dt.Rows[0]["SGradeID"].ToString(); } if (Convert.ToBoolean(dt.Rows[0]["Contract"].ToString()) == true) { chkContract.Checked = true; dtpCFDate.Value = Convert.ToDateTime(dt.Rows[0]["CFDate"].ToString()); dtpCTDate.Value = Convert.ToDateTime(dt.Rows[0]["CTDate"].ToString()); if (Convert.ToBoolean(dt.Rows[0]["CLifeTime"].ToString()) == true) { chkCLife.Checked = true; } //txtCGradeName.Text = dt.Rows[0]["CGrade"].ToString(); //txtCGradeName.Tag = dt.Rows[0]["CGradeID"].ToString(); } if (Convert.ToBoolean(dt.Rows[0]["Service"].ToString()) == true) { chkService.Checked = true; dtpHFDate.Value = Convert.ToDateTime(dt.Rows[0]["HFDate"].ToString()); dtpHTDate.Value = Convert.ToDateTime(dt.Rows[0]["HTDate"].ToString()); if (Convert.ToBoolean(dt.Rows[0]["HLifeTime"].ToString()) == true) { chkHLife.Checked = true; } //txtHGradeName.Text = dt.Rows[0]["HGrade"].ToString(); //txtHGradeName.Tag = dt.Rows[0]["HGradeID"].ToString(); } txtRemarks.Text = dt.Rows[0]["Remarks"].ToString(); } if (m_lRegisterId != 0) { if (m_oRegister.CheckRegTrans(m_lVendorId) == true) { cmdRemove.Visible = false; cmdOK.Enabled = false; } else { cmdRemove.Visible = true; cmdOK.Enabled = true; } } UpdateRegNo(); }