private void Form_vehicle_return_Shown(object sender, EventArgs e)
{
using (Vehicle_ds.sp_select_vehicleDataTable dttable = Vehicle_ds.Select_vehicle(_vehicle_id))
{
// no vehicle found. should not display form
if (dttable.Rows.Count == 0)
{
this.Close();
return;
}
txt_reg_no.Text = dttable[0].registration_no;
txt_vbrand.Text = dttable[0].vehicle_brand_name;
txt_vgroup.Text = dttable[0].vehicle_group_name;
txt_vmodel.Text = dttable[0].vehicle_model_name;
dtp_purchase.Value = dttable[0].purchase_date;
if (dttable[0]["seller_person"] != DBNull.Value)
{
txt_seller.Text = dttable[0].seller_person_name; // seller is person
}
else
{
txt_seller.Text = dttable[0].seller_org_name + '\n' + dttable[0].seller_branch_name; // seller is organisation
}
}
using (Vehicle_return_ds.sp_select_vehicle_returnDataTable dttable = Vehicle_return_ds.Select_vehicle_return(_vehicle_id))
{
if (dttable.Rows.Count > 0)
{
dtp_return.Value = dttable[0].return_date;
txt_return_by.Text = dttable[0].return_by;
btn_return_by.Tag = dttable[0].return_by_id;
num_compensation.Value = dttable[0].compensation;
txt_remark.Text = dttable[0].remark;
}
}
}
private void Btn_ok_Click(object sender, EventArgs e)
{
int return_by = int.Parse(btn_return_by.Tag.ToString());
if (return_by == 0)
{
MessageBox.Show("'Return by' not selected.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
bool is_updating = false;
using (Vehicle_return_ds.sp_select_vehicle_returnDataTable dttable = Vehicle_return_ds.Select_vehicle_return(_vehicle_id))
{
is_updating = dttable.Rows.Count > 0;
}
if (is_updating)
{
if (!Vehicle_return_ds.Update_vehicle_return(_vehicle_id, dtp_return.Value, return_by, num_compensation.Value, txt_remark.Text.Trim()))
{
MessageBox.Show("Update failed.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
if (!Vehicle_return_ds.Insert_vehicle_return(_vehicle_id, dtp_return.Value, return_by, num_compensation.Value, txt_remark.Text.Trim()))
{
MessageBox.Show("Insert failed.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
this.DialogResult = DialogResult.OK;
this.Close();
}
