public NhapHang GetNhapHang(int?iD)
{
NhapHang findResults = webEnglishDBContext.NhapHang.Find(iD);
findResults.IdnguoiDungNavigation = webEnglishDBContext.NguoiDung.Find(findResults.IdnguoiDung);
return(findResults);
}
public JsonResult ThemPhieuNhapHang(string ten, int kho, int mancc, long[] arraysp, int[] arraysl, int[] arraydg, int[] arrayvat)
{
var msg = 1;
NhapHang nh = new NhapHang();
var UserLogin = kiemtra.getUser(User.Identity.Name);
nh.Name = ten;
nh.UserId = UserLogin.Id;
nh.State = (int)NhapHangType.Waiting;
nh.MaNCC = mancc;
nh.Date = DateTime.Now;
nh.DateEnd = nh.Date.AddDays(7);
nh.MaCN = UserLogin.MaCN;
nh.WarehouseID = kho;
nh.CT_NhapHangs = new List <CT_NhapHang>();
for (int i = 0; i < arraysp.Length; i++)
{
nh.CT_NhapHangs.Add(new CT_NhapHang()
{
ItemId = arraysp[i], Price = arraydg[i], Quantity = arraysl[i], VAT = arrayvat[i]
});
}
db.NhapHangs.Add(nh);
try {
db.SaveChanges();
}
catch (Exception e)
{
log.Error("Lỗi thêm phiếu nhập hàng: " + e.Message);
}
return(Json(new { msg }));
}
public async Task <IHttpActionResult> PutNhapHang(int id, NhapHang nhapHang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != nhapHang.id)
{
return(BadRequest());
}
db.Entry(nhapHang).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!NhapHangExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <NhapHang> Create(NhapHang entity)
{
entity.CreateUserId = _getIdService.CreateIdUser();
var check = await _repository.InsertAsync(entity);
return(check);
}
private NhapHang LayDuLieuPhieuNhap()
{
int id = maskedTextBoxMaPhieuNhap.Text.Length == 0 ? 0 : int.Parse(maskedTextBoxMaPhieuNhap.Text.ToString());
NhapHang p = new NhapHang(id, int.Parse(comboBoxTenNhanVien.SelectedValue.ToString()), dateTimePickerNgayNhapHang.Value, textBoxNhaCungCap.Text, textBoxSDTNhaCungCap.Text, textBoxDiaChiNhaCungCap.Text);
return(p);
}
private void panel1_Click(object sender, EventArgs e)
{
NhapHang nhapHang = new NhapHang();
nhapHang.ShowDialog();
Init();
}
public void Remove(int?id)
{
NhapHang findResults = webEnglishDBContext.NhapHang.Find(id);
webEnglishDBContext.Remove(findResults);
webEnglishDBContext.SaveChanges();
}
public NhapHang getDetailsById(int id)
{
string query = string.Format("SELECT * FROM dbo.NhapHang WHERE id = {0}", id);
DataTable data = ExcuteQuery(query);
NhapHang dm = new NhapHang(data.Rows[0]);
return(dm);
}
public ActionResult DeleteConfirmed(string id)
{
NhapHang nhapHang = db.NhapHangs.Find(id);
db.NhapHangs.Remove(nhapHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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");
}
}
}
public ActionResult UpdateNhapHang(NhapHang nhapHang)
{
if (nhapHang == null)
{
return(BadRequest());
}
_repository.UpdateNhapHangAsync(nhapHang);
return(Ok("Update NhapHang Successful!"));
}
public ActionResult Edit([Bind(Include = "MaNhapHang,NgayNhapHang,LoaiHangHoa,DonGia,SoLuong,ThanhTien")] NhapHang nhapHang)
{
if (ModelState.IsValid)
{
db.Entry(nhapHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nhapHang));
}
public bool update(NhapHang O)
{
try
{
return(dal.update(O));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Create([Bind(Include = "MaNhapHang,NgayNhapHang,LoaiHangHoa,DonGia,SoLuong,ThanhTien")] NhapHang nhapHang)
{
if (ModelState.IsValid)
{
db.NhapHangs.Add(nhapHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nhapHang));
}
public int themLS(NhapHang NH)
{
try
{
return(nhDAO.ThemLS(NH));
}
catch (SqlException ex)
{
throw ex;
}
}
public int xoa(NhapHang NH)
{
try
{
return(nhDAO.Xoa(NH));
}
catch (SqlException ex)
{
throw ex;
}
}
public bool add(NhapHang O)
{
try
{
return(dal.add(O));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> GetNhapHang(int id)
{
NhapHang nhapHang = await db.NhapHang.FindAsync(id);
if (nhapHang == null)
{
return(NotFound());
}
return(Ok(nhapHang));
}
public async Task <IHttpActionResult> PostNhapHang(NhapHang nhapHang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.NhapHang.Add(nhapHang);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = nhapHang.id }, nhapHang));
}
public JsonResult PostExport(string ma)
{
bool success = true;
string message = "Kết quả: Xuất báo cáo thành công.";
try
{
var daoNH = new NhapHangDao();
NhapHang obj_PNK = daoNH.GetById(ma);
List <ChiTietNhap> lst_CT_PNK = obj_PNK.ChiTietNhaps.OrderBy(obj => (obj.ID)).ToList();
List <DT_NhapKho> lst_DT_NK = new List <DT_NhapKho>();
for (int i = 0; i < lst_CT_PNK.Count; i++)
{
DT_NhapKho obj_DT_NK = new DT_NhapKho();
obj_DT_NK.STT = (i + 1).ToString();
obj_DT_NK.Mat_Hang = lst_CT_PNK.ElementAt(i).HangHoa.TenHH.ToString();
obj_DT_NK.So_Luong = lst_CT_PNK.ElementAt(i).SoLuong.ToString();
obj_DT_NK.DVT = lst_CT_PNK.ElementAt(i).HangHoa.DonViTinh.Ten;
obj_DT_NK.Don_Gia = lst_CT_PNK.ElementAt(i).DonGia.ToString();
obj_DT_NK.Ma_Kho = lst_CT_PNK.ElementAt(i).MaKho.ToString();
obj_DT_NK.Thanh_Tien = (int.Parse(obj_DT_NK.So_Luong) * double.Parse(obj_DT_NK.Don_Gia)).ToString();
lst_DT_NK.Add(obj_DT_NK);
}
System.Web.HttpContext.Current.Session["Ma_NCC"] = obj_PNK.NhaCungCap.MaNCC;
System.Web.HttpContext.Current.Session["Ten_NCC"] = obj_PNK.NhaCungCap.CongTy;
System.Web.HttpContext.Current.Session["Dia_Chi_NCC"] = obj_PNK.NhaCungCap.DiaChi;
System.Web.HttpContext.Current.Session["Nguoi_Giao"] = obj_PNK.NguoiGiaoHang;
System.Web.HttpContext.Current.Session["Nguoi_Lap"] = obj_PNK.NguoiLapPhieu;
System.Web.HttpContext.Current.Session["Dien_Giai"] = obj_PNK.DienGiai;
System.Web.HttpContext.Current.Session["So_CT"] = obj_PNK.IDNhap;
System.Web.HttpContext.Current.Session["SDT_NCC"] = obj_PNK.NhaCungCap.DienThoai.ToString();
System.Web.HttpContext.Current.Session["Ngay_HT"] = obj_PNK.NgayNhap.Value.Day.ToString() + "/" + obj_PNK.NgayNhap.Value.Month.ToString() + "/" + obj_PNK.NgayNhap.Value.Year.ToString();
System.Web.HttpContext.Current.Session["Tong_Tien"] = String.Format("{0:0,0}", obj_PNK.TongTien.Value);
System.Web.HttpContext.Current.Session["Tien_Chu"] = CommonFunction.ConvertCurrency(obj_PNK.TongTien.Value);
System.Web.HttpContext.Current.Session["Data_Source"] = lst_DT_NK;
}
catch (Exception ex)
{
success = false;
message = "Kết quả: " + ex.ToString() + ".";
}
return(Json(new
{
success = success,
message = message
}));
}
public List <NhapHang> getListByNameNCC(string str)
{
List <NhapHang> dsNH = new List <NhapHang>();
string query = string.Format("SELECT * FROM dbo.NhapHang WHERE dbo.NhapHang.idNCC IN (SELECT dbo.NhaCungCap.id FROM dbo.NhaCungCap WHERE name = N'{0}') AND hide = 0", str);
DataTable data = ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
NhapHang nh = new NhapHang(item);
dsNH.Add(nh);
}
return(dsNH);
}
public int UpdateData(NhapHang NH)
{
SqlParameter[] para =
{
new SqlParameter("maPN", NH.MaPN),
new SqlParameter("ngayNhap", NH.NgayNhap),
new SqlParameter("tongTien", NH.TongTien),
new SqlParameter("maHH", NH.MaHH),
new SqlParameter("soLuong", NH.SoLuong),
new SqlParameter("donGia", NH.DonGia),
};
return(ExcuteSQL("SuaNH", para));
}
public List <NhapHang> getListHide()
{
List <NhapHang> dsNH = new List <NhapHang>();
string query = "SELECT * FROM dbo.NhapHang WHERE hide = 1";
DataTable data = ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
NhapHang nh = new NhapHang(item);
dsNH.Add(nh);
}
return(dsNH);
}
public List <NhapHang> getListByStringNV(string str)
{
List <NhapHang> dsNH = new List <NhapHang>();
string query = string.Format("SELECT * FROM dbo.NhapHang WHERE dbo.NhapHang.idNV IN (SELECT dbo.NhanVien.id FROM dbo.NhanVien WHERE name LIKE N'%{0}%') AND hide = 0", str);
DataTable data = ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
NhapHang nh = new NhapHang(item);
dsNH.Add(nh);
}
return(dsNH);
}
public bool Insert(NhapHang nhapHang)
{
decimal tt = 0;
var nh = new NhapHang();
nh.NgayNhap = DateTime.Now;
nh.MaNH = nhapHang.MaNH;
nh.TongTien = tt;
nh.NguoiNhap = nhapHang.NguoiNhap;
db.NhapHangs.Add(nh);
db.SaveChanges();
return(true);
}
// GET: NhapHangs/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NhapHang nhapHang = db.NhapHangs.Find(id);
if (nhapHang == null)
{
return(HttpNotFound());
}
return(View(nhapHang));
}
public bool update(NhapHang O)
{
string query = string.Format("UPDATE dbo.NhapHang SET soluong = {0} WHERE id = {1}", O.soluong, O.id);
try
{
ExcuteNonQuery(query);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool add(NhapHang O)
{
string query = string.Format("INSERT INTO dbo.NhapHang(idMH,idNCC,idNV,soluong,thanhtien) VALUES ({0},{1},{2},{3},{4})", O.idMH, O.idNCC, O.idNV, O.soluong, O.thanhtien);
try
{
ExcuteNonQuery(query);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(NhapHang obj)
{
SqlParameter[] param =
{
new SqlParameter("IDNhapHang", obj.IDNhapHang),
new SqlParameter("NgayNhap", obj.NgayNhap),
new SqlParameter("IDNhaCungCap", obj.IDNhaCungCap),
new SqlParameter("IDNhanVien", obj.IDNhanVien),
new SqlParameter("GhiChu", obj.GhiChu),
new SqlParameter("SoLuongSanPham", obj.SoLuongSanPham),
new SqlParameter("TongTien", obj.TongTien)
};
return(DBConnect.Instance.ExecuteSQL("sp_NhapHang_Update", param));
}
public async Task <IHttpActionResult> DeleteNhapHang(int id)
{
NhapHang nhapHang = await db.NhapHang.FindAsync(id);
if (nhapHang == null)
{
return(NotFound());
}
db.NhapHang.Remove(nhapHang);
await db.SaveChangesAsync();
return(Ok(nhapHang));
}