SqlCommand setData(SqlCommand cmd, DanhMucSP categoryTarget)
{
cmd.Parameters.Add("@MaDM", SqlDbType.VarChar).Value = categoryTarget.MaDM;
cmd.Parameters.Add("@TenDM", SqlDbType.NVarChar).Value = categoryTarget.TenDM;
cmd.Parameters.Add("@SoLuong", SqlDbType.Int).Value = categoryTarget.SoLuong;
return(cmd);
}
public async Task <bool> Add(DanhMucSP danhMucSP)
{
await db.DanhMucSP.AddAsync(danhMucSP);
await db.SaveChangesAsync();
return(true);
}
public DanhMucSP EditProductCategory(DanhMucSP productcategoryToEdit)
{
var originalProductCategory = GetProductCategory(productcategoryToEdit.MaDM);
_entities.Entry(originalProductCategory).CurrentValues.SetValues(productcategoryToEdit);
//_entities.Update_DanhMucSP(productcategoryToEdit.MaDM, productcategoryToEdit.TenDM, productcategoryToEdit.SoLuong);
_entities.SaveChanges();
return(productcategoryToEdit);
}
public bool DeleteCategory(DanhMucSP categoryToDelete)
{
try
{
_categoryrepository.DeleteProductCategory(categoryToDelete);
}
catch
{
return(false);
}
return(true);
}
public DanhMucSP EditProductCategory(DanhMucSP productcategoryToEdit)
{
var originalProductCategory = GetProductCategory(productcategoryToEdit.MaDM);
if (!originalProductCategory.Equals(productcategoryToEdit))
{
originalProductCategory.TenDM = productcategoryToEdit.TenDM;
originalProductCategory.SoLuong = productcategoryToEdit.SoLuong;
}
_entities.SaveChanges();
return(productcategoryToEdit);
}
private void dvDanhmuc_SelectionChanged(object sender, EventArgs e)
{
btnxoa.Visible = true;
btnsua.Visible = true;
btnthem.Visible = false;
if (dvDanhmuc.SelectedRows.Count > 0)
{
DanhMucSP dm = (DanhMucSP)dvDanhmuc.SelectedRows[0].DataBoundItem;
txtmadm.Text = dm.MaDM.ToString();
txttendm.Text = dm.TenDM.ToString();
}
}
public void DeleteProductCategory(DanhMucSP productcategoryToDelete)
{
if (connection.State == ConnectionState.Closed || connection.State == ConnectionState.Broken)
{
connection.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Delete_DanhMucSP";
cmd.Parameters.Add("@MaDM", SqlDbType.VarChar).Value = productcategoryToDelete.MaDM;
cmd.Connection = connection;
cmd.ExecuteNonQuery();
connection.Close();
}
public DanhMucSP EditProductCategory(DanhMucSP productcategoryToEdit)
{
if (connection.State == ConnectionState.Closed || connection.State == ConnectionState.Broken)
{
connection.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Update_DanhMucSP";
cmd = setData(cmd, productcategoryToEdit);
cmd.Connection = connection;
cmd.ExecuteNonQuery();
connection.Close();
return(productcategoryToEdit);
}
//Đã check lần 1-Finish
#region Danh Mục SP
public bool CreateCategory(DanhMucSP categoryToCreate)
{
if (!ValidateCategory(categoryToCreate))
{
return(false);
}
try
{
_categoryrepository.CreateProductCategory(categoryToCreate);
}
catch
{
return(false);
}
return(true);
}
// update
public bool Update(DanhMucSP entity)
{
try
{
var xb = db.DanhMucSPs.Find(entity.MaDM);
xb.MaDM = entity.MaDM;
xb.TenDM = entity.TenDM;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool EditCategory(DanhMucSP categoryToEdit)
{
if (!ValidateCategory(categoryToEdit))
{
return(false);
}
try
{
_categoryrepository.EditProductCategory(categoryToEdit);
}
catch
{
return(false);
}
return(true);
}
public JsonResult Delete(int id)
{
bool result = false;
Sach ct = db.Saches.Where(x => x.MaDM == id).FirstOrDefault();
if (ct == null)
{
DanhMucSP s = db.DanhMucSPs.Where(x => x.MaDM == id).SingleOrDefault();
if (s != null)
{
new CategoryDao().Delete(id);
db.SaveChanges();
result = true;
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool ValidateCategory(DanhMucSP categoryToValidate)
{
_validationDictionary.Clear();
if (categoryToValidate.MaDM.Trim().Length == 0)
{
_validationDictionary.AddError("MaDM", "Vui lòng nhập mã danh mục");
}
if (categoryToValidate.TenDM.Length == 0)
{
_validationDictionary.AddError("Ten", "Vui lòng nhập tên danh mục");
}
if (categoryToValidate.SoLuong < 0)
{
_validationDictionary.AddError("SoLuong", "Vui lòng nhập số lượng hợp lệ");
}
return(_validationDictionary.IsValid);
}
public ActionResult Edit(DanhMucSP xb)
{
if (ModelState.IsValid)
{
var dao = new CategoryDao();
var result = dao.Update(xb);
if (result)
{
SetAlert("Sửa thông tin danh mục thành công", "success");
return(RedirectToAction("Index", "Category"));
}
else
{
ModelState.AddModelError("", "Cập nhật thông tin danh mục không thành công");
}
}
return(View("Index"));
}
public ActionResult Create(DanhMucSP tt)
{
if (ModelState.IsValid)
{
var dao = new CategoryDao();
long id = dao.Insert(tt);
if (id > 0)
{
SetAlert("Thêm danh mục sản phẩm thành công", "success");
return(RedirectToAction("Index", "Category"));
}
else
{
ModelState.AddModelError("", "Thêm danh mục không thành công");
}
}
return(View("Index"));
}
public DanhMucSP GetProductCategory(string Key)
{
if (connection.State == ConnectionState.Closed || connection.State == ConnectionState.Broken)
{
connection.Open();
}
//Kiểm tra thông tin đăng nhập
string cmdsql = "SELECT * FROM DanhMucSP Where MaDM='" + Key + "' ";
SqlCommand myCommand = new SqlCommand(cmdsql, connection);
DataTable dataTable = new DataTable();
try
{
SqlDataReader sqlDataReader = myCommand.ExecuteReader();
dataTable.Load(sqlDataReader);
DanhMucSP Target = Infrastructure.Encode.ConvertToNumberale <DanhMucSP>(dataTable).FirstOrDefault();
return(Target);
}
catch
{
return(null);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
int flag = 0;
//Kiểm tra text box
if (!checkSoLuong())
{
return;
}
DanhMucSP Target = getProductCategory();
if (btnThem.Enabled == true)
{
if (_service.CreateCategory(Target))
{
MessageBox.Show("Thêm thành công");
}
else
{
flag = 1;
}
}
if (btnSua.Enabled == true)
{
if (_service.EditCategory(Target))
{
MessageBox.Show("Sửa thành công");
}
else
{
flag = 1;
}
}
if (btnXoa.Enabled == true)
{
DialogResult dlr = MessageBox.Show("Bạn có muốn xóa hóa đơn", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlr == DialogResult.Yes)
{
if (_service.DeleteCategory(Target))
{
MessageBox.Show("Xóa thành công");
}
else
{
flag = 1;
}
}
}
if (flag == 0)
{
View();
HienChiTiet(false);
btnThem.Enabled = true;
btnXoa.Enabled = true;
btnSua.Enabled = true;
XoaTrangChiTiet();
}
else
{
ViewErrors();
}
}
public void DeleteProductCategory(DanhMucSP target)
{
_entities.DanhMucSPs.Remove(target);
_entities.SaveChanges();
}
// Insert
public long Insert(DanhMucSP entity)
{
db.DanhMucSPs.Add(entity);
db.SaveChanges();
return(entity.MaDM);
}
public DanhMucSP CreateProductCategory(DanhMucSP target)
{
_entities.DanhMucSPs.Add(target);
_entities.SaveChanges();
return(target);
}
