public void UPDATE_CUSTOMER(string fname, string lname, string tel, string email, int id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@F_NAME", SqlDbType.NVarChar, 50); parm[0].Value = fname; parm[1] = new SqlParameter("@L_NAME", SqlDbType.NVarChar, 50); parm[1].Value = lname; parm[2] = new SqlParameter("@PHONE", SqlDbType.NVarChar, 50); parm[2].Value = tel; parm[3] = new SqlParameter("@EMAIL", SqlDbType.NVarChar, 50); parm[3].Value = email; parm[4] = new SqlParameter("@ID", SqlDbType.Int); parm[4].Value = id; DAL.ExecuteCommand("UPDATE_CUSTOMER", parm); DAL.close(); }
public void ADD_ORDERS(int id_order, DateTime date_time, int cust_id, string desc_ord, string sales_man) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] parm = new SqlParameter[5]; parm[0] = new SqlParameter("@ID_ORD", SqlDbType.Int); parm[0].Value = id_order; parm[1] = new SqlParameter("@DATE_ORD", SqlDbType.DateTime); parm[1].Value = date_time; parm[2] = new SqlParameter("@CUST_ID", SqlDbType.Int); parm[2].Value = cust_id; parm[3] = new SqlParameter("@DESC_ORD", SqlDbType.NVarChar, 75); parm[3].Value = desc_ord; parm[4] = new SqlParameter("@SALES_MAN", SqlDbType.NVarChar, 50); parm[4].Value = sales_man; DAL.ExecuteCommand("ADD_ORDERS", parm); DAL.close(); }
public void UPDATE_Exam(int course_code, int doctor_code, int Intake_code, string date_Exam, string date_resetExam, string path, int id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@course_code", SqlDbType.Int); param[0].Value = course_code; param[1] = new SqlParameter("@doctor_code", SqlDbType.Int); param[1].Value = doctor_code; param[2] = new SqlParameter("@Intake_code", SqlDbType.Int); param[2].Value = Intake_code; param[3] = new SqlParameter("@date_Exam", SqlDbType.Date); param[3].Value = date_Exam; param[4] = new SqlParameter("@date_resetExam", SqlDbType.Date); param[4].Value = date_resetExam; param[5] = new SqlParameter("@path", SqlDbType.VarChar); param[5].Value = path; param[6] = new SqlParameter("@Exam_code", SqlDbType.Int); param[6].Value = id; DAL.ExectCommand("UPDATE_Exam", param); DAL.close(); }
public DataTable searchMat(string name) { DAL.DataAccessLayer accessobject = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ref", SqlDbType.NVarChar, 50); param[0].Value = name; DataTable Dt = new DataTable(); Dt = accessobject.selectData("searchMat", param); accessobject.close(); //foreach (DataRow row in Dt.Rows) //{ // // try // // { // // row["سعر الشراء"] = String.Format("{0:n0}", Convert.ToDouble(row["سعر الشراء"])); // // // // row["سعر البيع"] = String.Format("{0:n0}", Convert.ToDouble(row["سعر البيع"])); // // } // // catch (Exception ex) // // { // // } //} return(Dt); }
public DataTable BringSeedsByType(string type_name, string storid) { DAL.DataAccessLayer accessobject = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 50); param[0].Value = type_name; param[1] = new SqlParameter("@store_id", SqlDbType.NVarChar, 50); param[1].Value = storid; DataTable Dt = new DataTable(); Dt = accessobject.selectData("BringSeedsByType", param); accessobject.close(); foreach (DataRow row in Dt.Rows) { row["purchasing_price"] = String.Format("{0:n0}", Convert.ToDouble(row["purchasing_price"])); row["selling_price"] = String.Format("{0:n0}", Convert.ToDouble(row["selling_price"])); } return(Dt); }
//public void UpdateDebts(string CustomerId, string NewTotal, string NewReceived , string OldTotal,string OldRec) //{ // DAL.DataAccessLayer accessobject = new DAL.DataAccessLayer(); // SqlParameter[] param = new SqlParameter[3]; // param[0] = new SqlParameter("@customer_id", SqlDbType.NVarChar, 50); // param[0].Value = CustomerId; // param[1] = new SqlParameter("@new_total", SqlDbType.NVarChar, 50); // param[1].Value = NewTotal; // param[2] = new SqlParameter("@new_received", SqlDbType.NVarChar, 50); // param[2].Value = NewReceived; // param[3] = new SqlParameter("@old_total", SqlDbType.NVarChar, 50); // param[3].Value = OldTotal; // param[4] = new SqlParameter("@old_received", SqlDbType.NVarChar, 50); // param[4].Value =OldRec; // accessobject.Executecmd("delete_debts_on_update_invoice", param); // accessobject.close(); //} public void UpdateDebts(string CustomerId, string OrderID, string debt_value, Double MoneyOf, DateTime Dt) { DAL.DataAccessLayer accessobject = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@customer_id", SqlDbType.NVarChar, 50); param[0].Value = CustomerId; param[1] = new SqlParameter("@order_id", SqlDbType.NVarChar, 50); param[1].Value = OrderID; param[2] = new SqlParameter("@debt_value", SqlDbType.NVarChar, 50); param[2].Value = debt_value; param[3] = new SqlParameter("@moneyOf", SqlDbType.Money); param[3].Value = MoneyOf; param[4] = new SqlParameter("@dateT", SqlDbType.DateTime); param[4].Value = Dt; accessobject.open(); accessobject.Executecmd("delete_debts_on_update_invoice", param); accessobject.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 UPDATE_Registered_Student(string TOEFL, string Specialization, string Worked_Fulltime, string document_path, int Intake_code, string accepted, string id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@TOEFL", SqlDbType.VarChar); param[0].Value = TOEFL; param[1] = new SqlParameter("@Specialization", SqlDbType.VarChar); param[1].Value = Specialization; param[2] = new SqlParameter("@Worked_Fulltime", SqlDbType.VarChar); param[2].Value = Worked_Fulltime; param[3] = new SqlParameter("@document_path", SqlDbType.VarChar); param[3].Value = document_path; param[4] = new SqlParameter("@Intake_code", SqlDbType.Int); param[4].Value = Intake_code; param[5] = new SqlParameter("@accepted", SqlDbType.VarChar); param[5].Value = accepted; param[6] = new SqlParameter("@Unique_num", SqlDbType.VarChar); param[6].Value = id; DAL.ExectCommand("UPDATE_Registered_Student", param); 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(); }
public DataTable set_RepaymentForInvoice_in_the_tables(int inv_id, double recived, string Note) { DAL.DataAccessLayer accessobject = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@id", SqlDbType.Int); param[0].Value = inv_id; param[1] = new SqlParameter("@mny", SqlDbType.Money); param[1].Value = recived; param[2] = new SqlParameter("@dateT", SqlDbType.DateTime); param[2].Value = DateTime.Now; param[3] = new SqlParameter("@debt_note", SqlDbType.NVarChar, 50); param[3].Value = Note; DataTable Dt = new DataTable(); Dt = accessobject.selectData("set_RepaymentForInvoice_in_the_tables", param); accessobject.close(); return(Dt); }
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 UPDATE_Research(string Unique_num, int doctor_code, string title_research, string type, string date, int id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@Unique_num", SqlDbType.VarChar); param[0].Value = Unique_num; param[1] = new SqlParameter("@doctor_code", SqlDbType.Int); param[1].Value = doctor_code; param[2] = new SqlParameter("@title_research", SqlDbType.VarChar); param[2].Value = title_research; param[3] = new SqlParameter("@type", SqlDbType.VarChar); param[3].Value = type; param[4] = new SqlParameter("@date", SqlDbType.Date); param[4].Value = date; param[5] = new SqlParameter("@Research_code", SqlDbType.Int); param[5].Value = id; DAL.ExectCommand("UPDATE_Research", param); DAL.close(); }
public void update_inv_tail(int mat_no, string matName, int order_no, int qte, double price, double amount) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@mat_no", SqlDbType.Int); param[0].Value = mat_no; param[1] = new SqlParameter("@order_no", SqlDbType.Int); param[1].Value = order_no; param[2] = new SqlParameter("@qte", SqlDbType.Int); param[2].Value = qte; param[3] = new SqlParameter("@price", SqlDbType.Money); param[3].Value = price; param[4] = new SqlParameter("@amount", SqlDbType.Money); param[4].Value = amount; param[5] = new SqlParameter("@mat_name", SqlDbType.NVarChar, 50); param[5].Value = matName; DAL.Executecmd("add_order_detail", param); DAL.close(); }
public void UPDATE_Book(string name, string publisher, string auther, string text_book, string id) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@name", SqlDbType.VarChar); param[0].Value = name; param[1] = new SqlParameter("@publisher", SqlDbType.VarChar); param[1].Value = publisher; param[2] = new SqlParameter("@auther", SqlDbType.VarChar); param[2].Value = auther; param[3] = new SqlParameter("@text_book", SqlDbType.VarChar); param[3].Value = text_book; param[4] = new SqlParameter("@ISPN", SqlDbType.VarChar); param[4].Value = id; DAL.ExectCommand("UPDATE_Book", param); DAL.close(); }
public void ADD_PRODUCT(int id_cat, string label_product, string id_product, int quantity, string price, byte[] image) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] parm = new SqlParameter[6]; parm[0] = new SqlParameter("@ID_CAT", SqlDbType.Int); parm[0].Value = id_cat; parm[1] = new SqlParameter("@ID_PRODUCT", SqlDbType.NVarChar, 50); parm[1].Value = id_product; parm[2] = new SqlParameter("@LABEL_PRODUCT", SqlDbType.NVarChar, 50); parm[2].Value = label_product; parm[3] = new SqlParameter("@QUANTITY", SqlDbType.Int); parm[3].Value = quantity; parm[4] = new SqlParameter("@PRICE", SqlDbType.NVarChar, 50); parm[4].Value = price; parm[5] = new SqlParameter("@PRODUCT_IMAGE", SqlDbType.Image); parm[5].Value = image; DAL.ExecuteCommand("ADD_PRODUCT", parm); DAL.close(); }
public void add_serve_detail(string ServeName, int order_no, int qte, double price, double amount) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@serve_no", SqlDbType.Int); param[0].Value = order_no; param[1] = new SqlParameter("@qte", SqlDbType.Int); param[1].Value = qte; param[2] = new SqlParameter("@price", SqlDbType.Money); param[2].Value = price; param[3] = new SqlParameter("@amount", SqlDbType.Money); param[3].Value = amount; param[4] = new SqlParameter("@serve_name", SqlDbType.NVarChar, 50); param[4].Value = ServeName; DAL.Executecmd("add_serve_detail", param); DAL.close(); }
public DataTable sel_sumation(int id) { DAL.DataAccessLayer accessobject = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@mnth", SqlDbType.Int); param[0].Value = id; accessobject.open(); DataTable Dt = new DataTable(); Dt = accessobject.selectData("sel_sumation", param); accessobject.close(); foreach (DataRow row in Dt.Rows) { try { row["amount"] = String.Format("{0:n0}", Convert.ToDouble(row["amount"])); } catch { } } return(Dt); }
public void Add_Grade(int course_code, int Intake_code, string Unique_num, decimal Assignment, decimal final_Exam, decimal Total_grade, string year) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@course_code", SqlDbType.Int); param[0].Value = course_code; param[1] = new SqlParameter("@Intake_code", SqlDbType.Int); param[1].Value = Intake_code; param[2] = new SqlParameter("@Unique_num", SqlDbType.VarChar); param[2].Value = Unique_num; param[3] = new SqlParameter("@Assignment", SqlDbType.Decimal); param[3].Value = Assignment; param[4] = new SqlParameter("@final_Exam", SqlDbType.Decimal); param[4].Value = final_Exam; param[5] = new SqlParameter("@Total_grade", SqlDbType.Decimal); param[5].Value = Total_grade; param[6] = new SqlParameter("@year", SqlDbType.Date); param[6].Value = year; DAL.ExectCommand("Add_Grade", param); DAL.close(); }
public DataTable GetStatementPeriod(string id, DateTime start, DateTime end) { DAL.DataAccessLayer accessobject = new DAL.DataAccessLayer(); DataTable IdOfOoder = new DataTable(); IdOfOoder = getOrderOfCustomerP(id, start, end); DataTable result = new DataTable(); if (IdOfOoder.Rows.Count > 0) { for (int i = 0; i <= IdOfOoder.Rows.Count - 1; i++) { SqlParameter[] param = new SqlParameter[1]; String invid = IdOfOoder.Rows[i][0].ToString(); param[0] = new SqlParameter("@id", SqlDbType.NVarChar, 50); param[0].Value = invid; DataTable Dt = new DataTable(); Dt = accessobject.selectData("get_statement", param); accessobject.close(); result.Merge(Dt); } } return(result); }
public void ADD_Course_B_D(int id_course, int id_doctor, int id_intake, string id_book, int id_program, string from_date, string to_date, string plan) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@course_code", SqlDbType.Int); param[0].Value = id_course; param[1] = new SqlParameter("@doctor_code", SqlDbType.Int); param[1].Value = id_doctor; param[2] = new SqlParameter("@Intake_code", SqlDbType.Int); param[2].Value = id_intake; param[3] = new SqlParameter("@ISPN", SqlDbType.VarChar); param[3].Value = id_book; param[4] = new SqlParameter("@program_code", SqlDbType.Int); param[4].Value = id_program; param[5] = new SqlParameter("@from_date", SqlDbType.Date); param[5].Value = from_date; param[6] = new SqlParameter("@to_date", SqlDbType.Date); param[6].Value = to_date; param[7] = new SqlParameter("@plan", SqlDbType.VarChar); param[7].Value = plan; DAL.ExectCommand("ADD_Course_B_D", 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(); }
/******************************** 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 insertMtr(string nameMtr, Double buyPrice, Double salePrice, double quantity, string type, string storeid) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@mat_name", SqlDbType.VarChar, 50); param[0].Value = nameMtr; param[1] = new SqlParameter("@mat_buy_price", SqlDbType.Money); param[1].Value = buyPrice; param[2] = new SqlParameter("@mat_sale_price", SqlDbType.Money); param[2].Value = salePrice; param[3] = new SqlParameter("@Quantity", SqlDbType.Decimal); param[3].Value = quantity; param[4] = new SqlParameter("@type_name", SqlDbType.NVarChar, 50); param[4].Value = type; param[5] = new SqlParameter("@dateT", SqlDbType.DateTime); param[5].Value = DateTime.Now; param[6] = new SqlParameter("@store_id", SqlDbType.NVarChar, 50); param[6].Value = storeid; DAL.Executecmd("insertMatirials", 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(); }
public void add_comp_order_detail(int order_no, string productName, double qte, double price, double amount) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@product_name", SqlDbType.NVarChar, 50); param[0].Value = productName; param[1] = new SqlParameter("@order_no", SqlDbType.Int); param[1].Value = order_no; param[2] = new SqlParameter("@qte", SqlDbType.Decimal); param[2].Value = qte; param[3] = new SqlParameter("@price", SqlDbType.Money); param[3].Value = price; param[4] = new SqlParameter("@amount", SqlDbType.Money); param[4].Value = Convert.ToDouble(amount); DAL.Executecmd("add_comp_order_detail", param); DAL.close(); }
/**********************************************************************/ // اجراء لاضافة البيانات لقاعدة البيانات 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 add_order_details(string id_prod, int id_order, int qte, string price, float discount, string amount, string total_amount) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] parm = new SqlParameter[7]; parm[0] = new SqlParameter("@id_pro", SqlDbType.NVarChar, 50); parm[0].Value = id_prod; parm[1] = new SqlParameter("@id_order", SqlDbType.Int); parm[1].Value = id_order; parm[2] = new SqlParameter("@qte", SqlDbType.Int); parm[2].Value = qte; parm[3] = new SqlParameter("@price", SqlDbType.NVarChar, 50); parm[3].Value = price; parm[4] = new SqlParameter("@discount", SqlDbType.Float); parm[4].Value = discount; parm[5] = new SqlParameter("@amount", SqlDbType.NVarChar, 50); parm[5].Value = amount; parm[6] = new SqlParameter("@total_amount", SqlDbType.NVarChar, 50); parm[6].Value = total_amount; DAL.ExecuteCommand("add_order_details", parm); DAL.close(); }
public void add_doc(int customerID, string id, string note, double total_ammount, double recived, string isCashed, DateTime dateT) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@id", SqlDbType.Int); param[0].Value = Convert.ToInt32(id); param[1] = new SqlParameter("@doc_date", SqlDbType.DateTime); param[1].Value = dateT; param[2] = new SqlParameter("@note", SqlDbType.NVarChar, 50); param[2].Value = note; param[3] = new SqlParameter("@customer_iD", SqlDbType.Int); param[3].Value = customerID; param[4] = new SqlParameter("@total_amount", SqlDbType.Money); param[4].Value = total_ammount; param[5] = new SqlParameter("@recived", SqlDbType.Money); param[5].Value = recived; param[6] = new SqlParameter("@isCashed", SqlDbType.NVarChar, 50); param[6].Value = isCashed; DAL.Executecmd("add_doc", param); DAL.close(); }
/*************************************** ADD **************************************************/ // اجراء لاضافة البيانات لقاعدة البيانات public void ADD_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("ADD_SUPPLAY", param); DAL.close(); }
public void ADD_TAKSET(int id, string rece_price, string total_in_cash, string RABHH, string day, string monthly_price, string mo, string ye) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); DAL.open(); SqlParameter[] parm = new SqlParameter[8]; parm[0] = new SqlParameter("@ID_CUST", SqlDbType.Int); parm[0].Value = id; parm[1] = new SqlParameter("@REC_PRICE", SqlDbType.NVarChar, 50); parm[1].Value = rece_price; parm[2] = new SqlParameter("@TOTAL_IN_CASH", SqlDbType.NVarChar, 50); parm[2].Value = total_in_cash; parm[3] = new SqlParameter("@RABHH", SqlDbType.NVarChar, 50); parm[3].Value = RABHH; parm[4] = new SqlParameter("@day", SqlDbType.NVarChar, 50); parm[4].Value = day; parm[5] = new SqlParameter("@monthly_price", SqlDbType.NVarChar, 50); parm[5].Value = monthly_price; parm[6] = new SqlParameter("@MONTH", SqlDbType.NVarChar, 50); parm[6].Value = mo; parm[7] = new SqlParameter("@YEAR", SqlDbType.NVarChar, 50); parm[7].Value = ye; DAL.ExecuteCommand("ADD_TAKSET", parm); DAL.close(); }