public int Insert(MatHang mh)
{
if (Load_DAL("select * from MatHang where MaHang='" + mh.MaHang + "'").Rows.Count > 0)
{
return(2);
}
else if (Load_DAL("select * from MatHang where TenHang='" + mh.TenHang + "'").Rows.Count > 0)
{
return(3);
}
else
{
SqlCommand cmd = new SqlCommand("Insert_MatHang", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ma", mh.MaHang));
cmd.Parameters.Add(new SqlParameter("@ten", mh.TenHang));
cmd.Parameters.Add(new SqlParameter("@malh", mh.MaLH));
cmd.Parameters.Add(new SqlParameter("@dvt", mh.DVT));
try { if (con.State != ConnectionState.Open)
{
con.Open();
}
} catch { return(-2); }
try { cmd.ExecuteNonQuery(); return(1); } catch { return(0); } finally { if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}
void TimKiemHang()
{
DataTable dt = new DataTable();
dt = MatHang.findhang(txtSerchhang.Text.Trim());
dgvTimKiem.DataSource = dt;
}
void TimKiemGiaNhap()
{
DataTable dt = new DataTable();
dt = MatHang.findgianhap(txtSearchGiaNhap.Text.Trim());
dgvTimKiem.DataSource = dt;
}
public ActionResult CreateLan2(MatHang mathang)
{
ThongBaoMvc thongbao;
var item = db.MatHangs.SingleOrDefault(s => s.ItemId == bientam.ItemId);
if (!string.IsNullOrEmpty(mathang.Propertynames))
{
item.Propertynames = mathang.Propertynames;
try
{
db.SaveChanges();
thongbao = new ThongBaoMvc {
CssClassName = "success", Message = "Cập nhật chi tiết sản phẩm thành công"
};
TempData["ResultAction"] = thongbao;
LogMgr.AddLog(User.Identity.Name, 5, "Cập nhập chi tiết sản phẩm " + item.Name + "-" + item.ItemId);
return(RedirectToAction("Index", "Item"));
}
catch (Exception ex)
{
log.Error("Lỗi ở CreateLan2" + ex.Message);
thongbao = new ThongBaoMvc {
CssClassName = "danger", Message = "Lỗi"
};
TempData["ResultAction"] = thongbao;
}
}
var tt = item.LoaiCap3.PropertyNames.ToString().Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
ViewBag.Info = tt;
return(View());
}
void TimKiemTen()
{
DataTable dt = new DataTable();
dt = MatHang.findname(txtSearch.Text.Trim());
dgvTimKiem.DataSource = dt;
}
public List <MatHang> LoadData()
{
try
{
dp.Connect();
string sqlstr = "SELECT * FROM MatHang";
List <MatHang> list = new List <MatHang>();
SqlDataReader dr = dp.ExecuteReader(sqlstr);
//List<MatHang> list = new List<MatHang>();
while (dr.Read())
{
string maMatHang = dr.GetString(0);
string tenMatHang = dr.GetString(1);
string maNhaCungCap = dr.GetString(2);
string tenNhaCungCap = dr.GetString(3);
int donGia = dr.GetInt32(4);
int giaBan = dr.GetInt32(5);
string maLoaiTien = dr.GetString(6);
int namSanXuat = dr.GetInt32(7);
MatHang N = new MatHang(maMatHang, tenMatHang, maNhaCungCap, tenNhaCungCap, donGia, giaBan, maLoaiTien, namSanXuat);
list.Add(N);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
dp.Disconnect();
}
}
public ActionResult SuaSP(MatHang g, HttpPostedFileBase fileUpload)
{
//Kiểm tra đường dẫn
if (ModelState.IsValid)
{
if (fileUpload != null)
{
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/Images/Product/"), fileName);
//Lưu hình
fileUpload.SaveAs(path);
g.Anhbia = "/Product/" + fileName;
}
//Lưu vào CSDL
var obj = db.MatHangs.SingleOrDefault(p => p.MaHang == g.MaHang);
obj.MaDM = g.MaDM;
obj.MaThuongHieu = g.MaThuongHieu;
obj.TenHang = g.TenHang;
obj.SoLuongBan = g.SoLuongBan;
obj.SoLuongTon = g.SoLuongTon;
obj.NgayCapNhat = g.NgayCapNhat;
obj.Mau = g.Mau;
obj.Mota = g.Mota;
obj.Anhbia = g.Anhbia;
obj.Giaban = g.Giaban;
obj.Size = g.Size;
db.SubmitChanges();
return(RedirectToAction("QuanLySanPham"));
}
//Đưa dữ liệu vào dropdown
ViewBag.MaDM = new SelectList(db.DanhMucs.OrderBy(n => n.TenDM), "MaDM", "TenDM");;
ViewBag.MaNXB = new SelectList(db.ThuongHieus.OrderBy(n => n.TenThuongHieu), "MaThuongHieu", "TenThuongHieu");
return(View(g));
}
private void btnThem_Click(object sender, EventArgs e)
{
int i = -1; string s = "";
try
{
MatHang ob = new MatHang(txtMaMH.Text, txtTenMH.Text, cbxMaLH.SelectedValue.ToString(), txtDVT.Text);
i = mh.Insert(ob);
}
catch { s = "Dữ liệu đã nhập không phù hợp!\n Mời nhập lại!!"; }
switch (i)
{
case -2:
s = "Lỗi kết nối!!";
break;
case 1:
s = "Thêm thành công!!";
Frm_MatHang_Load(sender, e);
break;
case 2:
s = "Không thể thêm dữ liệu!!\n Mã mặt hàng này đã tồn tại!!";
break;
case 3:
s = "Không thể thêm dữ liệu!!\n Hãy chọn tên mặt hàng khác, tên mặt hàng này đã có trong hệ thống!!";
break;
case 0:
s = "Lỗi!! Không thể thêm dữ liệu!!";
break;
}
MessageBox.Show(s, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public ActionResult Themmoimathang(MatHang mathang, HttpPostedFileBase fileUpload)
{
ViewBag.MSLH = new SelectList(db.LoaiHangs.ToList().OrderBy(n => n.TenLoaiHang), "MSLH", "TenLoaiHang");
if (fileUpload == null)
{
ViewBag.Thongbao = "Vui lòng chọn ảnh bìa";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/HinhAnh/HinhAnh(MatHang)"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.Thongbao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
mathang.HinhAnh = fileName;
db.MatHangs.InsertOnSubmit(mathang);
db.SubmitChanges();
}
return(RedirectToAction("MatHang"));
}
}
public DataTable TenMH(MatHang mathang)
{
string query = "sp_TenMH_TheoMa '" + mathang.MaMH + "'";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
return(result);
}
public int Delete(MatHang mh)
{
if (Load_DAL("select * from MatHang where MaHang='" + mh.MaHang + "'").Rows.Count == 0)
{
return(2);
}
else if (Load_DAL("select * from CTPN where MaHang='" + mh.MaHang + "'").Rows.Count > 0)
{
return(3);
}
else if (Load_DAL("select * from CTPX where MaHang='" + mh.MaHang + "'").Rows.Count > 0)
{
return(4);
}
else if (Load_DAL("select * from CTMH where MaHang='" + mh.MaHang + "'").Rows.Count > 0)
{
return(5);
}
else
{
SqlCommand cmd = new SqlCommand("Delete_MatHang", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ma", mh.MaHang));
try { if (con.State != ConnectionState.Open)
{
con.Open();
}
} catch { return(-2); }
try { cmd.ExecuteNonQuery(); return(1); } catch { return(0); } finally { if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
}
public async Task <ActionResult> MH_Sua(MatHang mh, HttpPostedFileBase fileUpload)
{
ViewBag.MSLH = new SelectList(db.LoaiHangs, "MSLH", "TenLoaiHang", mh.MSLH);
if (fileUpload == null)
{
ViewBag.ThongBao = "Vui lòng chọn ảnh";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/HinhAnh/HinhAnh(MatHang)"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
MatHang mhh = db.MatHangs.Where(x => x.MSMH == mh.MSMH).Single <MatHang>();
mhh.TenHang = mh.TenHang;
mhh.MSLH = mh.MSLH;
mhh.SoLuong = mh.SoLuong;
mhh.TrangThai = mh.TrangThai;
mhh.DonGia = mh.DonGia;
mhh.HinhAnh = fileName;
mhh.NgayCapNhat = mh.NgayCapNhat;
await db.SaveChangesAsync();
}
}
return(RedirectToAction("MatHang"));
}
public void AddMH(MatHang m)
{
PBL3 db = new PBL3();
db.MatHang.Add(m);
db.SaveChanges();
}
public IHttpActionResult PostMatHang(MatHang matHang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.matHangs.Add(matHang);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (MatHangExists(matHang.IDMH))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = matHang.IDMH }, matHang));
}
//
// GET: /XemChiTietSP/
public ActionResult Index(long?id)
{
var db = new ProductDB();
MatHang mathang = db.getProductByID(id);
return(View(mathang));
}
public async Task <IActionResult> Edit(string id, [Bind("MaMH,Ten,MaLH,MaDVT,NgaySanXuat,SoLuongNhap,SoLuongBan,GiaBan,GiaMua,VAT,MoTa,NgayNhap,NgayHetHan,HinhMinhHoa")] MatHang matHang)
{
if (id != matHang.MaMH)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(matHang);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MatHangExists(matHang.MaMH))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["MaDVT"] = new SelectList(_context.DonViTinhs, "MaDVT", "MaDVT", matHang.MaDVT);
ViewData["MaLH"] = new SelectList(_context.LoaiHangs, "MaLH", "MaLH", matHang.MaLH);
return(View(matHang));
}
//Thêm 1 mặt hàng
public Result InsertMatHang(string pMaHang, string pTenMatHang, string pMaLoaiMatHang, string pDVT, decimal?pGiaBan,
decimal?pGiaNhap, string pMaNhaCC, byte?pBaoHanh, string pTinhTrangHang)
{
if (checkPrimaryKeyMatHang(pMaHang) == false)
{
return(Result.PRIMARY_KEY);
}
if (checkUniqueNameMatHang(pTenMatHang) == false)
{
return(Result.UNIQUE_NAME);
}
try
{
mh = new MatHang();
mh.MaHang = pMaHang;
mh.TenMatHang = pTenMatHang;
mh.MaLoaiMatHang = pMaLoaiMatHang;
mh.DVT = pDVT;
mh.GiaBan = pGiaBan;
mh.GiaNhap = pGiaNhap;
mh.MaNhaCC = pMaNhaCC;
mh.BaoHanh = pBaoHanh;
mh.TinhTrangHang = "Chưa nhập hàng";
qlch.MatHangs.InsertOnSubmit(mh);
qlch.SubmitChanges();
return(Result.SUCCESS);
}
catch
{
return(Result.FAILED);
}
}
private void btThemHang_Click(object sender, EventArgs e)
{
MatHang matHang = (MatHang)matHangList[lvMatHang.SelectedIndices[0]];
int pos = kiemTraMatHang(matHang);
if (pos == -1)
{
matHangChoList.Insert(0, new MatHang(matHang.id, matHang.tenMatHang, matHang.idNganhHang, matHang.donGia,
Convert.ToInt32(nudSoLuongTinhTien.Value)));
string[] row = { matHang.tenMatHang, nudSoLuongTinhTien.Value.ToString(), matHang.donGia.ToString() };
ListViewItem viewItem = new ListViewItem(row);
lvChiTietHoaDon.Items.Add(viewItem);
}
else
{
MatHang matHang1 = (MatHang)matHangChoList[pos];
((MatHang)matHangChoList[pos]).soLuong = matHang1.soLuong + Convert.ToInt32(nudSoLuongTinhTien.Value);
lvChiTietHoaDon.Items.Clear();
foreach (MatHang matHang2 in matHangChoList)
{
string[] row = { matHang2.tenMatHang, matHang2.soLuong.ToString(), matHang2.donGia.ToString() };
ListViewItem viewItem = new ListViewItem(row);
lvChiTietHoaDon.Items.Add(viewItem);
}
}
lvMatHang.SelectedItems[0].SubItems[1].Text = (Convert.ToInt32(lvMatHang.SelectedItems[0].SubItems[1].Text) -
(int)nudSoLuongTinhTien.Value).ToString();
((MatHang)matHangList[lvMatHang.SelectedIndices[0]]).soLuong += -(int)nudSoLuongTinhTien.Value;
nudSoLuongTinhTien.Maximum = ((MatHang)matHangList[lvMatHang.SelectedIndices[0]]).soLuong;
loadTinhTien();
}
public static ArrayList getAllMatHangFromNganhHang(int idNganhHang)
{
ArrayList dataList = new ArrayList();
try
{
DataSet dataSet = MatHangDAO.getMatHangFromIdNganhHang(idNganhHang);
foreach (DataRow row in dataSet.Tables[0].Rows)
{
int id = Convert.ToInt32(row["id"]);
string tenMatHang = row["tenMatHang"].ToString();
//int idNganhHang1 = Convert.ToInt32(row["idNganhHang"]);
float donGian = (float)Convert.ToDouble(row["donGia"]);
int soLuong = Convert.ToInt32(row["soLuong"]);
MatHang matHang = new MatHang(id, tenMatHang, idNganhHang, donGian, soLuong);
dataList.Insert(0, matHang);
}
}
catch (SqlException e)
{
}
return(dataList);
}
public frmUpdateHangHoa(MatHang transmission)
{
InitializeComponent();
xeDien = transmission;
showInforMatHang();
}
public async Task <ActionResult> MH_Them(MatHang mh, HttpPostedFileBase fileupload)
{
ViewBag.MSLH = new SelectList(db.LoaiHangs, "MSLH", "TenLoaiHang", mh.MSLH);
if (fileupload == null)
{
ViewBag.ThongBao = "Vui lòng chọn ảnh";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileupload.FileName);
var path = Path.Combine(Server.MapPath("~/HinhAnh/HinhAnh(MatHang)"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại";
}
else
{
fileupload.SaveAs(path);
}
mh.HinhAnh = fileName;
db.MatHangs.Add(mh);
await db.SaveChangesAsync();
}
return(RedirectToAction("MatHang"));
}
}
public async Task <IActionResult> ChiTietDonHang(int?id)
{
var donHang = await _context.DonHang
.SingleOrDefaultAsync(m => m.ID == id);
var dsChiTiet = from ct in _context.ChiDietDonHang
where ct.DonHangID == id
select ct;
var dsMatHang = new List <MatHang>();
foreach (var ct in dsChiTiet)
{
var sanPham = await _context.SanPham.SingleOrDefaultAsync(sp => sp.ID == ct.SanPhamID);
var mh = new MatHang();
mh.sanPham = sanPham;
mh.soLuong = ct.SoLuong;
mh.tongTien = ct.TongTien;
dsMatHang.Add(mh);
}
var duLieuChiTiet = new DuLieuChiTietDonHang();
duLieuChiTiet.donHang = donHang;
duLieuChiTiet.chiTietDonHang = dsMatHang;
return(View(duLieuChiTiet));
}
private void btnMH_Click(object sender, EventArgs e)
{
pnContainer.Controls.Clear();
MatHang mathang = new MatHang();
pnContainer.Controls.Add(mathang);
}
public IHttpActionResult PutMatHang(string id, MatHang matHang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != matHang.IDMH)
{
return(BadRequest());
}
db.Entry(matHang).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!MatHangExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(long id)
{
MatHang mathang = db.MatHangs.Find(id);
db.MatHangs.Remove(mathang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public float getGiaNhapById(int id)
{
string query = string.Format("SELECT * FROM dbo.MatHang WHERE id = {0}", id);
DataTable data = ExcuteQuery(query);
MatHang mh = new MatHang(data.Rows[0]);
return(mh.gianhap);
}
// Token: 0x06000188 RID: 392 RVA: 0x0002CF30 File Offset: 0x0002B130
public frmMatHang(string strtitle, string strtenSP, MatHang matHang)
{
this.InitializeComponent();
this.strTitle = strtitle;
this.Text += this.strTitle;
this.strTenSP = strtenSP;
this.MatHangSelected = matHang;
}
public int getIdByName(string name)
{
string query = string.Format("SELECT * FROM dbo.MatHang WHERE name = N'{0}'", name);
DataTable data = ExcuteQuery(query);
MatHang mh = new MatHang(data.Rows[0]);
return(mh.id);
}
private void btnLuuN_Click(object sender, EventArgs e)
{
id = 0; int dem = -1;
NhapHangBLL bll = new NhapHangBLL();
MatHangBLL mhb = new MatHangBLL();
for (int i = 0; i < lvMHN.Items.Count; i++)
{
NhapHang nh = new NhapHang();
// nh.id = int.Parse(lvMHN.Items[i].SubItems[0].Text);
nh.idMH = int.Parse(lvMHN.Items[i].SubItems[0].Text);
nh.idNCC = int.Parse(lvMHN.Items[i].SubItems[1].Text);
nh.idNV = int.Parse(lvMHN.Items[i].SubItems[2].Text);
nh.soluong = int.Parse(lvMHN.Items[i].SubItems[3].Text);
nh.thanhtien = float.Parse(lvMHN.Items[i].SubItems[4].Text);
MatHang mh = mhb.getDetailsById(nh.idMH);
mh.soluong += nh.soluong;
nh.thanhtien = nh.soluong * mhb.getGiaNhapById(nh.idMH);
try
{
if ((id = bll.getIdAndInsert(nh)) != 0)
{
dem++;
mhb.update(mh);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (ckReportN.Checked == true)
{
id = id - dem;
tcAdd.Controls.Clear();
tcAdd.Controls.Add(HoaDonNhap);
loadReport(1);
}
else
{
if (lvMHN.Items.Count != 0)
{
MessageBox.Show("Lưu thành công");
Close();
}
else
{
MessageBox.Show("Chưa có dữ liệu");
}
}
}
/// <summary>
/// Sự kiện hiển thị thông tin của sản phẩm được click.
/// </summary>
private void PicHang_Click(object sender, EventArgs e)
{
MatHang result = ((sender as PictureBox).Tag) as MatHang;
//Sao chép dữ liệu của đối tượng để truyền dữ liệu sang form khác làm việc
frmInforMatHang frm = new frmInforMatHang(result, account);
frm.ShowDialog();
loadListXe(MatHangBUS.Instance.getListMatHang());
}
