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