public static Tin SelectById(Int32 TIN_ID)
{
Tin Item = new Tin();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("TIN_ID", TIN_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static Tin SelectById(SqlConnection con, String TIN_ID)
{
var item = new Tin();
var obj = new SqlParameter[1];
obj[0] = new SqlParameter("TIN_ID", TIN_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblTin_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
item = getFromReader(rd);
}
}
return(item);
}
public static Tin SelectByLangBaseID(String TIN_LangBase_ID, string Lang)
{
Tin Item = new Tin();
SqlParameter[] obj = new SqlParameter[2];
obj[0] = new SqlParameter("TIN_LangBase_ID", TIN_LangBase_ID);
obj[1] = new SqlParameter("TIN_Lang", Lang);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Select_SelectByLangBaseId_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static Tin SelectByIdView(string VBD_ID)
{
Tin Item = new Tin();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("TIN_ID", VBD_ID);
List <Files> filelist = new List <Files>();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Select_SelectByIdView_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
Files item = new Files();
if (rd.FieldExists("F_Ten"))
{
item.Ten = (String)(rd["F_Ten"]);
}
if (rd.FieldExists("F_ID"))
{
item.ID = (Int32)(rd["F_ID"]);
}
if (rd.FieldExists("F_NguoiTao"))
{
item.NguoiTao = (String)(rd["F_NguoiTao"]);
}
if (rd.FieldExists("F_Size"))
{
item.Size = (Int32)(rd["F_Size"]);
}
if (rd.FieldExists("F_MimeType"))
{
item.MimeType = (String)(rd["F_MimeType"]);
}
if (rd.FieldExists("F_Download"))
{
item.Download = (Int32)(rd["F_Download"]);
}
filelist.Add(item);
}
}
Item.Filelist = filelist;
return(Item);
}
public static void UpdateHetHanMulti(Tin TinHetHan)
{
SqlParameter[] obj = new SqlParameter[3];
obj[0] = new SqlParameter("TIN_ID", TinHetHan.multiID);
obj[1] = new SqlParameter("TIN_HetHan", TinHetHan.HetHan);
obj[2] = new SqlParameter("TIN_NgayHetHan", TinHetHan.NgayHetHan);
string htl = string.Format("{0:dd/MM/yy}", TinHetHan.NgayHetHan);
if (htl != "01/01/01")
{
obj[2] = new SqlParameter("TIN_NgayHetHan", TinHetHan.NgayHetHan);
}
else
{
obj[2] = new SqlParameter("TIN_NgayHetHan", DBNull.Value);
}
SqlHelper.ExecuteNonQuery(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Update_UpdateHetHanMultiById_hungpm", obj);
}
public static string FormatTinMoi(Tin item, string domain)
{
var c = HttpContext.Current;
var sb = new StringBuilder();
sb.AppendFormat(@"<div _id=""{4}"" class=""tin-item-DanhMucStyle1Tiny""><a class=""tin-item-ten"" href=""{0}/Tin-tuc/{2}/{3}/{4}.html"">{5}</a>
<span class=""tin-item-mota"">{6}</span>
</div>"
, domain
, string.IsNullOrEmpty(item.Anh) ? "" : string.Format(@"<img class=""tin-item-img"" src=""{0}/lib/up/rss/{1}"">", domain, Lib.imgSize(item.Anh, "105x70"))
, Lib.Bodau(item.DM_Ten)
, Lib.Bodau(item.Ten)
, item.ID
, item.Ten
, item.MoTa
, item.NgayTao.ToString("HH:mm tt dd/MM/yyyy"));
return(sb.ToString());
}
public static string FormatDanhMucItemSmall(Tin item, string domain, string css)
{
return(string.Format(@"
<div class=""{8}"">
<a href=""{0}/Tin-tuc/{6}/{5}/{2}.html"" class=""tin-item-imgBox"">
<img src=""{0}/lib/up/tintuc/{1}"" class=""tin-item-img"" />
</a>
<a href=""{0}/Tin-tuc/{6}/{5}/{2}.html"" class=""tin-item-ten"">{3}</a>
<span class=""tin-item-moTa"">{4}</span>
</div>
"
, domain
, Lib.imgSize(item.Anh, "")
, item.ID
, item.Ten
, item.MoTa
, Lib.Bodau(item.Ten)
, Lib.Bodau(item.DM_Ten)
, item.DM_ID
, css));
}
public static string formatSlides(Tin item, string domain)
{
var c = HttpContext.Current;
var sb = new StringBuilder();
sb.AppendFormat(@"
<div class=""slide"">
<a href=""{4}"" target=""_blank"">
<img class=""tin-item-img"" width=""990"" height=""340"" src=""{0}/lib/up/tintuc/{1}""></a>
<div class=""caption"">
<p><b>{3}</b><br/>{4}</p>
</div>
</div>", domain
, Lib.imgSize(item.Anh, "990x340")
, item.Alias
, item.Ten
, item.MoTa
, item.ID
, item.Nguon);
return(sb.ToString());
}
public static Tin getFromReader(IDataReader rd)
{
Tin Item = new Tin();
if (rd.FieldExists("TIN_ID"))
{
Item.ID = (Guid)(rd["TIN_ID"]);
}
if (rd.FieldExists("TIN_ID"))
{
Item._ID = (Guid)(rd["TIN_ID"]);
}
if (rd.FieldExists("_TIN_ID"))
{
Item._ID = (Guid)(rd["_TIN_ID"]);
}
if (rd.FieldExists("TIN_GH_ID"))
{
Item.GH_ID = (Guid)(rd["TIN_GH_ID"]);
}
if (rd.FieldExists("TIN_DM_ID"))
{
Item.DM_ID = (Guid)(rd["TIN_DM_ID"]);
}
if (rd.FieldExists("TIN_Lang"))
{
Item.Lang = (String)(rd["TIN_Lang"]);
}
if (rd.FieldExists("TIN_LangBased"))
{
Item.LangBased = (Boolean)(rd["TIN_LangBased"]);
}
if (rd.FieldExists("TIN_LangBased_ID"))
{
Item.LangBased_ID = (Guid)(rd["TIN_LangBased_ID"]);
}
if (rd.FieldExists("TIN_Alias"))
{
Item.Alias = (String)(rd["TIN_Alias"]);
}
if (rd.FieldExists("TIN_DM_Ten"))
{
Item.DM_Ten = (String)(rd["TIN_DM_Ten"]);
}
if (rd.FieldExists("TIN_Ten"))
{
Item.Ten = (String)(rd["TIN_Ten"]);
}
if (rd.FieldExists("TIN_MoTa"))
{
Item.MoTa = (String)(rd["TIN_MoTa"]);
}
if (rd.FieldExists("TIN_NoiDung"))
{
Item.NoiDung = (String)(rd["TIN_NoiDung"]);
}
if (rd.FieldExists("TIN_KeyWords"))
{
Item.KeyWords = (String)(rd["TIN_KeyWords"]);
}
if (rd.FieldExists("TIN_Description"))
{
Item.Description = (String)(rd["TIN_Description"]);
}
if (rd.FieldExists("TIN_TacGia"))
{
Item.TacGia = (String)(rd["TIN_TacGia"]);
}
if (rd.FieldExists("TIN_Anh"))
{
Item.Anh = (String)(rd["TIN_Anh"]);
}
if (rd.FieldExists("TIN_ThuTu"))
{
Item.ThuTu = (Int32)(rd["TIN_ThuTu"]);
}
if (rd.FieldExists("TIN_Nguon"))
{
Item.Nguon = (String)(rd["TIN_Nguon"]);
}
if (rd.FieldExists("TIN_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["TIN_NgayTao"]);
}
if (rd.FieldExists("TIN_NguoiTao"))
{
Item.NguoiTao = (String)(rd["TIN_NguoiTao"]);
}
if (rd.FieldExists("TIN_NgayCapNhat"))
{
Item.NgayCapNhat = (DateTime)(rd["TIN_NgayCapNhat"]);
}
if (rd.FieldExists("TIN_NguoiCapNhat"))
{
Item.NguoiCapNhat = (String)(rd["TIN_NguoiCapNhat"]);
}
if (rd.FieldExists("TIN_NgayDang"))
{
Item.NgayDang = (DateTime)(rd["TIN_NgayDang"]);
}
if (rd.FieldExists("TIN_NgayHetHan"))
{
Item.NgayHetHan = (DateTime)(rd["TIN_NgayHetHan"]);
}
if (rd.FieldExists("TIN_Views"))
{
Item.Views = (Int32)(rd["TIN_Views"]);
}
if (rd.FieldExists("TIN_Hot"))
{
Item.Hot = (Boolean)(rd["TIN_Hot"]);
}
if (rd.FieldExists("TIN_Active"))
{
Item.Active = (Boolean)(rd["TIN_Active"]);
}
if (rd.FieldExists("TIN_Publish"))
{
Item.Publish = (Boolean)(rd["TIN_Publish"]);
}
if (rd.FieldExists("TIN_HetHan"))
{
Item.HetHan = (Boolean)(rd["TIN_HetHan"]);
}
if (rd.FieldExists("TIN_Moi"))
{
Item.Moi = (Boolean)(rd["TIN_Moi"]);
}
if (rd.FieldExists("TIN_RowId"))
{
Item.RowId = (Guid)(rd["TIN_RowId"]);
}
if (rd.FieldExists("TIN_DM_Ten"))
{
Item.DM_Ten = (String)(rd["TIN_DM_Ten"]);
}
return(Item);
}
public static Tin Update(Tin item)
{
var Item = new Tin();
var obj = new SqlParameter[29];
obj[0] = new SqlParameter("TIN_ID", item.ID);
obj[1] = new SqlParameter("TIN_GH_ID", item.GH_ID);
obj[2] = new SqlParameter("TIN_DM_ID", item.DM_ID);
obj[3] = new SqlParameter("TIN_Lang", item.Lang);
obj[4] = new SqlParameter("TIN_LangBased", item.LangBased);
obj[5] = new SqlParameter("TIN_LangBased_ID", item.LangBased_ID);
obj[6] = new SqlParameter("TIN_Alias", item.Alias);
obj[7] = new SqlParameter("TIN_Ten", item.Ten);
obj[8] = new SqlParameter("TIN_Keywords", item.KeyWords);
obj[9] = new SqlParameter("TIN_Description", item.Description);
obj[10] = new SqlParameter("TIN_MoTa", item.MoTa);
obj[11] = new SqlParameter("TIN_NoiDung", item.NoiDung);
obj[12] = new SqlParameter("TIN_TacGia", item.TacGia);
obj[13] = new SqlParameter("TIN_Anh", item.Anh);
obj[14] = new SqlParameter("TIN_ThuTu", item.ThuTu);
obj[15] = new SqlParameter("TIN_Nguon", item.Nguon);
if (item.NgayTao > DateTime.MinValue)
{
obj[16] = new SqlParameter("TIN_NgayTao", item.NgayTao);
}
else
{
obj[16] = new SqlParameter("TIN_NgayTao", DBNull.Value);
}
obj[17] = new SqlParameter("TIN_NguoiTao", item.NguoiTao);
if (item.NgayCapNhat > DateTime.MinValue)
{
obj[18] = new SqlParameter("TIN_NgayCapNhat", item.NgayCapNhat);
}
else
{
obj[18] = new SqlParameter("TIN_NgayCapNhat", DBNull.Value);
}
obj[19] = new SqlParameter("TIN_NguoiCapNhat", item.NguoiCapNhat);
if (item.NgayDang > DateTime.MinValue)
{
obj[20] = new SqlParameter("TIN_NgayDang", item.NgayDang);
}
else
{
obj[20] = new SqlParameter("TIN_NgayDang", DBNull.Value);
}
if (item.NgayHetHan > DateTime.MinValue)
{
obj[21] = new SqlParameter("TIN_NgayHetHan", item.NgayHetHan);
}
else
{
obj[21] = new SqlParameter("TIN_NgayHetHan", DBNull.Value);
}
obj[22] = new SqlParameter("TIN_Views", item.Views);
obj[23] = new SqlParameter("TIN_Hot", item.Hot);
obj[24] = new SqlParameter("TIN_Active", item.Active);
obj[25] = new SqlParameter("TIN_Publish", item.Publish);
obj[26] = new SqlParameter("TIN_HetHan", item.HetHan);
obj[27] = new SqlParameter("TIN_Moi", item.Moi);
obj[28] = new SqlParameter("TIN_RowId", item.RowId);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Update_UpdateNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static Tin Insert(Tin inserted)
{
var item = new Tin();
var obj = new SqlParameter[29];
obj[0] = new SqlParameter("TIN_ID", inserted.ID);
obj[1] = new SqlParameter("TIN_GH_ID", inserted.GH_ID);
obj[2] = new SqlParameter("TIN_DM_ID", inserted.DM_ID);
obj[3] = new SqlParameter("TIN_Lang", inserted.Lang);
obj[4] = new SqlParameter("TIN_LangBased", inserted.LangBased);
obj[5] = new SqlParameter("TIN_LangBased_ID", inserted.LangBased_ID);
obj[6] = new SqlParameter("TIN_Alias", inserted.Alias);
obj[7] = new SqlParameter("TIN_Ten", inserted.Ten);
obj[8] = new SqlParameter("TIN_MoTa", inserted.MoTa);
obj[9] = new SqlParameter("TIN_NoiDung", inserted.NoiDung);
obj[10] = new SqlParameter("TIN_TacGia", inserted.TacGia);
obj[11] = new SqlParameter("TIN_Anh", inserted.Anh);
obj[12] = new SqlParameter("TIN_ThuTu", inserted.ThuTu);
obj[13] = new SqlParameter("TIN_Nguon", inserted.Nguon);
obj[14] = new SqlParameter("TIN_NgayTao", inserted.NgayTao);
obj[15] = new SqlParameter("TIN_NguoiTao", inserted.NguoiTao);
// obj[16] = new SqlParameter("TIN_NgayCapNhat", Updated.NgayCapNhat);
string capnhat = string.Format("{0:dd/MM/yy}", inserted.NgayCapNhat);
if (capnhat != "01/01/01")
{
obj[16] = new SqlParameter("TIN_NgayCapNhat", inserted.NgayCapNhat);
}
else
{
obj[16] = new SqlParameter("TIN_NgayCapNhat", DBNull.Value);
}
obj[17] = new SqlParameter("TIN_NguoiCapNhat", inserted.NguoiCapNhat);
string htl = string.Format("{0:dd/MM/yy}", inserted.NgayDang);
if (htl != "01/01/01")
{
obj[18] = new SqlParameter("TIN_NgayDang", inserted.NgayDang);
}
else
{
obj[18] = new SqlParameter("TIN_NgayDang", DBNull.Value);
}
// obj[16] = new SqlParameter("TIN_NgayHetHan", Updated.NgayHetHan);
string htl1 = string.Format("{0:dd/MM/yy}", inserted.NgayHetHan);
if (htl1 != "01/01/01")
{
obj[19] = new SqlParameter("TIN_NgayHetHan", inserted.NgayHetHan);
}
else
{
obj[19] = new SqlParameter("TIN_NgayHetHan", DBNull.Value);
}
//obj[18] = new SqlParameter("TIN_NgayDang", Updated.NgayDang);
//obj[19] = new SqlParameter("TIN_NgayHetHan", Updated.NgayHetHan);
obj[20] = new SqlParameter("TIN_Views", inserted.Views);
obj[21] = new SqlParameter("TIN_Hot", inserted.Hot);
obj[22] = new SqlParameter("TIN_Active", inserted.Active);
obj[23] = new SqlParameter("TIN_Publish", inserted.Publish);
obj[24] = new SqlParameter("TIN_HetHan", inserted.HetHan);
obj[25] = new SqlParameter("TIN_Moi", inserted.Moi);
obj[26] = new SqlParameter("TIN_RowId", inserted.RowId);
obj[27] = new SqlParameter("TIN_KeyWords", inserted.KeyWords);
obj[28] = new SqlParameter("TIN_Description", inserted.Description);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblTin_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
item = getFromReader(rd);
}
}
return(item);
}
