public void Delete(OSanPham sach)
{
conn.connect();
var comm = new SqlCommand("SanPham_Delete", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = sach.MaSanPham;
comm.ExecuteNonQuery();
}
public ActionResult Update(OSanPham model)
{
if (ModelState.IsValid)
{
var pro = sanphamService.Get(new OSanPham {
MaSanPham = model.MaSanPham
});
if (pro != null)
{
try
{
model.TenVanTat = Help.Helper.convertToUnSign3(model.TenSanPham);
//model.CreateBy = CurrentUser.Name;
if (model.IsSach != null && model.IsSach == true)
{
foreach (var item in model.MaTacGia)
{
var tacgia = tacGiaService.Get(item);
model.TuKhoa += Help.Helper.convertLower(tacgia.Ten + ",");
}
}
sanphamService.Update(model);
sach_TacGiaService.Delete(model.MaSanPham);
if (model.MaTacGia != null && model.MaTacGia.ToList().Count > 0)
{
foreach (int item in model.MaTacGia)
{
sach_TacGiaService.Add(new OSach_TacGia
{
MaTacGia = item,
MaSanPham = model.MaSanPham,
});
}
}
return(RedirectToAction("Search", "QuanLySanPham", new { isSach = model.IsSach }));
}
catch (Exception e)
{
}
}
}
List <OChuDe> listCate = chuDeService.GetAll();
ViewBag.ListCate = new SelectList(listCate, "MaChuDe", "Ten");
List <ONhaXuatBan> listNXB = nxbService.GetAll();
ViewBag.ListNXB = new SelectList(listNXB, "MaNXB", "TenNXB");
ViewBag.ListTacGia = tacGiaService.GetAllActive();
ViewBag.ListNCC = new SelectList(nccService.GetAllActive(), "MaNCC", "TenNCC");
ViewBag.IsEdit = true;
return(View(model));
}
public OSanPham Get(OSanPham sach)
{
conn.connect();
var comm = new SqlCommand("SanPham_Get", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = sach.MaSanPham;
OSanPham item = new OSanPham();
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
item = Help.DAL.ConvertDataTable <OSanPham>(dt).FirstOrDefault();
return(item);
}
public OSanPham GetByShortName(string shortname)
{
conn.connect();
var comm = new SqlCommand("SanPham_GetByShortName", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@TenVanTat", SqlDbType.NVarChar).Value = shortname;
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
OSanPham item = new OSanPham();
item = Help.DAL.ConvertDataTable <OSanPham>(dt).FirstOrDefault();
return(item);
}
public List <OSanPham> GetOrther(OSanPham model)
{
conn.connect();
var comm = new SqlCommand("SanPham_GetOrther", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = model.MaSanPham;
comm.Parameters.Add("@IsSach", SqlDbType.Bit).Value = model.IsSach;
comm.Parameters.Add("@MaChuDe", SqlDbType.Int).Value = model.MaChuDe;
List <OSanPham> list = new List <OSanPham>();
DataTable dt = new DataTable();
dt.Load(comm.ExecuteReader());
list = Help.DAL.ConvertDataTable <OSanPham>(dt);
return(list);
}
public void Update(OSanPham sach)
{
conn.connect();
var comm = new SqlCommand("SanPham_Update", conn.db);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = sach.MaSanPham;
comm.Parameters.Add("@TenSanPham", SqlDbType.NVarChar).Value = sach.TenSanPham;
comm.Parameters.Add("@MaChuDe", SqlDbType.Int).Value = sach.MaChuDe;
//comm.Parameters.Add("@MoTa", SqlDbType.NVarChar).Value = sach.MoTa;
comm.Parameters.Add(new SqlParameter("@MoTa", sach.MoTa ?? (object)DBNull.Value));
comm.Parameters.Add("@Anh", SqlDbType.NVarChar).Value = sach.Anh;
comm.Parameters.Add("@GiaBan", SqlDbType.Decimal).Value = sach.GiaBan;
//comm.Parameters.Add("@GiaNhap", SqlDbType.Decimal).Value = sach.GiaNhap;
comm.Parameters.Add(new SqlParameter("@GiaNhap", sach.GiaNhap ?? (object)DBNull.Value));
comm.Parameters.Add("@SoLuong", SqlDbType.Int).Value = sach.SoLuong;
comm.Parameters.Add(new SqlParameter("@GhiChu", sach.GhiChu ?? (object)DBNull.Value));
comm.Parameters.Add("@TenVanTat", SqlDbType.NVarChar).Value = Help.Helper.convertToUnSign3(sach.TenVanTat);
comm.Parameters.Add("@IsHot", SqlDbType.Bit).Value = sach.SanPhamHot;
comm.Parameters.Add("@IsActive", SqlDbType.Bit).Value = sach.TrangThai;
comm.Parameters.Add("@Keyword", SqlDbType.NVarChar).Value = sach.TuKhoa;
//comm.Parameters.Add("@Sale", SqlDbType.Int).Value = sach.Sale;
comm.Parameters.Add(new SqlParameter("@Sale", sach.KhuyenMai ?? (object)DBNull.Value));
comm.Parameters.Add("@IsSach", SqlDbType.Bit).Value = sach.IsSach;
//comm.Parameters.Add("@MaNXB", SqlDbType.Int).Value = sach.MaNXB;
comm.Parameters.Add(new SqlParameter("@MaNXB", sach.MaNXB ?? (object)DBNull.Value));
comm.Parameters.Add(new SqlParameter("@MaNCC", sach.MaNCC ?? (object)DBNull.Value));
comm.Parameters.Add(new SqlParameter("@DichGia", sach.DichGia ?? (object)DBNull.Value));
//comm.Parameters.Add("@KichThuoc", SqlDbType.NVarChar).Value = sach.KichThuoc;
comm.Parameters.Add(new SqlParameter("@KichThuoc", sach.KichThuoc ?? (object)DBNull.Value));
//comm.Parameters.Add("@NamXB", SqlDbType.Int).Value = sach.NamXB;
comm.Parameters.Add(new SqlParameter("@NamXB", sach.NamXB ?? (object)DBNull.Value));
comm.Parameters.Add(new SqlParameter("@SoTrang", sach.SoTrang ?? (object)DBNull.Value));
comm.ExecuteNonQuery();
}
public ActionResult Create(bool isSach)
{
OSanPham data = new OSanPham();
data.TrangThai = false;
data.SanPhamHot = false;
data.IsSach = isSach;
List <OChuDe> listCate = chuDeService.GetAll();
ViewBag.ListCate = new SelectList(listCate, "MaChuDe", "Ten");
List <ONhaXuatBan> listNXB = nxbService.GetAll();
ViewBag.ListNXB = new SelectList(listNXB, "MaNXB", "TenNXB");
ViewBag.ListTacGia = new SelectList(tacGiaService.GetAll(), "MaTacGia", "Ten");
ViewBag.ListNCC = new SelectList(nccService.GetAllActive(), "MaNCC", "TenNCC");
return(View("Update", data));
}
public ActionResult Create(OSanPham model)
{
if (ModelState.IsValid)
{
// var pro = ServiceFactory.NewsgoryManager.Get(new Newsgories { NewsgoryId = model.NewsgoryId });
try
{
model.TenVanTat = Help.Helper.convertToUnSign3(model.TenSanPham);
model.TuKhoa += Help.Helper.convertLower(model.TenSanPham + ", ");
var category = chuDeService.Get(new OChuDe {
MaChuDe = (int)model.MaChuDe
});
model.TuKhoa += Help.Helper.convertLower(category.Ten + ",");
var account = (OAccount)Session["Account"];
model.NguoiTao = (Guid)account.MaTK;
if (model.IsSach != null && model.IsSach == true)
{
foreach (var item in model.MaTacGia)
{
var tacgia = tacGiaService.Get(item);
model.TuKhoa += Help.Helper.convertLower(tacgia.Ten + ",");
}
}
//if (model.IsSach == true)
//{
// System.IO.FileStream fs = new System.IO.FileStream("/sach/" + model.TenVanTat, System.IO.FileMode.Create);
//}
//else
//{
// System.IO.FileStream fs = new System.IO.FileStream("/do-dung-hoc-tap/" + model.TenVanTat, System.IO.FileMode.Create);
//}
sanphamService.Add(model);
if (model.IsSach != null && model.IsSach == true)
{
var idSach = sanphamService.GetLastId();
if (model.MaTacGia.ToList() != null && model.MaTacGia.ToList().Count > 0)
{
foreach (int item in model.MaTacGia)
{
sach_TacGiaService.Add(new OSach_TacGia
{
MaTacGia = item,
MaSanPham = idSach,
});
}
}
}
return(RedirectToAction("Search", "QuanLySanPham", new { isSach = model.IsSach }));
}
catch (Exception e)
{
}
}
List <OChuDe> listCate = chuDeService.GetAll();
ViewBag.ListCate = new SelectList(listCate, "MaChuDe", "Ten");
List <ONhaXuatBan> listNXB = nxbService.GetAll();
ViewBag.ListNXB = new SelectList(listNXB, "MaNXB", "TenNXB");
ViewBag.ListTacGia = new SelectList(tacGiaService.GetAll(), "MaTacGia", "Ten");
ViewBag.ListNCC = new SelectList(nccService.GetAllActive(), "MaNCC", "TenNCC");
ViewBag.IsEdit = true;
return(View("Update", model));
}
