public List<BasicContentInfo> GetBasicContents()
{
var data = new List<BasicContentInfo>();
using (DataCommand cmd = DataCommandManager.GetDataCommand("GetBasicContents"))
{
using (IDataReader dr = cmd.ExecuteDataReader())
{
while (dr.Read())
{
var model = new BasicContentInfo();
if (!Convert.IsDBNull(dr["Id"]))
{
model.Id = Convert.ToInt32(dr["Id"]);
}
if (!Convert.IsDBNull(dr["Title"]))
{
model.Title = dr["Title"].ToString();
}
if (!Convert.IsDBNull(dr["Category"]))
{
model.Category = dr["Category"].ToString();
}
if (!Convert.IsDBNull(dr["LinkPath"]))
{
model.LinkPath = dr["LinkPath"].ToString();
}
if (!Convert.IsDBNull(dr["Content"]))
{
model.Content = dr["Content"].ToString();
}
if(!Convert.IsDBNull(dr["InDate"]))
{
model.InDate = Convert.ToDateTime(dr["InDate"]);
}
if (!Convert.IsDBNull(dr["Summary"]))
{
model.Content = dr["Summary"].ToString();
}
data.Add(model);
}
}
}
return data;
}
public BasicContentInfo GetBasicContentById(int id)
{
var model = new BasicContentInfo();
using (DataCommand cmd = DataCommandManager.GetDataCommand("GetBasicContentById"))
{
cmd.SetParameterValue("@Id", id);
using (IDataReader dr = cmd.ExecuteDataReader())
{
while(dr.Read())
{
if (!Convert.IsDBNull(dr["Id"]))
{
model.Id = Convert.ToInt32(dr["Id"]);
}
if (!Convert.IsDBNull(dr["Title"]))
{
model.Title = dr["Title"].ToString();
}
if (!Convert.IsDBNull(dr["Category"]))
{
model.Category = dr["Category"].ToString();
}
if (!Convert.IsDBNull(dr["LinkPath"]))
{
model.LinkPath = dr["LinkPath"].ToString();
}
if (!Convert.IsDBNull(dr["Content"]))
{
model.Content = dr["Content"].ToString();
}
if (!Convert.IsDBNull(dr["Summary"]))
{
model.Summary = dr["Summary"].ToString();
}
}
}
}
return model;
}
public int UpdateBasicContent()
{
var model = new BasicContentInfo();
model.Id = Convert.ToInt32(HttpContext.Current.Request.Params["BasicContentId"]);
model.Title = HttpContext.Current.Request.Params["Title"];
model.Category = HttpContext.Current.Request.Params["Category"];
model.LinkPath = HttpContext.Current.Request.Params["LinkPath"];
model.Content = HttpContext.Current.Request.Params["Content"];
model.Summary = HttpContext.Current.Request.Params["Summary"];
IBasicContentService basicContentService=new BasicContentService();
return basicContentService.Update(model);
}
public int Update(BasicContentInfo model)
{
using (DataCommand cmd = DataCommandManager.GetDataCommand("UpdateBasicContent"))
{
cmd.SetParameterValue("@Id", model.Id);
cmd.SetParameterValue("@Title", model.Title);
cmd.SetParameterValue("@Category", model.Category);
cmd.SetParameterValue("@LinkPath", model.LinkPath);
cmd.SetParameterValue("@Content", model.Content);
cmd.SetParameterValue("@Summary", model.Summary);
return cmd.ExecuteNonQuery();
}
}
public int Update(BasicContentInfo model)
{
return basicContentDataAccess.Update(model);
}
public int Insert(BasicContentInfo model)
{
return basicContentDataAccess.Insert(model);
}
