public ActionResult Create([Bind(Include = "MaLoaiVeSo,Tinh,Flag")] LoaiVeso loaiVeso)
{
if (ModelState.IsValid)
{
LoaiVeso LVS = db.LoaiVesoes.Find(loaiVeso.MaLoaiVeSo);
if (LVS == null)
{
loaiVeso.Flag = true;
db.LoaiVesoes.Add(loaiVeso);
db.SaveChanges();
TempData["notice"] = "Successfully create";
TempData["maloaiveso"] = loaiVeso.MaLoaiVeSo;
TempData["tinh"] = loaiVeso.Tinh;
return(RedirectToAction("Index"));
}
else
{
TempData["notice"] = "Failed create";
TempData["maloaiveso"] = loaiVeso.MaLoaiVeSo;
}
}
return(View(loaiVeso));
}
public ActionResult DeleteConfirmed(string id)
{
LoaiVeso loaiVeso = db.LoaiVeso.Find(id);
loaiVeso.Flag = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(string id)
{
LoaiVeso dl = db.LoaiVesoes.Find(id);
dl.Flag = false;
TempData["notice"] = "Successfully delete";
TempData["tensanpham"] = dl.MaLoaiVeSo;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ChinhSua(LoaiVeso _LoaiVeso)
{
if (!ModelState.IsValid)
{
return(View());
}
db.Entry(_LoaiVeso).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Xoa(string _MaLoaiVeSo)
{
LoaiVeso lvs = db.LoaiVesoes.SingleOrDefault(n => n.MaLoaiVeSo == _MaLoaiVeSo);
if (lvs == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(lvs));
}
public ActionResult Edit([Bind(Include = "MaLoaiVeSo,Tinh,GiaBan,Flag")] LoaiVeso loaiVeso)
{
if (ModelState.IsValid)
{
loaiVeso.Flag = true;
db.Entry(loaiVeso).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiVeso));
}
public ActionResult XacNhanXoa(string _MaLoaiVeSo)
{
LoaiVeso lvs = db.LoaiVesoes.SingleOrDefault(n => n.MaLoaiVeSo == _MaLoaiVeSo);
if (lvs == null)
{
Response.StatusCode = 404;
return(null);
}
db.LoaiVesoes.Remove(lvs);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaLoaiVeSo,Tinh,Flag")] LoaiVeso loaiVeso)
{
if (ModelState.IsValid)
{
loaiVeso.Flag = true;
db.Entry(loaiVeso).State = EntityState.Modified;
db.SaveChanges();
TempData["notice"] = "Successfully edit";
TempData["maloaiveso"] = loaiVeso.MaLoaiVeSo;
return(RedirectToAction("Index"));
}
return(View(loaiVeso));
}
// GET: Admin/LoaiVesoes/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LoaiVeso loaiVeso = db.LoaiVesoes.Find(id);
if (loaiVeso == null)
{
return(HttpNotFound());
}
return(View(loaiVeso));
}
public bool Update(LoaiVeso loai)
{
try
{
var tempt = db.LoaiVesoes.Find(loai.MaLoaiVeSo);
tempt.Tinh = loai.Tinh;
tempt.Flag = loai.Flag;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Create([Bind(Include = "MaLoaiVeSo,Tinh,Flag")] LoaiVeso loaiVeso)
{
if (ModelState.IsValid)
{
loaiVeso.Flag = true;
db.LoaiVesoes.Add(loaiVeso);
TempData["notice"] = "Successfully create";
TempData["tensanpham"] = loaiVeso.MaLoaiVeSo;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiVeso));
}
public ActionResult Create([Bind(Include = "MaLoaiVeSo,Tinh,GiaBan,Flag")] LoaiVeso loaiVeso)
{
if (ModelState.IsValid)
{
var dal = new LoaiVeSo_DAL();
loaiVeso.MaLoaiVeSo = dal.AutoID();
loaiVeso.Flag = true;
db.LoaiVeso.Add(loaiVeso);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiVeso));
}
public ActionResult Edit(LoaiVeso loai)
{
if (ModelState.IsValid)
{
loai.Flag = true;
var dao = new LoaiVeSoDao();
var result = dao.Update(loai);
if (result)
{
return(RedirectToAction("Index", "LoaiVeSo"));
}
}
else
{
ModelState.AddModelError("", "Chỉnh sửa giải không thành công");
}
return(View("Index"));
}
public ActionResult Create(LoaiVeso loai)
{
if (ModelState.IsValid)
{
var dao = new LoaiVeSoDao();
loai.Flag = true;
string result = dao.Insert(loai);
if (result != null)
{
return(RedirectToAction("Index", "LoaiVeSo"));
}
}
else
{
//return RedirectToAction("Create", "LoaiVeSo");
ModelState.AddModelError("", "Thêm loại vé mới không thành công");
}
return(View("Index"));
}
public ActionResult DeleteConfirmed(string id)
{
LoaiVeso loaiVeso = db.LoaiVesoes.Find(id);
int count = db.LoaiVesoes.Where(p => p.MaLoaiVeSo == id).Count();
if (count > 0)
{
loaiVeso.Flag = false;
}
else
{
db.LoaiVesoes.Remove(loaiVeso);
}
db.SaveChanges();
TempData["notice"] = "Successfully delete";
TempData["maloaiveso"] = loaiVeso.MaLoaiVeSo;
TempData["tinh"] = loaiVeso.Tinh;
return(RedirectToAction("Index"));
}
public ActionResult ThemMoi(LoaiVeso _LoaiVeso)
{
db.LoaiVesoes.Add(_LoaiVeso);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ThemMoi(string MaDaiLy, string MaLoaiVeSo, System.DateTime NgayNhan, PhatHanh _PhatHanh, LoaiVeso _LVS)
{
ViewBag.MaDaiLy = new SelectList(db.DaiLies.ToList().OrderBy(n => n.TenDaiLy), "MaDaiLy", "TenDaiLy");
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes.ToList().OrderBy(n => n.Tinh), "MaLoaiVeSo", "Tinh");
////try
//{
// SqlParameter param1 = new SqlParameter("@MADAILY", _PhatHanh.MaDaiLy);
// SqlParameter param2 = new SqlParameter("@MALOAIVESO", _PhatHanh.MaLoaiVeSo);
// SqlParameter param3 = new SqlParameter("@SLG", _PhatHanh.SoLuong);
// SqlParameter param4 = new SqlParameter("@NgayNhan", _PhatHanh.NgayNhan);
// SqlParameter param5 = new SqlParameter("@SLBan", _PhatHanh.SLBan);
// SqlParameter param6 = new SqlParameter("@DoanhThuDPH", _PhatHanh.DoanhThuDPH);
// SqlParameter param7 = new SqlParameter("@HoaHong", _PhatHanh.HoaHong);
// SqlParameter param8 = new SqlParameter("@TienThanhToan", _PhatHanh.TienThanhToan);
// var db = new QLVSEntities();
// var data = db.Database.ExecuteSqlCommand("them @MADAILY, @MALOAIVESO, @SLG, @NgayNhan, @SLBan, @DoanhThuDPH, @HoaHong, @TienThanhToan", param1, param2, param3, param4, param5, param6, param7, param8);
// return RedirectToAction("Index");
//}
//catch
//{
// return View();
//}
MaDaiLy = _PhatHanh.MaDaiLy;
MaLoaiVeSo = _PhatHanh.MaLoaiVeSo;
NgayNhan = _PhatHanh.NgayNhan;
_PhatHanh.DoanhThuDPH = _PhatHanh.SLBan * _LVS.GiaVe;
db.PhatHanhs.Add(_PhatHanh);
SLGiao slg = new SLGiao();
_PhatHanh.SoLuong = slg.TinhToanSLPhatTheoDaiLy(MaDaiLy, MaLoaiVeSo, NgayNhan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public string Insert(LoaiVeso entity)
{
db.LoaiVesoes.Add(entity);
db.SaveChanges();
return(entity.MaLoaiVeSo);
}
