public List <QUANG_CAO> getAllQC()
{
c = new ConnectDb();
List <QUANG_CAO> list = new List <QUANG_CAO>();
SqlCommand cmd = new SqlCommand("getAllQC", c.conn);
cmd.CommandType = CommandType.StoredProcedure;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
QUANG_CAO item = new QUANG_CAO();
item.ID = (int)rdr["ID"];
item.TENQC = (string)rdr["TENQC"];
item.HINH = (string)rdr["HINH"];
item.LINK = (string)rdr["LINK"];
item.TT = (int)rdr["TT"];
list.Add(item);
}
return(list);
}
public ActionResult Capnhat(QUANG_CAO model)
{
model.ID = Convert.ToInt32(Request["txtmaqc"]);
model.TENQC = Request["txttenqc"].ToString();
model.LINK = Request["txtlinkqc"].ToString();
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Image/Ads/"), fileName);
file.SaveAs(path);
model.HINH = "/Image/Ads/" + fileName;
}
else
{
model.HINH = Request["txturlqc1"].ToString();
}
}
model.TT = Convert.ToInt32(Request["tttrangthaiup"].ToString());
if (model.TENQC != "")
{
var t = new Models.AdsModel();
var result = t.UpdateOneQC(model.ID, model.TENQC, model.HINH, model.LINK, model.TT);
if (result)
{
return(RedirectToAction("Index", "QuangCao"));
}
else
{
return(RedirectToAction("Index", "QuangCao"));
}
}
else
{
return(RedirectToAction("Index", "QuangCao"));
}
}
public ActionResult Them(QUANG_CAO model)
{
model.TENQC = Request["txttenQuangCao"].ToString();
model.LINK = Request["txtLink"].ToString();
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Image/Ads/"), fileName);
file.SaveAs(path);
model.HINH = "/Image/Ads/" + fileName;
}
else
{
model.HINH = "/Image/Ads/banner_728x90.gif";
}
}
model.TT = Convert.ToInt32(Request["tttrangthaiadd"]);
if (model.TENQC != "")
{
var t = new Models.AdsModel();
var result = t.insertOneQC(model.TENQC, model.HINH, model.LINK, model.TT);
if (result)
{
return(RedirectToAction("Index", "QuangCao"));
}
else
{
return(RedirectToAction("Index", "QuangCao"));
}
}
else
{
return(RedirectToAction("Index", "QuangCao"));
}
}
public ActionResult Xoa(QUANG_CAO model)
{
model.ID = Convert.ToInt32(Request["txtiads"].ToString());
var img = Request["txtiad"].ToString();
var t = new Models.AdsModel();
var result = t.delOneQC(model.ID);
if (result)
{
if (!img.Equals("/Image/Ads/banner_728x90.gif"))
{
var fullPath = Server.MapPath(img);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
}
return(RedirectToAction("Index", "QuangCao"));
}
else
{
return(RedirectToAction("Index", "QuangCao"));
}
}
