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