public ActionResult ThemMoi(SoLuongDK _SoLuongDK)
{
ViewBag.MaDaiLy = new SelectList(db.DaiLies.ToList().OrderBy(n => n.TenDaiLy), "MaDaiLy", "TenDaiLy");
db.SoLuongDKs.Add(_SoLuongDK);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void insert_SoLuongDk(SoLuongDK a)
{
QLVESODataContext db = new QLVESODataContext();
db.SoLuongDKs.InsertOnSubmit(a);
db.SubmitChanges();
}
public ActionResult Create()
{
SoLuongDK dl = new SoLuongDK();
dl.MaDaiLy = getMaDL();
return(View(dl));
}
public void delete_SoLuongDk(string ID)
{
QLVESODataContext db = new QLVESODataContext();
SoLuongDK b = db.SoLuongDKs.Where(a => a.ID == ID).Single();
db.SoLuongDKs.DeleteOnSubmit(b);
db.SubmitChanges();
}
public ActionResult Create()
{
SoLuongDK a = new SoLuongDK();
a.ID = getMaDL();
ViewBag.MaDaiLy = new SelectList(db.DaiLies, "MaDaiLy", "MaDaiLy");
return(View(a));
}
public ActionResult DeleteConfirmed(string id)
{
SoLuongDK sldk = db.SoLuongDK.Find(id);
sldk.Flag = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: SoLuongDKs/Create
public ActionResult Create()
{
SoLuongDK sldk = new SoLuongDK();
sldk.ID = getID();
sldk.NgayDK = DateTime.Now;
ViewBag.MaDaiLy = new SelectList(db.DaiLies, "MaDaiLy", "TenDaiLy");
return(View(sldk));
}
public ActionResult DeleteConfirmed(string id)
{
SoLuongDK dl = db.SoLuongDKs.Find(id);
dl.Flag = false;
TempData["notice"] = "Successfully delete";
TempData["tensanpham"] = dl.ID;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create()
{
SetViewBagMaDaiLy();
SoLuongDK dk = new SoLuongDK();
var dao = new SoLuongDKDao();
dk.NgayDK = DateTime.Now;
dk.ID = dao.AutoGetMa();
return(View(dk));
}
public void update_SoLuongDk(SoLuongDK a)
{
QLVESODataContext db = new QLVESODataContext();
SoLuongDK b = db.SoLuongDKs.Where(x => x.ID == a.ID).Single();
b.MaLoaiveSo = a.MaLoaiveSo;
b.MaDaiLy = a.MaDaiLy;
b.NgayDK = a.NgayDK;
b.SoLuongDK1 = a.SoLuongDK1;
db.SubmitChanges();
}
public ActionResult ChinhSua(SoLuongDK _SoLuongDK)
{
ViewBag.MaDaiLy = new SelectList(db.DaiLies.ToList().OrderBy(n => n.TenDaiLy), "MaDaiLy", "TenDaiLy", _SoLuongDK.MaDaiLy);
if (!ModelState.IsValid)
{
return(View());
}
db.Entry(_SoLuongDK).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Xoa(string _ID)
{
SoLuongDK dl = db.SoLuongDKs.SingleOrDefault(n => n.ID == _ID);
if (dl == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(dl));
}
public bool Update_SoLuongDk(SoLuongDK a)
{
try
{
dalSoLuongDk.update_SoLuongDk(a);
return(true);
}
catch
{
return(false);
}
}
public bool Insert_SoLuongDk(SoLuongDK a)
{
try
{
dalSoLuongDk.insert_SoLuongDk(a);
return(true);
}
catch
{
return(false);
}
}
public ActionResult Edit([Bind(Include = "ID,MaDaiLy,NgayDK,SoLuongDK1,Flag")] SoLuongDK sldk)
{
if (ModelState.IsValid)
{
TempData["notice"] = "Successfully edit";
TempData["tensanpham"] = sldk.ID;
db.Entry(sldk).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sldk));
}
private void btsua_Click(object sender, EventArgs e)
{
SoLuongDK soLuongDK = new SoLuongDK();
soLuongDK.ID = txtmadk.EditValue.ToString();
soLuongDK.MaLoaiveSo = cbLoaiveso.EditValue.ToString();
soLuongDK.MaDaiLy = cbMadaily.EditValue.ToString();
soLuongDK.NgayDK = DateTime.Parse(cbNgayDK.EditValue.ToString());
soLuongDK.SoLuongDK1 = int.Parse(txtsoLuongDk.EditValue.ToString());
busSoLuongDangKy.Update_SoLuongDk(soLuongDK);
Load_DS_SLDK();
}
public ActionResult XacNhanXoa(string _ID)
{
SoLuongDK dl = db.SoLuongDKs.SingleOrDefault(n => n.ID == _ID);
if (dl == null)
{
Response.StatusCode = 404;
return(null);
}
db.SoLuongDKs.Remove(dl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ChinhSua(string _ID)
{
SoLuongDK dk = db.SoLuongDKs.SingleOrDefault(n => n.ID == _ID);
if (dk == null)
{
Response.StatusCode = 404;
return(null);
}
ViewBag.MaDaiLy = new SelectList(db.DaiLies.ToList().OrderBy(n => n.TenDaiLy), "MaDaiLy", "TenDaiLy", dk.MaDaiLy);
//return View(db.SoLuongDKs.SingleOrDefault(n=>n.ID.Equals(_ID)));
return(View(dk));
}
public ActionResult Create([Bind(Include = "ID,MaDaiLy,NgayDK,SoLuongDK1,Flag")] SoLuongDK sldk)
{
if (ModelState.IsValid)
{
sldk.Flag = true;
db.SoLuongDKs.Add(sldk);
TempData["notice"] = "Successfully create";
TempData["tensanpham"] = sldk.ID;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sldk));
}
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SoLuongDK sldk = db.SoLuongDKs.Find(id);
if (sldk == null)
{
return(HttpNotFound());
}
return(View(sldk));
}
public ActionResult Edit([Bind(Include = "MaSoLuongDK,MaDaiLy,NgayDK,SoLuongDK1,Flag")] SoLuongDK sldk)
{
if (ModelState.IsValid)
{
sldk.Flag = true;
db.Entry(sldk).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaDaiLy = new SelectList(db.DaiLy, "MaDaiLy", "TenDaiLy", sldk.MaDaiLy);
return(View(sldk));
}
// GET: SoLuongDKs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SoLuongDK soLuongDK = db.SoLuongDKs.Find(id);
if (soLuongDK == null)
{
return(HttpNotFound());
}
ViewBag.MaDaiLy = new SelectList(db.DaiLies, "MaDaiLy", "TenDaiLy", soLuongDK.MaDaiLy);
return(View(soLuongDK));
}
public ActionResult Edit([Bind(Include = "ID,MaDaiLy,NgayDK,SoLuongDK1,Flag")] SoLuongDK soLuongDK)
{
if (ModelState.IsValid)
{
soLuongDK.Flag = true;
db.Entry(soLuongDK).State = EntityState.Modified;
db.SaveChanges();
TempData["notice"] = "Successfully edit";
TempData["masl"] = soLuongDK.MaDaiLy;
DaiLy givename = db.DaiLies.Where(s => s.MaDaiLy == soLuongDK.MaDaiLy).FirstOrDefault();
TempData["daily"] = givename.TenDaiLy;
return(RedirectToAction("Index"));
}
ViewBag.MaDaiLy = new SelectList(db.DaiLies, "MaDaiLy", "TenDaiLy", soLuongDK.MaDaiLy);
return(View(soLuongDK));
}
public bool Update(SoLuongDK kq)
{
try
{
var tempt = db.SoLuongDKs.Find(kq.ID);
tempt.MaDaiLy = kq.MaDaiLy;
tempt.SoLuongDK1 = kq.SoLuongDK1;
tempt.NgayDK = kq.NgayDK;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Edit(SoLuongDK sl)
{
if (ModelState.IsValid)
{
var dao = new SoLuongDKDao();
sl.Flag = true;
var result = dao.Update(sl);
if (result)
{
return(RedirectToAction("Index", "SoLuongDK"));
}
}
else
{
ModelState.AddModelError("", "Chỉnh sửa giải không thành công");
}
return(View("Index"));
}
public ActionResult Create([Bind(Include = "MaSoLuongDK,MaDaiLy,NgayDK,SoLuongDK1,Flag")] SoLuongDK sldk)
{
if (ModelState.IsValid)
{
var dal = new SLDangKy_DAL();
sldk.MaSoLuongDK = dal.AutoID();
sldk.Flag = true;
db.SoLuongDK.Add(sldk);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaDaiLy = new SelectList(db.DaiLy, "MaDaiLy", "TenDaiLy", sldk.MaDaiLy);
return(View(sldk));
}
public ActionResult Create(SoLuongDK sl)
{
if (ModelState.IsValid)
{
var dao = new SoLuongDKDao();
sl.Flag = true;
string result = dao.Insert(sl);
if (result != null)
{
return(RedirectToAction("Index", "SoLuongDK"));
}
}
else
{
ModelState.AddModelError("", "Thêm giải mới không thành công");
}
return(View("Index"));
}
private void simpleButton1_Click(object sender, EventArgs e)
{
SoLuongDK soLuongDK = new SoLuongDK();
soLuongDK.ID = txtmadk.EditValue.ToString();
soLuongDK.MaLoaiveSo = cbLoaiveso.EditValue.ToString();
soLuongDK.MaDaiLy = cbMadaily.EditValue.ToString();
soLuongDK.NgayDK = DateTime.Parse(cbNgayDK.EditValue.ToString());
soLuongDK.SoLuongDK1 = int.Parse(txtsoLuongDk.EditValue.ToString());
if (busSoLuongDangKy.Exits_SoLuongDK_byMa(soLuongDK.ID))
{
MessageBox.Show("Đã tồn tại mã: " + soLuongDK.ID.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
busSoLuongDangKy.Insert_SoLuongDk(soLuongDK);
Load_DS_SLDK();
}
}
public ActionResult DeleteConfirmed(string id)
{
SoLuongDK soLuongDK = db.SoLuongDKs.Find(id);
string MaDL = soLuongDK.MaDaiLy;
int count = db.SoLuongDKs.Where(p => p.ID == id).Count();
if (count > 0)
{
soLuongDK.Flag = false;
}
else
{
db.SoLuongDKs.Remove(soLuongDK);
}
db.SaveChanges();
TempData["notice"] = "Successfully delete";
TempData["masl"] = soLuongDK.ID;
DaiLy givename = db.DaiLies.Where(s => s.MaDaiLy == MaDL).FirstOrDefault();
TempData["daily"] = givename.TenDaiLy;
return(RedirectToAction("Index"));
}
public string Insert(SoLuongDK entity)
{
db.SoLuongDKs.Add(entity);
db.SaveChanges();
return(entity.ID);
}
