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);
}
