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