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());
}
