/// <summary>
/// Xóa áp giá dựa theo ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Delete(int?id)
{
Apgia apgia = db.Apgias.Find(id);
db.Apgias.Remove(apgia);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ApgiaID,Ten,LoaiapgiaID,Denmuc,Gia")] Apgia apgia)
{
if (ModelState.IsValid)
{
db.Entry(apgia).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LoaiapgiaID = new SelectList(db.Loaiapgias, "LoaiapgiaID", "Ten", apgia.LoaiapgiaID);
return(View(apgia));
}
public ActionResult Create([Bind(Include = "ApgiaID,Ten,LoaiapgiaID,Denmuc,Gia")] Apgia apgia)
{
if (ModelState.IsValid)
{
db.Apgias.Add(apgia);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LoaiapgiaID = new SelectList(db.Loaiapgias, "LoaiapgiaID", "Ten", apgia.LoaiapgiaID);
return(View(apgia));
}
// GET: /Apgia/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Apgia apgia = db.Apgias.Find(id);
if (apgia == null)
{
return(HttpNotFound());
}
return(View(apgia));
}
// GET: /Apgia/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Apgia apgia = db.Apgias.Find(id);
if (apgia == null)
{
return(HttpNotFound());
}
ViewBag._LoaiapgiaID = new SelectList(db.Loaiapgias, "LoaiapgiaID", "Ten", apgia.LoaiapgiaID);
return(View(apgia));
}
/// <summary>
/// Lấy số tiền theo áp giá
/// </summary>
/// <param name="ApGiaID"></param>
/// <returns></returns>
public double?getSoTienTheoApGia(String tenApGia)
{
HoaDonHaDongEntities thisDB = new HoaDonHaDongEntities();
switch (tenApGia)
{
case "SH1":
Apgia _apGiaSH1 = thisDB.Apgias.FirstOrDefault(p => p.Ten == "SH1");
if (_apGiaSH1 != null)
{
return(_apGiaSH1.Gia);
}
break;
case "SH2":
Apgia _apGiaSH2 = thisDB.Apgias.FirstOrDefault(p => p.Ten == "SH2");
if (_apGiaSH2 != null)
{
return(_apGiaSH2.Gia);
}
break;
case "SH3":
Apgia _apGiaSH3 = thisDB.Apgias.FirstOrDefault(p => p.Ten == "SH3");
if (_apGiaSH3 != null)
{
return(_apGiaSH3.Gia);
}
break;
case "SH4":
Apgia _apGiaSH4 = thisDB.Apgias.FirstOrDefault(p => p.Ten == "SH4");
if (_apGiaSH4 != null)
{
return(_apGiaSH4.Gia);
}
break;
//khối kinh doanh
case "HC":
Apgia HC = thisDB.Apgias.FirstOrDefault(p => p.Ten == "HC");
if (HC != null)
{
return(HC.Gia);
}
break;
case "CC":
Apgia CC = thisDB.Apgias.FirstOrDefault(p => p.Ten == "CC");
if (CC != null)
{
return(CC.Gia);
}
break;
case "SX-XD":
Apgia SXXD = thisDB.Apgias.FirstOrDefault(p => p.Ten == "SX-XD");
if (SXXD != null)
{
return(SXXD.Gia);
}
break;
case "KDDV":
Apgia KDDV = thisDB.Apgias.FirstOrDefault(p => p.Ten == "KDDV");
if (KDDV != null)
{
return(KDDV.Gia);
}
break;
}
return(0);
}