protected void rptrNewsInHome_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { { Label lblIDNews = e.Item.FindControl("lblIDNews") as Label; HyperLink lnkTitle = e.Item.FindControl("lnkTitle") as HyperLink; HyperLink lnkImage = e.Item.FindControl("lnkImage") as HyperLink; Image imgMinhhoa = e.Item.FindControl("imgMinhhoa") as Image; Label lblDesc = e.Item.FindControl("lblDesc") as Label; HyperLink lnkChitiet = e.Item.FindControl("lnkChitiet") as HyperLink; if (lnkTitle != null && imgMinhhoa != null && lnkChitiet != null && lnkImage != null && lblDesc != null) { NewsEntity newsEntity = new NewsEntity(); newsEntity = NewsBRL.GetOne(Convert.ToInt32(lblIDNews.Text)); lnkTitle.NavigateUrl = "~/Content.aspx?sID=" + newsEntity.iNewsID; lnkChitiet.NavigateUrl = "~/Content.aspx?sID=" + newsEntity.iNewsID; lnkTitle.Text = INVI.INVILibrary.INVIString.GetCuttedString(newsEntity.sTitle, 70); if (File.Exists(Server.MapPath(ConfigurationManager.AppSettings["UploadPath"] + newsEntity.sImage))) imgMinhhoa.ImageUrl = ConfigurationManager.AppSettings["UploadPath"] + newsEntity.sImage; else { Panel pnAnh = e.Item.FindControl("pnAnh") as Panel; pnAnh.Visible = false; } lblDesc.Text = INVI.INVILibrary.INVIString.GetCuttedString(newsEntity.sDesc, 150); } } } }
public bool Delete(Guid Id) { bool toReturn = false; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { NewsEntity _NewsEntity = new NewsEntity(Id); if (adapter.FetchEntity(_NewsEntity)) { adapter.DeleteEntity(_NewsEntity); toReturn = true; } } return toReturn; }
public ActionResult DeleteNews(NewsEntity model) { bool isSuccessful = NewsBLL.Instance.Delete(model); if (isSuccessful == true) { return RedirectToAction("Index"); } else { GenerateAndPassNewsCategory(); return View(model); } }
/// <summary> /// 得到一个对象实体 /// </summary> public NewsEntity GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, ftypeid, ftitle, fcontent, CreateBy, CreateTime, UpdateBy, UpdateTime "); strSql.Append(" from tbNews "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; NewsEntity model = new NewsEntity(); DataTable dt = SqlHelper.GetDataTable(SqlHelper.connStr, CommandType.Text, strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[0]["id"].ToString()); } if (dt.Rows[0]["ftypeid"].ToString() != "") { model.ftypeid = int.Parse(dt.Rows[0]["ftypeid"].ToString()); } model.ftitle = dt.Rows[0]["ftitle"].ToString(); model.fcontent = dt.Rows[0]["fcontent"].ToString(); model.CreateBy = dt.Rows[0]["CreateBy"].ToString(); if (dt.Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(dt.Rows[0]["CreateTime"].ToString()); } model.UpdateBy = dt.Rows[0]["UpdateBy"].ToString(); if (dt.Rows[0]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(dt.Rows[0]["UpdateTime"].ToString()); } return(model); } else { return(null); } }
public JsonResult GetNews(int count, string newsid) { NewsEntity news = new NewsEntity(); string jsonstr = string.Empty; if (count > 0) { List <NewsEntity> lstNews = NewsService.GetCountNews(count, true); jsonstr = JsonHelper.ToJson <List <NewsEntity> >(lstNews); } if (!string.IsNullOrEmpty(newsid)) { NewsEntity newe = NewsService.GetNewsByID(newsid.ToInt(0)); jsonstr = JsonHelper.ToJson(newe); } return(Json(jsonstr)); }
public void TestToNewsBll() { var newsEntity = new NewsEntity { PartitionKey = "Malaga;2015-05-04", RowKey = string.Format("NEWS;{0}", Guid.NewGuid()), Title = "title", Content = "content", Author = "author" }; NewsBll newsBll = NewsEntity.ToNewsBll(newsEntity); Assert.AreEqual(newsEntity.Title, newsBll.Title); Assert.AreEqual(newsEntity.Content, newsBll.Content); Assert.AreEqual(newsEntity.Author, newsBll.Author); }
public NewsDTO ToDTO(NewsEntity entity) { NewsDTO dto = new NewsDTO(); dto.AdminId = entity.AdminId; dto.Click = entity.Click; dto.Contents = entity.Contents; dto.CreateTime = entity.CreateTime; dto.Id = entity.Id; dto.ImgURL = entity.ImgURL; dto.NewsTypeId = entity.NewsTypeId; dto.Publisher = entity.Admin.Name; dto.Rate = entity.Rate; dto.Title = entity.Title; dto.Preview = entity.Preview; return(dto); }
public long AddNew(long adminId, string title, string imgUrl, string contents) { using (MyDbContext dbc = new MyDbContext()) { NewsEntity entity = new NewsEntity(); entity.AdminId = adminId; entity.Title = title; entity.Contents = contents; entity.Preview = CommonHelper.NoHTML(contents); entity.ImgURL = imgUrl; entity.Rate = 0; entity.Click = 0; dbc.News.Add(entity); dbc.SaveChanges(); return(entity.Id); } }
public static NewsInfo TranslateNewsInfo(NewsEntity entity) { NewsInfo info = new NewsInfo(); if (entity != null) { info.ID = entity.ID; info.ChannelID = entity.ChannelID; info.Title = entity.Title; info.zhaiyao = entity.zhaiyao; info.Content = entity.Content; info.AttachmentIDs = entity.AttachmentIDs; info.Sort = entity.Sort; info.Status = entity.Status; info.Operator = entity.Operator; } return(info); }
/// <summary> /// 获取下一期 /// </summary> /// <param name="pk"></param> /// <returns></returns> private NewsEntity GetNextNewsByPk(int pk) { NewsEntity entity = null; int tempPrePk = pk; lock (_lock) { do { tempPrePk = (tempPrePk + 1) <= 0 ? 45524 : (tempPrePk + 1); DataTable table = commonBll.ExcuteSqlDataTable(string.Format(GetNewsAbstractSql, tempPrePk.ToString()), DatabaseLinksEnum.Base); entity = table.DataTableToObject <NewsEntity>(); } while (entity == null); //return newsBll.GetEntity(n => n.PK == tempPrePk); } return(entity); }
public void WriteNewsData(List <AppDataManager.DataDesc> data) { LocalDb _NewsDB = new LocalDb("News"); System.Data.IDataReader reader = _NewsDB.getLatestNewsOrderID(); int tempOrder = 0; while (reader.Read()) { tempOrder = int.Parse(reader[0].ToString()); } tempOrder += 1; foreach (NewsDataManager.NewsDataDesc d in data) { NewsEntity news = new NewsEntity("", d.title, "", "", "", "", tempOrder.ToString()); _NewsDB.appendTableFromBottom("News", news); } _NewsDB.close(); }
public List <NewsEntity> GetNews(string keyWords, int bigTypeID, int typeid, int publishStatus, int pageSize, int pageIndex, ref int totalCount, ref int pageCount) { List <NewsEntity> list = new List <NewsEntity>(); DataTable dt = NewsDAL.BaseDAL.GetNews(keyWords, bigTypeID, typeid, publishStatus, pageSize, pageIndex, ref totalCount, ref pageCount); foreach (DataRow dr in dt.Rows) { NewsEntity model = new NewsEntity(); model.FillData(dr); if (model.News_Type > 0) { model.NewsType = GetNewsTypeByCode(model.News_Type); } list.Add(model); } return(list); }
/// <summary> /// Converts a NewsEntity object to a NewsBE object /// </summary> /// <param name="news">NewsEntity to convert</param> /// <returns></returns> protected NewsBE GetEntity(NewsEntity news) { if (null == news) { return(null); } var result = new NewsBE { Author = news.author, Date = news.date, Source = news.source, SourceUrl = news.source_url, Story = news.story, Title = news.title, TitlePath = news.url_title }; return(result); }
public void TestFromNewsBll() { var newsBll = new NewsBll { Id = Guid.NewGuid(), Date = DateTime.Parse("2015-05-04"), City = "Malaga", Title = "title", Content = "content", Author = "author" }; NewsEntity convertedNews = NewsEntity.FromNewsBll(newsBll); Assert.AreEqual("Malaga;2015-05-04", convertedNews.PartitionKey); Assert.AreEqual(string.Format("NEWS;{0}", newsBll.Id.ToString()), convertedNews.RowKey); Assert.AreEqual(newsBll.Title, convertedNews.Title); Assert.AreEqual(newsBll.Content, convertedNews.Content); Assert.AreEqual(newsBll.Author, convertedNews.Author); }
/// <summary> /// 根据ID得到一个公告实体 /// </summary> /// <param name="id">公告ID</param> /// <returns>公告实体</returns> public static IMethodResult AdminGetNews(Int32 id) { if (!AdminManager.HasPermission(PermissionType.NewsManage)) { throw new NoPermissionException(); } if (id <= 0) { return(MethodResult.InvalidRequest(RequestType.News)); } NewsEntity entity = NewsRepository.Instance.GetEntity(id); if (entity == null) { return(MethodResult.NotExist(RequestType.News)); } return(MethodResult.Success(entity)); }
public async Task <TData <string> > SaveViewTimes([FromBody] IdParam param) { TData <string> obj = null; TData <NewsEntity> objNews = await newsBLL.GetEntity(param.Id.Value); NewsEntity newsEntity = new NewsEntity(); if (objNews.Result != null) { newsEntity.Id = param.Id.Value; newsEntity.ViewTimes = objNews.Result.ViewTimes; newsEntity.ViewTimes++; obj = await newsBLL.SaveForm(newsEntity); } else { obj = new TData <string>(); obj.Message = "文章不存在"; } return(obj); }
public ActionResult CreateNews(NewsEntity model) { NewsEntity modelToSave = model; if (model.NewsDate == DateTimeHelper.Min) { modelToSave.NewsDate = DateTime.Now; } modelToSave.NewsGuid = Guid.NewGuid(); bool isSuccessful = NewsBLL.Instance.Create(modelToSave); if (isSuccessful == true) { return RedirectToAction("Index"); } else { GenerateAndPassNewsCategory(); return View(); } }
public List <AppDataManager.DataDesc> GetNewsUpdate(string length) { LocalDb _NewsDB = new LocalDb("News"); List <AppDataManager.DataDesc> FetchedData = new List <AppDataManager.DataDesc>(); System.Data.IDataReader reader = _NewsDB.getNewsDataUpdate(int.Parse(length)); while (reader.Read()) { NewsEntity entity = new NewsEntity(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString()); FetchedData.Add(new NewsDataManager.NewsDataDesc(int.Parse(entity._showOrder), entity._title, entity._icon, entity._content)); } _NewsDB.close(); return(FetchedData); }
public static bool UpdateNewsById(this IStore store, IEnumerable <NewsEntity> news) { Debug.Assert(news != null); var newsTable = TableStore.Instance.GetTable(TableStore.NewsTableName); var allNews = newsTable.GetAllItems <NewsEntity>(); List <NewsEntity> validatedNewsItems = new List <NewsEntity>(); foreach (NewsEntity ne in news) { try { NewsEntity tempNews = allNews.Values.FirstOrDefault(n => n.Title.ToLower() == ne.Title.ToLower()); if (tempNews == null) { // Insert validatedNewsItems.Add(ne); } else { // Update - Currently we will skip it } } catch (Exception) { // TODO - Add exception } } if (validatedNewsItems.Count > 0) { var retList = store.UpdateNewsItemById(validatedNewsItems); Debug.Assert(retList.Count == 1); var key = retList.Keys.FirstOrDefault(); return((key != null) ? retList[key] : false); } return(true); }
/// <summary> /// 根据ID得到一个公告实体 /// </summary> /// <param name="id">公告ID</param> /// <returns>公告实体</returns> public static NewsEntity GetNews(Int32 id) { if (id <= 0) { throw new InvalidRequstException(RequestType.News); } NewsEntity entity = NewsCache.GetNewsCache(id);//读取缓存 if (entity == null) { entity = NewsRepository.Instance.GetEntity(id); NewsCache.SetNewsCache(entity);//设置缓存 } if (entity == null) { throw new NullResponseException(RequestType.News); } return(entity); }
public static bool ModifiyNews(NewsEntity entity) { int result = 0; if (entity != null) { NewsRepository mr = new NewsRepository(); NewsInfo newInfo = TranslateNewsInfo(entity); if (entity.ID > 0) { result = mr.UpdateNew(newInfo); } else { result = mr.InsertNew(newInfo); } //List<StoreInfo> miList = mr.InsertNew();//刷新缓存 //Cache.Add("StoreALL", miList); } return(result > 0); }
public JsonResult SaveNews(string news) { JavaScriptSerializer serializer = new JavaScriptSerializer(); NewsEntity model = serializer.Deserialize <NewsEntity>(news); bool flag = false; if (model.News_Uni_Code == 0) { flag = NewsBusiness.BaseBusiness.AddNews(model); } else { flag = NewsBusiness.BaseBusiness.EditNews(model); } jsonResult.Add("result", flag?1:0); return(new JsonResult() { Data = jsonResult, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public IEnumerable <NewsEntity> GetAllNews() { var newsList = newsRepository.Get(); List <NewsEntity> newsEntities = null; if (newsList != null) { newsEntities = new List <NewsEntity>(); foreach (var item in newsList) { NewsEntity entity = new NewsEntity(); entity.NewsId = item.NewsId; entity.Title = item.Title; entity.Abstract = item.Abstract; entity.News = item.News1; entity.AirDate = item.AirDate; entity.ImagePath = item.ImagePath; newsEntities.Add(entity); } } return(newsEntities); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(NewsEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbNews set "); strSql.Append(" ftypeid = @ftypeid , "); strSql.Append(" ftitle = @ftitle , "); strSql.Append(" fcontent = @fcontent , "); strSql.Append(" CreateBy = @CreateBy , "); strSql.Append(" CreateTime = @CreateTime , "); strSql.Append(" UpdateBy = @UpdateBy , "); strSql.Append(" UpdateTime = @UpdateTime "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@ftypeid", SqlDbType.Int, 4), new SqlParameter("@ftitle", SqlDbType.NVarChar, 50), new SqlParameter("@fcontent", SqlDbType.Text), new SqlParameter("@CreateBy", SqlDbType.NVarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@UpdateBy", SqlDbType.NVarChar, 50), new SqlParameter("@UpdateTime", SqlDbType.DateTime) }; parameters[0].Value = model.id; parameters[1].Value = model.ftypeid; parameters[2].Value = model.ftitle; parameters[3].Value = model.fcontent; parameters[4].Value = model.CreateBy; parameters[5].Value = model.CreateTime; parameters[6].Value = model.UpdateBy; parameters[7].Value = model.UpdateTime; object obj = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), parameters); return(Convert.ToInt32(obj)); }
public virtual ActionResult Remove(string[] id) { var result = new Dictionary <string, object>(); var rev = false; if (id != null) { var infos = new List <NewsEntity>(); foreach (var i in id) { var info = new NewsEntity { Id = i.Convert <long>(), SaveType = SaveType.Remove }; infos.Add(info); } rev = this.SaveEntities(infos); } result.Add("Status", rev); return(this.Jsonp(result)); }
public ActionResult GetNewsPageList(int?page, int?pagesize, int type) { Pagination pagination = new Pagination(); pagination.rows = pagesize ?? 10; pagination.page = page ?? 1; NewsEntity para = new NewsEntity(); para.Type = type; para.LanguageKey = CurrentLanguge.LanguageKey; pagination.sidx = "CreateTime"; pagination.sord = "desc"; var pageList = NewsBLL.Instance.GetPageList(para, ref pagination); var JsonData = new { rows = pageList, total = pagination.total, page = pagination.page, records = pagination.records, }; return(Content(JsonData.ToJson())); }
public List <AppDataManager.DataDesc> GetNewsSituation(string situationID) { LocalDb _NewsDB = new LocalDb("News"); string[] idx = _NewsDB.getSituationIndex(situationID); System.Data.IDataReader reader = _NewsDB.getNewsDataSituation(int.Parse(idx[1])); List <AppDataManager.DataDesc> FetchedData = new List <AppDataManager.DataDesc>(); while (reader.Read()) { NewsEntity entity = new NewsEntity(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), reader[6].ToString()); FetchedData.Add(new NewsDataManager.NewsDataDesc(int.Parse(entity._showOrder), entity._title, entity._icon, entity._content)); } _NewsDB.close(); return(FetchedData); }
public ActionResult CreateNews(NewsEntity model) { NewsEntity modelToSave = model; if (model.NewsDate == DateTimeHelper.Min) { modelToSave.NewsDate = DateTime.Now; } modelToSave.NewsGuid = Guid.NewGuid(); bool isSuccessful = NewsBLL.Instance.Create(modelToSave); if (isSuccessful == true) { return(RedirectToAction("Index")); } else { GenerateAndPassNewsCategory(); return(View()); } }
public IEnumerable <NewsEntity> GetLatestNews() { var newsList = newsRepository.Get(); List <NewsEntity> newsEntities = null; if (newsList != null) { newsEntities = new List <NewsEntity>(); foreach (var item in newsList) { NewsEntity entity = new NewsEntity(); entity.NewsId = item.NewsId; entity.Title = item.Title; entity.Abstract = item.Abstract; entity.News = item.News1; entity.AirDate = item.AirDate; entity.ImagePath = item.ImagePath; newsEntities.Add(entity); } return(newsEntities.OrderByDescending(n => n.AirDate).Take(6)); } return(null); }
/// <summary> /// 获得数据列表 /// </summary> public List <NewsEntity> DataTableToList(DataTable dt) { List <NewsEntity> modelList = new List <NewsEntity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { NewsEntity model; for (int n = 0; n < rowsCount; n++) { model = new NewsEntity(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["ftypeid"].ToString() != "") { model.ftypeid = int.Parse(dt.Rows[n]["ftypeid"].ToString()); } model.ftitle = dt.Rows[n]["ftitle"].ToString(); model.fcontent = dt.Rows[n]["fcontent"].ToString(); model.CreateBy = dt.Rows[n]["CreateBy"].ToString(); if (dt.Rows[n]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(dt.Rows[n]["CreateTime"].ToString()); } model.UpdateBy = dt.Rows[n]["UpdateBy"].ToString(); if (dt.Rows[n]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(dt.Rows[n]["UpdateTime"].ToString()); } modelList.Add(model); } } return(modelList); }
public static Int32 Add(int iUserID,string sTitle, string sDesc, string sImage, string sTag, DateTime tNgaydang, string sContent, bool bVerified, params int[] arrCategory) { NewsEntity entity = new NewsEntity(); entity.sTitle = sTitle; entity.sDesc = sDesc; entity.sImage = sImage; entity.sTag = sTag; entity.tDate = tNgaydang; entity.sContent = sContent; entity.bVerified = bVerified; entity.iViews = 0; entity.iUserID = iUserID; checkLogic(entity); checkDuplicate(entity, true); int iNewsID = NewsDAL.Add(entity); foreach (int iCatID in arrCategory) { NewsCategoryEntity oNewsCat = new NewsCategoryEntity(); oNewsCat.iNewsID = iNewsID; oNewsCat.iCategoryID = iCatID; NewsCategoryDAL.Add(oNewsCat); } return iNewsID; }
public void Modify() { int id = (Request["ID"] ?? "").ToInt(0); string Title = Request["Title"] ?? ""; int status = (Request["Status"] ?? "").ToInt(0); int ChannelID = (Request["ChannelID"] ?? "").ToInt(0); string content = Request["Content"] ?? ""; content = Request["Content"] ?? ""; string zhaiyao = Request["zhaiyao"] ?? ""; string AttachmentIDs = Request["AttachmentIDs"] ?? ""; NewsEntity entity = new NewsEntity(); entity.ID = id; entity.Title = Title; entity.ChannelID = ChannelID; entity.zhaiyao = zhaiyao; entity.AttachmentIDs = AttachmentIDs; entity.Operator = CurrentUser == null ? 0 : CurrentUser.UserID; entity.Content = content; entity.Status = status; NewsService.ModifiyNews(entity); Response.Redirect("/News/"); }
/// <summary> /// Kiểm tra trùng lặp bản ghi /// </summary> /// <param name="entity">NewsEntity: NewsEntity</param> private static void checkDuplicate(NewsEntity entity, bool CheckInsert) { List<NewsEntity> list = NewsDAL.GetAll(); if (list.Exists( delegate(NewsEntity oldEntity) { bool result= oldEntity.sContent.Equals(entity.sContent, StringComparison.OrdinalIgnoreCase); if(!CheckInsert) result=result && oldEntity.iNewsID!= entity.iNewsID; return result; } )) { list.Clear(); throw new Exception(EX_NEWS_EXISTED); } }
protected void lbtnDelete_Click(object sender, EventArgs e) { try { if (!PermissionBRL.CheckPermission("Xoatintuc")) Response.End(); foreach (GridViewRow row in grvNews.Rows) { CheckBox chkDelete = row.FindControl("chkDelete") as CheckBox; if (chkDelete != null && chkDelete.Checked) { int newsID = Convert.ToInt32(grvNews.DataKeys[row.RowIndex].Values["iNewsID"]); NewsEntity oNews = new NewsEntity(); oNews.iNewsID = newsID; NewsBRL.Remove(oNews); Response.Write("<script language=\"javascript\">alert('Xóa thành công.');location='Default.aspx?page=NewsManager';</script>"); napGridView(); } } } catch (Exception ex) { Response.Write("<script language=\"javascript\">alert('" + ex.Message + "');location='Default.aspx?page=NewsManager';</script>"); } }
/// <summary> /// /// </summary> /// <param name="entity"></param> private static void checkExist(NewsEntity entity) { NewsEntity oNews = NewsDAL.GetOne(entity.iNewsID); if (oNews == null) throw new Exception(EX_NOT_EXIST); }
/// <summary> /// Kiểm tra tồn tại khóa ngoại /// </summary> /// <param name="entity">NewsEntity:entity</param> private static void checkFK(NewsEntity entity) { UserEntity oUser = UserDAL.GetOne(entity.iUserID); if (oUser != null) { throw new Exception(EX_USERID_NOTFOUND); } }
/// <summary> /// Kiểm tra logic Entity /// </summary> /// <param name="entity">NewsEntity: Tin tức Entity</param> private static void checkLogic(NewsEntity entity) { if (String.IsNullOrEmpty(entity.sTitle)) throw new Exception(EX_TITLE_EMPTY); if (String.IsNullOrEmpty(entity.sContent)) throw new Exception(EX_CONTENT_EMPTY); if (entity.iUserID < 0) throw new Exception(EX_USERID_INVALID); if (entity.iViews < 0) throw new Exception(EX_VIEW_INVALID); if (entity.tDate > DateTime.Now) throw new Exception(EX_DATE_INVALID); }
/// <summary> /// Kiểm tra và thêm mới News /// </summary> /// <param name="entity">Entity</param> /// <returns>Int32: ID của Khách Hàng Mới Thêm Vào</returns> public static Int32 Add(NewsEntity entity) { checkLogic(entity); checkDuplicate(entity, true); return NewsDAL.Add(entity); }
public bool Update(NewsEntity _NewsEntity) { bool toReturn = false; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { RelationPredicateBucket filter = new RelationPredicateBucket(); IPredicateExpression _PredicateExpression = new PredicateExpression(); _PredicateExpression.Add(NewsFields.Id == _NewsEntity.Id); filter.PredicateExpression.Add(_PredicateExpression); adapter.UpdateEntitiesDirectly(_NewsEntity, filter); toReturn = true; } return toReturn; }
public void SetUpCell(NewsEntity news) { titleLabel.Text = news.Title; topicLabel.Text = news.Topic; weekLabel.Text = "Week " + news.Week.ToIso8601Weeknumber() + " | " + news.Week.Year; }
public NewsEntity Insert(NewsEntity _NewsEntity) { using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { adapter.SaveEntity(_NewsEntity, true); } return _NewsEntity; }
public NewsEntity Insert(string Subject, string TextId, string Body, DateTime CreatedDate, string CreatedBy, bool IsVisible) { NewsEntity _NewsEntity = new NewsEntity(); using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { _NewsEntity.Subject = Subject; _NewsEntity.TextId = TextId; _NewsEntity.Body = Body; _NewsEntity.CreatedDate = CreatedDate; _NewsEntity.CreatedBy = CreatedBy; _NewsEntity.IsVisible = IsVisible; adapter.SaveEntity(_NewsEntity, true); } return _NewsEntity; }
public bool Update(Guid Id, string Subject, string TextId, string Body, DateTime CreatedDate, string CreatedBy, bool IsVisible) { bool toReturn = false; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { NewsEntity _NewsEntity = new NewsEntity(Id); if (adapter.FetchEntity(_NewsEntity)) { _NewsEntity.Subject = Subject; _NewsEntity.TextId = TextId; _NewsEntity.Body = Body; _NewsEntity.CreatedDate = CreatedDate; _NewsEntity.CreatedBy = CreatedBy; _NewsEntity.IsVisible = IsVisible; adapter.SaveEntity(_NewsEntity, true); toReturn = true; } } return toReturn; }
public bool Update(NewsEntity _NewsEntity, RelationPredicateBucket filter) { bool toReturn = false; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { adapter.UpdateEntitiesDirectly(_NewsEntity, filter); toReturn = true; } return toReturn; }
/// <summary> /// Kiểm tra và xoá News /// </summary> /// <param name="entity">NewsEntity</param> /// <returns>bool:kết quả thực hiện</returns> public static bool Remove(NewsEntity entity) { if(entity.iNewsID<=0) throw new Exception(EX_ID_INVALID); List<RateEntity> lstRate = RateDAL.GetByiNewsID(entity.iNewsID); if (lstRate != null && lstRate.Count > 0) { foreach (RateEntity rateEntity in lstRate) RateDAL.Remove(rateEntity.iRateID); } // List<PollEntity> lstPoll = PollDAL.GetByiNewsID(entity.iNewsID); if (lstPoll != null && lstPoll.Count > 0) { foreach (PollEntity poll in lstPoll) PollDAL.Remove(poll.iPollID); } // List<FeedbackEntity> lstFeedback = FeedbackDAL.GetByiNewsID(entity.iNewsID); if (lstFeedback != null && lstFeedback.Count > 0) { foreach (FeedbackEntity feedBack in lstFeedback) FeedbackDAL.Remove(feedBack.iFeedbackID); } // List<NewsCategoryEntity> lstNC = NewsCategoryDAL.GetByiNewsID(entity.iNewsID); if (lstNC != null && lstNC.Count > 0) { foreach (NewsCategoryEntity newCat in lstNC) NewsCategoryDAL.Remove(newCat.iNewsCategoryID); } // return NewsDAL.Remove(entity.iNewsID); }
private List<NewsEntity> LoadListnews(Worksheet worksheet, SharedStringTable sharedString) { //Initialize the customer list. List<NewsEntity> result = new List<NewsEntity>(); //LINQ query to skip first row with column names. IEnumerable<Row> dataRows = (from row in worksheet.Descendants<Row>() where row.RowIndex > 1 select row); foreach (Row row in dataRows) { //LINQ query to return the row's cell values. //Where clause filters out any cells that do not contain a value. //Select returns the value of a cell unless the cell contains // a Shared String. //If the cell contains a Shared String, its value will be a // reference id which will be used to look up the value in the // Shared String table. IEnumerable<String> textValues = from cell in row.Descendants<Cell>() select (cell.DataType != null && cell.DataType.HasValue && cell.DataType == CellValues.SharedString ? sharedString.ChildElements[Utils.CIntDef(cell.CellValue.InnerText)].InnerText : cell.CellValue.InnerText); //Check to verify the row contained data. if (textValues.Count() > 0) { //Create a customer and add it to the list. var textArray = textValues.ToArray(); string _title = Utils.CStrDef(textArray[0]); string _masp = Utils.CStrDef(textArray[1]).Trim(); string _congnghe = Utils.CStrDef(textArray[2]); string _weight = Utils.CStrDef(textArray[3]); int _idhsx = getIdCate(Utils.CStrDef(textArray[4])); int _idxuatxu = getIdCate(Utils.CStrDef(textArray[5])); string _bhhanh = Utils.CStrDef(textArray[6]); int _status = getIdStatus(Utils.CStrDef(textArray[7])); int _vat = getIdVat(Utils.CStrDef(textArray[8])); int _period = getIDperiod(Utils.CStrDef(textArray[10])); decimal _price = Utils.CDecDef(Utils.CStrDef(textArray[12])); decimal _pricePromos = Utils.CDecDef(Utils.CStrDef(textArray[13])); decimal _pricegiovang = Utils.CDecDef(Utils.CStrDef(textArray[14])); decimal _priceMuavao = Utils.CDecDef(Utils.CStrDef(textArray[15])); int _idcat = getIdCate(Utils.CStrDef(textArray[16])); NewsEntity newsenti = new NewsEntity(); newsenti._news_tile = _title; newsenti._news_code = _masp; newsenti._news_congnghe = _congnghe; newsenti._news_weight = _weight; newsenti._news_hangsx = _idhsx; newsenti._news_xuatxu = _idxuatxu; newsenti._news_baohanh = _bhhanh; newsenti._news_status = _status; newsenti._news_vat = _vat; newsenti._news_period = _period; newsenti._news_price = _price; newsenti._news_priceMos = _pricePromos; newsenti._news_priceGiovang = _pricegiovang; newsenti._news_priceMuavao = _priceMuavao; newsenti._catid = _idcat; result.Add(newsenti); } else { //If no cells, then you have reached the end of the table. break; } } //Return populated list of customers. return result; }
public static NewsEntity CreateNewsEntity(int ID, string content, string title) { NewsEntity newsEntity = new NewsEntity(); newsEntity.Id = ID; newsEntity.Content = content; newsEntity.Title = title; return newsEntity; }
public NewsEntity SelectOne(Guid Id) { NewsEntity toReturn = null; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { NewsEntity _NewsEntity = new NewsEntity(Id); if (adapter.FetchEntity(_NewsEntity)) { toReturn = _NewsEntity; } } return toReturn; }
public void Delete(NewsEntity entity) { service.Delete(entity); }
/// <summary> /// Kiểm tra và chỉnh sửa News /// </summary> /// <param name="entity">NewsEntity</param> /// <returns>bool:kết quả thực hiện</returns> public static bool Edit(NewsEntity entity) { checkExist(entity); checkLogic(entity); checkDuplicate(entity, false); return NewsDAL.Edit(entity); }
protected void btnOK_Click(object sender, EventArgs e) { if (!PermissionBRL.CheckPermission("Capnhaptintuc")) Response.End(); try { NewsEntity entity = new NewsEntity(); entity.sTitle = txtTitle.Text; entity.sDesc = txtDesc.Text; entity.sTag = txtTag.Text; entity.sContent = ftbNoidung.Text; entity.bVerified = chkVerify.Checked; entity.iUserID = Convert.ToInt32(Session["UserID"]); // Ngày đăng DateTime date, datetime; bool result = DateTime.TryParseExact(txtDate_datepicker.Value, "dd/MM/yyyy", null, DateTimeStyles.None, out date); if (!result) throw new Exception("Ngày tháng không hợp lê"); datetime = new DateTime(date.Year, date.Month, date.Day, DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); string sDatetime = datetime.ToString(); //entity.tDate = date; entity.tDate = datetime; // Ảnh minh họa if (fuImage.HasFile) { INVIHelper.UploadImage(fuImage); entity.sImage = fuImage.FileName; } else if (txtUrl.Text.Length > 0) { String[] s; s = txtUrl.Text.Split('/'); String sFilename = s[s.Length - 1]; System.Net.WebClient objWebClient = new System.Net.WebClient(); objWebClient.DownloadFile(txtUrl.Text, HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["UploadPath"] + sFilename)); fuImage.SaveAs(HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["UploadPath"] + sFilename)); entity.sImage = sFilename; } else entity.sImage = imgNews.ImageUrl.Replace(ConfigurationManager.AppSettings["UploadPath"], ""); //Nhóm tin List<Int32> lstCategory = new List<int>(); for (int i = 0; i < lstbNhomtin.Items.Count; i++) { if (lstbNhomtin.Items[i].Selected) { try { int categoryID = Convert.ToInt32(lstbNhomtin.Items[i].Value); lstCategory.Add(categoryID); } catch { } } } int[] arrCategory = lstCategory.ToArray(); // if (btnOK.CommandName == "Edit") { entity.iNewsID = Convert.ToInt32(btnOK.CommandArgument); NewsBRL.Edit(entity.iNewsID, entity.sTitle, entity.sDesc, entity.sImage, entity.sTag, entity.tDate, entity.sContent, entity.bVerified, arrCategory); } else NewsBRL.Add(entity.iUserID, entity.sTitle, entity.sDesc, entity.sImage, entity.sTag, entity.tDate, entity.sContent, entity.bVerified, arrCategory); lblThongbao.Text = "Cập nhật thành công"; Response.Write("<script language=\"javascript\">alert('Cập nhập thành công');location='Default.aspx?page=NewsUpdate';</script>"); //Nạp lại dữ liệu Response.Redirect(Request.Url.ToString()); } catch (Exception ex) { Response.Write("<script language=\"javascript\">alert('" + ex.Message + "');location='Default.aspx?page=NewsUpdate';</script>"); } }
NewsEntity getNews() { NewsEntity news = new NewsEntity(); news.Id = Guid.NewGuid(); news.Subject = Filter.GetMaxString(txtSubject.Text.Trim(), NewsFields.Subject.MaxLength); news.Body = txtBody.Value; news.CreatedBy = Util.CurrentUserName; news.IsMenu = chkIsMenu.Checked; news.Description = txtDescription.Text.Trim(); return news; }
public void SetUpCell(NewsEntity news) { headLeftView.BackgroundColor = news.Domain.ToDescription().ToUiColor(); authorNews.Text = news.Author; titleNews.Text = news.Title; }
public void AddToNewsEntities(NewsEntity newsEntity) { base.AddObject("NewsEntities", newsEntity); }