public static void Admin_update(Areas.Models.TinTuc tin)
{
openConnect();
SqlCommand cmd = new SqlCommand("Admin_sp_update_TinTuc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", tin.Id1);
cmd.Parameters.AddWithValue("@TieuDe", tin.TieuDe1.Trim());
cmd.Parameters.AddWithValue("@Tag", tin.Tag1.Trim());
cmd.Parameters.AddWithValue("@NoiDung", tin.NoiDung1.Trim());
cmd.Parameters.AddWithValue("@HienThi", tin.HienThi1);
if (tin.HienThi1)
{
cmd.Parameters.AddWithValue("@NgayDang", DateTime.Now.ToString());
}
else
{
cmd.Parameters.AddWithValue("@NgayDang", "");
}
cmd.Parameters.AddWithValue("@TuKhoa", tin.TuKhoa1.Trim());
cmd.Parameters.AddWithValue("@Anh", tin.Anh1.Trim());
cmd.Parameters.AddWithValue("@MetaTitle", tin.MetaTitle1.Trim());
cmd.Parameters.AddWithValue("@Hot", tin.Hot1);
cmd.Parameters.AddWithValue("@DanhMuc", tin.DanhMuc1);
cmd.ExecuteNonQuery();
closeConnect();
}
public static Areas.Models.TinTuc selectTT(string matin)
{
Areas.Models.TinTuc tt = new Areas.Models.TinTuc();
SqlCommand cmd = new SqlCommand("sp_select_TinTuc_ID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", matin);
openConnect();
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
tt.Id1 = rd["Id"] is DBNull ? 0 : rd.GetInt32(0);
tt.TieuDe1 = rd["TieuDe"] is DBNull ? "" : rd.GetString(1).Trim();
tt.Tag1 = rd["Tag"] is DBNull ? "" : rd.GetString(2);
tt.NoiDung1 = rd["NoiDung"] is DBNull ? "" : rd.GetString(3).Trim();
tt.NgayDang1 = rd["NgayDang"] is DBNull ? d : rd.GetDateTime(4);
tt.NgayTao1 = rd["NgayTao"] is DBNull ? d : rd.GetDateTime(5);
tt.HienThi1 = rd["HienThi"] is DBNull ? false : rd.GetBoolean(6);
tt.TuKhoa1 = rd["TuKhoa"] is DBNull ? "" : rd.GetString(7).Trim();
tt.DanhMuc1 = rd["DanhMuc"] is DBNull ? 0 : rd.GetInt32(8);
tt.TenDM1 = rd["Ten"] is DBNull ? "" : rd.GetString(9).Trim();
tt.Anh1 = rd["Anh"] is DBNull ? "" : rd.GetString(10).Trim();
tt.MetaTitle1 = rd["MetaTitle"] is DBNull ? "" : rd.GetString(11).Trim();
tt.TacGia1 = rd["tentg"] is DBNull ? "" : rd.GetString(12).Trim();
tt.Hot1 = rd["Hot"] is DBNull ? false : rd.GetBoolean(13);
}
rd.Close();
return(tt);
}
public static List <Areas.Models.TinTuc> selectTTDM(string dm)
{
List <Areas.Models.TinTuc> list = new List <Areas.Models.TinTuc>();
SqlCommand cmd = new SqlCommand(" select tintuc.Id,TieuDe,Tag,NoiDung,NgayDang,TuKhoa,DanhMuc,Anh,tintuc.MetaTitle,danhmuc.ten from tintuc,danhmuc where tintuc.HienThi = 1 and DanhMuc = 1 and danhmuc.id = tintuc.danhmuc and tintuc.danhmuc = @danhmuc order by NgayTao", con);
cmd.Parameters.AddWithValue("danhmuc", dm);
openConnect();
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Areas.Models.TinTuc tt = new Areas.Models.TinTuc();
tt.Id1 = rd["Id"] is DBNull ? 0 : rd.GetInt32(0);
tt.TieuDe1 = rd["TieuDe"] is DBNull ? "" : rd.GetString(1).Trim();
tt.Tag1 = rd["Tag"] is DBNull ? "" : rd.GetString(2);
tt.NoiDung1 = rd["NoiDung"] is DBNull ? "" : rd.GetString(3).Trim();
tt.NgayDang1 = rd["NgayDang"] is DBNull ? d : rd.GetDateTime(4);
tt.TuKhoa1 = rd["TuKhoa"] is DBNull ? "" : rd.GetString(5).Trim();
tt.DanhMuc1 = rd["DanhMuc"] is DBNull ? 0 : rd.GetInt32(6);
tt.Anh1 = rd["Anh"] is DBNull ? "" : rd.GetString(7).Trim();
tt.MetaTitle1 = rd["MetaTitle"] is DBNull ? "" : rd.GetString(8).Trim();
tt.TenDM1 = rd["MetaTitle"] is DBNull ? "" : rd.GetString(9).Trim();
list.Add(tt);
}
rd.Close();
return(list);
}
public static List <Areas.Models.TinTuc> selectTT4()
{
List <Areas.Models.TinTuc> list = new List <Areas.Models.TinTuc>();
SqlCommand cmd = new SqlCommand(" select top 6 Id,TieuDe,Tag,NoiDung,NgayDang,TuKhoa,DanhMuc,Anh,MetaTitle from tintuc where HienThi = 1 order by NgayTao", con);
openConnect();
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Areas.Models.TinTuc tt = new Areas.Models.TinTuc();
tt.Id1 = rd["Id"] is DBNull ? 0 : rd.GetInt32(0);
tt.TieuDe1 = rd["TieuDe"] is DBNull ? "" : rd.GetString(1).Trim();
tt.Tag1 = rd["Tag"] is DBNull ? "" : rd.GetString(2);
tt.NoiDung1 = rd["NoiDung"] is DBNull ? "" : rd.GetString(3).Trim();
tt.NgayDang1 = rd["NgayDang"] is DBNull ? d : rd.GetDateTime(4);
tt.TuKhoa1 = rd["TuKhoa"] is DBNull ? "" : rd.GetString(5).Trim();
tt.DanhMuc1 = rd["DanhMuc"] is DBNull ? 0 : rd.GetInt32(6);
tt.Anh1 = rd["Anh"] is DBNull ? "" : rd.GetString(7).Trim();
tt.MetaTitle1 = rd["MetaTitle"] is DBNull ? "" : rd.GetString(8).Trim();
list.Add(tt);
}
rd.Close();
return(list);
}
public ActionResult InsertTT(Areas.Models.TinTuc tt, string selectDM, string url)
{
if (Session["login"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
string id = Session["login"].ToString();
tt.DanhMuc1 = Int32.Parse(selectDM);
tt.Anh1 = url;
tt.TacGia1 = id;
tt.MetaTitle1 = DAL.XuLiChuoi.xoaKhoangTrang(tt.TieuDe1);
string[] tagg = tt.Tag1.Split(',');
DAL.TinTuc.insert(tt);
for (int i = 0; i < tagg.Length; i++)
{
DAL.Tag.insert(tagg[i]);
DAL.Tag.insertTagtt(tagg[i], DAL.TinTuc.getIDTT());
}
ViewBag.listTag = DAL.Tag.getTag();
ViewBag.listDM = DAL.DanhMuc.select(id);
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult updateTT(string idTT, Areas.Models.TinTuc tt, string selectDM, string url)
{
if (Session["login"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
string id = Session["login"].ToString();
//
tt.Id1 = Int32.Parse(idTT);
tt.DanhMuc1 = Int32.Parse(selectDM);
if (!String.IsNullOrWhiteSpace(url))
{
tt.Anh1 = url;
}
DAL.TinTuc.update(tt);
string[] tagg = tt.Tag1.Split(',');
//DAL.TinTuc.checkAdmin(id);
DAL.Tag.deteleTagtt(tt.Id1.ToString());
for (int i = 0; i < tagg.Length; i++)
{
DAL.Tag.insert(tagg[i]);
DAL.Tag.insertTagtt(tagg[i], tt.Id1.ToString());
}
return(RedirectToAction("Index", "Home"));
}
}
public static void update(Areas.Models.TinTuc tin)
{
openConnect();
SqlCommand cmd = new SqlCommand("sp_update_TinTuc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TieuDe", tin.TieuDe1.Trim());
cmd.Parameters.AddWithValue("@Tag", XuLiChuoi.xoaKhoangTrang(tin.Tag1.Trim()));
cmd.Parameters.AddWithValue("@NoiDung", tin.NoiDung1.Trim());
cmd.Parameters.AddWithValue("@TuKhoa", XuLiChuoi.xoaKhoangTrang(tin.TuKhoa1.Trim()));
cmd.Parameters.AddWithValue("@Anh", tin.Anh1.Trim());
cmd.Parameters.AddWithValue("@MetaTitle", XuLiChuoi.xoaKhoangTrang(tin.TieuDe1.Trim()));
cmd.Parameters.AddWithValue("@Id", tin.Id1);
cmd.Parameters.AddWithValue("@DanhMuc", tin.DanhMuc1);
cmd.ExecuteNonQuery();
closeConnect();
}
public static void insert(Areas.Models.TinTuc tin)
{
openConnect();
SqlCommand cmd = new SqlCommand("sp_insert_TinTuc", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TieuDe", tin.TieuDe1.Trim());
cmd.Parameters.AddWithValue("@Tag", tin.Tag1.Trim());
cmd.Parameters.AddWithValue("@NoiDung", tin.NoiDung1.Trim());
cmd.Parameters.AddWithValue("@TuKhoa", tin.TuKhoa1.Trim());
cmd.Parameters.AddWithValue("@Anh", tin.Anh1.Trim());
cmd.Parameters.AddWithValue("@MetaTitle", tin.MetaTitle1.Trim());
cmd.Parameters.AddWithValue("@TacGia", tin.TacGia1.Trim());
cmd.Parameters.AddWithValue("@DanhMuc", tin.DanhMuc1);
cmd.ExecuteNonQuery();
closeConnect();
}
public static List <string> getTag()
{
List <string> l = new List <string>();
openConnect();
SqlCommand cmd = new SqlCommand("select tag from tag", con);
SqlDataReader rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rd.Read())
{
Areas.Models.TinTuc tt = new Areas.Models.TinTuc();
string ttag = rd["Tag"] is DBNull ? "" : rd.GetString(0).Trim();
l.Add(ttag);
}
rd.Close();
closeConnect();
return(l);
}
