private void FrmUpdateKennelType_Load(object sender, EventArgs e)
{
//load combo with kennel type from rates table
DataSet ds = new DataSet();
ds = Rates.getktype(ds);
for (int i = 0; i < ds.Tables["kt"].Rows.Count; i++)
{
cboKennel_Type.Items.Add(ds.Tables[0].Rows[i][0].ToString());
}
}
public void loadCombo()
{
//load combo with kennel type from rates table
DataSet ds = new DataSet();
ds = Rates.getktype(ds);
cboKennelTypes.Items.Clear();
cboKennelTypes.SelectedIndex = -1;
cboKennelTypes.Items.Add("Select Kennel Type");
for (int i = 0; i < ds.Tables["kt"].Rows.Count; i++)
{
cboKennelTypes.Items.Add(ds.Tables[0].Rows[i][0].ToString());
}
}
private void cboKennel_Type_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboKennel_Type.SelectedIndex == -1)
{
return;
}
Rates updateKennel = new Rates();
updateKennel.getkennelDetails(cboKennel_Type.Text);
txtDesc.Text = updateKennel.getDesc();
txtRate.Text = updateKennel.getRate().ToString();
grpUpdateKennelType.Visible = true;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
//validation
if (txtDesc.Text.Equals(""))
{
MessageBox.Show("Please give desciption of kennel");
txtDesc.Focus();
return;
}
decimal parsedValue;
if (!Decimal.TryParse(txtRate.Text, out parsedValue))
{
MessageBox.Show("This is a number only field");
txtRate.Focus();
return;
}
else if (parsedValue < 0)
{
MessageBox.Show("The value must be above 0");
txtRate.Focus();
return;
}
//update kennel type
Rates UpdatekennelType = new Rates(cboKennel_Type.Text.ToUpper(), txtDesc.Text.ToUpper(), Convert.ToDecimal(txtRate.Text));
//save data in Rates Table
UpdatekennelType.updKennelType();
//confirmation message
MessageBox.Show("Kennel type " + cboKennel_Type.Text.ToUpper() + " has been updated", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
//reset UI
grpUpdateKennelType.Visible = false;
cboKennel_Type.SelectedIndex = -1;
}
