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();
}
}
