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