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