public DataTable Get_All_Customers()
{
dal.opendb();
DataTable dt = new DataTable();
dt = dal.select("Get_All_Customers", null);
dal.closedb();
return(dt);
}
public DataTable Get_Categories()
{
dal.opendb();
DataTable dt = new DataTable();
dt = dal.select("Get_Categories", null);
dal.closedb();
return(dt);
}
public DataTable Login(string id, string pwd)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@id", SqlDbType.VarChar, 50);
param[0].Value = id;
param[1] = new SqlParameter("@pwd", SqlDbType.VarChar, 50);
param[1].Value = pwd;
DAL.opendb();
DataTable dt = new DataTable();
dt = DAL.select("SP_Login", param);
DAL.closedb();
return(dt);
}
public DataTable Get_Last_Id_For_Print()
{
DataTable dt = new DataTable();
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.opendb();
dt = dal.select("Get_Last_Id_For_Print", null);
dal.closedb();
return(dt);
}
public DataTable Search_Orders(string criterion)
{
DataTable dt = new DataTable();
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.opendb();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@criterion", SqlDbType.VarChar, 50);
param[0].Value = criterion;
dt = dal.select("Search_Orders", param);
dal.closedb();
return(dt);
}
public DataTable Get_Order_Details(int oID)
{
DataTable dt = new DataTable();
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
dal.opendb();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("oID", SqlDbType.Int);
param[0].Value = oID;
dt = dal.select("Get_Order_Details", param);
dal.closedb();
return(dt);
}
public DataTable Verify_Quantity(int pID, int Quantity)
{
dal.opendb();
SqlParameter[] param = new SqlParameter[2];
DataTable dt = new DataTable();
param[0] = new SqlParameter("@pID", SqlDbType.Int);
param[0].Value = pID;
param[1] = new SqlParameter("Quantity", SqlDbType.Int);
param[1].Value = Quantity;
dt = dal.select("Verify_Quantity", param);
return(dt);
}