public ActionResult Read([DataSourceRequest] DataSourceRequest request) { log4net.Config.XmlConfigurator.Configure(); string whereCondition = ""; if (request.Filters.Count > 0) { whereCondition = " AND " + new KendoApplyFilter().ApplyFilter(request.Filters[0]); } var data = new Master_Announcement().GetPage(request.Page, request.PageSize, whereCondition, currentUser.UserID); return(Json(data)); }
public ActionResult Partial() { if (userAsset.ContainsKey("View") && userAsset["View"]) { IDbConnection dbConn = new OrmliteConnection().openConn(); var dict = new Dictionary <string, object>(); dict["asset"] = userAsset; dict["activestatus"] = new CommonLib().GetActiveStatus(); ViewData["listConfig_Announcement"] = new Master_Announcement().GetAllSort("", "CreatedAt", "DESC"); dbConn.Close(); return(PartialView("_Home", dict)); } else { return(RedirectToAction("LogOn", "Account")); } }
public ActionResult Create(Master_Announcement item) { //if (form.AllKeys.Contains("TextContent")) //{ // item.TextContent = form.Get("TextContent"); //} //CHECK IS NULL VALUE if (string.IsNullOrEmpty(item.TextContent)) { item.TextContent = ""; } if (string.IsNullOrEmpty(item.HTMLContent)) { item.HTMLContent = ""; } if (string.IsNullOrEmpty(item.Title)) { item.Title = ""; } IDbConnection dbConn = new OrmliteConnection().openConn(); try { var isExist = dbConn.GetByIdOrDefault <Master_Announcement>(item.AnnouncementID); if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Đối tượng này đã tồn tại." })); } item.CreatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; dbConn.Insert <Master_Announcement>(item); long lastInsertId = dbConn.GetLastInsertId(); dbConn.Close(); return(Json(new { success = true, AnnouncementID = lastInsertId, createdat = item.CreatedAt, createdby = item.CreatedBy })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; dbConn.Update <Master_Announcement>(item); dbConn.Close(); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "You don't have permission" })); } } catch (Exception ex) { log.Error("AD_Announcement - Create - " + ex.Message); return(Json(new { success = false, message = ex.Message })); } finally { dbConn.Close(); } }