public static void FILL_COMBOBOX(hyflexComboBox CMB_CATEGORY, string QRY, string DisplayMember, string ValueMember, int SelectedIndex) { try { CONNECTION.open_connection(); using (MySqlDataAdapter DA = new MySqlDataAdapter(QRY, CONNECTION.CON)) { DataTable DT = new DataTable(); DA.Fill(DT); if (DT.Rows.Count > 0) { CMB_CATEGORY.DataSource = DT; CMB_CATEGORY.DisplayMember = DisplayMember; CMB_CATEGORY.ValueMember = ValueMember; CMB_CATEGORY.SelectedIndex = SelectedIndex; } else { CMB_CATEGORY.DataSource = null; } } } catch (Exception EX) { MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error()); mdg.ShowDialog(); } }
public static string GEN_NEXT_GUEST_NO() { string ACC = "GU-"; CONNECTION.open_connection(); using (MySqlDataAdapter adp1 = new MySqlDataAdapter("SELECT guest_id FROM guest", CONNECTION.CON)) { DataTable tbl1 = new DataTable(); adp1.Fill(tbl1); if (tbl1.Rows.Count > 0) { using (MySqlDataAdapter adp2 = new MySqlDataAdapter("SELECT MAX(SUBSTRING(guest_id,4,10)) FROM guest", CONNECTION.CON)) { DataTable tbl2 = new DataTable(); adp2.Fill(tbl2); if (tbl2.Rows.Count > 0) { int in_no = Convert.ToInt32(tbl2.Rows[0].Field <string>(0)); in_no = in_no + 1; if (in_no < 10) { ACC = ACC + "00000" + in_no.ToString(); } else if (in_no < 100) { ACC = ACC + "0000" + in_no.ToString(); } else if (in_no < 1000) { ACC = ACC + "000" + in_no.ToString(); } else if (in_no < 10000) { ACC = ACC + "00" + in_no.ToString(); } else if (in_no < 100000) { ACC = ACC + "0" + in_no.ToString(); } else { ACC = ACC + in_no.ToString(); } } else { ACC = "GU-000001"; } } } else { ACC = "GU-000001"; } } return(ACC); }
public static string GEN_NEXT_GRN_NO() { string GRN = "GR-"; CONNECTION.open_connection(); using (MySqlDataAdapter adp1 = new MySqlDataAdapter("SELECT grn_no FROM grn", CONNECTION.CON)) { DataTable tbl1 = new DataTable(); adp1.Fill(tbl1); if (tbl1.Rows.Count > 0) { using (MySqlDataAdapter adp2 = new MySqlDataAdapter("SELECT MAX(SUBSTRING(grn_no,4,10)) FROM grn", CONNECTION.CON)) { DataTable tbl2 = new DataTable(); adp2.Fill(tbl2); if (tbl2.Rows.Count > 0) { int in_no = Convert.ToInt32(tbl2.Rows[0].Field <string>(0)); in_no = in_no + 1; if (in_no < 10) { GRN = GRN + "0000" + in_no.ToString(); } else if (in_no < 100) { GRN = GRN + "000" + in_no.ToString(); } else if (in_no < 1000) { GRN = GRN + "00" + in_no.ToString(); } else if (in_no < 10000) { GRN = GRN + "0" + in_no.ToString(); } else { GRN = GRN + in_no.ToString(); } } else { GRN = "GR-00001"; } } } else { GRN = "GR-00001"; } } return(GRN); }
public static double GET_DATA(String QRY) { try { CONNECTION.open_connection(); using (MySqlDataAdapter DA = new MySqlDataAdapter(QRY, CONNECTION.CON)) { DataTable DT = new DataTable(); DA.Fill(DT); if (DT.Rows.Count > 0) { return(DT.Rows[0].Field <double>(0)); } else { return(0); } } } catch (Exception EX) { return(0); } }
public static String GET_MAX_INT_ID(String QRY) { try { CONNECTION.open_connection(); using (MySqlDataAdapter DA = new MySqlDataAdapter(QRY, CONNECTION.CON)) { DataTable DT = new DataTable(); DA.Fill(DT); if (DT.Rows.Count > 0) { return(DT.Rows[0].Field <int>(0).ToString()); } else { return("0"); } } } catch (Exception EX) { return(EX.ToString()); } }