public bool XoaLK(LinhKien lk, Gia_LK glk)
{
bool isXoaGiaLK = lkDAL.XoaGiaLinhKien(glk);
bool isXoaLK = lkDAL.XoaLinhKien(lk);
return(isXoaGiaLK && isXoaGiaLK);
}
public ActionResult Add(string MLLK, string MLM, string MNCC, string TLK, string TSKT, string TGBH, string MT, HttpPostedFileBase photo)
{
ViewBag.Title = "Thêm linh kiện mới";
var product = new LinhKien();
product.maLoaiLinhKien = int.Parse(MLLK);
product.maLoaiMay = int.Parse(MLM);
product.maNhaCungCap = int.Parse(MNCC);
product.tenLinhKien = TLK;
product.thongSoKyThuat = TSKT;
product.thoiGianBaoHanh = TGBH;
product.moTa = MT;
product.img = "";
if (ModelState.IsValid)
{
if (photo != null && photo.ContentLength > 0)
{
var path = Path.Combine(Server.MapPath("~/Areas/Admin/Content/Photo/"),
System.IO.Path.GetFileName(photo.FileName));
photo.SaveAs(path);
product.img = photo.FileName;
}
var dao = new DbAcessLinhKienMayTinh();
dao.Add(product);
return(RedirectToAction("Index"));
}
else
{
return(View(product));
}
}
public bool ThemLinhKien(LinhKien lk)
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
// string newBarcode = LinhKienBUS.TaoMa();
string sql_Them = "insert into LinhKien(MaLK,TenLK,LoaiLK,NhaSX,XuatXu,NamSX,SoLuong,MaNCC) values ('" +
lk.Str_MaLK + "',N'" +
lk.Str_TenLK + "','" +
lk.Str_LoaiLK + "','" +
lk.Str_NSX + "','" +
lk.Str_XuatXu + "','" +
lk.NamSX1 + "'," +
lk.SoLuong1 + ",'" +
lk.Str_MaNCC + "')";
dtsql.ExecNonQuery(sql_Them);
return(true);
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
return(false);
}
}
private void btnXuat_Click(object sender, EventArgs e)
{
for (int x = 0; x < mList_Goc.Count; x++)
{
if (mList_Goc[x].IDTuyChon != "")
{
LinhKien linhkien = mList.FirstOrDefault(v => v.ID == mList_Goc[x].ID);
mList_Goc[x].TenSanPham = linhkien.TenSanPham;
mList_Goc[x].Gia = linhkien.Gia;
mList_Goc[x].GiaSoSanh = linhkien.GiaSoSanh;
mList_Goc[x].Tag = linhkien.Tag;
mList_Goc[x].ChuThich = linhkien.ChuThich;
}
}
dataGridViewXuat.Show();
dataGridViewXuat.Rows.Clear();
foreach (LinhKien sp in mList_Goc)
{
int n = dataGridViewXuat.Rows.Add();
dataGridViewXuat.Rows[n].Cells[0].Value = sp.Alias;
dataGridViewXuat.Rows[n].Cells[1].Value = sp.TenSanPham;
dataGridViewXuat.Rows[n].Cells[2].Value = sp.SKU;
dataGridViewXuat.Rows[n].Cells[3].Value = sp.Gia;
dataGridViewXuat.Rows[n].Cells[4].Value = sp.GiaSoSanh;
dataGridViewXuat.Rows[n].Cells[5].Value = sp.AnhDaiDien;
dataGridViewXuat.Rows[n].Cells[6].Value = sp.CanNang;
dataGridViewXuat.Rows[n].Cells[7].Value = sp.ID;
dataGridViewXuat.Rows[n].Cells[8].Value = sp.IDTuyChon;
dataGridViewXuat.Rows[n].Cells[9].Value = sp.Tag;
}
btnExcel.Show();
}
public List <Anhs> DeleteAnh(User admin, LinhKien lk)
{
if (admin.chucNang == "admin")
{
model.Anhs.Remove(GetAnh(lk.maLinhKien));
model.SaveChanges();
}
return(GetListAnh(lk.maLinhKien));
}
public LinhKiens(LinhKien item)
{
MaLinhKien = item.maLinhKien;
MaLoaiLinhKien = item.maLoaiMay;
MaNhaCungCap = item.maNhaCungCap;
MaLoaiMay = item.maLoaiMay;
TenLinhKien = item.tenLinhKien;
ThongSoKyThuat = item.thongSoKyThuat;
MoTa = item.moTa;
GiaBan = item.giaBan;
ThoiGianBaoHanh = item.thoiGianBaoHanh;
}
public bool SuaTTLinhKien(LinhKien lk)
{
try
{
string sql_SuaTTlk = "update LINHKIEN SET TENLK = '" + lk.Str_TenLK + "', LOAILK='" + lk.Str_LoaiLK + "', NHASX= '" + lk.Str_NSX + "',XUATXU= '" + lk.Str_XuatXu + "', NAMSX='" + lk.NamSX1 + "', MANCC='" + lk.Str_MaNCC + "' where MaLK = '" + lk.Str_MaLK + "' ";
dtsql.ExecNonQuery(sql_SuaTTlk);
return(true);
}
catch
{
return(false);
}
}
public int Delete(int id)
{
LinhKien pro = Db.LinhKiens.Find(id);
if (pro != null)
{
Db.LinhKiens.Remove(pro);
return(Db.SaveChanges());
}
else
{
return(-1);
}
}
public bool XoaLinhKien(LinhKien lk)
{
try
{
string sqp_Xoa = "delete from LinhKien where MaLK = '" + lk.Str_MaLK + "' ";
dtsql.ExecNonQuery(sqp_Xoa);
return(true);
}
catch
{
return(false);
}
}
public bool CapNhatGiaNhap(LinhKien lk)
{
try
{
string sql_Them = "update LinhKien set " + "GiaNhap = " + "'" + lk.GiaNhap + "' where MaLK= '" + lk.Str_MaLK + "'";
dtsql.ExecNonQuery(sql_Them);
return(true);
}
catch
{
return(false);
}
}
public DataTable DanhsachGiaLK(LinhKien lk)
{
try
{
// tao cau sql lay DL
string sql_LK =
"select NgayApDung, GiaBan FROM GIA_LK where MaLK='" + lk.Str_MaLK + "' order by NgayApDung DESC ";
return(dtsql.ExecQuery(sql_LK));
}
catch
{
return(null);
}
}
private void dataGridViewKetQua_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
dataGridViewKetQua.CurrentRow.Selected = true;
_linhkien = new LinhKien();
_linhkien.ID = Convert.ToInt32(dataGridViewKetQua.Rows[e.RowIndex].Cells["ID"].FormattedValue.ToString());
_linhkien.TenLinhKien = dataGridViewKetQua.Rows[e.RowIndex].Cells["Ten"].FormattedValue.ToString();
_linhkien.GiaTien = Convert.ToInt32(dataGridViewKetQua.Rows[e.RowIndex].Cells["Gia"].FormattedValue.ToString());
}
catch
{ }
lbSanPham.Text = _linhkien.TenLinhKien;
lbGia.Text = _linhkien.GiaTien.ToString() + "đ";
}
public eLinhKien TimKiemLKTheoTen(string tenlk) // Lấy dữ liệu của xe theo mã xe
{
LinhKien x = db.LinhKiens.Where(s => s.TenLK.Contains(tenlk)).FirstOrDefault();
if (x != null)
{
eLinhKien t = new eLinhKien();
t.Malk = x.MaLK;
t.Tenlk = x.TenLK;
t.Loailk = x.Loai;
t.Giatien = double.Parse(x.GiaTien.ToString());
return(t);
}
else
{
return(null);
}
}
public List <LinhKiens> AddLinhKien(Users admin, LinhKiens lk)
{
if (admin.chucNang == "admin")
{
var linhKien = new LinhKien();
linhKien.maLinhKien = lk.MaLinhKien;
linhKien.maLoaiLinhKien = lk.MaLoaiLinhKien;
linhKien.maNhaCungCap = lk.MaNhaCungCap;
linhKien.maLoaiMay = lk.MaLoaiMay;
linhKien.tenLinhKien = lk.TenLinhKien;
linhKien.thongSoKyThuat = lk.ThongSoKyThuat;
linhKien.moTa = lk.MoTa;
linhKien.giaBan = lk.GiaBan;
linhKien.thongSoKyThuat = lk.ThongSoKyThuat;
linhKien.thoiGianBaoHanh = lk.ThoiGianBaoHanh;
model.LinhKiens.Add(linhKien);
model.SaveChanges();
}
return(GetListLinhKien());
}
private void btnXuLi_Click(object sender, EventArgs e)
{
foreach (LinhKien _linhkien in mList_Goc)
{
if (mList_KetQua.FirstOrDefault(v => v.DuongDan == _linhkien.DuongDan) == null)
{
LinhKien mLinhKien = new LinhKien();
mLinhKien = _linhkien;
mLinhKien.ListAnh.Add(_linhkien.AnhDaiDien);
mLinhKien.LinkAnhSaPo = _linhkien.AnhDaiDien;
mList_KetQua.Add(mLinhKien);
}
else
{
int x = mList_KetQua.FindIndex(v => v.DuongDan == _linhkien.DuongDan);
mList_KetQua[x].ListAnh.Add(_linhkien.AnhDaiDien);
mList_KetQua[x].LinkAnhSaPo = mList_KetQua[x].LinkAnhSaPo + "," + _linhkien.AnhDaiDien;
}
}
ShowDataGirdViewEnd();
}
public bool CapNhatLK(LinhKien lk)
{
try
{
string sql_Sua = "update LinhKien set " +
"TenLK = " + "'" + lk.Str_TenLK + "' ," +
"LoaiLK = " + "'" + lk.Str_LoaiLK + "'," +
"NhaSX = " + "'" + lk.Str_NSX + "'," +
"XuatXu = " + "'" + lk.Str_XuatXu + "'," +
"NamSx = " + "" + lk.NamSX1 + "," +
"NhaCC = " + "'" + lk.Str_MaNCC + "'," +
"SoLuong = " + "'" + lk.SoLuong1 + "' " +
" where id = " + lk.Str_MaLK;
dtsql.ExecNonQuery(sql_Sua);
return(true);
}
catch
{
return(false);
}
}
public void Add(LinhKien pro)
{
Db.LinhKiens.Add(pro);
Db.SaveChanges();
}
public void CapNhatSLKho(LinhKien ex)
{
bus.CapNhatSLKho(ex);
}
public async Task <IActionResult> AddPost([FromForm] ProductAddViewModel dto)
{
if (!ModelState.IsValid)
{
//Get All Category
var categorys = await _llkRepository.getAll();
var categoryDTO = _mapper.Map <List <LoaiLinhKienDTO> >(categorys);
ViewBag.Category = categoryDTO;
//Get All Manufactuer
var manufactuers = await _nccRepository.getAll();
var manuDTO = _mapper.Map <List <NhaCungCapDTO> >(manufactuers);
ViewBag.Manu = manuDTO;
return(View("~/Views/Admin/Product/Add.cshtml", dto));
}
//Lưu Hình vào Server
string contentRootPath = _webHostEnvironment.ContentRootPath;
string pathS = "";
Random rnd = new Random();
pathS = Path.Combine(contentRootPath, "images");
pathS = Path.Combine(pathS, "products");
string Hinh = "";
foreach (var formFile in dto.files)
{
if (formFile.Length > 0)
{
try
{
string fileName = dto.MaLK + rnd.Next(1, 100000) + Path.GetExtension(formFile.FileName);
string _path = Path.Combine(contentRootPath, "wwwroot\\images");
_path = Path.Combine(_path, "products");
_path = Path.Combine(_path, fileName);
using (var fileStream = new FileStream(_path, FileMode.Create))
{
await formFile.CopyToAsync(fileStream);
}
Hinh += fileName + ",";
}
catch
{
//Get All Category
var categorys = await _llkRepository.getAll();
var categoryDTO = _mapper.Map <List <LoaiLinhKienDTO> >(categorys);
ViewBag.Category = categoryDTO;
//Get All Manufactuer
var manufactuers = await _nccRepository.getAll();
var manuDTO = _mapper.Map <List <NhaCungCapDTO> >(manufactuers);
ViewBag.Manu = manuDTO;
ModelState.AddModelError("Hinh", "Upload hình không thành công");
return(View("~/Views/Admin/Product/Add.cshtml", dto));
}
}
}
Hinh = Hinh.Remove(Hinh.Length - 1);
//Create Entity
LinhKien lk = new LinhKien();
lk.TenLK = dto.TenLK;
lk.MaLK = dto.MaLK;
lk.MoTa = dto.MoTa;
lk.TGBH = dto.TGBH;
lk.SLTonKho = dto.SLTonKho;
DonGia donGia = new DonGia();
donGia.DonGiaBan = (decimal)dto.Gia;
donGia.GiamGia = dto.GiamGia;
donGia.ApDung = true;
donGia.Ngay = DateTime.Now.Date;
List <DonGia> donGias = new List <DonGia>();
donGias.Add(donGia);
lk.DonGias = donGias;
var loaillk = await _llkRepository.getById(dto.Loai);
var ncc = await _nccRepository.getById(dto.NCC);
lk.Loai = loaillk;
lk.NCC = ncc;
lk.Hinh = Hinh;
await _linhKienRepository.Add(lk);
return(Redirect("/admin/product"));
}
public async Task Add(LinhKien item)
{
item.isDelete = 0;
_context.LinhKiens.Add(item);
await _context.SaveChangesAsync();
}
public void UpdateSL(LinhKien lk)
{
KetNoi.ExecuteReader(@"Update LinhKien Set SoLuongTon=" + lk.SoLuongTon + " Where MaLK='" + lk.MaLK + "' ");
}
public void UpdateSoLuongKho(LinhKien ex)
{
bus.UpdateSoLuongKho(ex);
}
public bool CapNhatGiaNhap(LinhKien lk)
{
return(lkDAL.CapNhatGiaNhap(lk));
}
public void UpdateSoLuongKho(LinhKien ex)
{
KetNoi.ExecuteReader(@"Update LinhKien Set SoLuongTon=" + ex.SoLuongTon + " Where MaLK=N'" + ex.MaLK + "'");
}
public void UpdateSL(LinhKien lk)
{
bus.UpdateSL(lk);
}
public async Task Update(LinhKien item)
{
_context.LinhKiens.Update(item);
await _context.SaveChangesAsync();
}
private void cbxSheet_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
System.Data.DataTable dt = tableCollection[cbxSheet.SelectedItem.ToString()];
dataGridViewData.DataSource = dt;
mList_Goc = (from DataRow dr in dt.Rows
select new LinhKien()
{
Alias = dr["Đường dẫn / Alias"].ToString(),
TenSanPham = dr["Tên sản phẩm"].ToString(),
NoiDung = dr["Nội dung"].ToString(),
NhaCungCap = dr["Nhà cung cấp"].ToString(),
Loai = dr["Loại"].ToString(),
Tag = dr["Tags"].ToString(),
HienThi = dr["Hiển thị"].ToString(),
ThuocTinh = dr["Thuộc tính 1(Option1 Name)"].ToString(),
GiaTriThuocTinh = dr["Giá trị thuộc tính 1(Option1 Value)"].ToString(),
ThuocTinh2 = dr["Thuộc tính 2(Option2 Name)"].ToString(),
GiaTriThuocTinh2 = dr["Giá trị thuộc tính 2(Option2 Value)"].ToString(),
ThuocTinh3 = dr["Thuộc tính 3(Option3 Name)"].ToString(),
GiaTriThuocTinh3 = dr["Giá trị thuộc tính 1(Option3 Value)"].ToString(),
SKU = dr["Mã (SKU)"].ToString(),
QuanLyKho = dr["Quản lý kho"].ToString(),
SoLuong = dr["Số lượng"].ToString(),
ChoPhepBan = dr["Cho phép tiếp tục mua khi hết hàng(continue/deny)"].ToString(),
Variant = dr["Variant Fulfillment Service"].ToString(),
Gia = dr["Giá"].ToString(),
GiaSoSanh = dr["Giá so sánh"].ToString(),
YeuCauVanChuyen = dr["Yêu cầu vận chuyển"].ToString(),
VAT = dr["VAT"].ToString(),
MaVach = dr["Mã vạch(Barcode)"].ToString(),
AnhDaiDien = dr["Ảnh đại diện"].ToString(),
ChuThich = dr["Chú thích ảnh"].ToString(),
TheTieuDe = dr["Thẻ tiêu đề(SEO Title)"].ToString(),
TheMoTa = dr["Thẻ mô tả(SEO Description)"].ToString(),
CanNang = dr["Cân nặng"].ToString(),
DonViCan = dr["Đơn vị cân nặng"].ToString(),
AnhPhienBan = dr["Ảnh phiên bản"].ToString(),
MoTaNgan = dr["Mô tả ngắn"].ToString(),
ID = dr["Id sản phẩm"].ToString(),
IDTuyChon = dr["Id tùy chọn"].ToString()
}).ToList();
for (int x = 0; x < mList_Goc.Count; x++)
{
if (mList.FirstOrDefault(v => v.ID == mList_Goc[x].ID) == null)
{
LinhKien _linhkien = new LinhKien();
_linhkien = mList_Goc[x];
if (mList_Goc[x].AnhDaiDien == "")
{
}
else
{
_linhkien.mListAnh.Add(mList_Goc[x].AnhDaiDien);
}
mList.Add(_linhkien);
}
else
{
int stt = mList.FindIndex(v => v.ID == mList_Goc[x].ID);
mList[stt].mListAnh.Add(mList_Goc[x].AnhDaiDien);
}
}
}
catch
{
MessageBox.Show("Bảng Excel đang được sử dụng bởi một ứng dụng khác", "Thông Báo");
}
}
public void CapNhatSLTon(LinhKien lk)
{
KetNoi.ExecuteReader(@"Update LinhKien Set SoLuongTon=" + lk.SoLuongTon + " Where MalK=N'" + lk.MaLK + "'");
}
public async Task Delete(LinhKien item)
{
item.isDelete = 1;
_context.LinhKiens.Update(item);
await _context.SaveChangesAsync();
}
public void CapNhatSLTon(LinhKien lk)
{
bus.CapNhatSLTon(lk);
}
