/// <summary>
/// Insert sang bảng news wap
/// </summary>
/// <param name="NewsID"></param>
private void SaveWapContent(string NewsID, int NewsStatus)
{
if (chkCopyToWap.Checked)
{
NewsEditHelper.SaveWapContent(Convert.ToInt64(NewsID), NewsContent.Text, NewsStatus);
}
}
public void ProcessRequest(HttpContext context)
{
try {
long NewsID = 0;
Int64.TryParse(context.Request.Form["news_id"].ToString(), out NewsID);
int CatID = 0;
Int32.TryParse(context.Request.Form["cat_id"].ToString(), out CatID);
//NewsEditHelper.AutoSave_Insert(NewsID, CatID, context.Request.Form["news_title"].ToString(), context.Request.Form["image"].ToString(), context.Request.Form["sapo"].ToString(), context.Request.Form["news_content"].ToString(), DateTime.Now);
NewsRow objNewsRow = NewsEditHelper.GetNewsInfo_News(NewsID, false);
if (objNewsRow == null)
{
NewsEditHelper.CreateNews(NewsID, CatID, string.Empty, context.Request.Form["news_title"].ToString(), context.Request.Form["image"].ToString(), context.Request.Form["news_title"].ToString(), context.Request.Form["sapo"].ToString(), context.Request.Form["news_content"].ToString(), string.Empty, false, 0 /*lưu tạm*/, 0, string.Empty, string.Empty, string.Empty, DateTime.Now, false, false, 0, string.Empty, string.Empty, string.Empty, false, string.Empty, string.Empty, string.Empty, 0, string.Empty, string.Empty);
}
else
if (objNewsRow.News_Status == 0)
{
NewsEditHelper.UpdateNews(NewsID, CatID, string.Empty, context.Request.Form["news_title"].ToString(), context.Request.Form["image"].ToString(), string.Empty, context.Request.Form["sapo"].ToString(), context.Request.Form["news_content"].ToString(), false, 0, 0, string.Empty, string.Empty, DateTime.Now, false, false, false, 0, string.Empty, string.Empty, string.Empty, string.Empty, false, string.Empty, string.Empty, string.Empty, 0, string.Empty, string.Empty);
}
context.Response.Write("Lưu tự động lúc : " + DateTime.Now);
}
catch (Exception ex) {
context.Response.Write(ex.Message);
}
}
private void BindData()
{
DataTable _list = NewsEditHelper.GetListCrawlerNews();
grdList.DataSource = _list;
grdList.DataBind();
}
private void BindData()
{
int _id = 0;
if (Int32.TryParse(Request.QueryString["ID"], out _id))
{
DataTable _obj = NewsEditHelper.GetCrawlerNews(_id);
if (_obj != null && _obj.Rows.Count > 0)
{
DataRow row = _obj.Rows[0];
ltrTitle.Text = row["News_Title"].ToString();
ltrSapo.Text = row["News_InitContent"].ToString();
long NewsID = Convert.ToInt64(NewsHelper.GenNewsID());
//NewsEditHelper.CreateNews(NewsID, 0, string.Empty, row["News_Title"].ToString(), string.Empty, "Theo " + row["SourceName"], row["News_InitContent"].ToString(), row["News_Content"].ToString(), string.Empty, false, 0, 0, string.Empty, string.Empty, string.Empty, DateTime.Now, false, false, 0, string.Empty, string.Empty, string.Empty, false, string.Empty, string.Empty, row["News_Source"].ToString(), 0, string.Empty, string.Empty);
//NewsEditHelper.UpdateCrawlerStatus(_id);
//Response.Redirect("/office/add,templist/" + NewsID + ".aspx");
}
}
}
/// <summary>
/// Kiểm tra xem bài viết này có đồng thời 2 người can thiệp không [bacth, 12:29 PM 5/31/2008]
/// </summary>
/// <param name="message">Thông báo trong trường hợp có sự động độ</param>
/// <returns></returns>
private bool isConcurrency(ref string message)
{
if (string.IsNullOrEmpty(Request.QueryString["NewsRef"]))
{
return(false); // bài viết mới - không đụng độ
}
string cpMode = Request.QueryString["cpmode"].Replace("add,", string.Empty);
long newsId = 0;
long.TryParse(Request.QueryString["NewsRef"], out newsId);
NewsRow news = NewsEditHelper.GetNewsInfo(newsId);
if (news == null)
{
message = "Bài viết không tồn tại hoặc đã bị xóa";
return(true);
}
if (cpMode.Equals("editwaitlist"))
{
if (news.News_Status != 1)
{
message = "Bài viết đã có người khác cập nhật";
return(true);
}
else
{
// kiểm tra xem có ai nhận biên tập không?
string otherUser = NewsEditHelper.getReceiver(newsId);
if (!string.IsNullOrEmpty(otherUser) && otherUser != Page.User.Identity.Name)
{
message = otherUser + " đã nhận biên tập bài này trong khi bạn đang xem bài viết";
return(true);
}
}
}
else if (cpMode.Equals("approvalwaitlist"))
{
if (news.News_Status != 2)
{
message = "Bài viết đã có người khác cập nhật";
return(true);
}
else
{
// kiểm tra xem có ai nhận duyệt không?
string otherUser = NewsEditHelper.getReceiver(newsId);
if (!string.IsNullOrEmpty(otherUser) && otherUser != Page.User.Identity.Name)
{
message = otherUser + " đã nhận duyệt bài này trong khi bạn đang xem bài viết";
return(true);
}
}
}
return(false);
}
private void BindData()
{
if (ID > 0)
{
var productObj = productController.SelectProduct(ID);
if (productObj != null)
{
txt_Name.Value = productObj.ProductName;
txt_Name_En.Value = productObj.ProductName_En;
txt_Summary.Value = productObj.ProductSumary;
txt_Sum_En.Value = productObj.ProductSumary_En;
txtSelectedFile.Value = productObj.ProductAvatar;
NewsContent.Text = productObj.ProductDescription;
NewsContent_En.Text = productObj.ProductDescription_En;
txt_Cost.Value = productObj.ProductCost.ToString();
ddlCategory.SelectedValue = productObj.ProductCategory.ToString();
txt_Video.Text = productObj.ProductVideo;
txt_tags.Value = productObj.ProductTag;
ddlLayout.SelectedValue = productObj.ProductLayout.ToString();
cb_IsActive.Checked = productObj.IsActive;
ddlGift.SelectedValue = productObj.ProductColor.ToString();
productType.Items.FindByValue(productObj.ProductType.ToString()).Selected = true;
try
{
hdMedia.Value = NewsMediaHelper.Get_ObjectId_By_FilmId(productObj.Id.ToString());
if (hdMedia.Value.TrimEnd(',').Length > 0)
{
BindToDropdown(cboMedia, NewsEditHelper.Get_Media_By_ListsId("Object_ID", "Object_Url", "MediaObject", hdMedia.Value));
}
}
catch (Exception ex)
{
}
if (productObj.ProductOtherCat != null)
{
string[] strOthers = productObj.ProductOtherCat.Split(",".ToCharArray());
for (int i = 0; i < lstOtherCat.Items.Count; i++)
{
foreach (string strItem in strOthers)
{
if (strItem == lstOtherCat.Items[i].Value)
{
lstOtherCat.Items[i].Selected = true;
break;
}
}
}
}
}
}
}
//ThienTD EDIT: xóa dữ liệu trong bảng News_Extesion
protected void btnSend_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request.QueryString["NewsRef"]))
{
NewsEditHelper.DeleteNews_Extension(Request.QueryString["NewsRef"]);
}
if (!String.IsNullOrEmpty(referUrl))
{
Response.Redirect(referUrl);
}
}
private void LoadProvinces()
{
DataTable provinces = NewsEditHelper.GetAllProvinces();
if (provinces != null && provinces.Rows.Count > 0)
{
ddlProvinces.DataSource = provinces;
ddlProvinces.DataBind();
}
ddlProvinces.Items.Insert(0, new ListItem("-- Chọn tỉnh thành --", "0"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var selectedItems = Request.Form["SelectedItems"];
if (selectedItems != null && selectedItems.ToString() != "")
{
NewsEditHelper.DeleteNewsCrawler(selectedItems.ToString());
}
}
}
private void GetAllTacGia()
{
DataTable authors = NewsEditHelper.GetAllTacGia();
if (authors != null && authors.Rows.Count > 0)
{
ddlAuthor.DataSource = authors;
ddlAuthor.DataBind();
}
ddlAuthor.Items.Insert(0, new ListItem("-- Chọn tác giả --", "0"));
}
private void UpdateNewsFileType(Int64 NewsID)
{
string selectedItems = string.Empty;
foreach (ListItem item in cblFileType.Items)
{
if (item.Selected)
{
selectedItems += item.Value + ",";
}
}
//if (!String.IsNullOrEmpty(selectedItems)) {
NewsEditHelper.UpdateNewsAttachmentFileType(NewsID, selectedItems);
//}
}
private void LoadAttachmentsType(long _news_id)
{
DataTable types = NewsEditHelper.GetAttachmentsType(_news_id);
if (types != null && types.Rows.Count > 0)
{
DataRow row = null;
foreach (ListItem item in cblFileType.Items)
{
for (int i = 0; i < types.Rows.Count; i++)
{
row = types.Rows[i];
if (item.Value == row["Type"].ToString())
{
item.Selected = true;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
long news_ID = 0;
if (!string.IsNullOrEmpty(Request.QueryString["nid"]))
{
news_ID = Convert.ToInt64(Request.QueryString["nid"]);
}
if (news_ID > 0)
{
NewsRow objNewsRow = NewsEditHelper.GetNewsInfo_News(news_ID, false);
NewsRow objNewsRow_Ex = NewsEditHelper.GetNewsInfo_NewsExtension(news_ID, false);
string title = LCSFinder.GetEditor(objNewsRow.News_Title, objNewsRow_Ex.News_Title)[0];
string Sapo = LCSFinder.GetEditor(objNewsRow.News_InitialContent, objNewsRow_Ex.News_InitialContent)[0];
string Content = LCSFinder.GetEditor(objNewsRow.News_Content, objNewsRow_Ex.News_Content)[0];
ltrTitle.Text = title;
ltrInit.Text = Sapo;
ltrContent.Text = Content;
}
}
}
protected void grdList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Copy"))
{
int _id = Convert.ToInt32(e.CommandArgument);
DataTable _obj = NewsEditHelper.GetCrawlerNews(_id);
if (_obj != null && _obj.Rows.Count > 0)
{
DataRow row = _obj.Rows[0];
long NewsID = Convert.ToInt64(NewsHelper.GenNewsID());
NewsEditHelper.CreateNews(NewsID, 0, string.Empty, row["News_Title"].ToString(), string.Empty, "Theo " + row["SourceName"], row["News_InitContent"].ToString(), row["News_Content"].ToString(), HttpContext.Current.User.Identity.Name, false, 0, 0, string.Empty, string.Empty, string.Empty, DateTime.Now, false, false, 0, string.Empty, string.Empty, string.Empty, false, string.Empty, string.Empty, row["News_Source"].ToString(), 0, string.Empty, string.Empty);
NewsEditHelper.UpdateCrawlerStatus(_id);
Response.Redirect("/office/add,templist/" + NewsID + ".aspx");
}
else
{
Response.Redirect("/office/crawler.aspx");
}
}
}
/// <summary>
/// Check whether current user can edit the news
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public static bool isHasPermission(HttpContext context)
{
if (context.Request.QueryString["NewsRef"] == null || context.Request.QueryString["NewsRef"] == string.Empty)
{
return(true);
}
else
{
string cpMode = context.Request.QueryString["cpmode"];
if (!string.IsNullOrEmpty(cpMode))
{
if (cpMode.Contains(","))
{
cpMode = cpMode.Substring(cpMode.IndexOf(",") + 1);
}
cpMode = cpMode.ToLower();
long newsId = long.Parse(context.Request.QueryString["NewsRef"]);
string userName = context.User.Identity.Name;
if (!string.IsNullOrEmpty(userName) && newsId != 0)
{
MainSecurity objsecu = new MainSecurity();
//Role objrole = objsecu.GetRole(context.User.Identity.Name);
NewsRow newsRow = NewsEditHelper.GetNewsInfo_News(newsId, false);
if (newsRow != null)
{
Permission permission = objsecu.GetPermission(userName);
MainDB db = new MainDB();
bool toReturn = false;
switch (cpMode)
{
case "templist":
toReturn = newsRow.News_Status == (byte)NewsStatus.LuuTam &&
db.StoredProcedures.News_isLastAccessUser(newsId, userName);
break;
case "editwaitlist":
toReturn = newsRow.News_Status == (byte)NewsStatus.ChoBienTap &&
permission.isBien_Tap_Bai &&
db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser());
break;
case "editinglist":
toReturn = newsRow.News_Status == (byte)NewsStatus.NhanBienTap &&
permission.isBien_Tap_Bai &&
db.StoredProcedures.News_isLastAccessUser(newsId, userName);
break;
case "approvalwaitlist":
toReturn = newsRow.News_Status == (byte)NewsStatus.ChoDuyet && permission.isDuyet_Bai &&
db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser());
break;
case "approvalwaitspeciallist":
toReturn = newsRow.News_Status == (byte)NewsStatus.ChoDuyet && permission.isDuyet_Bai &&
db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser());
break;
case "approvinglist":
toReturn = newsRow.News_Status == (byte)NewsStatus.NhanDuyet && permission.isDuyet_Bai &&
db.StoredProcedures.News_isLastAccessUser(newsId, userName);
break;
case "publishedlist":
toReturn = newsRow.News_Status == (byte)NewsStatus.XuatBan && permission.isXuat_Ban_Bai &&
db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser());
break;
case "removedlist":
toReturn = newsRow.News_Status == (byte)NewsStatus.GoBo && permission.isXuat_Ban_Bai &&
db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser());
break;
case "backlist":
toReturn = newsRow.News_Status == (byte)NewsStatus.TraLai &&
db.StoredProcedures.News_isLastAccessUser(newsId, userName);
break;
case "dellist":
toReturn = newsRow.News_Status == (byte)NewsStatus.XoaTam &&
db.StoredProcedures.News_isLastAccessUser(newsId, userName);
break;
}
return(toReturn);
}
}
}
}
return(false);
}
protected void btnPublish_Click(object sender, EventArgs e)
{
if (Validate())
{
// Get CatID cac chuyen muc khac
string strOtherCat = "";
foreach (ListItem item in lstOtherCat.Items)
{
if (item.Selected)
{
strOtherCat += item.Value + ",";
}
}
//string Tags = "";
foreach (ListItem item in cblTags.Items)
{
if (item.Selected)
{
hidLuongSuKien.Value += item.Value + ",";
}
}
hidLuongSuKien.Value = hidLuongSuKien.Value.TrimEnd(',');
if (strOtherCat != "")
{
strOtherCat = strOtherCat.Substring(0, strOtherCat.Length - 1);
}
string strNewsID = "";
string strcpmode = Request.QueryString["cpmode"].ToString().Replace("add,", "").Replace("#", "");
//xet 2 truong hop: 1 la tao va xuat ban, 2 sua va xuất bản
if (!string.IsNullOrEmpty(Request.QueryString["NewsRef"]))
{
strNewsID = Request.QueryString["NewsRef"].ToString();
objsoure.UpdateParameters[9].DefaultValue = "3";
// Neu chon ngay xuat ban voi truong hop chua Published
// thi check xem da chon PublishedDate chua
//if (getPublishTime().Year == 2000)
// objsoure.UpdateParameters[13].DefaultValue = DateTime.Now.ToString();
//else
objsoure.UpdateParameters[13].DefaultValue = getPublishTime().ToString();
objsoure.UpdateParameters[12].DefaultValue = strOtherCat;
objsoure.UpdateParameters["_str_Extension3"].DefaultValue = txtSourceLink.Text.Trim();
objsoure.UpdateParameters["_thread_id"].DefaultValue = hidLuongSuKien.Value.Trim();
// Get ViewNum cua Category
int template = CategoryHelper.getCatInfoAsCategoryRow(Convert.ToInt32(lstCat.SelectedValue)).Cat_ViewNum;
objsoure.UpdateParameters[17].DefaultValue = template.ToString();
objsoure.UpdateParameters[4].DefaultValue = txtSelectedFile.Text.Trim();
objsoure.UpdateParameters["_isSend"].DefaultValue = "true";
objsoure.Update();
NewsEditHelper.DeleteNews_Extension(Request.QueryString["NewsRef"]);
if (!String.IsNullOrEmpty(referUrl))
{
Response.Redirect(referUrl);
}
}
}
}
private void BindNewsEdit(long _news_id)
{
NewsRow objNewsRow = NewsEditHelper.GetNewsInfo_NewsExtension(_news_id, false);
MainSecurity objSercu = new MainSecurity();
Permission objPer = objSercu.GetPermission(Page.User.Identity.Name);
if (objPer.isXuat_Ban_Bai)
{
//Kiểm tra nếu có quyền xuất bản thì sẽ hiện dầy đủ thông tin
btnPublish.Visible = true;
// pnControl.Visible = true;
}
else
{
btnPublish.Visible = false;
}
if (objNewsRow != null)
{
if (!objPer.isXuat_Ban_Bai && Page.User.Identity.Name.Trim().ToLower() != objNewsRow.News_Author.Trim().ToLower())
{
throw new SecurityException("Bạn không có quyền truy cập vào trang này");
return;
}
ltrXuatBan.Text = "Bài viết do \"" + objNewsRow.News_Approver.ToUpper() + "\" xuất bản lúc " + objNewsRow.News_PublishDate.ToString("dd/MM/yyyy hh:mm");
lstCat.SelectedValue = objNewsRow.Cat_ID.ToString();
txtTitle.Text = objNewsRow.News_Title != null ? objNewsRow.News_Title : "";
txtSubTitle.Text = objNewsRow.News_Subtitle != null ? objNewsRow.News_Subtitle : "";
txtSource.Text = objNewsRow.News_Source != null ? objNewsRow.News_Source : "";
txtInit.Text = objNewsRow.News_InitialContent != null?NewsEditHelper.ReplaceImageSrcToEmoticon(objNewsRow.News_InitialContent) : "";
txtInit.Text = txtInit.Text.Replace("<br/>", System.Environment.NewLine);
if (Request.QueryString["redirect"] == null)
{
NewsContent.Text = objNewsRow.News_Content != null ? objNewsRow.News_Content : "";
Session["NewsContent"] = NewsContent.Text;
}
else
{
NewsContent.Text = Session["NewsContent"].ToString();
}
chkIsFocus.Checked = objNewsRow.IsNews_isFocusNull != true ? objNewsRow.News_isFocus : false;
cboIsHot.SelectedValue = objNewsRow.IsNews_ModeNull != true?objNewsRow.News_Mode.ToString() : "0";
hdRelatNews.Value = objNewsRow.News_Relation != null ? objNewsRow.News_Relation : "";
chkShowComment.Checked = objNewsRow.IsisCommentNull != true ? objNewsRow.isComment : false; //Cho phép hiện ảnh hay ko?
chkShowRate.Checked = objNewsRow.IsisUserRateNull != true ? objNewsRow.isUserRate : false;
txtSelectedFile.Text = objNewsRow.News_Image != null ? objNewsRow.News_Image : "";
txtImageTitle.Text = objNewsRow.News_ImageNote != null ? objNewsRow.News_ImageNote : "";
txtIcon.Text = objNewsRow.Icon != null ? objNewsRow.Icon : "";
txtMaCP.Text = objNewsRow.Extension1 != null ? objNewsRow.Extension1 : "";
txtExtension2.Text = objNewsRow.Extension2 != null ? objNewsRow.Extension2 : "";
txtSourceLink.Text = objNewsRow.Extension3 != null ? objNewsRow.Extension3 : "";
ddlAuthor.SelectedValue = objNewsRow.IsExtension4Null != true?objNewsRow.Extension4.ToString() : "0";
if (objNewsRow.Template != 0)
{
ddlProvinces.SelectedValue = objNewsRow.Template.ToString();
}
if (objNewsRow.News_OtherCat != null)
{
string[] strOthers = objNewsRow.News_OtherCat.Split(",".ToCharArray());
for (int i = 0; i < lstOtherCat.Items.Count; i++)
{
foreach (string strItem in strOthers)
{
if (strItem == lstOtherCat.Items[i].Value)
{
lstOtherCat.Items[i].Selected = true;
break;
}
}
}
}
if (!objNewsRow.IsNews_PublishDateNull)
{
SetValueForCombo(cboMonth, objNewsRow.News_PublishDate.Month.ToString());
SetValueForCombo(cboDay, objNewsRow.News_PublishDate.Day.ToString());
SetValueForCombo(cboYear, objNewsRow.News_PublishDate.Year.ToString());
SetValueForCombo(cboSercond, objNewsRow.News_PublishDate.Second.ToString());
SetValueForCombo(cboMinute, objNewsRow.News_PublishDate.Minute.ToString());
SetValueForCombo(cboHour, objNewsRow.News_PublishDate.Hour.ToString());
}
else
{
SetValueForCombo(cboMonth, "0");
SetValueForCombo(cboDay, "0");
SetValueForCombo(cboYear, "2000");
SetValueForCombo(cboSercond, "-1");
SetValueForCombo(cboMinute, "-1");
SetValueForCombo(cboHour, "-1");
}
if (!IsPostBack)
{
hdMedia.Value = DFISYS.BO.Editoral.NewsMedia.NewsMediaHelper.Get_ObjectId_By_NewsId(_news_id);
DataTable dtThread = ThreadHelper.SelectThreadByNewsID(_news_id);
if (dtThread != null && dtThread.Rows.Count > 0)
{
hidLuongSuKien.Value = dtThread.Rows[0]["Thread_ID"].ToString();
}
}
//Load data to Combobox Tin lien quan;
string str;
if (hdRelatNews.Value.TrimEnd(',') != "")
{
str = NewsEditHelper.Get_Media_By_ListsId("News_ID", "News_Title", "News", hdRelatNews.Value);
BindToDropdown(cboNews, str);
}
string strThread;
if (hidLuongSuKien.Value.TrimEnd(',') != "")
{
strThread = NewsEditHelper.Get_Media_By_ListsId("Thread_ID", "Title", "NewsThread", hidLuongSuKien.Value);
BindToDropdown(lstThread, strThread);
string[] arrThread = hidLuongSuKien.Value.Split(',');
if (arrThread != null && arrThread.Length > 0)
{
for (int i = 0; i < cblTags.Items.Count; i++)
{
foreach (string strItem in arrThread)
{
if (strItem == cblTags.Items[i].Value)
{
cblTags.Items[i].Selected = true;
break;
}
}
}
}
}
if (hdMedia.Value.TrimEnd(',').Length > 0)
{
str = NewsEditHelper.Get_Media_By_ListsId("Object_ID", "Object_Url", "MediaObject", hdMedia.Value);
//BindToDropdown(cboMedia, str);
}
LoadAttachmentsType(_news_id);
}
}
