public IntroductionInfo GetInfo(int id)
{
IntroductionInfo info = null;
SqlParameter[] param =
{
new SqlParameter("@id", id)
};
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_Introduction_GetById", param);
if (r != null)
{
info = new IntroductionInfo();
while (r.Read())
{
info.id = Int32.Parse(r["id"].ToString());
info.introductionTypeId = Int32.Parse(r["introductionTypeId"].ToString());
info.introductionTypeName = r["introductionTypeName"].ToString();
info.title = r["title"].ToString();
info.description = r["description"].ToString();
info.content = r["content"].ToString();
info.image = r["image"].ToString();
info.altImage = r["altImage"].ToString();
info.tag = r["tag"].ToString();
info.CreateDate = Convert.ToDateTime(r["CreateDate"]);
info.action = Convert.ToBoolean(r["action"]);
info.link = r["link"].ToString();
info.desseo = r["desseo"].ToString();
}
r.Close();
r.Dispose();
}
return(info);
}
private bool AddNews()
{
if (string.IsNullOrEmpty(txtTenTin.Text) || string.IsNullOrEmpty(Content.Text))
{
ltrThongbao.Text = "Bắt buộc nhập tên tin và nội dung tin";
return(false);
}
var info = new IntroductionInfo();
info.title = txtTenTin.Text;
info.introductionTypeName = drpNhomTin.SelectedItem.Text;
info.introductionTypeId = int.Parse(drpNhomTin.SelectedValue);
info.content = Content.Text;
info.desseo = txtMotaSeo.Text;
info.description = txtdesc.Text;
var nextId = UntilityFunction.nextId("tbl_Introduction");
info.link = Rewrite.GenDetail(info.introductionTypeName, info.introductionTypeId, nextId, info.title, Rewrite.About);
info.altImage = Server.HtmlEncode(info.title);
info.tag = txtkeyword.Text;
info.CreateDate = DateTime.Now;
info.action = chkAction.Checked;
if (upHinhanh.HasFile)
{
info.image = UploadImage(nextId);
}
ServiceFactory.GetInstanceIntroduction().Add(info);
return(true);
}
public List <IntroductionInfo> GetList(int pageIndex, int pageSize, out int total, int categoryId)
{
List <IntroductionInfo> list = null;
var t = 0;
SqlParameter[] param =
{
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@totalrow", DbType.Int32)
{
Direction = ParameterDirection.Output
},
new SqlParameter("@introductionTypeId", categoryId)
};
SqlCommand comx;
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_Introduction_GetList", param, out comx);
if (r != null)
{
list = new List <IntroductionInfo>();
while (r.Read())
{
var info = new IntroductionInfo();
info.id = Int32.Parse(r["id"].ToString());
info.introductionTypeId = Int32.Parse(r["introductionTypeId"].ToString());
info.introductionTypeName = r["introductionTypeName"].ToString();
info.title = r["title"].ToString();
info.description = r["description"].ToString();
info.content = r["content"].ToString();
info.image = r["image"].ToString();
info.altImage = r["altImage"].ToString();
info.tag = r["tag"].ToString();
info.CreateDate = Convert.ToDateTime(r["CreateDate"]);
info.action = Convert.ToBoolean(r["action"]);
info.link = r["link"].ToString();
info.desseo = r["desseo"].ToString();
list.Add(info);
}
r.Close();
r.Dispose();
t = int.Parse(comx.Parameters[2].Value.ToString());
}
total = t;
return(list);
}
public int Add(IntroductionInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@introductionTypeId", info.introductionTypeId),
new SqlParameter("@introductionTypeName", info.introductionTypeName),
new SqlParameter("@title", info.title),
new SqlParameter("@description", info.description),
new SqlParameter("@content", info.content),
new SqlParameter("@image", info.image),
new SqlParameter("@altImage", info.altImage),
new SqlParameter("@tag", info.tag),
new SqlParameter("@CreateDate", info.CreateDate),
new SqlParameter("@action", info.action),
new SqlParameter("@link", info.link),
new SqlParameter("@desseo", info.desseo)
};
return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_Introduction_Add", param).ToString()));
}
public int Update(IntroductionInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@id", info.id)
, new SqlParameter("@introductionTypeId",info.introductionTypeId),
new SqlParameter("@introductionTypeName", info.introductionTypeName),
new SqlParameter("@title", info.title),
new SqlParameter("@description", info.description),
new SqlParameter("@content", info.content),
new SqlParameter("@image", info.image),
new SqlParameter("@altImage", info.altImage),
new SqlParameter("@tag", info.tag),
new SqlParameter("@CreateDate", info.CreateDate),
new SqlParameter("@action", info.action),
new SqlParameter("@link", info.link),
new SqlParameter("@desseo", info.desseo)
};
return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_Introduction_Update", param));
}