public bool Add(string ev_id, string pro_id, float saleoff, string name, string start_date, string end_date, ref string error) { string sql = "Insert into Event values('" + ev_id + "',N'" + name + "','" + start_date + "','" + end_date + "')" + "Insert into Event_Detail values('" + ev_id + "','" + pro_id + "'," + saleoff + ")"; return(db.MyExecuteNonQuery(sql, CommandType.Text, ref error)); }
/*--------------------------------IMPORT--------------------------------------*/ public bool Add_Import_Bill(string imp_id, string dis_id, string emp_id, string date, float total, ref string err) { return(db.MyExecuteNonQuery("usp_iImport_Bill", CommandType.StoredProcedure, ref err, new SqlParameter("@imp_id", imp_id), new SqlParameter("@dis_id", dis_id), new SqlParameter("@emp_id", emp_id), new SqlParameter("@date", DateTime.Parse(date)), new SqlParameter("@total", total))); }
public bool Add(string cus_id, string name, string mid_name, string sur_name, string gender, string id, string address, string tel, string dob, string img_path, ref string error) { //string sql = "INSERT INTO Customer VALUES('" + cus_id + "',N'" + name + "',N'" + mid_name + "',N'" + sur_name + "','" + gender + "','" + id + "',N'" + address + "','" + tel + "','" + dob + "',N'" + img_path + "')"; return(db.MyExecuteNonQuery("usp_iKhachHang", CommandType.StoredProcedure, ref error, new SqlParameter("@cus_id", cus_id), new SqlParameter("@name", name), new SqlParameter("@mid_name", mid_name), new SqlParameter("@sur_name", sur_name), new SqlParameter("@gender", gender), new SqlParameter("@id", id), new SqlParameter("@add", address), new SqlParameter("@tel", tel), new SqlParameter("@dob", DateTime.Parse(dob)), new SqlParameter("@img", img_path) )); }
public DataSet Get_Imp_Bill(ref string error) { string sql = null; try { if (d == 0) { d = 1; db.MyExecuteNonQuery(sql1, CommandType.Text, ref error); db.MyExecuteNonQuery(sql2, CommandType.Text, ref error); } sql = " Select *From Store_Imp_Bill"; }catch { } return(db.ExecuteQueryDataSet(sql, CommandType.Text)); }
//public bool SignUp(string emp_id, string cus_id, string user, string pass, ref string error) //{ // string sql = "INSERT INTO ACCOUNT VALUES(N'" + emp_id +"',N'" + cus_id +"',N'" + user + "',N'" + pass + "')"; // return db.MyExecuteNonQuery(sql, CommandType.Text, ref error); //} public bool ChangePassword(string username, string oldpass, string newpass, ref string err) { return(db.MyExecuteNonQuery("usp_uMatKhau", CommandType.StoredProcedure, ref err, new SqlParameter("@username", username), new SqlParameter("@oldpass", oldpass), new SqlParameter("@newpass", newpass) )); }
public bool Add(string emp_id, string name, string mid_name, string sur_name, string gender, string id, string address, string tel, string dob, string job, string img_path, string stt, ref string error) { //string sql = "INSERT INTO Employee VALUES('"+emp_id+"',N'"+name+ "',N'"+mid_name+ "',N'"+sur_name+ "','"+gender+ "','"+id + "',N'"+address + "','" +tel + "','" +dob+ "','" +job + "',N'" +img_path + "')"; return(db.MyExecuteNonQuery("usp_iNhanVien", CommandType.StoredProcedure, ref error, new SqlParameter("@emp_id", emp_id), new SqlParameter("@name", name), new SqlParameter("@mid_name", mid_name), new SqlParameter("@sur_name", sur_name), new SqlParameter("@gender", gender), new SqlParameter("@id", id), new SqlParameter("@add", address), new SqlParameter("@tel", tel), new SqlParameter("@dob", DateTime.Parse(dob)), new SqlParameter("@jobid", job), new SqlParameter("@img", img_path), new SqlParameter("@status", stt) )); }
public bool Add_Category(string id, string name, ref string err) { return(db.MyExecuteNonQuery("usp_iLoaiSanPham", CommandType.StoredProcedure, ref err, new SqlParameter("@category_id", id), new SqlParameter("@name", name))); }