/**********************************************************************/ // اجراء لاضافة البيانات لقاعدة البيانات public void ADD_MONITER(int user_id, DateTime date, string time, string process, string screens) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@user_id", SqlDbType.Int); param[0].Value = user_id; param[1] = new SqlParameter("@date", SqlDbType.Date); param[1].Value = date; param[2] = new SqlParameter("@time", SqlDbType.NVarChar, 50); param[2].Value = time; param[3] = new SqlParameter("@process", SqlDbType.VarChar, 50); param[3].Value = process; param[4] = new SqlParameter("@screens", SqlDbType.VarChar, 50); param[4].Value = screens; DAL.ExcuteCommand("ADD_MONITER", param); DAL.close(); }
// اجراء تحديث على البيانات لقاعدة البيانات public void UPDATE_CATEGORY(string cat_code, string cat_name, string quantity, int dep_id, int unit_id, int sub_cat) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@cat_code", SqlDbType.NVarChar, 50); param[0].Value = cat_code; param[1] = new SqlParameter("@cat_name", SqlDbType.NVarChar, 50); param[1].Value = cat_name; param[2] = new SqlParameter("@quantity", SqlDbType.NVarChar, 50); param[2].Value = quantity; param[3] = new SqlParameter("@dep_id", SqlDbType.Int); param[3].Value = dep_id; param[4] = new SqlParameter("@unit_id", SqlDbType.Int); param[4].Value = unit_id; param[5] = new SqlParameter("@sub_cat_id", SqlDbType.Int); param[5].Value = sub_cat; DAL.ExcuteCommand("UPDATE_CATEGORY", param); DAL.close(); }
/******************************** ADD ******************************************/ // اجراء لاضافة البيانات لقاعدة البيانات public void ADD_PRODUCT(string pro_code, string pro_name, int pro_unit, int pro_category , string pro_contry, string pro_company, Double pro_pay, Double pro_sale) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@pro_code", SqlDbType.NVarChar, 50); param[0].Value = pro_code; param[1] = new SqlParameter("@pro_name", SqlDbType.VarChar, 50); param[1].Value = pro_name; param[2] = new SqlParameter("@pro_unit", SqlDbType.Int); param[2].Value = pro_unit; param[3] = new SqlParameter("@pro_category", SqlDbType.Int); param[3].Value = pro_category; param[4] = new SqlParameter("@pro_contry", SqlDbType.VarChar, 50); param[4].Value = pro_contry; param[5] = new SqlParameter("@pro_company", SqlDbType.VarChar, 50); param[5].Value = pro_company; param[6] = new SqlParameter("@pro_pay", SqlDbType.Float); param[6].Value = pro_pay; param[7] = new SqlParameter("@pro_sale", SqlDbType.Float); param[7].Value = pro_sale; DAL.ExcuteCommand("ADD_PRODUCT", param); DAL.close(); }
public void DeleteAllTransports() { DAL.DataAccessLayer dal = new DAL.DataAccessLayer(); dal.Open(); dal.ExcuteCommand("SP_DeleteAllTransports", null); dal.Close(); }
public void ADD_PRODUCT(int ID_Cat, string Product_Name, string ID_Product, int Qty, string Price, byte[] Img) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@ID_CAT", SqlDbType.Int); param[0].Value = ID_Cat; param[1] = new SqlParameter("@ID_PRODUCT", SqlDbType.NVarChar, 50); param[1].Value = ID_Product; param[2] = new SqlParameter("@PRODUCT_NAME", SqlDbType.NVarChar, 50); param[2].Value = Product_Name; param[3] = new SqlParameter("@QTY", SqlDbType.Int); param[3].Value = Qty; param[4] = new SqlParameter("@PRICE", SqlDbType.NVarChar, 50); param[4].Value = Price; param[5] = new SqlParameter("@IMG", SqlDbType.Image); param[5].Value = Img; DAL.ExcuteCommand("SP_AddProduct", param); DAL.Close(); }
// اجراء التعديل البيانات لقاعدة البيانات public void UPDATE_PRIV(int user_id, int screen_id, Boolean priv_display, Boolean priv_add, Boolean priv_edit, Boolean priv_delete) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@user_id", SqlDbType.Int); param[0].Value = user_id; param[1] = new SqlParameter("@screen_id", SqlDbType.Int); param[1].Value = screen_id; param[2] = new SqlParameter("@priv_display", SqlDbType.Bit); param[2].Value = priv_display; param[3] = new SqlParameter("@priv_add", SqlDbType.Bit); param[3].Value = priv_add; param[4] = new SqlParameter("@priv_edit", SqlDbType.Bit); param[4].Value = priv_edit; param[5] = new SqlParameter("@priv_delete", SqlDbType.Bit); param[5].Value = priv_delete; DAL.ExcuteCommand("UPDATE_PRIV", param); DAL.close(); }
/*************************************** UPDATE **************************************************/ // اجراء لاضافة البيانات لقاعدة البيانات public void UPDATE_CUSTOMER(string cust_code, string cust_name, int cust_phone, string cust_addrees /*, Boolean cust_status*/) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@cust_code", SqlDbType.NVarChar, 50); param[0].Value = cust_code; param[1] = new SqlParameter("@cust_name", SqlDbType.VarChar, 50); param[1].Value = cust_name; param[2] = new SqlParameter("@cust_phone", SqlDbType.Int); param[2].Value = cust_phone; param[3] = new SqlParameter("@cust_addrees", SqlDbType.VarChar, 50); param[3].Value = cust_addrees; //param[4] = new SqlParameter("@cust_status", SqlDbType.Bit); //param[4].Value = cust_status; DAL.ExcuteCommand("UPDATE_CUSTOMER", param); DAL.close(); }
public void DeleteAllHistory() { DAL.DataAccessLayer dal = new DAL.DataAccessLayer(); dal.Open(); dal.ExcuteCommand("SP_DeleteAllHistory", null); dal.Close(); }
public void DeleteAllGovernorates() { DAL.DataAccessLayer dal = new DAL.DataAccessLayer(); dal.Open(); dal.ExcuteCommand("SP_DeleteAllGovernorates", null); dal.Close(); }
public void DeleteAllArrivalStations() { DAL.DataAccessLayer dal = new DAL.DataAccessLayer(); dal.Open(); dal.ExcuteCommand("SP_DeleteAllArrivalStations", null); dal.Close(); }
public void ADD_INOIES_DETEALS2(string sales_code, string pro_code, string pro_name, string pro_unit , Double pro_sale, int pro_quntity, Double inv_total) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@sales_code", SqlDbType.NVarChar, 50); param[0].Value = sales_code; param[1] = new SqlParameter("@pro_code", SqlDbType.NVarChar, 50); param[1].Value = pro_code; param[2] = new SqlParameter("@pro_name", SqlDbType.NVarChar, 50); param[2].Value = pro_name; param[3] = new SqlParameter("@pro_unit", SqlDbType.NVarChar, 50); param[3].Value = pro_unit; param[4] = new SqlParameter("@pro_sale", SqlDbType.Float); param[4].Value = pro_sale; param[5] = new SqlParameter("@pro_quntity", SqlDbType.Int); param[5].Value = pro_quntity; param[6] = new SqlParameter("@inv_total", SqlDbType.Float); param[6].Value = inv_total; DAL.ExcuteCommand("ADD_INOIES_DETEALS2", param); DAL.close(); }
// اجراء لاضافة البيانات لقاعدة البيانات public void ADD_SPEND_DETALIS(string pro_code, string pro_name, string pro_unit, int pro_quantity, string spend_code) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@pro_code", SqlDbType.NVarChar, 50); param[0].Value = pro_code; param[1] = new SqlParameter("@pro_name", SqlDbType.NVarChar, 50); param[1].Value = pro_name; param[2] = new SqlParameter("@pro_unit", SqlDbType.NVarChar, 50); param[2].Value = pro_unit; param[3] = new SqlParameter("@pro_quantity", SqlDbType.Int); param[3].Value = pro_quantity; param[4] = new SqlParameter("@spend_code", SqlDbType.NVarChar, 50); param[4].Value = spend_code; DAL.ExcuteCommand("ADD_SPEND_DETALIS", param); DAL.close(); }
private void BtnDelete_Click(object sender, EventArgs e) { try { Confirmation cfr = new Confirmation(); if (cfr.ShowDialog() == DialogResult.OK) { SqlParameter[] param = new SqlParameter[1]; int id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value); param[0] = new SqlParameter("@IdProvider", SqlDbType.Int); param[0].Value = id; data.ExcuteCommand("DeleteProvider", param); if (dataGridView1.Rows.Count != 0) { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index); } MessageBox.Show("Vous avez suprimé ce fournisseur avec succés", "Suprimer", MessageBoxButtons.OK, MessageBoxIcon.Information); lblPos.Text = bmb.Position + 1 + "/" + bmb.Count; } } catch { return; } }
public void DeleteAllRecruitingAreas() { DAL.DataAccessLayer dal = new DAL.DataAccessLayer(); dal.Open(); dal.ExcuteCommand("SP_DeleteAllRecruitingAreas", null); dal.Close(); }
/******************************** ADD ******************************************/ // اجراء لاضافة البيانات لقاعدة البيانات public void ADD_BILLS_2(string bills_no, DateTime bills_date, Double bills_amount, string bills_amount_ar , string bills_descrption, int cust_id, string cust_name) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@bills_no", SqlDbType.NVarChar, 50); param[0].Value = bills_no; param[1] = new SqlParameter("@bills_date", SqlDbType.DateTime); param[1].Value = bills_date; param[2] = new SqlParameter("@bills_amount", SqlDbType.Float); param[2].Value = bills_amount; param[3] = new SqlParameter("@bills_amount_ar", SqlDbType.NVarChar, 50); param[3].Value = bills_amount_ar; param[4] = new SqlParameter("@bills_descrption", SqlDbType.NVarChar, 50); param[4].Value = bills_descrption; param[5] = new SqlParameter("@cust_id", SqlDbType.Int); param[5].Value = cust_id; param[6] = new SqlParameter("@cust_name", SqlDbType.NVarChar, 50); param[6].Value = cust_name; DAL.ExcuteCommand("ADD_BILLS_2", param); DAL.close(); }
/*************************************** UPDATE **************************************************/ // اجراء لاضافة البيانات لقاعدة البيانات public void UPDATE_SUPPLAY(string supp_code, string supp_name, int supp_phone, string aupp_addrees /*, Boolean supp_status*/) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@supp_code", SqlDbType.NVarChar, 50); param[0].Value = supp_code; param[1] = new SqlParameter("@supp_name", SqlDbType.VarChar, 50); param[1].Value = supp_name; param[2] = new SqlParameter("@supp_phone", SqlDbType.Int); param[2].Value = supp_phone; param[3] = new SqlParameter("@aupp_addrees", SqlDbType.VarChar, 50); param[3].Value = aupp_addrees; //param[4] = new SqlParameter("@supp_status", SqlDbType.Bit); //param[4].Value = supp_status; DAL.ExcuteCommand("UPDATE_SUPPLAY", param); DAL.close(); }
public void UpdateArrivalIdInStudents() { DAL.DataAccessLayer dal = new DAL.DataAccessLayer(); dal.Open(); dal.ExcuteCommand("SP_UpdateArrivalIdInStudents", null); dal.Close(); }
//function to add student public void Add_Student(int GeneralNumber, int Company, string Name, string Degree, string RecruitingArea, string Governorate) { DAL.DataAccessLayer dal = new DAL.DataAccessLayer(); dal.Open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@GeneralNumber", SqlDbType.Int); param[0].Value = GeneralNumber; param[1] = new SqlParameter("@Company", SqlDbType.Int); param[1].Value = Company; param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 50); param[2].Value = Name; param[3] = new SqlParameter("@Degree", SqlDbType.NVarChar, 50); param[3].Value = Degree; param[4] = new SqlParameter("@RecruitingArea", SqlDbType.NVarChar, 50); param[4].Value = RecruitingArea; param[5] = new SqlParameter("@Governorate", SqlDbType.NVarChar, 50); param[5].Value = Governorate; /* * param[6] = new SqlParameter("@Degree_Id", SqlDbType.Int); * param[6].Value = Degree_Id; * param[7] = new SqlParameter("@RecruitingArea_Id", SqlDbType.Int); * param[7].Value = RecruitingArea_Id; * param[8] = new SqlParameter("@Governorate_Id", SqlDbType.Int); * param[8].Value = Governorate_Id; * */ dal.ExcuteCommand("SP_AddStudent", param); dal.Close(); }
/******************************** ADD ******************************************/ // اجراء لاضافة البيانات لقاعدة البيانات public void ADD_INVOIES(string sales_code, DateTime sales_date, Double sales_discount, Double sales_exstra , int cust_id, Double total_invoes, Double pro_sale, Double sales_type, Double total_cost, Double total_profit , Double total_paid, string total_paid_text, Double total_remain, string total_remain_text) { /*, Double pro_pay, Double pro_sale*/ /*, int cust_id*/ DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[14]; param[0] = new SqlParameter("@sales_code", SqlDbType.NVarChar, 50); param[0].Value = sales_code; param[1] = new SqlParameter("@sales_date", SqlDbType.DateTime); param[1].Value = sales_date; param[2] = new SqlParameter("@sales_discount", SqlDbType.Float); param[2].Value = sales_discount; param[3] = new SqlParameter("@sales_exstra", SqlDbType.Float); param[3].Value = sales_exstra; param[4] = new SqlParameter("@cust_id", SqlDbType.Int); param[4].Value = cust_id; param[5] = new SqlParameter("@total_invoes", SqlDbType.Float); param[5].Value = total_invoes; param[6] = new SqlParameter("@total_cost", SqlDbType.Float); param[6].Value = total_cost; param[7] = new SqlParameter("@total_profit", SqlDbType.Float); param[7].Value = total_profit; param[8] = new SqlParameter("@pro_sale", SqlDbType.Float); param[8].Value = pro_sale; param[9] = new SqlParameter("@sales_type", SqlDbType.Float); param[9].Value = sales_type; //Double total_paid,string total_paid_text, Double total_remain,string total_remain_text param[10] = new SqlParameter("@total_paid", SqlDbType.Float); param[10].Value = total_paid; param[11] = new SqlParameter("@total_paid_text", SqlDbType.NVarChar, 50); param[11].Value = total_paid_text; param[12] = new SqlParameter("@total_remain", SqlDbType.Float); param[12].Value = total_remain; param[13] = new SqlParameter("@total_remain_text", SqlDbType.NVarChar, 50); param[13].Value = total_remain_text; DAL.ExcuteCommand("ADD_INVOIES", param); DAL.close(); }
// اجراء حذف البيانات لقاعدة البيانات public void DeleteUnit(String ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50); param[0].Value = ID; DAL.ExcuteCommand("DeleteUnit", param); DAL.close(); }
// اجراء حذف البيانات لقاعدة البيانات public void DELETE_DEPARTMINT(String dep_id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@dep_id", SqlDbType.VarChar, 50); param[0].Value = dep_id; DAL.ExcuteCommand("DELETE_DEPARTMINT", param); DAL.close(); }
public void DELETE_PRODUCT(string ID) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50); param[0].Value = ID; DAL.ExcuteCommand("SP_DeleteProduct", param); DAL.Close(); }
// اجراء حذف البيانات لقاعدة البيانات public void DeleteSupplyer(String supplyer_id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@supplyer_id", SqlDbType.VarChar, 50); param[0].Value = supplyer_id; DAL.ExcuteCommand("DeleteSupplyer", param); DAL.close(); }
// اجراء حذف البيانات لقاعدة البيانات public void DELETE_SUB_CAT(String sub_cat_id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50); param[0].Value = sub_cat_id; DAL.ExcuteCommand("DELETE_SUB_CAT", param); DAL.close(); }
/******************************* الارصدة *******************************************/ // اجراء لاضافة البيانات لقاعدة البيانات public void ADD_PALANCE(DateTime date) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@date", SqlDbType.Date); param[0].Value = date; DAL.ExcuteCommand("ADD_PALANCE", param); DAL.close(); }
public void AddProvider(int IdProvider, string ProviderName, string Tele1, string Tele2, string Tele3, string Tele4, string Email) { SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@IdProvider", SqlDbType.Int); param[0].Value = IdProvider; param[1] = new SqlParameter("@ProviderName", SqlDbType.NVarChar, 60); param[1].Value = ProviderName; param[2] = new SqlParameter("@Tele1", SqlDbType.NChar, 14); param[2].Value = Tele1; param[3] = new SqlParameter("@Tele2", SqlDbType.NChar, 14); param[3].Value = Tele2; param[4] = new SqlParameter("@Tele3", SqlDbType.NChar, 14); param[4].Value = Tele3; param[5] = new SqlParameter("@Tele4", SqlDbType.NChar, 14); param[5].Value = Tele4; param[6] = new SqlParameter("@Email", SqlDbType.NVarChar, 100); param[6].Value = Email; data.ExcuteCommand("AddProvider", param); }
// اجراء لاضافة البيانات لقاعدة البيانات public void ADD_UNIT(string unit_name) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@unit_name", SqlDbType.NVarChar, 50); param[0].Value = unit_name; DAL.ExcuteCommand("ADD_UNIT", param); DAL.close(); }
/******************************** DELETE****************************************/ public void DELETE_SUPPLAY(string supp_code) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@supp_code", SqlDbType.NVarChar, 50); param[0].Value = supp_code; DAL.ExcuteCommand("DELETE_SUPPLAY", param); DAL.close(); }
// اجراء حذف البيانات لقاعدة البيانات public void DELETE_USERES(int user_id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@user_id", SqlDbType.Int); param[0].Value = user_id; DAL.ExcuteCommand("DELETE_USERES", param); DAL.close(); }
/******************************** DELETE****************************************/ public void DELETE_CUSTOMER(string cust_code) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@cust_code", SqlDbType.NVarChar, 50); param[0].Value = cust_code; DAL.ExcuteCommand("DELETE_CUSTOMER", param); DAL.close(); }