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