public ActionResult AddNewAnnounce(AnnounceModel announceModel) { if (!ModelState.IsValid) { return View(announceModel); } try { string updateBy = AccountInfo.GetUserName(Request); AnnouncementTableAdapter announceTableAdapter = new AnnouncementTableAdapter(); string title = announceModel.title; string subject = announceModel.subject; Boolean isAuto = false; DateTime date = DateTime.Now; announceTableAdapter.InsertNewAnnounce(title, subject, isAuto, date, updateBy, date); Session["addAnnounce"] = "Đăng tin thành công!"; } catch (Exception ex) { Log.ErrorLog(ex.Message); Session["addAnnounce"] = "Đăng tin thất bại!"; } return RedirectToAction("AddNewAnnounce", "Announce"); }
public ActionResult DeleteAnnounce(int announceID) { AnnouncementTableAdapter announceTableAdapter = new AnnouncementTableAdapter(); try { announceTableAdapter.DeleteAnnounceByID(announceID); Session["deleteAnnounce"] = "Xóa thành công!"; } catch (Exception ex) { Log.ErrorLog(ex.Message); Session["deleteAnnounce"] = "Xóa thất bại!"; } return RedirectToAction("ListAnnounce", "Announce"); }
public ActionResult EditAnnounce(string announceID) { AnnounceModel announcement = new AnnounceModel(); AnnouncementTableAdapter announcementAdapter = new AnnouncementTableAdapter(); try { int announceId = Convert.ToInt32(announceID); DataTable announcementTable = announcementAdapter.GetDataByAnnounceID(announceId); announcement.annoucemenID = Convert.ToInt32(announcementTable.Rows[0]["AnnouncementID"]); announcement.title = Convert.ToString(announcementTable.Rows[0]["Title"]); announcement.isAuto = Convert.ToBoolean(announcementTable.Rows[0]["IsAuto"]); announcement.subject = Convert.ToString(announcementTable.Rows[0]["Subject"]); } catch (Exception ex) { Log.ErrorLog(ex.Message); return RedirectToAction("Error", "ErrorController"); } return View(announcement); }
public ActionResult EditAnnounce(AnnounceModel announceModel, string announceID) { AnnouncementTableAdapter announceTableAdapter = new AnnouncementTableAdapter(); try { int announceId = Convert.ToInt32(announceID); string updateBy = AccountInfo.GetUserName(Request); string title = announceModel.title; string subject = announceModel.subject; Boolean isAuto = false; DateTime date = DateTime.Now; announceTableAdapter.UpdateAnnounce(title, subject, isAuto, updateBy, date, announceId); Session["editAnnounce"] = "Cập nhật thành công!"; } catch (Exception ex) { Log.ErrorLog(ex.Message); Session["editAnnounce"] = "Cập nhật thất bại!"; } return RedirectToAction("EditAnnounce", "Announce", new { @announceID = announceID }); }
public ActionResult ViewAnnounce(string title, string date, string page, string amountPerPage) { ViewBag.error = ""; string username = AccountInfo.GetUserName(Request); AnnouncementTableAdapter announcementAdapter = new AnnouncementTableAdapter(); DataTable dt = new DataTable(); if (String.IsNullOrWhiteSpace(title)) { title = null; } DateTime date_; if (String.IsNullOrWhiteSpace(date)) { date = null; } else if (!DateTime.TryParseExact(date, "dd/MM/yyyy", null , System.Globalization.DateTimeStyles.None , out date_)) { ViewBag.error = "Sai định dạng ngày, tháng"; date = null; } else { date = date_.ToString("yyyy-MM-dd"); } int page_; if (!int.TryParse(page, out page_)) { page = null; page_ = 1; } int amountPerPage_; if (!int.TryParse(amountPerPage, out amountPerPage_)) { amountPerPage = "10"; amountPerPage_ = 10; } try { string query = "SELECT * FROM( SELECT *, ROW_NUMBER() OVER (ORDER BY insertedDate DESC) AS RowNum " + "FROM Announcement "; string conditionQuery = ""; string countQuery = "SELECT COUNT(AnnouncementID) FROM Announcement "; if (title != null || date != null) { conditionQuery += "WHERE "; bool isFirst = false; if (title != null) { conditionQuery += "Title like '%" + title + "%' "; isFirst = true; } if (date != null) { if (isFirst) { conditionQuery += "AND "; } conditionQuery += "InsertedDate BETWEEN '" + date + " 00:00:000' AND '" + date + " 23:59:59:999' "; } } announcementAdapter.Connection.Open(); SqlCommand countCmd = new SqlCommand(countQuery + conditionQuery, announcementAdapter.Connection); int count = (int)countCmd.ExecuteScalar(); int maxPage = (count / amountPerPage_); if (count % amountPerPage_ != 0) { maxPage++; } ViewBag.maxPage = maxPage; if (page_ > maxPage) { page_ = maxPage; } ViewBag.curPage = page_; ViewBag.amountPerPage = amountPerPage_; int minRowNum = ((page_ - 1) * amountPerPage_) + 1; int maxRowNum = page_ * amountPerPage_; query += conditionQuery; query += ") AS SOD WHERE SOD.RowNum BETWEEN (" + minRowNum + ") AND (" + maxRowNum + ") "; SqlCommand getDataCmd = new SqlCommand(query, announcementAdapter.Connection); SqlDataAdapter getDataAdapter = new SqlDataAdapter(getDataCmd); getDataAdapter.Fill(dt); } catch (Exception ex) { Log.ErrorLog(ex.Message); return View("Error"); } return View(dt); }