public ResultBase <ManagePostModel> AddUpdatePublicPost(ManagePostModel managePostModel)
{
var result = new ResultBase <ManagePostModel> {
IsSuccess = false
};
var Session = _sessionHelper.GetDecodedSession();
try
{
using (SqlConnection sqlConnection = Utils.Utils.GetConnection(_configuration))
{
using (SqlCommand cmd = new SqlCommand("PR_POST_PublicPost_Insert", sqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ImageName", managePostModel.ImageName);
cmd.Parameters.AddWithValue("@CategoryID", managePostModel.PostCategory);
cmd.Parameters.AddWithValue("@PostedDateTime", DateTime.Now);
cmd.Parameters.AddWithValue("@QuoteText", managePostModel.QuoteText);
cmd.Parameters.AddWithValue("@IsActive", true);
cmd.Parameters.AddWithValue("@UserName", Session.UserName);
cmd.Parameters.AddWithValue("@UserID", Session.UserID);
int PostID = cmd.ExecuteNonQuery();
if (PostID > 0)
{
_tagsBll.AddEditTags(managePostModel.Tags, PostID);
result.Result = managePostModel;
result.IsSuccess = true;
result.Message = "Your Record has been Saved";
}
else
{
result.Message = "Something went wrong please try again letter";
}
}
}
}
catch (Exception ex)
{
result.Message = "Something Went Wring while Saving record. Please try again letter." + ex.Message;
}
return(result);
}
public async Task <IActionResult> ManageQuotes(ManagePostModel sampleImageModel)
{
var path = Path.Combine(_hostingEnvironment.WebRootPath, @"Assets/Image/UserUploadedImages/");
string fileName = DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + Path.GetExtension(sampleImageModel.ImageContent.FileName);
var FileSaveLocation = path + fileName;
if (sampleImageModel.ImageContent != null)
{
using (Stream fileStream = new FileStream(FileSaveLocation, FileMode.Create))
{
await sampleImageModel.ImageContent.CopyToAsync(fileStream);
}
}
else
{
//Select existing uploaded image
}
sampleImageModel.ImageName = DrawOverImageBll.DrawTextOverImage(sampleImageModel.QuoteText, FileSaveLocation, sampleImageModel.Position, sampleImageModel.FontColor, sampleImageModel.FontSize);
_quotesBll.AddUpdatePublicPost(sampleImageModel);
return(RedirectToAction("Index", "Home"));
}
public JsonResult GetListPost()
{
var currentPage = 1;
var status = -1;
var keyword = string.Empty;
var pageSize = (Request["pagination[perpage]"] != null) ? Utils.ConvertToInt32(Request["pagination[perpage]"]) : SystemSettings.DefaultPageSize;
if (Request["pagination[page]"] != null)
{
currentPage = Utils.ConvertToInt32(Request["pagination[page]"], 1);
}
if (Request["query[Status]"] != null)
{
status = Utils.ConvertToInt32(Request["query[Status]"], -1);
}
if (Request["query[generalSearch]"] != null)
{
keyword = Request["query[generalSearch]"].ToString();
}
var model = new ManagePostModel();
model.meta = new CommonMetaPagingModel();
model.meta.field = Request["sort[field]"];
model.meta.sort = Request["sort[sort]"];
var filter = new IdentityPost
{
//Name = !string.IsNullOrEmpty(model.Name) ? model.Name.Trim() : null,
//Phone = !string.IsNullOrEmpty(model.Phone) ? model.Phone.Trim() : null,
//Code = !string.IsNullOrEmpty(model.Code) ? model.Code.Trim() : null,
//FromDate = string.IsNullOrEmpty(model.FromDate) ? null : (DateTime?)DateTime.ParseExact(model.FromDate, ManagePostModel.DATETIME_FORMAT, null),
//ToDate = string.IsNullOrEmpty(model.ToDate) ? null : (DateTime?)DateTime.ParseExact(model.ToDate, ManagePostModel.DATETIME_FORMAT, null),
Keyword = keyword,
PageIndex = currentPage,
PageSize = pageSize,
SortField = model.meta.field,
SortType = model.meta.sort,
Status = status
};
try
{
model.data = _mainStore.GetByPage(filter);
model.meta.perpage = pageSize;
if (model.data != null && model.data.Count > 0)
{
model.meta.total = model.data[0].TotalCount;
model.meta.page = currentPage;
model.meta.pages = (int)Math.Ceiling((double)model.meta.total / (double)model.meta.perpage);
}
if (model.data.HasData())
{
foreach (var item in model.data)
{
item.Cover = SocialCdnHelper.GetFullImgPath(item.Cover);
item.CreatedDateLabel = item.CreatedDate.DateTimeQuestToString();
foreach (var type in Enum.GetValues(typeof(EnumPostType)))
{
if ((int)type == item.PostType)
{
item.PostTypeLabel = EnumExtensions.GetEnumDescription((Enum)type);
}
}
}
}
return(Json(new { data = model.data, meta = model.meta }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
this.AddNotification(NotifSettings.Error_SystemBusy, NotificationType.ERROR);
logger.Error("Failed to GetListPost because: " + ex.ToString());
}
return(Json(new { model }, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(ManagePostModel model)
{
return(View(model));
}
