public void ADD_RECEIPT_ITEM(
string pname,
int pid,
double pprice,
int pcount,
double pdiscount,
double ptotal,
double finall_total,
string receipt_no)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
//
MySqlParameter[] param = new MySqlParameter[9];
param[0] = new MySqlParameter("_R_ITEM_NAME", pname);
param[1] = new MySqlParameter("_R_ITEM_PRODUCT_ID", pid);
param[2] = new MySqlParameter("_R_ITEM_PRICE", pprice);
param[3] = new MySqlParameter("_R_ITEM_COUNT", pcount);
param[4] = new MySqlParameter("_R_ITEM_DISCOUNT", pdiscount);
param[5] = new MySqlParameter("_R_ITEM_TOTAL", ptotal);
param[6] = new MySqlParameter("_R_ITEM_FINAL_TOTAL", finall_total);
param[7] = new MySqlParameter("_R_INFO_NO", receipt_no);
param[8] = new MySqlParameter("_R_ITEM_CRETED_AT", DateTime.Now);
DAL.ExecuteCommand("ADD_RECEIPT_ITEMS", param);
DAL.CloseConnection();
}
public void DELETE_DEVICE(int r_id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_R_ID", r_id);
DAL.ExecuteCommand("DELETE_DEVICE", param);
DAL.CloseConnection();
}
public void DELETE_PRODUCT(int p_id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_P_ID", p_id);
DAL.ExecuteCommand("DELETE_PRODUCT", param);
DAL.CloseConnection();
}
public DataTable GET_ALL_CATEGORIES()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_ALL_CATEGORIES", null);
DAL.CloseConnection();
return(dt);
}
public DataTable GET_ALL_RECEIPT_ITEMS()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
DataTable dt = new DataTable();
dt = DAL.SelectData("ADD_RECEIPT_ITEMS", null);
DAL.CloseConnection();
return(dt);
}
public DataTable GET_ALL_REPAIRING()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_ALL_DEVICE_REPAIRING", null);
DAL.CloseConnection();
return(dt);
}
public DataTable GET_CLIENTS_ACC_DEBIT_STATISTICS()
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_CLIENTS_ACC_DEBIT_STATISTICS", null);
DAL.CloseConnection();
return(dt);
}
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 GET_PRODUCT_IMAGE(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("GET_PRODUCT_IMAGE", param);
DAL.CloseConnection();
return(dt);
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//
public DataTable CHECk_IS_BARCODE_EXISTS(string barcode)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_P_BARCODE", barcode);
DataTable dt = new DataTable();
dt = DAL.SelectData("CHECk_IS_BARCODE_EXISTS", param);
DAL.CloseConnection();
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 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 void UPDATE_PASSWORD(int id, string newPass)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("_ID", id);
param[1] = new MySqlParameter("_NEW_PASS", newPass);
DAL.ExecuteCommand("UPDATE_PASSWORD", param);
DAL.CloseConnection();
}
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_ITEMS(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_ITEMS", param);
DAL.CloseConnection();
return(dt);
}
public DataTable CHECk_IS_CATEGORY_EXISTS(string c_name)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_C_NAME", c_name);
DataTable dt = new DataTable();
dt = DAL.SelectData("CHECk_IS_CATEGORY_EXISTS", param);
DAL.CloseConnection();
return(dt);
}
//public DataTable GET_ALL_ACCOUNTS_CASH()
//{
// DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
// DAL.OpenConnection();
// DataTable dt = new DataTable();
// dt = DAL.SelectData("GET_ALL_ACOUNT_RECEIPT_INFO", null);
// DAL.CloseConnection();
// return dt;
//}
public DataTable GET_ALL_ACCOUNT_CASH(int a_id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_C_ID", a_id);
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_ALL_ACCOUNT_CASH", param);
DAL.CloseConnection();
return(dt);
}
public DataTable SEARCH_PRODUCT(string p_name)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_P_NAME", p_name);
DataTable dt = new DataTable();
dt = DAL.SelectData("SEARCH_PRODUCT", param);
DAL.CloseConnection();
return(dt);
}
public DataTable CHECK_IS_PRODUCT_TYPE_AND_NAME(string p_name, bool is_inner)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("_P_NAME", p_name);
param[1] = new MySqlParameter("_P_IS_ITEM_INNER", is_inner);
DataTable dt = new DataTable();
dt = DAL.SelectData("CHECK_IS_PRODUCT_TYPE_AND_NAME", param);
DAL.CloseConnection();
return(dt);
}
public void ADD_CATEGORY(string name, string deskripition)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("_C_NAME", name);
param[1] = new MySqlParameter("_C_DESKRIPTION", deskripition);
DAL.ExecuteCommand("ADD_CATEGORY", param);
DAL.CloseConnection();
}
public DataTable CHECK_IS_PRODUCT_EXISTS(string p_name, bool i_code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("_P_NAME", p_name);
param[1] = new MySqlParameter("_P_BARCODE", i_code);
DataTable dt = new DataTable();
dt = DAL.SelectData("CHECK_IS_PRODUCT_EXISTS", param);
DAL.CloseConnection();
return(dt);
}
public DataTable SEARCH_PRODUCT_BARCODE(bool is_inner, string p_barcode)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("_P_BARCODE", p_barcode);
param[1] = new MySqlParameter("_P_IS_ITEM_INNER", is_inner);
DataTable dt = new DataTable();
dt = DAL.SelectData("SEARCH_PRODUCT_BARCODE", param);
DAL.CloseConnection();
return(dt);
}
public DataTable GET_ALL_CLIENTS_ACCOUNT(string acc_type)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("_A_TYPE", acc_type);
DataTable dt = new DataTable();
dt = DAL.SelectData("GET_ALL_CLIENTS_ACCOUNT", param);
DAL.CloseConnection();
return(dt);
}
public void ADD_ACOUNT_RECEIPT_INFO(int c_a_id, string c_name, double total, string code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[5];
param[0] = new MySqlParameter("_C_ACOUNT_ID", c_a_id);
param[1] = new MySqlParameter("_C_ANAME", c_name);
param[2] = new MySqlParameter("_R_TOTAL", total);
param[3] = new MySqlParameter("_R_CODE", code);
param[4] = new MySqlParameter("_R_CREATED_AT", DateTime.Now);
DAL.ExecuteCommand("ADD_ACOUNT_RECEIPT_INFO", param);
DAL.CloseConnection();
}
public void ADD_RECEIPT_INFO(string name, string phone, double total, double dis_total, string receipt_no)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[7];
param[0] = new MySqlParameter("_R_I_NAME", name);
param[1] = new MySqlParameter("_R_I_PHONE", phone);
param[2] = new MySqlParameter("_R_I_TOTAL", total);
param[3] = new MySqlParameter("_R_I_DISCOUNT", dis_total);
param[4] = new MySqlParameter("_R_I_NO", receipt_no);
param[5] = new MySqlParameter("_R_I_TYPE", "مبيعات");
param[6] = new MySqlParameter("_R_I_CREATED_AT", DateTime.Now);
DAL.ExecuteCommand("ADD_RECEIPT_INFO", param);
DAL.CloseConnection();
}
public void UPDATE_CLIENT_ACCOUNT(int id, string store_name, string c_name, int c_phone, string a_type, string desk)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[6];
param[0] = new MySqlParameter("_A_ID", id);
param[1] = new MySqlParameter("_A_STORE_NAME", store_name);
param[2] = new MySqlParameter("_A_C_NAME", c_name);
param[3] = new MySqlParameter("_A_C_PHONE", c_phone);
param[4] = new MySqlParameter("_A_TYPE", a_type);
param[5] = new MySqlParameter("_A_DESKRIPTION", desk);
DAL.ExecuteCommand("UPDATE_CLIENT_ACCOUNT", param);
DAL.CloseConnection();
}
public void ADD_CASH_TO_ACC(int c_a_id, string c_type, string c_name, double total, string note)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[6];
param[0] = new MySqlParameter("_C_ACOUNT_ID", c_a_id);
param[1] = new MySqlParameter("_C_ACC_TYPE", c_type);
param[2] = new MySqlParameter("_C_ANAME", c_name);
param[3] = new MySqlParameter("_C_CASH_TOTAL", total);
param[4] = new MySqlParameter("_C_NOTE", note);
param[5] = new MySqlParameter("_C_CREATED_AT", DateTime.Now);
DAL.ExecuteCommand("ADD_CASH_TO_ACC", param);
DAL.CloseConnection();
}
public DataTable LOGIN(string U_NAME, string PWD)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("_U_NAME", U_NAME);
param[1] = new MySqlParameter("_PWD", PWD);
DAL.OpenConnection();
DataTable dt = new DataTable();
dt = DAL.SelectData("SP_LOGIN", param);
DAL.CloseConnection();
return(dt);
}
public void UPDATE_PRODUCT(int id, string name, string deskripition, int quantatiy, double price, double buy_price, string barcode, int cate_id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[8];
param[0] = new MySqlParameter("_P_ID", id);
param[1] = new MySqlParameter("_P_NAME", name);
param[2] = new MySqlParameter("_P_DESKRIPTION", deskripition);
param[3] = new MySqlParameter("_P_QUAANITY", quantatiy);
param[4] = new MySqlParameter("_P_PRICE", price);
param[5] = new MySqlParameter("_P_BUY_PRICE", buy_price);
param[6] = new MySqlParameter("_P_BARCODE", barcode);
param[7] = new MySqlParameter("_P_CATE_ID", cate_id);
DAL.ExecuteCommand("UPDATE_PRODUCT", param);
DAL.CloseConnection();
}
public void UPDATE_PRODUCT(int id, string name, double price, double s_price, int quantatiy, string deskripition, string barcode, int cat_id, bool is_item_inner)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.OpenConnection();
MySqlParameter[] param = new MySqlParameter[9];
param[0] = new MySqlParameter("_P_ID", id);
param[1] = new MySqlParameter("_P_NAME", name);
param[2] = new MySqlParameter("_P_PRICE", price);
param[3] = new MySqlParameter("_P_PRICE_SELL", s_price);
param[4] = new MySqlParameter("_P_QUANTITY", quantatiy);
param[5] = new MySqlParameter("_P_DESKRIPTION", deskripition);
param[6] = new MySqlParameter("_P_BARCODE", barcode);
param[7] = new MySqlParameter("_P_CATE_ID", cat_id);
param[8] = new MySqlParameter("_P_IS_ITEM_INNER", is_item_inner);
DAL.ExecuteCommand("UPDATE_PRODUCT", param);
DAL.CloseConnection();
}