private void fillInsuranceTypeCmboBox() { InsuranceTypeData dataSet = new InsuranceTypeBS().laod(); cmbInsuranceType.DataSource = dataSet.Tables[InsuranceTypeData.InsuranceType_TABLE]; cmbInsuranceType.DisplayMember = InsuranceTypeData.InsuranceCaption_FIELD; cmbInsuranceType.ValueMember = InsuranceTypeData.InsuranceId_FIELD; }
private void fillInsuranceTypeCmboBox() { cmbInsuranceType.Items.Clear(); int userId = int.Parse(UsersBS.loginedUser.Tables[UsersData.users_TABLE].Rows[0][UsersData.id_FIELD] + ""); InsuranceTypeData dataSet = new InsuranceTypeBS().userLimitedList(); //add empty row DataRow dr = dataSet.Tables[0].NewRow(); dr[InsuranceTypeData.InsuranceCaption_FIELD] = ""; dr[InsuranceTypeData.InsuranceId_FIELD] = 0; dataSet.Tables[0].Rows.InsertAt(dr, 0); // cmbInsuranceType.DataSource = dataSet.Tables[InsuranceTypeData.InsuranceType_TABLE]; cmbInsuranceType.DisplayMember = InsuranceTypeData.InsuranceCaption_FIELD; cmbInsuranceType.ValueMember = InsuranceTypeData.InsuranceId_FIELD; }
private void btnDelete_Click(object sender, EventArgs e) { InsuranceTypeBS isb = new InsuranceTypeBS(); string idStr = _gridTools.getCurrentRowValue(InsuranceTypeData.InsuranceId_FIELD) + ""; if (idStr == null || idStr.Length <= 0) { return; } DialogResult dr = MessageBox.Show("آیا مایلید حذف کنید ؟", "", MessageBoxButtons.YesNo); if (dr.Equals(DialogResult.Yes)) { int id = int.Parse(idStr); InsuranceTypeData inData = new InsuranceTypeData(); int n = isb.delete(id); if (n == 0) // there is an error in deleting { MessageBox.Show("امکان حذف این مقدار وجود ندارد"); } emptyForm(); fillGrid(); } }
private void btnUpdate_Click(object sender, EventArgs e) { int id = -1; if (dataGridView1.RowCount <= 0) { dataMode = NEW_MODE; } if (!dataMode.Equals(NEW_MODE)) { id = int.Parse(_gridTools.getCurrentRowValue(InsuranceTypeData.InsuranceId_FIELD) + ""); } string caption = _gridTools.getCurrentRowValue(InsuranceTypeData.InsuranceCaption_FIELD) + ""; InsuranceTypeBS isb = new InsuranceTypeBS(); string strCaption = this.txtInsuranceType.Text; if (strCaption.Trim().Length <= 0) { txtInsuranceType.Focus(); MessageBox.Show("لطفا یک مقدار برای نوع بیمه وارد کنید"); return; } string str = this.cmbDaysBeforExp.Text; int d = 0; if (str.Trim().Length <= 0) { cmbDaysBeforExp.Focus(); MessageBox.Show("لطفا یک مقدار برای نوع بیمه وارد کنید"); return; } try { d = int.Parse(str); } catch (Exception ex) { cmbDaysBeforExp.Focus(); MessageBox.Show("عدد وارد شده برای روز صحیح نیست"); return; } string colorStr = ColorTranslator.ToHtml(pnlColor.BackColor); InsuranceTypeData inData = new InsuranceTypeData(); DataRow dr = inData.Tables[InsuranceTypeData.InsuranceType_TABLE].NewRow(); dr[InsuranceTypeData.InsuranceCaption_FIELD] = strCaption; dr[InsuranceTypeData.DAYSBEFOREXP_FIELD] = d; dr[InsuranceTypeData.InsuranceId_FIELD] = id; dr[InsuranceTypeData.INSURANCETYPECOLOR_FIELD] = colorStr; inData.Tables[InsuranceTypeData.InsuranceType_TABLE].Rows.Add(dr); if (dataMode.Equals(NEW_MODE)) { isb.add(inData); } else if (dataMode.Equals(EDIT_MODE)) { isb.update(inData); } dataMode = EDIT_MODE; btnRefresh_Click(null, null); fillGrid(); }
public InsuranceTypeForm() { InitializeComponent(); _insuranceTypeBS = new InsuranceTypeBS(); _gridTools = new GridTools(dataGridView1); }