public ActionResult Edit([Bind(Include = "MaPhatHanh,MaDaiLy,MaLoaiVeSo,SoLuong,NgayNhan,SLBan,DoanhThuDPH,HoaHong,TienThanhToan,Flag")] PhatHanh phatHanh)
{
if (ModelState.IsValid)
{
phatHanh.Flag = true;
var sl = db.SoLuongDK.Where(x => x.MaDaiLy == phatHanh.MaDaiLy && x.Flag == true).OrderByDescending(x => x.NgayDK).Take(1).FirstOrDefault().SoLuongDK1;
if (phatHanh.SoLuong == null)
{
phatHanh.SoLuong = sl;
}
else
{
double tk = thongke(phatHanh.MaDaiLy);
if (tk < 75 && phatHanh.SoLuong > sl)
{
//Error
ModelState.AddModelError(string.Empty, "Phần trăm doanh số của đại lý này là " + tk + ". Không thể tăng số lượng vé số phát hành");
return(View(phatHanh));
}
}
db.Entry(phatHanh).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaDaiLy = new SelectList(db.DaiLy, "MaDaiLy", "TenDaiLy", phatHanh.MaDaiLy);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVeso, "MaLoaiVeSo", "Tinh", phatHanh.MaLoaiVeSo);
return(View(phatHanh));
}
public void insert_Phathanh(PhatHanh a)
{
QLVESODataContext db = new QLVESODataContext();
db.PhatHanhs.InsertOnSubmit(a);
db.SubmitChanges();
}
public void delete_Phathanh(string Maphathanh)
{
QLVESODataContext db = new QLVESODataContext();
PhatHanh b = db.PhatHanhs.Where(a => a.MaPhatHanh == Maphathanh).Single();
db.PhatHanhs.DeleteOnSubmit(b);
db.SubmitChanges();
}
public ActionResult DeleteConfirmed(string id)
{
PhatHanh phatHanh = db.PhatHanh.Find(id);
phatHanh.Flag = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create()
{
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes, "MaLoaiVeSo", "MaLoaiVeSo");
ViewBag.MaDaiLy = new SelectList(db.DaiLies, "MaDaiLy", "MaDaiLy");
PhatHanh ph = new PhatHanh();
ph.MaPH = getMaPH();
return(View(ph));
}
public ActionResult DeleteConfirmed(string id, string id1)
{
PhatHanh ph = db.PhatHanhs.FirstOrDefault(m => m.MaLoaiVeSo == id && m.MaDaiLy == id1);
ph.Flag = false;
TempData["notice"] = "Successfully delete";
TempData["tensanpham"] = ph.MaLoaiVeSo;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Xoa(int _ID)
{
PhatHanh ph = db.PhatHanhs.SingleOrDefault(n => n.ID == _ID);
if (ph == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(ph));
}
public ActionResult ChinhSua(PhatHanh _PhatHanh)
{
ViewBag.MaDaiLy = new SelectList(db.DaiLies.ToList().OrderBy(n => n.TenDaiLy), "MaDaiLy", "TenDaiLy", _PhatHanh.MaDaiLy);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes.ToList().OrderBy(n => n.Tinh), "MaLoaiVeSo", "Tinh", _PhatHanh.MaLoaiVeSo);
if (!ModelState.IsValid)
{
return(View());
}
db.Entry(_PhatHanh).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MaDaiLy,MaLoaiVeSo,SoLuong,NgayNhan,SLBan,DoanhThuDPH,HoaHong,TienThanhToan,Flag")] PhatHanh ph)
{
if (ModelState.IsValid)
{
TempData["notice"] = "Successfully edit";
TempData["tensanpham"] = ph.MaLoaiVeSo;
db.Entry(ph).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ph));
}
public bool Update_phathanh(PhatHanh a)
{
try
{
dALPhatHanh.update_PhatHanh(a);
return(true);
}
catch
{
return(false);
}
}
public ActionResult Create()
{
var pt = new PhatHanh();
var dao = new PhatHanhDao();
pt.ID = dao.AutoGetMa();
pt.NgayNhan = DateTime.Now;
pt.HoaHong = 10;
SetViewBagMaLoaiVe();
SetViewBagMaDaiLy();
return(View(pt));
}
public bool Insert_Phathanh(PhatHanh a)
{
try
{
dALPhatHanh.insert_Phathanh(a);
return(true);
}
catch
{
return(false);
}
}
public ActionResult ChinhSua(int _ID)
{
PhatHanh ph = db.PhatHanhs.SingleOrDefault(n => n.ID == _ID);
if (ph == null)
{
Response.StatusCode = 404;
return(null);
}
ViewBag.MaDaiLy = new SelectList(db.DaiLies.ToList().OrderBy(n => n.TenDaiLy), "MaDaiLy", "TenDaiLy", ph.MaDaiLy);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes.ToList().OrderBy(n => n.Tinh), "MaLoaiVeSo", "Tinh", ph.MaLoaiVeSo);
return(View(ph));
}
public ActionResult Edit(PhatHanh ph)
{
if (ModelState.IsValid)
{
ph.HoaHong = Convert.ToInt32(ph.HoaHong);
TempData["notice"] = "Successfully edit";
TempData["tensanpham"] = ph.MaLoaiVeSo;
db.Entry(ph).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ph));
}
public void update_PhatHanh(PhatHanh a)
{
QLVESODataContext db = new QLVESODataContext();
PhatHanh b = db.PhatHanhs.Where(x => x.MaPhatHanh == a.MaPhatHanh).Single();
b.NgayPhatHanh = a.NgayPhatHanh;
b.SLBan = SL_pp(b.MaPhatHanh) - SL_trave(b.MaPhatHanh);
b.SoLuong = a.SoLuong;
b.DoanhThuDPH = a.DoanhThuDPH;
b.HoaHong = a.HoaHong;
b.TienThanhToan = a.TienThanhToan;
db.SubmitChanges();
}
public ActionResult XacNhanXoa(int _ID)
{
PhatHanh ph = db.PhatHanhs.SingleOrDefault(n => n.ID == _ID);
if (ph == null)
{
Response.StatusCode = 404;
return(null);
}
db.PhatHanhs.Remove(ph);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(string id, string id1)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PhatHanh ph = db.PhatHanhs.FirstOrDefault(m => m.MaLoaiVeSo == id && m.MaDaiLy == id1);
if (ph == null)
{
return(HttpNotFound());
}
return(View(ph));
}
public ActionResult Create([Bind(Include = "MaDaiLy,MaLoaiVeSo,SoLuong,NgayNhan,SLBan,DoanhThuDPH,HoaHong,TienThanhToan,Flag")] PhatHanh ph)
{
if (ModelState.IsValid)
{
ph.Flag = true;
db.PhatHanhs.Add(ph);
TempData["notice"] = "Successfully create";
TempData["tensanpham"] = ph.MaLoaiVeSo;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ph));
}
public ActionResult Delete(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PhatHanh ph = db.PhatHanhs.FirstOrDefault(m => m.MaPH == id);
if (ph == null)
{
return(HttpNotFound());
}
return(View(ph));
}
private void Lbbangchu1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
XRLabel label = (XRLabel)sender;
string check = System.Convert.ToString(GetCurrentColumnValue("t_tt1"));
if (!string.IsNullOrEmpty(check))
{
label.Text = PhatHanh.DocTienBangChu(System.Convert.ToInt32(GetCurrentColumnValue("t_tt1")), " đồng");
}
else
{
label.Text = null;
}
}
// GET: PhatHanhs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PhatHanh phatHanh = db.PhatHanh.Find(id);
if (phatHanh == null)
{
return(HttpNotFound());
}
return(View(phatHanh));
}
private void btsua_Click(object sender, EventArgs e)
{
PhatHanh a = new PhatHanh();
a.MaPhatHanh = txtmaphathanh.EditValue.ToString();
a.SoLuong = int.Parse(txtslve.EditValue.ToString());
a.NgayPhatHanh = DateTime.Parse(txtngayphathanh.EditValue.ToString());
a.SLBan = int.Parse(txtslban.EditValue.ToString());
a.DoanhThuDPH = int.Parse(txtdoanhthu.EditValue.ToString());
a.HoaHong = float.Parse(txthoahong.EditValue.ToString());
a.TienThanhToan = float.Parse(txttienthanhtoan.EditValue.ToString());
busPhathanh.Update_phathanh(a);
Load_DS_Phathanh();
}
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PhatHanh ph = db.PhatHanhs.FirstOrDefault(m => m.MaPH == id);
if (ph == null)
{
return(HttpNotFound());
}
ViewBag.MaDaiLy = new SelectList(db.DaiLies, "MaDaiLy", "MaDaiLy", ph.DaiLy.MaDaiLy);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVesoes, "MaLoaiVeSo", "MaLoaiVeSo", ph.LoaiVeso.MaLoaiVeSo);
return(View(ph));
}
// GET: PhatHanhs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PhatHanh phatHanh = db.PhatHanh.Find(id);
if (phatHanh == null)
{
return(HttpNotFound());
}
ViewBag.MaDaiLy = new SelectList(db.DaiLy, "MaDaiLy", "TenDaiLy", phatHanh.MaDaiLy);
ViewBag.MaLoaiVeSo = new SelectList(db.LoaiVeso, "MaLoaiVeSo", "Tinh", phatHanh.MaLoaiVeSo);
return(View(phatHanh));
}
public ActionResult Edit([Bind(Include = "MaDaiLy,MaLoaiVeSo,SoLuong,NgayNhan,SLBan,DoanhThuDPH,HoaHong,TienThanhToan,Flag")] PhatHanh ph)
{
if (ModelState.IsValid)
{
//ph.HoaHong = 10;
string hoa = ph.HoaHong.ToString();
hoa = hoa.Substring(0, 2);
int hoah = int.Parse(hoa);
ph.HoaHong = hoah;
TempData["notice"] = "Successfully edit";
TempData["tensanpham"] = ph.MaLoaiVeSo;
db.Entry(ph).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ph));
}
public bool Update(PhatHanh pt)
{
try
{
var tempt = db.PhatHanhs.Find(pt.ID);
tempt.MaLoaiVeSo = pt.MaLoaiVeSo;
tempt.MaDaiLy = pt.MaDaiLy;
tempt.SoLuong = pt.SoLuong;
tempt.TienThanhToan = pt.TienThanhToan;
tempt.SLBan = pt.SLBan;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Edit(PhatHanh loai)
{
if (ModelState.IsValid)
{
loai.Flag = true;
var dao = new PhatHanhDao();
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 bool Update(PhatHanh pc)
{
try
{
var tempt = db.PhatHanhs.FirstOrDefault(m => m.MaDaiLy == pc.MaDaiLy);
tempt.LoaiVeso = pc.LoaiVeso;
tempt.HoaHong = pc.HoaHong;
tempt.MaLoaiVeSo = pc.MaLoaiVeSo;
tempt.NgayNhan = pc.NgayNhan;
tempt.SLBan = pc.SLBan;
tempt.SoLuong = pc.SoLuong;
tempt.TienThanhToan = pc.TienThanhToan;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private void btthem_Click(object sender, EventArgs e)
{
PhatHanh a = new PhatHanh();
a.MaPhatHanh = txtmaphathanh.EditValue.ToString();
a.SoLuong = int.Parse(txtslve.EditValue.ToString());
a.NgayPhatHanh = DateTime.Parse(txtngayphathanh.EditValue.ToString());
a.SLBan = int.Parse(txtslban.EditValue.ToString());
a.DoanhThuDPH = int.Parse(txtdoanhthu.EditValue.ToString());
a.HoaHong = float.Parse(txthoahong.EditValue.ToString());
a.TienThanhToan = float.Parse(txttienthanhtoan.EditValue.ToString());
if (busPhathanh.Exits_Phathanh_byMa(a.MaPhatHanh))
{
MessageBox.Show("Mã đại lý đã tồn tại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
busPhathanh.Insert_Phathanh(a);
Load_DS_Phathanh();
}
}
public ActionResult Create(PhatHanh phatHanh)
{
if (ModelState.IsValid)
{
var dao = new PhatHanhDao();
phatHanh.Flag = true;
decimal slg = TinhToanSLPhatTheoDaiLy(phatHanh.MaDaiLy, phatHanh.MaLoaiVeSo, phatHanh.NgayNhan);
phatHanh.SoLuong = (int)slg;
string result = dao.Insert(phatHanh);
if (result != null)
{
return(RedirectToAction("Index", "PhatHanh"));
}
}
else
{
//return RedirectToAction("Create", "PhatHanh");
ModelState.AddModelError("", "Thêm loại vé mới không thành công");
}
return(View("Index"));
}
