public DataTable GET_ALL_PRODUCTS()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GET_ALL_PRODUCTS",null);
DAL.Close();
return Dt;
}
public DataTable GET_IMAGE_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("GET_IMAGE_PRODUCT", param);
DAL.Close();
return Dt;
}
public DataTable GET_IMAGE_PRODUCT(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
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_IMAGE_PRODUCT", param);
DAL.Close();
return(Dt);
}
public DataTable GET_ALL_PRODUCTS(bool is_item_inner)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_P_IS_ITEM_INNER", is_item_inner);
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_ALL_PRODUCTS", param);
DAL.CloseConnection();
return(dt);
}
public DataTable delete_user(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.Int);
param[0].Value = id;
DAL.Open();
DataTable dt = DAL.SelectData("delete_user", 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.ConClose();
return(dt);
}
public DataTable verifycate(string cate)
{
DataTable dt = new DataTable();
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
SqlParameter [] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.VarChar, 50);
param[0].Value = cate;
dt = dal.SelectData("verifycate", param);
dal.Close();
return(dt);
}
public DataTable SearchDonation_Ar(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@text", SqlDbType.VarChar, 50);
param[0].Value = ID;
Dt = DAL.SelectData("SearchDonation_Ar", param);
DAL.Close();
return(Dt);
}
public DataTable SearchUsers2(string Criterion)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Criterion", SqlDbType.VarChar, 50);
param[0].Value = Criterion;
DataTable Dt = new DataTable();
Dt = DAL.SelectData("SearchUsers2", param);
DAL.Close();
return(Dt);
}
public DataTable GET_ALL_ACCOUNT_RECEIPT(int a_id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_C_ACOUNT_ID", a_id);
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_ALL_ACCOUNT_RECEIPT", param);
DAL.CloseConnection();
return(dt);
}
public DataTable CHECK_PASSWORD(string old_pass)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_OLD_PASS", old_pass);
DataTable dt = new DataTable();
dt = DAL.SelectData("CHECK_PASSWORD", param);
DAL.CloseConnection();
return(dt);
}
public DataTable SEARCH_RECEIPT_BY_NO(string r_no)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_R_I_NO", r_no);
DataTable dt = new DataTable();
dt = DAL.SelectData("SEARCH_RECEIPT_BY_NO", param);
DAL.CloseConnection();
return(dt);
}
public DataTable RechercherEpreuve(string ID)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.VarChar, 80);
param[0].Value = ID;
dt = dal.SelectData("RechercherEpreuve", param);
dal.Close();
return(dt);
}
public DataTable VerifierIDGroupe(string ID)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@id", SqlDbType.Int);
param[0].Value = ID;
dt = dal.SelectData("VerifierIDGroupe", param);
dal.Close();
return(dt);
}
public DataTable searchpatient(string name)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@name", SqlDbType.NVarChar);
param[0].Value = name;
DAL.Open();
DataTable dt = DAL.SelectData("get_patient_by_name", param);
DAL.Close();
return(dt);
}
public DataTable get_reversnum(DateTime visitdate)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@visit_date", SqlDbType.DateTime);
param[0].Value = visitdate;
DAL.Open();
DataTable dt = DAL.SelectData("get_reservnum", param);
DAL.Close();
return(dt);
}
public DataTable tot_cost(DateTime date)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@visit_date", SqlDbType.Date);
param[0].Value = date;
DAL.Open();
DataTable dt = DAL.SelectData("tot_cost", param);
DAL.Close();
return(dt);
}
public DataTable get_patient_history(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@pid", SqlDbType.Int);
param[0].Value = id;
DAL.Open();
DataTable dt = DAL.SelectData("get_patient_report", param);
DAL.Close();
return(dt);
}
public DataTable SEARCH_Program(string USE)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable DT = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@USE", SqlDbType.VarChar, 50);
param[0].Value = USE;
DT = DAL.SelectData("SEARCH_Program", param);
DAL.close();
return(DT);
}
public string fillIDCustomer()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
dt = DAL.SelectData("LOAD_MAXID_payedmoney_Customer", null);
foreach (DataRow row in dt.Rows)
{
ID = row[0].ToString();
}
return(ID);
}
public DataTable VerifyDonatorID(string ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
Dt = DAL.SelectData("VerfiyDonatorID", param);
DAL.Close();
return(Dt);
}
public DataTable PRT_ALL_INVO(int COUST_ID)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@COUST_ID", SqlDbType.Int);
param[0].Value = COUST_ID;
dt = dal.SelectData("PRT_ALL_INVO", param);
dal.ConClose();
return(dt);
}
public DataTable Get_Image_Donation(int ID)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
Dt = DAL.SelectData("Get_Image_Donation", param);
DAL.Close();
return(Dt);
}
public DataTable RPT_ITMS_DTLS(int ID_PRODUCT)
{
DAL.DataAccessLayer dal = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID_PRODUCT", SqlDbType.Int);
param[0].Value = ID_PRODUCT;
dt = dal.SelectData("RPT_ITMS_DTLS", param);
dal.ConClose();
return(dt);
}
public string fillID()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
dt = DAL.SelectData("GETMAXCustomerID", null);
foreach (DataRow row in dt.Rows)
{
ID = row[0].ToString();
}
return(ID);
}
public DataTable GET_ACOUNT_RECEIPT_ITEMS(string code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_A_R_INFO_CODE", code);
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_ACOUNT_RECEIPT_ITEMS", param);
DAL.CloseConnection();
return(dt);
}
public DataTable SEARCH_REPAIRING(string r_o_phone)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_R_OWNER_PHONE", r_o_phone);
DataTable dt = new DataTable();
dt = DAL.SelectData("SEARCH_REPAIRING", param);
DAL.CloseConnection();
return(dt);
}
public DataTable P_AM_Get_Product_type(string search)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Search", SqlDbType.NVarChar);
param[0].Value = search;
dt = DAL.SelectData("P_AM_Get_Product_type", param);
DAL.Close();
return(dt);
}
public DataTable CHECk_PRODUCT_QUANTITY(int p_id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_P_ID", p_id);
DataTable dt = new DataTable();
dt = DAL.SelectData("CHECk_PRODUCT_QUANTITY", param);
DAL.CloseConnection();
return(dt);
}
public DataTable GET_R_order() // no enteres any parameters becouse we need every parameters.
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("GetAll_ReturnItem", null);
DAL.Close();
return(Dt);
}
public DataTable MAX_R_ORDER_ID()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
DataTable Dt = new DataTable();
Dt = DAL.SelectData("MaxID_ReturnItem", null);
DAL.Close();
return(Dt);
}
public DataTable get_month(DateTime date)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@visit_date", SqlDbType.DateTime);
param[0].Value = date;
DAL.Open();
DataTable dt = DAL.SelectData("patients_per_month", 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.NVarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@PWD", SqlDbType.NVarChar, 50);
param[1].Value = PWD;
DataTable Dt = new DataTable();
Dt = DAL.SelectData("SP_LOGIN", param);
DAL.Close();
return Dt;
}