private void fillGrid() { if (selectedIds.Count == 0) { return; } InsuranceInfoBS bs = new InsuranceInfoBS(); InsuranceInfoData data = bs.getByIds(selectedIds); DataRowCollection rows = data.Tables[0].Rows; for (int i = 0; i < rows.Count; i++) { long id = (long)rows[i][InsuranceInfoData.id_FIELD]; Object[] row = new object[8]; row[0] = i + 1; row[1] = ""; row[2] = ""; row[3] = rows[i][InsuranceInfoData.mobileNumber_FIELD]; row[4] = rows[i][InsuranceInfoData.name_FIELD]; row[5] = rows[i][InsuranceInfoData.family_FIELD]; row[6] = rows[i][InsuranceInfoData.insuranceNumber_FIELD]; row[7] = rows[i][InsuranceInfoData.id_FIELD] = id; dataGridView1.Rows.Add(row); } }
private void initForm() { isDeleted = false; if (_id > 0) { InsuranceInfoData data = insuranceInfoBs.getById(_id); txtName.Text = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.name_FIELD].ToString(); cmbCustomerType.SelectedIndex = (int)data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.CustomerType_FIELD]; txtFamily.Text = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.family_FIELD].ToString(); txtPhoneNumber.Text = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.phoneNumber_FIELD].ToString(); txtMobilePhone.Text = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.mobileNumber_FIELD].ToString(); txtBirthDate.Text = toShamsiString(data, InsuranceInfoData.BirthDate_FIELD); txtAddress.Text = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.address_FIELD].ToString(); selectComboItemForInsuraceType(int.Parse( data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.insuranceType_FIELD].ToString())); txtInsuranceNumber.Text = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.insuranceNumber_FIELD].ToString(); txtBeginDate.Text = toShamsiString(data, InsuranceInfoData.beginDate_FIELD); txtEndDate.Text = toShamsiString(data, InsuranceInfoData.endDate_FIELD); txtLastUpdateDate.Text = toShamsiString(data, InsuranceInfoData.creationDate_FIELD); txtCreationDate.Text = toShamsiString(data, InsuranceInfoData.lastUpdateDate_FIELD); txtDescription.Text = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.description_FIELD].ToString(); } else { linkAttachment.Enabled = false; txtCreationDate.Text = getTodayShamsi(); txtLastUpdateDate.Text = getTodayShamsi(); } }
public string getEndDateByInsuranceNumer(string insNum) { InsuranceInfoData data = _insuranceInfoDAL.getByInsuranceNumer(insNum); string enddate = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][InsuranceInfoData.endDate_FIELD].ToString(); return(enddate); }
public InsuranceInfoData load(string condition) { InsuranceInfoData ds = new InsuranceInfoData(); dp.loadToDataSet(InsuranceInfoData.insuranceInfo_TABLE, ds, "(cancel is null or cancel=0)" + condition); fillRadif(ds); return(ds); }
private String toShamsiString(InsuranceInfoData data, string fieldName) { Object obj = data.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows[0][fieldName]; if (obj != null && obj.ToString().Length > 0) { return(RMX_TOOLS.date.DateXFormer.gregorianToPersianString((DateTime)obj)); } return(""); }
private void checkForLogging(int insuranceInfoId, string endDateStr) { InsuranceInfoBS insBS = new InsuranceInfoBS(); InsuranceInfoData insData = insBS.getById(insuranceInfoId); if (insData.Tables[0].Rows.Count > 0) { Boolean haveDid = Boolean.Parse(insData.Tables[0].Rows[0][InsuranceInfoData.haveDid_FIELD].ToString()); if (haveDid == false) { addlog(true, insuranceInfoId, endDateStr); } } }
public Boolean checkInsuranceNumberExists(string insNumber, int index) { InsuranceInfoData dataSet = new InsuranceInfoData(); //string query = "SELECT * FROM INSURACEINFO WHERE INSURANCENUMBER = '" + insNumber + "'"; string cond = "INSURANCENUMBER = '" + insNumber + "'"; if (index >= 0) { cond += "and id <>" + index; } dp.loadToDataSet("INSURANCEINFO", dataSet, cond); if (dataSet.Tables[0].Rows.Count <= 0) { return(false); } else { return(true); } }
private void btnUpdate_Click(object sender, EventArgs e) { string check = checkData(); if (check != null) { MessageBox.Show(check); return; } if (dataMode == EDIT_MODE) { if (dataGridView1.CurrentRow.Selected) { if (cbxHaveDid.Checked) { cbxHaveDid.Checked = Boolean.Parse(_gridTools.getCurrentRowValue(InsuranceInfoData.haveDid_FIELD).ToString()); } } } if (dataMode == NEW_MODE) { cbxHaveDid.Checked = false; } if (dataGridView1.RowCount <= 0) { dataMode = NEW_MODE; } InsuranceInfoBS isb = new InsuranceInfoBS(); InsuranceInfoData inData = new InsuranceInfoData(); DataRow dr = inData.Tables[InsuranceInfoData.insuranceInfo_TABLE].NewRow(); dr[InsuranceInfoData.name_FIELD] = txtName.Text.Trim(); dr[InsuranceInfoData.family_FIELD] = txtFamily.Text.Trim(); dr[InsuranceInfoData.phoneNumber_FIELD] = txtPhoneNumber.Text.Trim(); dr[InsuranceInfoData.insuranceNumber_FIELD] = txtInsuranceNumber.Text.Trim(); dr[InsuranceInfoData.haveDid_FIELD] = cbxHaveDid.Checked; dr[InsuranceInfoData.address_FIELD] = txtAddress.Text.Trim(); dr[InsuranceInfoData.description_FIELD] = txtDescription.Text.Trim(); dr[InsuranceInfoData.mobileNumber_FIELD] = txtMobilePhone.Text.Trim(); dr[InsuranceInfoData.CustomerType_FIELD] = cmbCustomerType.SelectedIndex; if (!dataMode.Equals(NEW_MODE)) { dr[InsuranceInfoData.id_FIELD] = _gridTools.getCurrentRowValue(InsuranceInfoData.id_FIELD); } // Date validation and converion #region dateValidation GregorianCalendar gcal = new GregorianCalendar(); int d = 12; int m = 0; int y = 0; CheckDate.checkDate(txtBeginDate.Text, ref y, ref m, ref d); DateTime persianDateDime = new DateTime(y, m, d, new PersianCalendar()); DateTime greorianDateTime = new DateTime(gcal.GetYear(persianDateDime), gcal.GetMonth(persianDateDime), gcal.GetDayOfMonth(persianDateDime), new GregorianCalendar()); dr[InsuranceInfoData.beginDate_FIELD] = greorianDateTime; // CheckDate.checkDate(txtEndDate.Text, ref y, ref m, ref d); persianDateDime = new DateTime(y, m, d, new PersianCalendar()); greorianDateTime = new DateTime(gcal.GetYear(persianDateDime), gcal.GetMonth(persianDateDime), gcal.GetDayOfMonth(persianDateDime), new GregorianCalendar()); dr[InsuranceInfoData.endDate_FIELD] = greorianDateTime; // //Creation Date String todayShamsi; String[] dateArr; CheckDate.checkDate(txtCreationDate.Text, ref y, ref m, ref d); if (dataMode.Equals(NEW_MODE)) { todayShamsi = RMX_TOOLS.date.DateXFormer.gregorianToPersianString(DateTime.Now); dateArr = todayShamsi.Split('/'); persianDateDime = new DateTime(int.Parse(dateArr[0]), int.Parse(dateArr[1]), int.Parse(dateArr[2]), new PersianCalendar()); } else { persianDateDime = new DateTime(y, m, d, new PersianCalendar()); } greorianDateTime = new DateTime(gcal.GetYear(persianDateDime), gcal.GetMonth(persianDateDime), gcal.GetDayOfMonth(persianDateDime), new GregorianCalendar()); dr[InsuranceInfoData.creationDate_FIELD] = greorianDateTime; // //Last update date todayShamsi = RMX_TOOLS.date.DateXFormer.gregorianToPersianString(DateTime.Now); dateArr = todayShamsi.Split('/'); persianDateDime = new DateTime(int.Parse(dateArr[0]), int.Parse(dateArr[1]), int.Parse(dateArr[2]), new PersianCalendar()); greorianDateTime = new DateTime(gcal.GetYear(persianDateDime), gcal.GetMonth(persianDateDime), gcal.GetDayOfMonth(persianDateDime), new GregorianCalendar()); dr[InsuranceInfoData.lastUpdateDate_FIELD] = greorianDateTime; // //Birth date if (txtBirthDate.Text.Trim() != DateConstants.NULL_Date.Trim()) { CheckDate.checkDate(txtBirthDate.Text, ref y, ref m, ref d); persianDateDime = new DateTime(y, m, d, new PersianCalendar()); greorianDateTime = new DateTime(gcal.GetYear(persianDateDime), gcal.GetMonth(persianDateDime), gcal.GetDayOfMonth(persianDateDime), new GregorianCalendar()); dr[InsuranceInfoData.BirthDate_FIELD] = greorianDateTime; } #endregion //fetch id from comboBox int id = int.Parse(cmbInsuranceType.SelectedValue + ""); dr[InsuranceInfoData.insuranceType_FIELD] = id; string insuranceNumber = txtInsuranceNumber.Text.Trim(); inData.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows.Add(dr); try { int index; if (dataMode == NEW_MODE) { index = -1; } else { index = int.Parse(_gridTools.getCurrentRowValue(InsuranceInfoData.id_FIELD).ToString()); } if (isb.checkInsuranceNumberExists(txtInsuranceNumber.Text.Trim(), index)) { MessageBox.Show("امکان اضافه کردن این رکورد وجود ندارد ، شماره بیمه تکراری است"); txtInsuranceNumber.Focus(); return; } if (dataMode.Equals(NEW_MODE)) { isb.add(inData); InsuranceInfoData iData = isb.getByInsuranceNumer(txtInsuranceNumber.Text.Trim()); if (iData.Tables[0].Rows.Count > 0) { addlog(cbxHaveDid.Checked, int.Parse(iData.Tables[0].Rows[0][InsuranceInfoData.id_FIELD].ToString()), iData.Tables[0].Rows[0][InsuranceInfoData.endDate_FIELD].ToString()); } } else if (dataMode.Equals(EDIT_MODE)) { if (cbxHaveDid.Checked) { checkForLogging(int.Parse(_gridTools.getCurrentRowValue(InsuranceInfoData.id_FIELD).ToString()), _gridTools.getCurrentRowValue(InsuranceInfoData.endDate_FIELD).ToString()); } isb.update(inData); } } catch (Exception ex) { string s = ex.ToString(); if (s.IndexOf("duplicate") >= 0) { MessageBox.Show("امکان اضافه کردن این رکورد وجود ندارد ، شماره بیمه تکراری است"); txtInsuranceNumber.Focus(); } else { MessageBox.Show(ex.ToString()); } return; } btnRefresh_Click(null, null); MainForm.MainFormInstance.fillGrid(); int addedRow = searcInGrid(insuranceNumber); if (addedRow == -1) { dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.RowCount - 1].Cells[0]; } else { dataGridView1.CurrentCell = dataGridView1.Rows[addedRow].Cells[0]; } dataGridView1_SelectionChanged(null, null); dataMode = EDIT_MODE; fillSearchMap(); MainForm.MainFormInstance.msDoAgantsJobDirectly(); //frmMain.msDoAgantsJobDirectly(); }
private void btnUpdate_Click(object sender, EventArgs e) { string check = checkData(); if (check != null) { MessageBox.Show(check); return; } InsuranceInfoData inData = new InsuranceInfoData(); DataRow dr = inData.Tables[InsuranceInfoData.insuranceInfo_TABLE].NewRow(); dr[InsuranceInfoData.id_FIELD] = _id; dr[InsuranceInfoData.name_FIELD] = txtName.Text.Trim(); dr[InsuranceInfoData.family_FIELD] = txtFamily.Text.Trim(); dr[InsuranceInfoData.phoneNumber_FIELD] = txtPhoneNumber.Text.Trim(); dr[InsuranceInfoData.insuranceNumber_FIELD] = txtInsuranceNumber.Text.Trim(); dr[InsuranceInfoData.haveDid_FIELD] = cbxHaveDid.Checked; dr[InsuranceInfoData.address_FIELD] = txtAddress.Text.Trim(); dr[InsuranceInfoData.description_FIELD] = txtDescription.Text.Trim(); dr[InsuranceInfoData.mobileNumber_FIELD] = txtMobilePhone.Text.Trim(); dr[InsuranceInfoData.CustomerType_FIELD] = cmbCustomerType.SelectedIndex; #region dateValidation GregorianCalendar gcal = new GregorianCalendar(); int d = 12; int m = 0; int y = 0; CheckDate.checkDate(txtBeginDate.Text, ref y, ref m, ref d); DateTime persianDateTime = new DateTime(y, m, d, new PersianCalendar()); DateTime greorianDateTime = new DateTime(gcal.GetYear(persianDateTime), gcal.GetMonth(persianDateTime), gcal.GetDayOfMonth(persianDateTime), new GregorianCalendar()); dr[InsuranceInfoData.beginDate_FIELD] = greorianDateTime; // CheckDate.checkDate(txtEndDate.Text, ref y, ref m, ref d); persianDateTime = new DateTime(y, m, d, new PersianCalendar()); greorianDateTime = new DateTime(gcal.GetYear(persianDateTime), gcal.GetMonth(persianDateTime), gcal.GetDayOfMonth(persianDateTime), new GregorianCalendar()); dr[InsuranceInfoData.endDate_FIELD] = greorianDateTime; // //Creation Date String todayShamsi; String[] dateArr; CheckDate.checkDate(txtCreationDate.Text, ref y, ref m, ref d); persianDateTime = new DateTime(y, m, d, new PersianCalendar()); greorianDateTime = new DateTime(gcal.GetYear(persianDateTime), gcal.GetMonth(persianDateTime), gcal.GetDayOfMonth(persianDateTime), new GregorianCalendar()); dr[InsuranceInfoData.creationDate_FIELD] = greorianDateTime; // //Last update date todayShamsi = RMX_TOOLS.date.DateXFormer.gregorianToPersianString(DateTime.Now); dateArr = todayShamsi.Split('/'); persianDateTime = new DateTime(int.Parse(dateArr[0]), int.Parse(dateArr[1]), int.Parse(dateArr[2]), new PersianCalendar()); greorianDateTime = new DateTime(gcal.GetYear(persianDateTime), gcal.GetMonth(persianDateTime), gcal.GetDayOfMonth(persianDateTime), new GregorianCalendar()); dr[InsuranceInfoData.lastUpdateDate_FIELD] = greorianDateTime; // //Birth date if (txtBirthDate.Text.Trim() != DateConstants.NULL_Date.Trim()) { CheckDate.checkDate(txtBirthDate.Text, ref y, ref m, ref d); persianDateTime = new DateTime(y, m, d, new PersianCalendar()); greorianDateTime = new DateTime(gcal.GetYear(persianDateTime), gcal.GetMonth(persianDateTime), gcal.GetDayOfMonth(persianDateTime), new GregorianCalendar()); dr[InsuranceInfoData.BirthDate_FIELD] = greorianDateTime; } #endregion //fetch id from comboBox int insuranceTypeId = int.Parse(cmbInsuranceType.SelectedValue + ""); dr[InsuranceInfoData.insuranceType_FIELD] = insuranceTypeId; string insuranceNumber = txtInsuranceNumber.Text.Trim(); inData.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows.Add(dr); try { if (insuranceInfoBs.checkInsuranceNumberExists(txtInsuranceNumber.Text.Trim(), _id)) { MessageBox.Show("امکان اضافه کردن این رکورد وجود ندارد ، شماره بیمه تکراری است"); txtInsuranceNumber.Focus(); return; } if (cbxHaveDid.Checked) { string endDate = insuranceInfoBs.getEndDateByInsuranceNumer(txtInsuranceNumber.Text.Trim()); checkForLogging(_id, endDate); } if (_id > 0) { insuranceInfoBs.update(inData); } else { insuranceInfoBs.add(inData); } this.Close(); } catch (Exception ex) { string s = ex.ToString(); if (s.IndexOf("duplicate") >= 0) { MessageBox.Show("امکان اضافه کردن این رکورد وجود ندارد ، شماره بیمه تکراری است"); txtInsuranceNumber.Focus(); } else { MessageBox.Show(ex.ToString()); } return; } // MainForm.MainFormInstance.fillGrid(); }
public int update(InsuranceInfoData dataSet) { return(_insuranceInfoDAL.update(dataSet)); }
public int add(InsuranceInfoData dataSet) { return(_insuranceInfoDAL.add(dataSet)); }
public int update(InsuranceInfoData dataSet) { return(dp.update(dataSet, InsuranceInfoData.insuranceInfo_TABLE)); }
public int add(InsuranceInfoData dataSet) { return(dp.add(dataSet, InsuranceInfoData.insuranceInfo_TABLE)); }
private void btnUpdate_Click(object sender, EventArgs e) { string check = checkData(); if (check != null) { MessageBox.Show(check); return; } if (_gridTools.getCurrentRowValue(InsuranceInfoData.id_FIELD) == null) { return; } InsuranceInfoBS isb = new InsuranceInfoBS(); InsuranceInfoData inData = new InsuranceInfoData(); DataRow dr = inData.Tables[InsuranceInfoData.insuranceInfo_TABLE].NewRow(); // if (cmbHaveDid.SelectedIndex == 1) // dr[InsuranceInfoData.haveDid_FIELD] = true; // if (cmbHaveDid.SelectedIndex == 2) // dr[InsuranceInfoData.haveDid_FIELD] = false; dr[InsuranceInfoData.name_FIELD] = txtName.Text; dr[InsuranceInfoData.family_FIELD] = txtFamily.Text; dr[InsuranceInfoData.phoneNumber_FIELD] = txtPhoneNumber.Text; dr[InsuranceInfoData.insuranceNumber_FIELD] = txtInsuranceNumber.Text; dr[InsuranceInfoData.id_FIELD] = _gridTools.getCurrentRowValue(InsuranceInfoData.id_FIELD); dr[InsuranceInfoData.address_FIELD] = _gridTools.getCurrentRowValue(InsuranceInfoData.address_FIELD); dr[InsuranceInfoData.haveDid_FIELD] = _gridTools.getCurrentRowValue(InsuranceInfoData.haveDid_FIELD); dr[InsuranceInfoData.cancel_FIELD] = _gridTools.getCurrentRowValue(InsuranceInfoData.cancel_FIELD); dr[InsuranceInfoData.address_FIELD] = txtAddress.Text.Trim(); dr[InsuranceInfoData.description_FIELD] = txtDescription.Text.Trim(); // Date validation and converion #region dateValidation GregorianCalendar gcal = new GregorianCalendar(); int d = 0; int m = 0; int y = 0; CheckDate.checkDate(txtBeginDate.Text, ref y, ref m, ref d); DateTime persianDateDime = new DateTime(y, m, d, new PersianCalendar()); DateTime greorianDateTime = new DateTime(gcal.GetYear(persianDateDime), gcal.GetMonth(persianDateDime), gcal.GetDayOfMonth(persianDateDime), new GregorianCalendar()); dr[InsuranceInfoData.beginDate_FIELD] = greorianDateTime; CheckDate.checkDate(txtEndDate.Text, ref y, ref m, ref d); persianDateDime = new DateTime(y, m, d, new PersianCalendar()); greorianDateTime = new DateTime(gcal.GetYear(persianDateDime), gcal.GetMonth(persianDateDime), gcal.GetDayOfMonth(persianDateDime), new GregorianCalendar()); dr[InsuranceInfoData.endDate_FIELD] = greorianDateTime; #endregion //fetch id from comboBox int id = int.Parse(cmbInsuranceType.SelectedValue + ""); dr[InsuranceInfoData.insuranceType_FIELD] = id; inData.Tables[InsuranceInfoData.insuranceInfo_TABLE].Rows.Add(dr); isb.update(inData); string insuranceNumber = txtInsuranceNumber.Text.Trim(); fillGrid(_condition); int addedRow = searcInGrid(insuranceNumber); if (addedRow == -1) { dataGridView1.Rows[dataGridView1.RowCount - 1].Selected = true; } else { dataGridView1.Rows[addedRow].Selected = true; } MainForm.MainFormInstance.fillGrid(); MessageBox.Show("به روز رسانی انجام شد"); }