private void Initilise_grd_img(object sender, EventArgs e)
{
// set up grd_image when image tab is selected for the first time after form loads
dttable_img = vehicle_model_image_ds.Select_vehicle_model_image(Model_id);
grd_img.DataSource = null;
grd_img.DataSource = dttable_img;
if (!Program.System_user.IsDeveloper)
{
Class_datagridview.Hide_unnecessary_columns(grd_img, new string[] { "image" });
}
((DataGridViewImageColumn)grd_img.Columns["image"]).ImageLayout = DataGridViewImageCellLayout.Zoom;
if (grd_img.Rows.Count == 0)
{
return;
}
foreach (DataGridViewRow grd_row in grd_img.Rows)
{
grd_row.Height = Program.GRD_IMAGE_ROW_HEIGHT;
}
grd_img.ClearSelection();
grd_img.CurrentCell = null;
// detach event handler after initilising images.
this.tabControl1.SelectedIndexChanged -= new System.EventHandler(this.Initilise_grd_img);
}
private void Form_datagridview_select_Shown(object sender, EventArgs e)
{
Class_datagridview.Setup_search_textbox(txt_search.TextBox, grd_main);
switch (_form_type)
{
case "PERSON_ORGANISATION":
lbl_type.Visible = true;
cmb_type.Visible = true;
Setup_person_organisation_form();
break;
}
grd_main.AutoResizeColumns();
if (_cols_to_display != null && _cols_to_display.Count() > 0)
{
Class_datagridview.Hide_unnecessary_columns(grd_main, _cols_to_display);
}
if (_value_col_name != "")
{
Class_datagridview.Select_row_by_value(grd_main, _value_col_name, _preselect_value);
}
}
private void Form_edit_insurance_comprehensive_Shown(object sender, EventArgs e)
{
if (!Program.System_user.Has_permission(Class_enum.User_permission.INSURANCE_COMPREHENSIVE_ADD_EDIT))
{
MessageBox.Show("ACCESS DENIED", "ACCESS DENIED", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.DialogResult = DialogResult.Cancel;
this.Close();
}
if (InsuranceComprehensive != 0)
{
using (Insurance_comprehensive_ds.sp_select_insurance_comprehensiveDataTable dttable =
Insurance_comprehensive_ds.Select_insurance_comprehensive(InsuranceComprehensive))
{
if (dttable.Any())
{
txt_title.Text = dttable[0].title;
}
}
}
using (Insurance_comprehensive_rate_ds.sp_select_insurance_comprehensive_rateDataTable dttable =
Insurance_comprehensive_rate_ds.Select_insurance_comprehensive_rate(InsuranceComprehensive, -1))
{
dttable.insurance_comprehensiveColumn.ReadOnly = true;
dttable.modified_byColumn.ReadOnly = true;
// not showing column but column needs value
dttable.insurance_comprehensiveColumn.DefaultValue = InsuranceComprehensive;
dttable.cc_minColumn.DefaultValue = 0;
dttable.cc_maxColumn.DefaultValue = 0;
dttable.valueColumn.DefaultValue = 0;
// not showing column but column needs value
dttable.modified_byColumn.DefaultValue = Program.System_user.Name;
// columns must have value!
dttable.cc_minColumn.AllowDBNull = false;
dttable.cc_maxColumn.AllowDBNull = false;
dttable.valueColumn.AllowDBNull = false;
grd_ins.DataSource = dttable;
if (!Program.System_user.IsDeveloper)
{
Class_datagridview.Hide_unnecessary_columns(grd_ins,
new string[] { "cc_min", "cc_max", "value" });
}
Class_datagridview.Set_column_to_money_column(grd_ins, "value");
grd_ins.Columns["modified_by"].ReadOnly = true;
grd_ins.Columns["modified_by"].DefaultCellStyle.BackColor = Color.LightGray;
}
}
private void Setup_grd_model(int int_vmodel = 0)
{
if (tv_vehicle.SelectedNode == null)
{
return;
}
int int_country = int.Parse(Class_treeview.Get_parent_node_by_level(tv_vehicle.SelectedNode, 0).Name);
int int_vbrand = -1;
int int_vgroup = -1;
if (tv_vehicle.SelectedNode.Level > 0)
{
int_vbrand = int.Parse(Class_treeview.Get_parent_node_by_level(tv_vehicle.SelectedNode, 1).Name);
}
if (tv_vehicle.SelectedNode.Level > 1)
{
int_vgroup = int.Parse(Class_treeview.Get_parent_node_by_level(tv_vehicle.SelectedNode, 2).Name);
}
grd_model.DataSource = null;
grd_model.DataSource = Vehicle_model_ds.Select_vehicle_model(int_country, int_vbrand, int_vgroup, -1);
if (!Program.System_user.IsDeveloper)
{
Class_datagridview.Hide_unnecessary_columns(grd_model, new string[] { "vehicle_model_name", "year_make", "engine_capacity", "no_of_door",
"seat_capacity", "fuel_type_name", "transmission_name", "vehicle_group_name", "vehicle_brand_name", "country_name" });
}
grd_model.AutoResizeColumns();
if (int_vmodel != 0)
{
foreach (DataGridViewRow grd_row in grd_model.Rows)
{
if (int.Parse(grd_row.Cells["vehicle_model"].Value.ToString()) == int_vmodel)
{
grd_model.ClearSelection();
grd_row.Cells["vehicle_model_name"].Selected = true;
grd_model.CurrentCell = grd_row.Cells["vehicle_model_name"];
break;
}
}
}
}
private void Listbox_ins_SelectedIndexChanged(object sender, EventArgs e)
{
if (listbox_ins.SelectedIndex >= 0)
{
grd_ins.DataSource = null;
grd_ins.DataSource = Insurance_comprehensive_rate_ds.
Select_insurance_comprehensive_rate((int)listbox_ins.SelectedValue, -1);
Class_datagridview.Set_column_to_money_column(grd_ins, new string[] { "value" });
grd_ins.AutoResizeColumns();
if (!Program.System_user.IsDeveloper)
{
Class_datagridview.Hide_unnecessary_columns(grd_ins,
new string[] { "cc_min", "cc_max", "value", "modified_by" });
}
}
}
private void Setup_grd_person_organisation()
{
if (cmb_type.SelectedItem == null)
{
return;
}
grd_main.DataSource = null;
if (cmb_type.SelectedItem.ToString().ToUpper() == "PERSON")
{
grd_main.DataSource = Person_ds.Select_person_simplified();
}
else
{
grd_main.DataSource = Organisation_branch_ds.Select_organisation_simplified();
}
Class_datagridview.Hide_columns(grd_main, "person", "organisation_branch", "organisation");
grd_main.AutoResizeColumns();
Apply_filter_grd();
}
private void Form_person_Shown(object sender, EventArgs e)
{
if (!Program.System_user.Has_permission(Class_enum.User_permission.VIEW_PERSON) && !Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_PERSON))
{
MessageBox.Show("You do not have sufficient permission to perform this action!",
"ACCESS DENIED", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
return;
}
grd_contact.DataSource = Person_contact_ds.Select_person_contact(PersonID);
grd_contact.AutoResizeColumns();
// database column nvarchar length is 100
Class_datagridview.Set_max_length_grd_col_same_with_datatable_col(grd_contact, "contact", "remark");
// allow dbnull because user is
((DataTable)grd_contact.DataSource).Columns["remark"].AllowDBNull = true;
Class_combobox.Setup_combobox(cmb_type, Person_type_ds.Select_person_type(), "person_type_description", "person_type");
cmb_type.SelectedValue = 1; // set default to INDIVIDUAL
Class_combobox.Setup_combobox(cmb_race, Race_ds.Select_race(), "race_description", "race");
Class_combobox.Setup_combobox(cmb_country, Country_ds.Select_country(), "country_name", "country");
cmb_country.SelectedValue = 133; // set default to malaysia
DataTable dttable_gender = new DataTable();
dttable_gender.Columns.Add("display");
dttable_gender.Columns.Add("value");
dttable_gender.Rows.Add("MALE", "MALE");
dttable_gender.Rows.Add("FEMALE", "FEMALE");
Class_combobox.Setup_combobox(cmb_gender, dttable_gender, "display", "value");
if (PersonID == 0)
{
return; // if zero means adding new person instead of editing
}
using (Person_ds.sp_select_personDataTable dttable_person = Person_ds.Select_person(PersonID))
{
if (dttable_person.Rows.Count == 0)
{
return;
}
txt_name.Text = dttable_person[0].name;
txt_ic_no.Text = dttable_person[0].ic_no;
if (dttable_person.Rows[0]["image"] != DBNull.Value)
{
picbox_image.Image = Image.FromStream(new MemoryStream(dttable_person[0].image));
}
cmb_type.SelectedValue = dttable_person[0].person_type;
txt_driving_license.Text = dttable_person[0].driving_license;
cmb_gender.SelectedValue = (dttable_person[0].gender) ? "MALE" : "FEMALE";
cmb_race.SelectedValue = dttable_person[0].race;
txt_address.Text = dttable_person[0].address;
txt_city.Text = dttable_person[0].city;
txt_state.Text = dttable_person[0].state;
txt_postcode.Text = dttable_person[0].postcode;
cmb_country.SelectedValue = dttable_person[0].country;
txt_occupation.Text = dttable_person[0].occupation;
txt_company.Text = dttable_person[0].company;
txt_url.Text = dttable_person[0].url;
}
}
private void DeleteToolStripMenuItem_Click(object sender, EventArgs e)
{
Class_datagridview.Remove_row_of_selected_cells(grd_contact);
}
private void Setup_grd_main(int int_id = 0)
{
grd_main.DataSource = null;
switch (_select_for)
{
case "":
if (cmb_type.ComboBox.SelectedItem.ToString() == "PERSON")
{
grd_main.DataSource = Person_ds.Select_person(-1);
Class_datagridview.Hide_columns(grd_main,
new string[] { "person", "image", "person_type", "gender", "race", "country" });
}
else
{
grd_main.DataSource = Organisation_branch_ds.Select_organisation_branch_with_org_details(-1);
Class_datagridview.Hide_columns(grd_main,
new string[] { "organisation", "organisation_type", "country" });
}
break;
case "SALESPERSON":
if (cmb_type.ComboBox.SelectedItem.ToString() == "PERSON")
{
grd_main.DataSource = Person_ds.Select_person_not_salesperson();
}
else
{
grd_main.DataSource = Organisation_branch_ds.Select_organisation_not_salesperson();
}
break;
case "FINANCE":
cmb_type.ComboBox.SelectedValue = "ORGANISATION";
cmb_type.Enabled = false; // ONLY organisation allowed for finance
grd_main.DataSource = Organisation_branch_ds.Select_organisation_not_finance();
break;
case "INSURANCE":
cmb_type.ComboBox.SelectedValue = "ORGANISATION";
cmb_type.Enabled = false; // ONLY organisation allowed for insurance
grd_main.DataSource = Organisation_branch_ds.Select_organisation_not_insurance();
break;
case "LOAN":
cmb_type.ComboBox.SelectedValue = "ORGANISATION";
cmb_type.Enabled = false; // ONLY organisation allowed for loan
grd_main.DataSource = Organisation_branch_ds.Select_organisation_not_loan();
break;
}
if (cmb_type.ComboBox.SelectedItem.ToString() == "PERSON")
{
Class_datagridview.Hide_columns(grd_main, new string[] { "person" });
if (int_id != 0)
{
Class_datagridview.Select_row_by_value(grd_main, "person", int_id);
}
btn_add.Enabled = Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_PERSON);
addToolStripMenuItem.Enabled = Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_PERSON);
btn_edit.Enabled = Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_PERSON) ||
Program.System_user.Has_permission(Class_enum.User_permission.VIEW_PERSON);
}
else
{
Class_datagridview.Hide_columns(grd_main, new string[] { "organisation_branch", "organisation" });
if (int_id != 0)
{
Class_datagridview.Select_row_by_value(grd_main, "organisation", int_id);
}
btn_add.Enabled = Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_ORGANISATION);
addToolStripMenuItem.Enabled = Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_ORGANISATION);
btn_edit.Enabled = Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_ORGANISATION) ||
Program.System_user.Has_permission(Class_enum.User_permission.VIEW_ORGANISATION);
}
Class_datagridview.Convert_column_to_link_column(grd_main, "url", "url");
grd_main.RowsDefaultCellStyle.WrapMode = DataGridViewTriState.True;
grd_main.AutoResizeColumns();
grd_main.AutoResizeRows();
Apply_search_filter_to_grd_main();
}
private void Form_organisation_Shown(object sender, EventArgs e)
{
if (!Program.System_user.Has_permission(Class_enum.User_permission.VIEW_ORGANISATION) &&
!Program.System_user.Has_permission(Class_enum.User_permission.ADD_EDIT_ORGANISATION))
{
MessageBox.Show("You do not have sufficient permission to perform this action!",
"ACCESS DENIED", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
return;
}
// ##################### GRD_CONTACT #####################
grd_contact.DataSource = Organisation_contact_ds.Select_organisation_contact(OrganisationID);
grd_contact.AutoResizeColumns();
// database column nvarchar length is 100
Class_datagridview.Set_max_length_grd_col_same_with_datatable_col(grd_contact, "contact", "remark");
// allow dbnull because empty string will enter dbnull to datagridviewcolumn
((DataTable)grd_contact.DataSource).Columns["remark"].AllowDBNull = true;
// ##################### END GRD_CONTACT #####################
Country_ds.sp_select_countryDataTable dttable_country = Country_ds.Select_country();
// ##################### GRD_BRANCH #####################
Organisation_branch_ds.sp_select_organisation_branch_by_orgDataTable dttable_branch = Organisation_branch_ds.Select_organisation_branch_by_org(OrganisationID);
dttable_branch.Columns["address"].AllowDBNull = true;
dttable_branch.Columns["city"].AllowDBNull = true;
dttable_branch.Columns["state"].AllowDBNull = true;
dttable_branch.Columns["postcode"].AllowDBNull = true;
dttable_branch.Columns.Remove("modified_by"); // no need show this
grd_branch.DataSource = dttable_branch;
grd_branch.Columns["organisation_branch"].Visible = false;
grd_branch.RowsDefaultCellStyle.WrapMode = DataGridViewTriState.True;
grd_branch.AutoResizeColumns();
grd_branch.AutoResizeRows();
Class_datagridview.Set_max_length_grd_col_same_with_datatable_col(grd_branch, "branch_name", "address", "city", "state", "postcode");
Class_datagridview.Replace_column_with_combobox_column(grd_branch, "country", dttable_country.Copy(), "country_name", "country");
grd_branch.Columns["address"].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
// ##################### END GRD_BRANCH #####################
Class_combobox.Setup_combobox(cmb_type, Organisation_type_ds.Select_organisation_type(),
"organisation_type_description", "organisation_type");
cmb_type.SelectedValue = 1; // set default value to CORPORATE
Class_combobox.Setup_combobox(cmb_country, dttable_country.Copy(), "country_name", "country");
cmb_country.SelectedValue = 133; // set default to malaysia
if (OrganisationID == 0)
{
return; // zero means adding new org
}
Organisation_ds.sp_select_organisationDataTable dttable_org = Organisation_ds.Select_organisation(OrganisationID);
if (dttable_org.Rows.Count == 0)
{
return;
}
txt_name.Text = dttable_org[0].name;
txt_registration_no.Text = dttable_org[0].registration_no;
cmb_country.SelectedValue = dttable_org[0].country;
cmb_type.SelectedValue = dttable_org[0].organisation_type;
txt_url.Text = dttable_org[0].url;
}
