public ActionResult Update(Areas.Models.Tag tag)
{
if (Session["login"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
DAL.Tag.update(tag.TenTag, tag.Url);
return(RedirectToAction("Index", "Tag"));
}
}
public static Areas.Models.Tag getTag(string id)
{
Areas.Models.Tag tt = new Areas.Models.Tag();
openConnect();
SqlCommand cmd = new SqlCommand("select * from tag where tag = @tag", con);
cmd.Parameters.AddWithValue("@tag", id);
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
tt.TenTag = rd["Tag"] is DBNull ? "" : rd.GetString(0).Trim();
tt.Url = rd["Url"] is DBNull ? "" : rd.GetString(1).Trim();
}
rd.Close();
closeConnect();
return(tt);
}
public ActionResult Create(Areas.Models.Tag tag)
{
Areas.Models.DanhMuc tin = new Models.DanhMuc();
if (Session["login"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
if (DAL.Tag.checkTag(tag.TenTag) > 0)
{
ModelState.AddModelError("", "Đã tồn tại");
return(View(tag));
}
DAL.Tag.insert(tag.TenTag, tag.Url);
return(RedirectToAction("Index", "Tag"));
}
}
public static List <Areas.Models.Tag> getALLTag()
{
List <Areas.Models.Tag> l = new List <Areas.Models.Tag>();
openConnect();
SqlCommand cmd = new SqlCommand("select * from tag", con);
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Areas.Models.Tag tt = new Areas.Models.Tag();
tt.TenTag = rd["Tag"] is DBNull ? "" : rd.GetString(0).Trim();
tt.Url = rd["Url"] is DBNull ? "" : rd.GetString(1).Trim();
l.Add(tt);
}
rd.Close();
closeConnect();
return(l);
}
