public void ThemHangHoa(CHangHoa hh) { Provider dao = new Provider(); try { dao.Connect(); string sql = "PRODUCT_Insert_New"; CommandType type = CommandType.StoredProcedure; dao.ExeCuteNonQuery(type, sql, new SqlParameter { ParameterName = "@Product_ID", Value = hh.Product_ID }, new SqlParameter { ParameterName = "@Product_Name", Value = hh.Product_Name }, new SqlParameter { ParameterName = "@Product_Type_ID", Value = hh.Product_Type_ID }, new SqlParameter { ParameterName = "@Product_Group_ID", Value = hh.Product_Group_ID }, new SqlParameter { ParameterName = "@Provider_ID", Value = hh.Provider_ID }, new SqlParameter { ParameterName = "@Barcode", Value = hh.Barcode }, new SqlParameter { ParameterName = "@Unit", Value = hh.Unit }, new SqlParameter { ParameterName = "@Photo", Value = hh.Photo }, new SqlParameter { ParameterName = "@Org_Price", Value = hh.Org_Price }, new SqlParameter { ParameterName = "@Sale_Price", Value = hh.Sale_Price }, new SqlParameter { ParameterName = "@Retail_Price", Value = hh.Retail_Price }, new SqlParameter { ParameterName = "@Customer_ID", Value = hh.Customer_ID }, new SqlParameter { ParameterName = "@Customer_Name", Value = hh.Customer_Name }, new SqlParameter { ParameterName = "@MinStock", Value = hh.MinStock }, new SqlParameter { ParameterName = "@UserID", Value = hh.UserID }, new SqlParameter { ParameterName = "@Active", Value = hh.Active } ); } catch (SqlException ex) { throw ex; } finally { dao.DisConnect(); } }
public void ThemKH(CKhachHang kh) { Provider dao = new Provider(); try { dao.Connect(); string sql = "CUSTOMER_Insert"; CommandType type = CommandType.StoredProcedure; dao.ExeCuteNonQuery(type, sql, new SqlParameter { ParameterName = "@Customer_ID", Value = kh.MaKH }, new SqlParameter { ParameterName = "@CustomerName", Value = kh.TenKH }, new SqlParameter { ParameterName = "@Customer_Type_ID", Value = kh.LoaiKH }, new SqlParameter { ParameterName = "@CustomerAddress", Value = kh.DiaChi }, new SqlParameter { ParameterName = "@Tax", Value = kh.MaSoThue }, new SqlParameter { ParameterName = "@Tel", Value = kh.DienThoai }, new SqlParameter { ParameterName = "@Fax", Value = kh.Fax }, new SqlParameter { ParameterName = "@Email", Value = kh.Email }, new SqlParameter { ParameterName = "@Mobile", Value = kh.DiDong }, new SqlParameter { ParameterName = "@Website", Value = kh.Website }, new SqlParameter { ParameterName = "@Contact", Value = kh.LienHe }, new SqlParameter { ParameterName = "@NickYM", Value = kh.NickYM }, new SqlParameter { ParameterName = "@NickSky", Value = kh.NickSky }, new SqlParameter { ParameterName = "@BankAccount", Value = kh.TaiKhoan }, new SqlParameter { ParameterName = "@BankName", Value = kh.NganHang }, new SqlParameter { ParameterName = "@CreditLimit", Value = kh.GioiHanNo }, new SqlParameter { ParameterName = "@Discount", Value = kh.ChietKhau }, new SqlParameter { ParameterName = "@Customer_Group_ID", Value = kh.KhuVuc }, new SqlParameter { ParameterName = "@Active", Value = kh.ConQL }, new SqlParameter { ParameterName = "@OrderID", Value = 0 }, new SqlParameter { ParameterName = "@Birthday", Value = "" }, new SqlParameter { ParameterName = "@Barcode", Value = kh.MaKH }, new SqlParameter { ParameterName = "@Position", Value = "" }, new SqlParameter { ParameterName = "@Area", Value = "" }, new SqlParameter { ParameterName = "@District", Value = "" }, new SqlParameter { ParameterName = "@Contry", Value = "" }, new SqlParameter { ParameterName = "@City", Value = "" }, new SqlParameter { ParameterName = "@Description", Value = "" }); } catch (SqlException ex) { throw ex; } finally { dao.DisConnect(); } }
public void ThemNV(CNhanVien nv) { Provider dao = new Provider(); try { dao.Connect(); string sql = "EMPLOYEE_Insert"; CommandType type = CommandType.StoredProcedure; dao.ExeCuteNonQuery(type, sql, new SqlParameter { ParameterName = "@Employee_ID", Value = nv.MaNV }, new SqlParameter { ParameterName = "@FirtName", Value = nv.FirtName }, new SqlParameter { ParameterName = "@LastName", Value = nv.LastName }, new SqlParameter { ParameterName = "@Employee_Name", Value = nv.TenNV }, new SqlParameter { ParameterName = "@Alias", Value = nv.Alias }, new SqlParameter { ParameterName = "@Sex", Value = nv.GioiTinh }, new SqlParameter { ParameterName = "@Address", Value = nv.DiaChi }, new SqlParameter { ParameterName = "@Country_ID", Value = nv.Country_ID }, new SqlParameter { ParameterName = "@H_Tel", Value = nv.H_Tel }, new SqlParameter { ParameterName = "@O_Tel", Value = nv.DienThoai }, new SqlParameter { ParameterName = "@Mobile", Value = nv.DiDong }, new SqlParameter { ParameterName = "@Fax", Value = nv.Fax }, new SqlParameter { ParameterName = "@Email", Value = nv.Email }, new SqlParameter { ParameterName = "@Birthday", Value = nv.NgaySinh }, new SqlParameter { ParameterName = "@Married", Value = nv.Married }, new SqlParameter { ParameterName = "@Position_ID", Value = nv.Position_ID }, new SqlParameter { ParameterName = "@JobTitle_ID", Value = nv.JobTitle_ID }, new SqlParameter { ParameterName = "@Branch_ID", Value = nv.Branch_ID }, new SqlParameter { ParameterName = "@Department_ID", Value = nv.BoPhan }, new SqlParameter { ParameterName = "@Team_ID", Value = nv.Team_ID }, new SqlParameter { ParameterName = "@PersonalTax_ID", Value = nv.PersonalTax_ID }, new SqlParameter { ParameterName = "@City_ID", Value = nv.City_ID }, new SqlParameter { ParameterName = "@District_ID", Value = nv.District_ID }, new SqlParameter { ParameterName = "@Manager_ID", Value = nv.QuanLy }, new SqlParameter { ParameterName = "@EmployeeType", Value = nv.EmployeeType }, new SqlParameter { ParameterName = "@BasicSalary", Value = nv.BasicSalary }, new SqlParameter { ParameterName = "@Advance", Value = nv.Advance }, new SqlParameter { ParameterName = "@AdvanceOther", Value = nv.AdvanceOther }, new SqlParameter { ParameterName = "@Commission", Value = nv.Commission }, new SqlParameter { ParameterName = "@Discount", Value = nv.Discount }, new SqlParameter { ParameterName = "@ProfitRate", Value = nv.ProfitRate }, new SqlParameter { ParameterName = "@IsPublic", Value = nv.IsPublic }, new SqlParameter { ParameterName = "@CreatedBy", Value = nv.CreatedBy }, new SqlParameter { ParameterName = "@CreatedDate", Value = nv.CreatedDate }, new SqlParameter { ParameterName = "@ModifiedBy", Value = nv.ModifiedBy }, new SqlParameter { ParameterName = "@ModifiedDate", Value = nv.ModifiedDate }, new SqlParameter { ParameterName = "@OwnerID", Value = nv.OwnerID }, new SqlParameter { ParameterName = "@Description", Value = nv.ChucVu }, new SqlParameter { ParameterName = "@Sorted", Value = nv.Sorted }, new SqlParameter { ParameterName = "@Active", Value = nv.ConQL }); } catch (SqlException ex) { throw ex; } finally { dao.DisConnect(); } }