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 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 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 Update(BasicContentInfo model) { return(basicContentDataAccess.Update(model)); }
public int Insert(BasicContentInfo model) { return(basicContentDataAccess.Insert(model)); }