public ActionResult DeleteConfirmed(int id) { SQLGOIY sQLGOIY = db.SQLGOIYs.Find(id); db.SQLGOIYs.Remove(sQLGOIY); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,NameTable,Name,SqlString")] SQLGOIY sQLGOIY) { if (ModelState.IsValid) { db.Entry(sQLGOIY).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sQLGOIY)); }
// GET: SQLGOIYs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SQLGOIY sQLGOIY = db.SQLGOIYs.Find(id); if (sQLGOIY == null) { return(HttpNotFound()); } return(View(sQLGOIY)); }
public ActionResult Create([Bind(Include = "ID,NameTable,Name,SqlString")] SQLGOIY sQLGOIY) { if (ModelState.IsValid) { List <SQLGOIY> sqlItem = db.SQLGOIYs.OrderByDescending(x => x.ID).ToList(); string tagName = ""; switch (sQLGOIY.NameTable) { case "Sản Phẩm": tagName = "_SP"; break; case "Nhân Viên": tagName = "_NV"; break; case "Đơn Hàng Xuất": tagName = "_DHX"; break; case "Đơn Hàng Nhập": tagName = "_DHN"; break; case "Đại Lý": tagName = "_DL"; break; case "Lưu Vết": tagName = "_LV"; break; } sQLGOIY.Name += (sqlItem != null && sqlItem.Count > 0) ? "(" + (sqlItem[0].ID + 1) + ")" + tagName : "(1)" + tagName; db.SQLGOIYs.Add(sQLGOIY); db.SaveChanges(); return(RedirectToAction("Create")); } return(View(sQLGOIY)); }
// GET: TimKiems public ActionResult Index(string ValueSearch, string option, string dhx = "") { if (Session["username"] == null) { return(RedirectToAction("Login", "TaiKhoans")); } if (string.IsNullOrEmpty(ValueSearch)) { return(View()); } ViewBag.NhanVien = db.NHANVIENs.Where(x => x.isXoa == false).ToList(); ViewBag.ListNCC = db.NHACUNGCAPs.Where(x => x.isXoa == false).ToList(); switch (option) { case "product": ViewBag.Type = 1; ViewBag.ListLSP = db.LOAISANPHAMs.Where(x => x.isXoa == false).ToList(); ViewBag.LisData = CBO.FillCollection <SANPHAM>(DataProvider.Instance.ExecuteReader("sp_FindStringInTable", ValueSearch, "dbo", "SanPham")); break; case "category": ViewBag.Type = 2; ViewBag.LisData = CBO.FillCollection <LOAISANPHAM>(DataProvider.Instance.ExecuteReader("sp_FindStringInTable", ValueSearch, "dbo", "LOAISANPHAM")); break; case "input": if (dhx.Equals("2")) { ViewBag.LisData = db.DONHANGNHAPs.Where(x => x.MaNhaCC + "" == ValueSearch).ToList(); } else { ViewBag.LisData = CBO.FillCollection <DONHANGNHAP>(DataProvider.Instance.ExecuteReader("sp_FindStringInTable", ValueSearch, "dbo", "DONHANGNHAP")); } ViewBag.Type = 3; ViewBag.ListNCC = db.NHACUNGCAPs.Where(x => x.isXoa == false).ToList(); break; case "output": ViewBag.Type = 4; if (dhx.Equals("1")) { ViewBag.LisData = db.DONHANGXUATs.Where(x => x.MaDaiLy + "" == ValueSearch).ToList(); } else if (dhx.Equals("3")) { string sql = string.Format(@"select dhx.* from DONHANGXUAT dhx left join LUUVET lv on lv.MaDHX = dhx.MaDHX left join TRAM t on t.MaTram = lv.MaTram where t.MaTram = '{0}'", ValueSearch); ViewBag.LisData = db.Database.SqlQuery <DONHANGXUAT>(sql).ToList(); } else { ViewBag.LisData = CBO.FillCollection <DONHANGXUAT>(DataProvider.Instance.ExecuteReader("sp_FindStringInTable", ValueSearch, "dbo", "DONHANGXUAT")); } break; case "luuvet": ViewBag.Type = 5; ViewBag.Tram = db.TRAMs.Where(x => x.isXoa == false).ToList();; ViewBag.LisData = CBO.FillCollection <LUUVET>(DataProvider.Instance.ExecuteReader("sp_FindStringInTable", ValueSearch, "dbo", "LUUVET")); break; case "NCC": ViewBag.Type = 6; ViewBag.Tram = db.TRAMs.Where(x => x.isXoa == false).ToList();; ViewBag.LisData = CBO.FillCollection <NHACUNGCAP>(DataProvider.Instance.ExecuteReader("sp_FindStringInTable", ValueSearch, "dbo", "NHACUNGCAP")); break; case "nhanvien": ViewBag.Type = 7; //ViewBag.Tram = db.TRAMs.Where(x => x.isXoa == false).ToList(); ; ViewBag.LisData = CBO.FillCollection <NHANVIEN>(DataProvider.Instance.ExecuteReader("sp_FindStringInTable", ValueSearch, "dbo", "NHANVIEN")); break; case "goiy": int idx = ValueSearch.IndexOf('('); if (idx >= 0) { int idxLast = ValueSearch.IndexOf(')'); int idxFirst = ValueSearch.IndexOf('('); int? idSql = int.Parse(ValueSearch.Substring(ValueSearch.IndexOf('(') + 1, (idxLast - idxFirst) - 1)); string tagName = ValueSearch.Substring(ValueSearch.IndexOf('_') + 1); SQLGOIY sQLGOIY = db.SQLGOIYs.Find(idSql); ViewBag.SQLString = sQLGOIY.Name; switch (tagName) { case "SP": ViewBag.Type = 1; ViewBag.ListLSP = db.LOAISANPHAMs.Where(x => x.isXoa == false).ToList(); ViewBag.LisData = db.Database.SqlQuery <SANPHAM>(sQLGOIY.SqlString).ToList(); break; case "NV": ViewBag.Type = 7; ViewBag.LisData = db.Database.SqlQuery <NHANVIEN>(sQLGOIY.SqlString).ToList(); break; case "DHX": ViewBag.Type = 4; ViewBag.ShowSoLuong = 1; ViewBag.LisData = db.Database.SqlQuery <SearchDonHangXuat>(sQLGOIY.SqlString).ToList(); break; case "DHN": if (sQLGOIY.ID == 63) { ViewBag.Type = 10; ViewBag.ListNCC = db.NHACUNGCAPs.Where(x => x.isXoa == false).ToList(); ViewBag.LisData = db.Database.SqlQuery <SearchTinhTongDaiLy>(sQLGOIY.SqlString).ToList(); } else { ViewBag.Type = 12; ViewBag.LisData = db.Database.SqlQuery <DetailSearchs>(sQLGOIY.SqlString).ToList(); } break; case "DL": if (sQLGOIY.ID == 62) { ViewBag.Type = 9; ViewBag.LisData = db.Database.SqlQuery <SearchTinhTongDaiLy>(sQLGOIY.SqlString).ToList(); } else { ViewBag.Type = 8; ViewBag.LisData = db.Database.SqlQuery <SearchDaiLy>(sQLGOIY.SqlString).ToList(); } break; case "LV": ViewBag.Type = 11; ViewBag.LisData = db.Database.SqlQuery <SearchTinhTongDaiLy>(sQLGOIY.SqlString).ToList(); break; } } break; } return(View()); }