public ActionResult DeleteConfirmed(int id) { HangSP hangSP = db.HangSPs.Find(id); db.HangSPs.Remove(hangSP); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MaHang,TenHang")] HangSP hangSP) { if (ModelState.IsValid) { db.Entry(hangSP).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hangSP)); }
public ActionResult Create([Bind(Include = "MaHang,TenHang")] HangSP hangSP) { if (ModelState.IsValid) { db.HangSPs.Add(hangSP); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hangSP)); }
public ActionResult Edit(int id, HangSP hsp) { try { // TODO: Add update logic here NhaSanXuatBus.Sua(id, hsp); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(HangSP hsp) { try { // TODO: Add insert logic here NhaSanXuatBus.Them(hsp); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(int id, HangSP HangSP) { try { // TODO: Add update logic here HangBus.Sua(HangSP); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(HangSP HangSP) { try { // TODO: Add insert logic here HangBus.Them(HangSP); return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: HangSPs/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HangSP hangSP = db.HangSPs.Find(id); if (hangSP == null) { return(HttpNotFound()); } return(View(hangSP)); }
private void btnSave_Click(object sender, EventArgs e) { switch (choose) { case 1: { if (txtNameBrand.Text == "") { MessageBox.Show("Please enter name of brand"); } else if (txtNameBrand.Text != "") { var hsp = from u in db.HangSPs select u; if (hsp.Count() == 0) { db.HSP_Ins("Hang0001", txtNameBrand.Text); } else { HangSP hspp = db.HangSPs.Where(s => s.tenHang.Equals(txtNameBrand.Text)).FirstOrDefault(); if (hspp != null) { MessageBox.Show("Alredy have this name"); } else if (hspp == null) { var hsppp = hsp.OrderByDescending(s => s.maHang).FirstOrDefault(); int stt = Convert.ToInt32(hsppp.maHang.Substring(4)) + 1; string id = ""; if (stt / 10 >= 100) { id = "Hang" + stt; } else if (stt / 10 >= 10 && stt / 10 < 100) { id = "Hang0" + stt; } else if (stt / 10 >= 1 && stt / 10 < 10) { id = "Hang00" + stt; } else if (stt / 10 == 0) { id = "Hang000" + stt; } db.HSP_Ins(id, txtNameBrand.Text); //dgvHangSP.DataSource = db.HSP_Sel(); } } Uc_HangSP_Load(sender, e); } break; } case 2: { if (txtIDBrand.Text == "") { MessageBox.Show("Please enter the id to delete"); } else { db.HSP_Del(txtIDBrand.Text); Uc_HangSP_Load(sender, e); } break; } case 3: { if (txtIDBrand.Text == "" || txtNameBrand.Text == "") { MessageBox.Show("Please enter the id and name of brand"); } else { HangSP hsp = db.HangSPs.Where(s => s.tenHang.Equals(txtNameBrand.Text)).FirstOrDefault(); if (hsp != null) { MessageBox.Show("Already have this name"); } else { db.HSP_Up(txtIDBrand.Text, txtNameBrand.Text); Uc_HangSP_Load(sender, e); } } break; } } }
public static void Sua(int id, HangSP hsp) { var db = new ShopDienThoaiConnectionDB(); db.Update <HangSP>("Set TenHang = @0, BiXoa=0 where MaLoai=@1", hsp.TenHang, id); }
public static void Them(HangSP hsp) { var db = new ShopDienThoaiConnectionDB(); db.Insert(hsp); }