public DataTable GET_ALL_PRODUCTS()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable Dt = new DataTable();
Dt = DAL.selectdata("GET_ALL_PRODUCTS", null);
DAL.Close();
return(Dt);
}
public DataTable select_customer()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable dt = new DataTable();
dt = DAL.selectdata("get_customer", null);
DAL.Close();
return(dt);
}
public DataTable GET_LAST_ORDER_ID_For_Print()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable dt = new DataTable();
dt = DAL.selectdata("GET_LAST_ORDER_ID_for_print", null);
DAL.Close();
return(dt);
}
public DataTable search_customer(string creation)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@creation", SqlDbType.VarChar);
param[0].Value = creation;
DataTable dt = new DataTable();
dt = DAL.selectdata("Search_customer", param);
DAL.Close();
return(dt);
}
public DataTable search_PRODUCT(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
param[0].Value = ID;
Dt = DAL.selectdata("search_PRODUCT", param);
DAL.Close();
return(Dt);
}
public DataTable SEARCHUSER(string SEARCH)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
SqlParameter[] PARAM = new SqlParameter[1];
PARAM[0] = new SqlParameter("@SEARCH", SqlDbType.VarChar, 50);
PARAM[0].Value = SEARCH;
dt = DAL.selectdata("SEARCHUSER", PARAM);
DAL.Close();
return(dt);
}
public DataTable Get_Imag(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, (50));
param[0].Value = ID;
dt = DAL.selectdata("Get_Imag", param);
DAL.Close();
return(dt);
}
public DataTable GET_ORDER_DETAILS_REPORT_forprint(int id_order)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
SqlParameter[] PARAM = new SqlParameter[1];
PARAM[0] = new SqlParameter("@id_order", SqlDbType.Int);
PARAM[0].Value = id_order;
dt = DAL.selectdata("GET_ORDER_DETAILS_REPORT_forprint", PARAM);
DAL.Close();
return(dt);
}
public DataTable VERIFY_QNT(string ID, int QNT_INTERED)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID_PRODUCT", SqlDbType.VarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@QNT_INTERED", SqlDbType.Int);
param[1].Value = QNT_INTERED;
Dt = DAL.selectdata("VERIFY_QNT", param);
DAL.Close();
return(Dt);
}
public DataTable LOGIN(string ID, string PWD)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
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.Open();
DataTable Dt = new DataTable();
Dt = DAL.selectdata("SP_Login", param);
DAL.Close();
return(Dt);
}