public void StartBindingData(int menuId)
{
_navigationUrl = "GalleryDetail.aspx";
_menuId = menuId;
try
{
var result = NewsDAL.GetAll(__type, menuId);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
return;
}
lbError.Visible = false;
_dataSource = result.Data.Tables[0];
grvProjectItems.DataSource = result.Data;
grvProjectItems.DataKeyNames = new string[] { "Id" };
grvProjectItems.DataBind();
}
catch (Exception ex)
{
LogHelpers.WriteError("[ucProjectItems][StartBindingData] Exception: " + ex.ToString());
}
}
private void StartLoadNewsInfo(int id)
{
string tag = _tag + "[StartLoadNewsInfo]";
var result = NewsDAL.Get(id);
if (result.Code < 0)
{
LogHelpers.WriteError(tag, result.ErrorMessage);
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
return;
}
lbError.Visible = false;
if (result.Data.Tables[0].Rows.Count == 0)
{
return;
}
NewsBOL BOL = new NewsBOL(result.Data.Tables[0].Rows[0]);
StartShowData(BOL);
}
public void StartDatabindingAbout(int menuId)
{
string tag = __tag + "[StartDatabindingAbout]";
if (menuId <= 0)
{
return;
}
try
{
var result = NewsDAL.GetAll(menuId);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
//--
LogHelpers.WriteError(tag, result.ErrorMessage);
return;
}
lvAbout.DataSource = result.Data;
lvAbout.DataBind();
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
//---
lbError.InnerText = ex.Message;
lbError.Visible = true;
}
}
public ActionResult UpdateAndCreate(string chkType, string chkAutoUpload, News newDetail)
{
try
{
if (newDetail.Id > 0)
{
if (isChief || (newDetail.CreatedBy == SysBaseInfor.GetCurrentUserId() && (newDetail.Status == 0 || newDetail.Status == 4)))
{
NewsDAL objCtrl = new NewsDAL();
newDetail.Type = !string.IsNullOrEmpty(chkType) ? (byte)1 : (byte)0;
newDetail.UpdatedAt = DateTime.Now;
newDetail.UpdatedBy = SysBaseInfor.GetCurrentUserId();
newDetail.UnitId = SysBaseInfor.GetCurrentUnitId().ToInt32();
if (!string.IsNullOrEmpty(chkAutoUpload))
{
var tmpContent = UploadAllImageInNewsToServer(newDetail.FullContent, newDetail.Id);
if (!string.IsNullOrEmpty(tmpContent))
{
newDetail.FullContent = tmpContent;
}
}
objCtrl.UpdateItem(newDetail);
return(Json(new { msg = "Success", idNews = newDetail.Id, typeAction = "UpdateAndCreate" }));
}
}
return(Json(new { msg = "Thao tác không thực hiện được" }));
}
catch (Exception ex)
{
return(Json(new { msg = ex.Message }));
}
}
public void StartBindingData(int menuId, string navigationUrl)
{
string tag = __tag + "[StartBindingData]";
//--
LogHelpers.WriteStatus(tag, "MenuId = " + menuId.ToString(), "Start.");
_navigationUrl = navigationUrl;
try
{
var result = NewsDAL.GetAll(menuId);
if (result.Code < 0)
{
return;
}
//---
lvNews.DataSource = result.Data;
lvNews.DataKeyNames = new string[] { "Id" };
lvNews.DataBind();
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
}
LogHelpers.WriteStatus(tag, "MenuId = " + menuId.ToString(), "End.");
}
public void StartBindingData(int menuId, string navigationUrl)
{
try
{
var result = NewsDAL.GetAll(menuId);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = false;
return;
}
_menuId = menuId;
_navigationUrl = navigationUrl;
_dataSource = result.Data.Tables[0];
grvIntroItems.DataSource = result.Data;
grvIntroItems.DataKeyNames = new string[] { "Id" };
grvIntroItems.DataBind();
}
catch (Exception ex)
{
LogHelpers.WriteError("[ucNewsItems][StartBindingData] Exception: " + ex.ToString());
}
}
public async Task <HttpResponseMessage> GetTopNews(int userID)
{
try
{
NewsDAL dal = new NewsDAL();
TopNewsInfo data = await dal.GetTopNews(userID);
if (data != null)
{
return(Request.CreateResponse <TopNewsInfo>(HttpStatusCode.OK, data));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound));
}
}
catch (DbEntityValidationException ex)
{
var controllerName = ControllerContext.RouteData.Values["controller"].ToString();
var actionName = ControllerContext.RouteData.Values["action"].ToString();
Logger log = new Logger();
log.ErrorLog(ex, controllerName, actionName);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError));
}
}
public async Task <HttpResponseMessage> UpdateNewsFavorite(int userID, int favID, string fav)
{
try
{
NewsDAL dal = new NewsDAL();
JsonResponse response = await dal.UpdateNewsFavorite(userID, favID, fav);
if (response != null && response.Flag)
{
return(Request.CreateResponse <JsonResponse>(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound));
}
}
catch (DbEntityValidationException ex)
{
var controllerName = ControllerContext.RouteData.Values["controller"].ToString();
var actionName = ControllerContext.RouteData.Values["action"].ToString();
Logger log = new Logger();
log.ErrorLog(ex, controllerName, actionName);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError));
}
}
private void StartDeleteItemsProcessing(string listId)
{
try
{
var result = NewsDAL.DeleteAll(listId);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
return;
}
lbError.Visible = false;
if (result.Data != null &&
result.Data.Tables.Count > 0 &&
result.Data.Tables[0].Rows.Count > 0)
{
ShowDeleteMessageErrors(result.Data.Tables[0]);
}
}
catch (Exception ex)
{
LogHelpers.WriteException("[ucNewsItems][StartDeleteItemsProcessing]", ex.ToString());
lbError.InnerText = ex.Message;
lbError.Visible = true;
}
}
public ActionResult Add(News news)
{
if (!Utilities.IsLoggedUser())
{
return(RedirectToAction("Login", "Home"));
}
LogHelpers.LogHandler.Info("Start");
ViewData["ListMenu"] = MenuDAL.GetSelectList();
if (news == null)
{
return(View("AddOrEdit", new News()));
}
if (!ModelState.IsValid)
{
return(View("AddOrEdit", news));
}
var result = NewsDAL.InsertOrUpdate(news);
if (result.Code < 0)
{
return(View("AddOrEdit", news));
}
return(RedirectToAction("Index"));
}
public NewsController(IOptions <AppSettings> setting)
{
Config = setting.Value;
if (dal == null)
{
dal = new NewsDAL(Config.ConnectionString);
}
}
public ActionResult Details(int?id)
{
if (!id.HasValue || id.Value <= 0)
{
return(RedirectToAction("Index"));
}
NewsBOL news = NewsDAL.Get(id.Value);
return(View(news));
}
public ActionResult GetNewsList()
{
try
{
NewsDAL obj = new NewsDAL();
return(Json(new { result = "success", list = obj.GetNewsList(), JsonRequestBehavior.AllowGet }));
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index(int?menuId)
{
Session["SelectedMenuId"] = menuId;
var result = NewsDAL.GetAll(menuId == null || !menuId.HasValue ? 0 : menuId.Value);
if (result.Code < 0)
{
LogHelpers.LogHandler.Error(result.ErrorMessage);
throw new HttpException(result.ErrorMessage);
}
return(View(result.Data));
}
public ActionResult CreateNews(string chkType, string chkAutoUpload, News newDetail)
{
try
{
if (string.IsNullOrEmpty(newDetail.Title))
{
return(Json(new { msg = "Bạn phải nhập tiêu đề" }));
}
if (string.IsNullOrEmpty(newDetail.Summary))
{
return(Json(new { msg = "Bạn phải nhập tóm tắt" }));
}
if (newDetail.CategoryID <= 0)
{
return(Json(new { msg = "Bạn phải chọn chuyên mục" }));
}
if (newDetail.Id == 0)
{
CategoriesDAL categoryCtrl = new CategoriesDAL();
var category = categoryCtrl.GetItemByID("Id", newDetail.CategoryID);
NewsDAL objCtrl = new NewsDAL();
newDetail.Type = !string.IsNullOrEmpty(chkType) ? (byte)1 : (byte)0;
newDetail.Active = 1;
newDetail.UnitId = SysBaseInfor.GetCurrentUnitId().ToInt32();
newDetail.CreatedAt = DateTime.Now;
newDetail.CreatedBy = SysBaseInfor.GetCurrentUserId();
newDetail.Status = isChief ? (byte)1 : (byte)0;
objCtrl.CreateItem(newDetail);
if (newDetail.Id > 0 && !string.IsNullOrEmpty(chkAutoUpload))
{
var tmpContent = UploadAllImageInNewsToServer(newDetail.FullContent, newDetail.Id);
if (!string.IsNullOrEmpty(tmpContent))
{
newDetail.FullContent = tmpContent;
}
objCtrl.UpdateItem(newDetail);
}
return(Json(new { msg = "Success", idNews = newDetail.Id, typeAction = "Create" }));
}
else
{
return(Json(new { msg = "Thao tác không thực hiện được" }));
}
}
catch (Exception ex)
{
return(Json(new { msg = ex.Message }));
}
}
public void StartBindingDataNews(int menuId, int id, string navigationUrl, string header)
{
string tag = __tag + "[StartBindingDataNews]";
//--
lbHeader.InnerText = header;
if (menuId <= 0)
{
return;
}
try
{
var result = NewsDAL.GetAll(menuId);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
//---
LogHelpers.WriteError(tag, result.ErrorMessage);
return;
}
if (result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0)
{
return;
}
ucNewsList.StartBindingData(result.Data, menuId, navigationUrl);
//--
if (id <= 0)
{
NewsBOL news = new NewsBOL(result.Data.Tables[0].Rows[0]);
lbHeader.InnerText = Utilities.IsLangueEN() ? news.Name_EN : news.Name_VN;
//--
ucNewsDetail.StartShowNewsDetail(news);
}
else
{
StartLoadNewsDetail(id);
}
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
//--
lbError.InnerText = ex.Message;
lbError.Visible = true;
}
}
public ActionResult AddUpdateNews(DAL.News n)
{
try
{
NewsDAL obj = new NewsDAL();
int newsId = 0;
obj.AddUpdate(n, out newsId);
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
string fileExt = file.FileName.Split('.').LastOrDefault();
string attachmentFolder = "doc";
if (fileExt == "jpg" || fileExt == "jpeg" || fileExt == "png")
{
attachmentFolder = "Images";
}
else
{
attachmentFolder = "Attachments";
}
string path = Server.MapPath("~/Files/News/" + attachmentFolder + "/" + newsId);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
var InputFileName = Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(path + "\\" + InputFileName);
//Save file to server folder
int count = 1;
checkIfFileExists:
if (System.IO.File.Exists(ServerSavePath))
{
ServerSavePath = Path.Combine(path + "\\" + InputFileName.Substring(0, InputFileName.LastIndexOf('.')) + count++ + InputFileName.Substring(InputFileName.IndexOf('.')));
goto checkIfFileExists;
}
else
{
file.SaveAs(ServerSavePath);
}
}
return(Json(new { result = "success", images = GetEventPhotos(newsId), newsId = newsId }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
WriteLogs.Write(ex);
return(Json(new { result = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Details(int id = 0)
{
#if DEBUG
_log.Debug("id: {0}", id);
#endif
ViewBag.PageType = __type;
NewsBOL model = NewsDAL.GetWithType(__type, id);
if (model == null)
{
return(RedirectToAction("Index"));
}
return(View(model));
}
private void StartAddSubItemAbout(HtmlGenericControl li, int menuId)
{
string tag = __tag + "[StartAddSubItemAbout]";
if (menuId <= 0)
{
return;
}
var result = NewsDAL.GetAll(menuId);
if (result.Code < 0)
{
LogHelpers.WriteError(tag, result.ErrorMessage);
return;
}
if (result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count < 0)
{
return;
}
HtmlGenericControl ul = new HtmlGenericControl("ul");
foreach (DataRow row in result.Data.Tables[0].Rows)
{
try
{
NewsBOL news = new NewsBOL(row);
//---
HtmlGenericControl subLi = new HtmlGenericControl("li");
subLi.InnerHtml = string.Format("<a href='{0}#{1}'>{2}</a>",
Utilities.GetNavigationUrl("AboutPage"),
news.Id,
Utilities.IsLangueEN() ? news.Name_EN : news.Name_VN);
//----
ul.Controls.Add(subLi);
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
}
}
if (ul.Controls.Count > 0)
{
li.Controls.Add(ul);
}
}
//
// GET: /News/
public ActionResult Index(int?id)
{
if (id == null || !id.HasValue || id.Value <= 0)
{
return(RedirectToAction("Index", "Home"));
}
var result = NewsDAL.Get(id.Value);
if (result.Code < 0)
{
return(RedirectToAction("Index", "Home"));
}
return(View(result.Data));
}
public void StartDeleteProjects()
{
if (this.grvProjectItems.Rows.Count == 0)
{
return;
}
string listId = string.Empty;
for (int i = 0; i < grvProjectItems.Rows.Count; i++)
{
GridViewRow row = grvProjectItems.Rows[i];
HtmlInputCheckBox chx = row.Cells[0].FindControl("chkRowItem") as HtmlInputCheckBox;
if (!chx.Checked)
{
continue;
}
if (!string.IsNullOrEmpty(listId))
{
listId += ",";
}
listId += grvProjectItems.DataKeys[i].Value.ToString();
}
if (!string.IsNullOrEmpty(listId))
{
var result = NewsDAL.DeleteAll(listId);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
return;
}
lbError.Visible = false;
if (result.Data != null &&
result.Data.Tables.Count > 0 &&
result.Data.Tables[0].Rows.Count > 0)
{
StartShowDeleteErrors(result);
}
}
}
public JsonResult Delete(string listId)
{
LogHelpers.LogHandler.Info("Start.");
try
{
var result = NewsDAL.DeleteAll(listId);
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogHelpers.LogHandler.Error(ex.ToString());
return(Json(new ResultData <int>()
{
Code = ex.HResult,
ErrorMessage = ex.Message
}, JsonRequestBehavior.AllowGet));
}
}
public void ProcessRequest(HttpContext context)
{
var inputStream = new StreamReader(context.Request.InputStream);
string receiveJson = inputStream.ReadToEnd();
try
{
dynamic news = JsonConvert.DeserializeObject(receiveJson);
object obj = null;
if (news.Priority != null)
{
obj = new
{
Id = Convert.ToInt32(news.Id),
Priority = Convert.ToInt32(news.Priority)
};
}
else
{
obj = new {
Id = Convert.ToInt32(news.Id),
Disable = Convert.ToBoolean(news.Disable)
};
}
//NewsBOL news = JsonConvert.DeserializeObject<NewsBOL>(receiveJson);
var result = NewsDAL.UpdatePriorityOrDisable(obj);
if (result.Code < 0)
{
_log.Error(result.ErrorMessage);
}
string responseString = JsonConvert.SerializeObject(result);
context.Response.ContentType = "application/json";
context.Response.Write(responseString);
}
catch (Exception ex)
{
_log.Error(ex.ToString());
}
}
public ActionResult DeleteNew(int idNews)
{
try
{
NewsDAL objCtrl = new NewsDAL();
var result = objCtrl.GetItemByID("Id", idNews);
if (isChief)
{
if (result.Status != 3)
{
if (result.CreatedBy == SysBaseInfor.GetCurrentUserId())
{
objCtrl.DeleteItemByValues("Id", idNews);
return(Content("Success"));
}
else
{
if (result.Status != 0 || result.Status != 4)
{
objCtrl.DeleteItemByValues("Id", idNews);
return(Content("Success"));
}
}
}
}
else
{
if (result.CreatedBy == SysBaseInfor.GetCurrentUserId() && (result.Status == 0 || result.Status == 4))
{
objCtrl.DeleteItemByValues("Id", idNews);
return(Content("Success"));
}
}
return(Content("Không thể xóa"));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public void StartLoadToNews()
{
string tag = __tag + "[StartLoadToNews]";
try
{
var result = NewsDAL.GetTopNews(10);
if (result.Code < 0)
{
LogHelpers.WriteError(tag, result.ErrorMessage);
return;
}
lvHomeNews.DataSource = result.Data;
lvHomeNews.DataBind();
}
catch (Exception ex)
{
LogHelpers.WriteException(tag, ex.ToString());
}
}
//
// GET: /News/
public ActionResult Index(int?id)
{
if (!Utilities.IsLoggedUser())
{
return(RedirectToAction("Login", "Home"));
}
if (id != null && !id.HasValue && id.Value > 0)
{
return(RedirectToAction("Edit/" + id.Value.ToString()));
}
var result = NewsDAL.GetAll(0);
if (result.Code < 0)
{
throw new HttpException(result.ErrorMessage);
}
return(View(result.Data));
}
public async Task <HttpResponseMessage> GetStudentDashboard(int userID, int batchID, string role, int currentIndex, int maxRows)
{
try
{
MIUEntities db = new MIUEntities();
StudentDashboardInfo data = new StudentDashboardInfo();
EventCalendarDAL dal = new EventCalendarDAL();
NewsDAL newsDAL = new NewsDAL();
ResultDAL resultDAL = new ResultDAL();
AnnouncementDAL announcementDAL = new AnnouncementDAL();
ReportAttendanceDAL reportAttendanceDAL = new ReportAttendanceDAL();
data.EventCalendar = await dal.GetAllEventCalendar(userID, role);
data.News = await newsDAL.GetNews(userID, currentIndex, maxRows);
string batchCode = db.Batches.Where(x => x.ID == batchID).Select(x => x.BatchCode).SingleOrDefault();
data.StudentDashboard = await resultDAL.GetResult(userID, batchCode);
data.Announcement = await announcementDAL.GetLatestAnnouncement();
//data.AttRateAndPercent = await reportAttendanceDAL.GetAttRateAndPercent(batchID, userID);
if (data != null)
{
return(Request.CreateResponse <StudentDashboardInfo>(HttpStatusCode.OK, data));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound));
}
}
catch (DbEntityValidationException ex)
{
var controllerName = ControllerContext.RouteData.Values["controller"].ToString();
var actionName = ControllerContext.RouteData.Values["action"].ToString();
Logger log = new Logger();
log.ErrorLog(ex, controllerName, actionName);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError));
}
}
public async Task <HttpResponseMessage> GetLectureDashboard(int accessorID, string role, int courseID = 0)
{
try
{
MIUEntities db = new MIUEntities();
LectureDashboardInfo data = new LectureDashboardInfo();
StudentDashboardDAL dal = new StudentDashboardDAL();
NewsDAL newsDAL = new NewsDAL();
ResultDAL resultDAL = new ResultDAL();
AnnouncementDAL announcementDAL = new AnnouncementDAL();
EventCalendarDAL eventDAL = new EventCalendarDAL();
//data.AttRateAndPercent = await reportAttendanceDAL.GetAttRateAndPercent(batchID, userID);
data = await dal.GetLectureDashboard(accessorID, courseID);
data.Announcement = await announcementDAL.GetLatestAnnouncement();
data.News = newsDAL.GetNews(accessorID, 1, 5).Result;
data.EventCalendar = eventDAL.GetAllEventCalendar(accessorID, role).Result;
//data.EventCalendar = eventDAL.GetEventCalendar(accessorID, 1, 5).Result;
if (data != null)
{
return(Request.CreateResponse <LectureDashboardInfo>(HttpStatusCode.OK, data));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound));
}
}
catch (DbEntityValidationException ex)
{
var controllerName = ControllerContext.RouteData.Values["controller"].ToString();
var actionName = ControllerContext.RouteData.Values["action"].ToString();
Logger log = new Logger();
log.ErrorLog(ex, controllerName, actionName);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError));
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
NewsBOL BOL = CreateNewsObject();
var result = NewsDAL.InsertOrUpdate(BOL);
if (result.Code < 0)
{
lbError.InnerText = result.ErrorMessage;
lbError.Visible = true;
return;
}
lbError.Visible = false;
GoBackPage();
}
catch (Exception ex)
{
LogHelpers.WriteError("[ucNewsItems][btnSubmit_Click]", ex.ToString());
}
}
public JsonResult GetDataNews(List <int> lstNewsGetData)
{
try
{
NewsDAL newCtrl = new NewsDAL();
foreach (int newsId in lstNewsGetData)
{
News news = newCtrl.GetItemByID("Id", newsId);
var tmpContent = UploadAllImageInNewsToServer(news.FullContent, news.Id);
if (!string.IsNullOrEmpty(tmpContent))
{
news.FullContent = tmpContent;
newCtrl.UpdateItem(news);
}
}
return(Json(new { Msg = "Success" }));
}
catch (Exception ex)
{
return(Json(new { Msg = "Fail" }));
}
}
