private void saveData()
{
//save data to chitietHDN
ChiTietHDN ctHDN = new ChiTietHDN();
ctHDN.IDHDN = mIDHDN;
ctHDN.IDSP = (long)cboSanPham.EditValue;
ctHDN.SoLuong = Convert.ToDouble(txtSoLuong.Text.Trim());
ctHDN.Dongia = Convert.ToDouble(txtDonGia.Text.Trim());
ctHDN.VAT = Convert.ToDouble(txtVAT.Text.Trim());
//save data to SanPham: so luong nhap va gia nhap.
SanPham sp = db.SanPhams.FirstOrDefault(x => x.ID == ctHDN.IDSP);
sp.SoLuong = sp.SoLuong + ctHDN.SoLuong;
sp.GiaNhap = ctHDN.Dongia * (1 + ctHDN.VAT / 100);
//save data to HDN
HoaDonNhap hd = db.HoaDonNhaps.FirstOrDefault(x => x.ID == ctHDN.IDHDN);
hd.TongTien = hd.TongTien + sp.GiaNhap * ctHDN.SoLuong;
db.ChiTietHDNs.Add(ctHDN);
db.SaveChanges();
loadDatatoGridView();
MsgUtil.MessageThemSuccess();
}
public ActionResult DeleteConfirmed(string SoHDN, string MaSP)
{
ChiTietHDN chiTietHDN = db.ChiTietHDNs.Find(SoHDN, MaSP);
db.ChiTietHDNs.Remove(chiTietHDN);
db.SaveChanges();
return(RedirectToAction("Details", "HoaDonNhaps", new { id = chiTietHDN.SoHDN }));
}
public ActionResult CreateCTHDN(CTHDNhapModel model)
{
if (ModelState.IsValid)
{
var cthdn = new ChiTietHDN();
var session_hdn = (ChuoiCuaHangTraSua.Common.MaHoaDonNhap)Session[ChuoiCuaHangTraSua.Common.Constants.MAHDN_SESSION];
if (session_hdn != null)
{
cthdn.MaHDN = session_hdn.Id;
}
else
{
DateTime dt = DateTime.Now;
var mahdn = dt.Day.ToString() + dt.Month.ToString() + dt.Year.ToString() + dt.Hour.ToString() + dt.Minute.ToString() + dt.Second.ToString();
var session_mahdnhap = new ChuoiCuaHangTraSua.Common.MaHoaDonNhap();
session_mahdnhap.Id = mahdn;
Session.Add(ChuoiCuaHangTraSua.Common.Constants.MAHDN_SESSION, session_mahdnhap);
cthdn.MaHDN = mahdn;
}
cthdn.MaDonViTinh = model.MaDonViTinh;
cthdn.MaNguyenLieu = model.MaNguyenLieu;
cthdn.SoLuong = new ChuoiCuaHangTraSua.Common.ConvertMoney().ConvertTien(model.SoLuong);
cthdn.GiaNhap = new ChuoiCuaHangTraSua.Common.ConvertMoney().ConvertTien(model.GiaNhap);
cthdn.ChietKhau = new ChuoiCuaHangTraSua.Common.ConvertMoney().ConvertTien(model.ChietKhau);
cthdn.ThanhTien = cthdn.GiaNhap * cthdn.SoLuong - cthdn.ChietKhau;
db.ChiTietHDNs.Add(cthdn);
var nguyenlieu_donvi = new NguyenLieuDonViDao().getBy_NLId_DVId(model.MaNguyenLieu, model.MaDonViTinh);
if (nguyenlieu_donvi != null)
{
var nl_dv = db.NguyenLieu_DonVi.Find(nguyenlieu_donvi.Id);
int?soluong = nguyenlieu_donvi.SoLuong;
nl_dv.SoLuong = soluong + cthdn.SoLuong;
nl_dv.GiaNhap = cthdn.GiaNhap;
db.SaveChanges();
}
else
{
var nl_dv = new NguyenLieu_DonVi();
nl_dv.MaNguyenLieu = cthdn.MaNguyenLieu;
nl_dv.MaDonViTinh = cthdn.MaDonViTinh;
nl_dv.SoLuong = cthdn.SoLuong;
nl_dv.GiaNhap = cthdn.GiaNhap;
db.NguyenLieu_DonVi.Add(nl_dv);
}
db.SaveChanges();
return(RedirectToAction("CreateHDN", "HoaDonNhapAdmin"));
}
else
{
return(RedirectToAction("CreateCTHDN", "HoaDonNhapAdmin"));
}
}
// GET: Admin/ChiTietHDBs/Delete/5
public ActionResult Delete(string SoHDN, string MaSP)
{
if (MaSP == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietHDN chiTietHDN = db.ChiTietHDNs.Find(SoHDN, MaSP);
if (chiTietHDN == null)
{
return(HttpNotFound());
}
return(View(chiTietHDN));
}
public ActionResult CreateCTHDN(CTHDNhapModel model)
{
if (ModelState.IsValid)
{
var cthdn = new ChiTietHDN();
var session_hdn = (DoAn.Common.Session.MaHoaDonNhap)Session[DoAn.Common.Constants.MAHDN_SESSION];
if (session_hdn != null)
{
cthdn.MaHDN = session_hdn.Id;
}
else
{
DateTime dt = DateTime.Now;
var mahdn = dt.Day.ToString() + dt.Month.ToString() + dt.Year.ToString() + dt.Hour.ToString() + dt.Minute.ToString() + dt.Second.ToString();
var session_mahdnhap = new DoAn.Common.Session.MaHoaDonNhap();
session_mahdnhap.Id = mahdn;
Session.Add(DoAn.Common.Constants.MAHDN_SESSION, session_mahdnhap);
cthdn.MaHDN = mahdn;
}
cthdn.MaDonViTinh = model.MaDonViTinh;
cthdn.MaNguyenLieu = model.MaNguyenLieu;
cthdn.SoLuong = new DoAn.Common.Function.ConvertMoney().ConvertTien(model.SoLuong);
cthdn.GiaNhap = new DoAn.Common.Function.ConvertMoney().ConvertTien(model.GiaNhap);
cthdn.ChietKhau = new DoAn.Common.Function.ConvertMoney().ConvertTien(model.ChietKhau);
cthdn.ThanhTien = cthdn.GiaNhap * cthdn.SoLuong - cthdn.ChietKhau;
db.ChiTietHDNs.Add(cthdn);
var nguyenlieu = db.NguyenLieux.Find(model.MaNguyenLieu);
nguyenlieu.GiaNhap = new DoAn.Common.Function.ConvertMoney().ConvertTien(model.GiaNhap);
nguyenlieu.SoLuong = nguyenlieu.SoLuong + new DoAn.Common.Function.ConvertMoney().ConvertTien(model.SoLuong);
db.SaveChanges();
return(RedirectToAction("CreateHDN", "HoaDonNhapAdmin"));
}
else
{
var viewmodel = new CTHDNhapModel();
viewmodel.SelectNguyenLieu = new SelectList(db.NguyenLieux, "Id", "TenNguyenLieu", model.MaNguyenLieu);
viewmodel.SoLuong = model.SoLuong;
return(View(viewmodel));
}
}
public ActionResult Create([Bind(Include = "SoHDN,MaSP,SoLuong,DonGia,GiamGia,ThanhTien")] ChiTietHDN chiTietHDN)
{
if (ModelState.IsValid)
{
if (db.ChiTietHDNs.Find(chiTietHDN.SoHDN, chiTietHDN.MaSP) != null)
{
ViewBag.Err = "Sản phẩm đã tồn tại";
}
else
{
db.ChiTietHDNs.Add(chiTietHDN);
db.SaveChanges();
return(RedirectToAction("Details", "HoaDonNhaps", new { id = chiTietHDN.SoHDN }));
}
}
ViewBag.MaSP = new SelectList(db.SanPhams, "MaSP", "TenSP", chiTietHDN.MaSP);
return(View(chiTietHDN));
}
public ActionResult EditCTHDN(CTHDNJson ct)
{
try
{
ChiTietHDN temp = db.ChiTietHDN.Where(n => (n.MaHDN == ct.MaHDN) && (n.MaThuoc == ct.MaThuoc)).SingleOrDefault();
var soLuongCu = temp.SoluongNhap;
temp.DonGiaNhap = Convert.ToDecimal(ct.DonGiaNhap); temp.SoluongNhap = Convert.ToInt32(ct.SoluongNhap);
db.Entry(temp).State = EntityState.Modified;
var soLuongMoi = temp.SoluongNhap - soLuongCu;
Thuoc data = db.Thuoc.Where(n => n.MaThuoc == temp.MaThuoc).SingleOrDefault();
data.SoLuong = data.SoLuong + soLuongMoi;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Sửa chi tiết hóa đơn nhập thành công" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { success = false, mesage = "Sửa không thành công" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult CreateCTHDN(CTHDNJson ct)
{
try
{
ChiTietHDN newHDN = new ChiTietHDN
{
MaHDN = ct.MaHDN,
MaThuoc = ct.MaThuoc,
DonGiaNhap = Convert.ToDecimal(ct.DonGiaNhap),
SoluongNhap = Convert.ToInt32(ct.SoluongNhap)
};
db.ChiTietHDN.Add(newHDN);
Thuoc data = db.Thuoc.Where(n => n.MaThuoc == newHDN.MaThuoc).SingleOrDefault();
var newCount = data.SoLuong + newHDN.SoluongNhap;
data.SoLuong = newCount;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { code = 200, mes = "Thêm chi tiết Hóa Đơn Nhập thành công" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { code = 500, mes = e.Message }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// To the entity.
/// </summary>
/// <param name="model">The model.</param>
/// <param name="destination">The destination.</param>
/// <returns>ChiTietHDN.</returns>
public static ChiTietHDN ToEntity(this ChiTietHdnModel model, ChiTietHDN destination)
{
return(model.MapTo(destination));
}
/// <summary>
/// To the model.
/// </summary>
/// <param name="entity">The entity.</param>
/// <returns>ChiTietHdnModel.</returns>
public static ChiTietHdnModel ToModel(this ChiTietHDN entity)
{
return(entity.MapTo <ChiTietHDN, ChiTietHdnModel>());
}
public void Insert(ChiTietHDN entity)
{
repos.Insert(entity);
}
public void Delete(ChiTietHDN entity)
{
repos.Delete(entity);
}
public void Update(ChiTietHDN entity)
{
repos.Update(entity);
}