public double getGiaXuatByMaSp(string maSanPham)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
CHITIETSANPHAM chitietSp = db.CHITIETSANPHAMs.SingleOrDefault(x => x.maSanPham == maSanPham);
return((double)chitietSp.donGiaXuat);
}
public ActionResult Create([Bind(Include = "CTSP_ID,SP_ID,CTSP_TRANGTHAI,CTSP_TEN")] CHITIETSANPHAM cHITIETSANPHAM)
{
HINHANHSPsController hINHANHSPsController = new HINHANHSPsController();
HINHANHSP hINHANHSP = new HINHANHSP();
HttpPostedFileBase file = Request.Files["Image"];
if (file != null)
{
cHITIETSANPHAM.CTSP_TRANGTHAI = 1;
Int32 length = file.ContentLength;
byte[] tempImage = new byte[length];
file.InputStream.Read(tempImage, 0, length);
hINHANHSP.HA_ND = tempImage;
hINHANHSP.HA_ID = db.autottang("HinhAnhSP", "HA_ID", db.HINHANHSPs.Count()).ToString();
hINHANHSPsController.addHA(hINHANHSP);
}
if (ModelState.IsValid)
{
db.CHITIETSANPHAMs.Add(cHITIETSANPHAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SP_ID = new SelectList(db.SANPHAMs, "SP_ID", "SP_TEN", cHITIETSANPHAM.SP_ID);
return(View(cHITIETSANPHAM));
}
public ActionResult CreateSP(string CTSP_ID, string SP_ID, string CTSP_TEN, string PN_ID, string CTN_GIA)
{
CHITIETSANPHAM sANPHAM = new CHITIETSANPHAM();
CHITIETNHAP cHITIETNHAP = new CHITIETNHAP();
CHITIETNHAPsController cHITIETNHAPs = new CHITIETNHAPsController();
string a = db.KiemTraID("ChiTietSanPham", "CTSP_ID", CTSP_ID);
if (!string.IsNullOrEmpty(a))
{
ModelState.AddModelError("", "Mã sản phẩm đã tồn tại !");
}
else
if (ModelState.IsValid)
{
cHITIETNHAP.CTN_ID = db.autottang("CHITIETNHAP", "CTN_ID", db.CHITIETNHAPs.Count()).ToString();
//cHITIETNHAP.PN_ID = Session["PNSP"].ToString();
cHITIETNHAP.PN_ID = PN_ID;
cHITIETNHAP.CTSP_ID = CTSP_ID;
cHITIETNHAP.CTN_GIA = Convert.ToInt32(CTN_GIA);
db.CHITIETNHAPs.Add(cHITIETNHAP);
sANPHAM.CTSP_ID = CTSP_ID;
sANPHAM.SP_ID = SP_ID;
sANPHAM.CTSP_TEN = CTSP_TEN;
sANPHAM.CTSP_TRANGTHAI = 1;
db.CHITIETSANPHAMs.Add(sANPHAM);
db.SaveChanges();
ModelState.AddModelError("", "Đã thêm sản phẩm " + sANPHAM.CTSP_ID);
}
return(View(sANPHAM));
}
//
// GET: /SanPham/Edit/5
public ActionResult Edit(string id)
{
CHITIETSANPHAM chitietsanpham = db.CHITIETSANPHAMs.Find(id);
ViewBag.MaSP = new SelectList(db.SANPHAMs, "MaSP", "MaLoaiSP", chitietsanpham.MaSP);
return(View(chitietsanpham));
}
public ActionResult DeleteConfirmed(string id)
{
CHITIETSANPHAM cHITIETSANPHAM = db.CHITIETSANPHAMs.Find(id);
db.CHITIETSANPHAMs.Remove(cHITIETSANPHAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void EditHuy(string id)
{
CHITIETSANPHAM cHITIETSANPHAM = db.CHITIETSANPHAMs.FirstOrDefault(sp => sp.CTSP_ID == id);
if (cHITIETSANPHAM != null)
{
cHITIETSANPHAM.CTSP_TRANGTHAI = 1;
db.SaveChanges();
}
}
public void ThemChiTietSanPhamMoi(CHITIETSANPHAM modifier, string maSanPham)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
CHITIETSANPHAM sp = new CHITIETSANPHAM();
sp.maSanPham = maSanPham;
sp.donGiaNhap = modifier.donGiaNhap;
sp.donGiaXuat = modifier.donGiaXuat;
db.CHITIETSANPHAMs.Add(sp);
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "CTSP_ID,SP_ID,CTSP_TRANGTHAI,CTSP_TEN")] CHITIETSANPHAM cHITIETSANPHAM)
{
if (ModelState.IsValid)
{
db.Entry(cHITIETSANPHAM).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SP_ID = new SelectList(db.SANPHAMs, "SP_ID", "SP_ID", cHITIETSANPHAM.SP_ID);
return(View(cHITIETSANPHAM));
}
public ActionResult Edit(CHITIETSANPHAM chitietsanpham)
{
if (ModelState.IsValid)
{
db.Entry(chitietsanpham).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaSP = new SelectList(db.SANPHAMs, "MaSP", "MaLoaiSP", chitietsanpham.MaSP);
return(View(chitietsanpham));
}
public ActionResult Edit([Bind(Include = "DN_ID,TTDH_ID,KH_ID,HTTT_ID,DN_NGALAPDON,DN_GHICHU,DN_SDT,DN_EMAIL,DN_DIACHI,DN_MATHE,DN_CHUTHE,DN_NGAYCAP")] DONHANG dONHANG)
{
Mail mail = new Mail();
var CTSP_ID = (from p in db.CHITIETDONHANGs where p.DN_ID == dONHANG.DN_ID select p);
CHITIETDONHANGsController cHITIETDONHANGs = new CHITIETDONHANGsController();
if (dONHANG != null)
{
if (Convert.ToInt16(dONHANG.TTDH_ID) == 2)
{
foreach (var i in CTSP_ID)
{
CHITIETSANPHAM cHITIETSANPHAM = db.CHITIETSANPHAMs.FirstOrDefault(sp => sp.CTSP_ID == i.CTSP_ID);
cHITIETDONHANGs.EditHuy(cHITIETSANPHAM.CTSP_ID);
}
string guimail = mail.SendMailFull("*****@*****.**", "vinhvavinh", "SMTP.gmail.com", "587", dONHANG.DN_EMAIL, "Đã hủy đơn hàng", "Đơn hàng " + dONHANG.DN_ID + " đã bị hủy .", true);
}
else if (Convert.ToInt16(dONHANG.TTDH_ID) == 1)
{
string guimail = mail.SendMailFull("*****@*****.**", "vinhvavinh", "SMTP.gmail.com", "587", dONHANG.DN_EMAIL, "Đã duyệt đơn hàng", "Đơn hàng " + dONHANG.DN_ID + " đã được duyệt thành công", true);
}
else if (Convert.ToInt16(dONHANG.TTDH_ID) == 3)
{
string guimail = mail.SendMailFull("*****@*****.**", "vinhvavinh", "SMTP.gmail.com", "587", dONHANG.DN_EMAIL, "Đã giao thành công", "Đơn hàng " + dONHANG.DN_ID + " đã được giao thành công", true);
}
dONHANG.NV_ID = Session["NV_ID"].ToString();
dONHANG.TTDH_ID = dONHANG.TTDH_ID;
if (ModelState.IsValid)
{
db.Entry(dONHANG).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dONHANG));
}
//if (ModelState.IsValid)
//{
//if (Convert.ToInt16(id_ttdh) == 2)
//{
// EditHuy(id_dh);
//}
// dONHANG.NV_ID = Session["NV_ID"].ToString();
// db.Entry(dONHANG).State = EntityState.Modified;
// db.SaveChanges();
// return RedirectToAction("Index");
//}
ViewBag.HTTT_ID = new SelectList(db.HINHTHUCTHANHTOANs, "HTTT_ID", "HTTT_TEN", dONHANG.HTTT_ID);
ViewBag.KH_ID = new SelectList(db.KHACHHANGs, "KH_ID", "KH_TEN", dONHANG.KH_ID);
ViewBag.TTDH_ID = new SelectList(db.TRANGTHAIDONHANGs, "TTDH_ID", "TTDH_TEN", dONHANG.TTDH_ID);
return(View(dONHANG));
}
public ActionResult Create(CHITIETSANPHAM chitietsanpham)
{
if (ModelState.IsValid)
{
db.CHITIETSANPHAMs.Add(chitietsanpham);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaSP = new SelectList(db.SANPHAMs, "MaSP", "MaLoaiSP", chitietsanpham.MaSP);
return(View(chitietsanpham));
}
// GET: CHITIETSANPHAMs/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETSANPHAM cHITIETSANPHAM = db.CHITIETSANPHAMs.Find(id);
if (cHITIETSANPHAM == null)
{
return(HttpNotFound());
}
return(View(cHITIETSANPHAM));
}
// GET: CHITIETSANPHAMs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETSANPHAM cHITIETSANPHAM = db.CHITIETSANPHAMs.Find(id);
if (cHITIETSANPHAM == null)
{
return(HttpNotFound());
}
ViewBag.SP_ID = new SelectList(db.SANPHAMs, "SP_ID", "SP_ID", cHITIETSANPHAM.SP_ID);
return(View(cHITIETSANPHAM));
}
public void Insert(ListProduct model)
{
QuanLyDTDBContent db = new QuanLyDTDBContent();
SANPHAM p = new SANPHAM();
string ID = getNextMaSP();
CHITIETSANPHAM chitietSP = new CHITIETSANPHAM();
LoaiSanPham loaiSP = new LoaiSanPham();
p.maSanPham = getNextMaSP();
p.tenSanPham = model.Name;
p.MaNhaCC = model.Producer;
p.ProductTypeID = model.ProductType;
chitietSP.donGiaNhap = (double)model.OriginalPrice;
chitietSP.donGiaXuat = (double)model.SellPrice;
p.Images = model.Image;
db.SANPHAMs.Add(p);
db.SaveChanges();
new ModifierTonKho().Insert(ID);
}
public JsonResult EditHuy(int id)
{
Mail mail = new Mail();
DONHANG dONHANG = db.DONHANGs.FirstOrDefault(m => m.DN_ID == id);
var SP_ID = (from p in db.CHITIETDONHANGs where p.DN_ID == id select p);
CHITIETDONHANGsController cHITIETDONHANGs = new CHITIETDONHANGsController();
if (dONHANG != null)
{
foreach (var i in SP_ID)
{
CHITIETSANPHAM cHITIETSANPHAM = db.CHITIETSANPHAMs.FirstOrDefault(sp => sp.CTSP_ID == i.CTSP_ID);
cHITIETDONHANGs.EditHuy(cHITIETSANPHAM.SP_ID);
}
dONHANG.TTDH_ID = 2;
string guimail = mail.SendMailFull("*****@*****.**", "vinhvavinh", "SMTP.gmail.com", "587", Session["KH_EMAIL"].ToString(), "Đã hủy đơn hàng", "Đơn hàng " + dONHANG.DN_ID + " đã bị hủy .", true);
db.SaveChanges();
}
string a = "Đã hũy đơn hàng " + id;
return(Json(a, JsonRequestBehavior.AllowGet));
}
//
// GET: /SanPham/Delete/5
public ActionResult Delete(string id)
{
CHITIETSANPHAM chitietsanpham = db.CHITIETSANPHAMs.Find(id);
return(View(chitietsanpham));
}
