/// <summary> /// this constructor is for EDITING existing salesperson /// </summary> /// <param name="int_salesperson"></param> public Form_edit_salesperson(int int_salesperson) { InitializeComponent(); SalespersonID = int_salesperson; Salesperson_ds.sp_select_salespersonDataTable dttable_salesperson = Salesperson_ds.Select_salesperson(SalespersonID); if (dttable_salesperson.Rows.Count > 0) { if (dttable_salesperson.Rows[0]["person"] == DBNull.Value) { _is_person = false; _person_orgbranch_id = dttable_salesperson[0].organisation_branch; } else { _is_person = true; _person_orgbranch_id = dttable_salesperson[0].person; } dtp_join.Value = dttable_salesperson[0].date_join; if (dttable_salesperson.Rows[0]["date_leave"] != DBNull.Value) { dtp_leave.Checked = true; dtp_leave.Value = dttable_salesperson[0].date_leave; } txt_location.Text = dttable_salesperson[0].location; txt_remark.Text = dttable_salesperson[0].remark; } }
private void Btn_ok_Click(object sender, EventArgs e) { if (!Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_SALESPERSON)) { // NO PERMISSION this.DialogResult = DialogResult.Cancel; this.Close(); return; } if (dtp_leave.Checked && dtp_leave.Value < dtp_join.Value) { MessageBox.Show("Date leave must be after date join.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (SalespersonID == 0) { // insert SalespersonID = Salesperson_ds.Insert_salesperson(_person_orgbranch_id, _is_person, txt_location.Text.Trim(), dtp_join.Value, dtp_leave.Checked ? dtp_leave.Value : (DateTime?)null, txt_remark.Text.Trim()); } else { // update Salesperson_ds.Update_salesperson(SalespersonID, txt_location.Text.Trim(), dtp_join.Value, dtp_leave.Checked ? dtp_leave.Value : (DateTime?)null, txt_remark.Text.Trim()); } // at this point, should not be zero anymore if (SalespersonID == 0) { MessageBox.Show("An error has occurred.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } this.DialogResult = DialogResult.OK; this.Close(); }