//GetMaxInputID
public int GetMaxInputID(string con)
{
int max_input_id = 0;
Int32.TryParse(ConnectionDB.GetOnlyRow("select max(InputID) from tb_InputHistory"), out max_input_id);
return(max_input_id);
}
//GetMaxSalespersonID
public int GetMaxSalespersonID(string con)
{
int max_salesperson_id = 0;
Int32.TryParse(ConnectionDB.GetOnlyRow("select max(SalespersonID) from tb_Salesperson"), out max_salesperson_id);
return(max_salesperson_id);
}
//GetMaxSettingID
public int GetMaxSettingID(string con)
{
int max_setting_id = 0;
Int32.TryParse(ConnectionDB.GetOnlyRow("select max(SettingID) from tb_Currency"), out max_setting_id);
return(max_setting_id);
}
//GetMaxPaymentID
public int GetMaxPaymentID(string con)
{
int max_payment_id = 0;
Int32.TryParse(ConnectionDB.GetOnlyRow("select max(PaymentID) from tb_Payment"), out max_payment_id);
return(max_payment_id);
}
//GetMaxOrderID
public int GetMaxOrderID(string con)
{
int max_order_id = 0;
Int32.TryParse(ConnectionDB.GetOnlyRow("select max(OrderID) from tb_Order"), out max_order_id);
return(max_order_id);
}
////get category follow paging
//public DataTable GetCategoryFollowPaging(int be_limit, int af_limit, string con1, string con2)
//{
// DataTable tb = new DataTable();
// string sql = "select * from [tb_Category] where [CategoryID] not in (select [CategoryID] from [tb_Category] " + con1 + " limit " + be_limit + ") " + con2 + " limit " + af_limit;
// tb = ConnectionDB.GetData(sql);
// return tb;
//}
//GetMaxCategoryID
public int GetMaxCategoryID(string con)
{
int max_category_id = 0;
Int32.TryParse(ConnectionDB.GetOnlyRow("select max(CategoryID) from tb_Category"), out max_category_id);
return(max_category_id);
}
//get maxCategoryID
public int GetMaxCategoryID()
{
int maxcat;
maxcat = Convert.ToInt32(ConnectionDB.GetOnlyRow("select max(CategoryID) from tb_Category"));
return(maxcat);
}
//get sum Category
public int GetSumCategory(string con)
{
int sum_category = 0;
string _sum_category = ConnectionDB.GetOnlyRow("select count([CategoryID]) from [tb_Category] " + con);
sum_category = Convert.ToInt32(_sum_category);
return(sum_category);
}
//get sum order
public int GetSumOrder(string con)
{
int sum_order = 0;
string _sum_order = ConnectionDB.GetOnlyRow("select count([OrderID]) from [tb_Order] " + con);
if (int.TryParse(_sum_order, out sum_order) == true)
{
return(sum_order);
}
else
{
return(0);
}
}
//find product is active
public bool FindProductIsActive(int categoryid)
{
string sql = "SELECT [ProductID] from [tb_Product] where [CategoryID] = " + categoryid + " AND [Active] = 1";
string result = ConnectionDB.GetOnlyRow(sql);
if (result == "")
{
return(false);
}
else
{
return(true);
}
}
//get sum Product
public int GetTotalProduct(string con)
{
int sum_product = 0;
string _sum_product = ConnectionDB.GetOnlyRow("select count([ProductID]) from [tb_Product] " + con);
if (Int32.TryParse(_sum_product, out sum_product))
{
return(sum_product);
}
else
{
return(0);
}
}
//GetQtyProductOutput
public int GetQtyProductOutput(string con)
{
string qty_productoutput = "";
string sql = "SELECT SUM(Qty) FROM [tb_OrderDetail] " + con;
qty_productoutput = ConnectionDB.GetOnlyRow(sql);
if (qty_productoutput == "")
{
return(0);
}
else
{
return(Convert.ToInt32(qty_productoutput));
}
}
//CheckExist
public string CheckExist(string condition)
{
string sql = "select [ProductID] from [tb_OrderDetail] " + condition;
return(ConnectionDB.GetOnlyRow(sql));
}