public JsonResult ApprovePost(int?Id) { try { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { var currentUser = (ClaimsPrincipal)Thread.CurrentPrincipal; var UserId = currentUser.Claims.Where(x => x.Type == ClaimTypes.PrimarySid).Select(c => c.Value).SingleOrDefault(); NewsPost newsPost = portalEntities.NewsPosts.Where(x => x.Id == Id).FirstOrDefault(); newsPost.IsReviewed = true; newsPost.ReviewedBy = int.Parse(UserId);; portalEntities.NewsPosts.Attach(newsPost); portalEntities.Entry(newsPost).State = EntityState.Modified; portalEntities.SaveChanges(); string category = newsType.GetByID(x => x.Id == newsPost.CategoryId).NewsType; var webadrs = ConfigurationManager.AppSettings["webid"]; Task.Factory.StartNew(() => new apiPlugin().pagePublish(newsPost.OdiaTitle, (webadrs + "/News/" + category + "/" + newsPost.PostedYear + "/" + newsPost.PostedMonth + "/" + Id + "/" + newsPost.SlugUrl))); } Task.Factory.StartNew(() => new NewsOprations().UpdateData()); return(Json(new { msg = "Post Approved Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Log.Error(ex.ToString()); } return(Json(new { msg = "Post Approve Unsucessful" }, JsonRequestBehavior.AllowGet)); }
public void UpdateData() { try { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { var item = portalEntities.Database.SqlQuery <int>("usp_LatestPopular"); } } catch (Exception ex) { Log.Error(ex.ToString()); } }
public int CheckRoleName(string RoleName) { try { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { var items = portalEntities.tblRoles.Where(x => x.RoleName == RoleName).ToList().Count; return(items); } } catch (Exception ex) { } return(0); }
public int CheckNewsType(string NewsType) { try { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { var items = portalEntities.tblNewsType.Where(x => x.NewsType == NewsType).ToList().Count; return(items); } } catch (Exception ex) { } return(0); }
public clsUser getCurrentUserId(int userId) { try { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { var item = portalEntities.Database.SqlQuery <clsUser>("usp_GetUser @UserId", new SqlParameter("@UserId", userId)).FirstOrDefault(); return(item); } } catch (Exception ex) { Log.Error(ex.ToString()); } return(null); }
public JsonResult GetTopicData(int?Id) { try { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { var item = (from news in portalEntities.NewsPosts where news.Id == Id select new { news.OdiaTitle, news.Tags, news.SeoMeta, news.PostedOn, news.ODShortDesc, news.EnglishTitle, news.ODContent }).FirstOrDefault(); return(Json(item, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { Log.Error(ex.ToString()); } return(null); }
public async Task Execute(IJobExecutionContext context) { Log.Info("Job was getting called"); try { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { using (SqlConnection connection = new SqlConnection(portalEntities.Database.Connection.ConnectionString)) { var item = portalEntities.SchdulePostConfig.ToList(); foreach (var lvltem in item) { if (lvltem.ScheduleTime <= DateTime.Now) { try { SqlCommand cmd = new SqlCommand("usp_AutoPublish", connection); cmd.Parameters.Add("@PostId", SqlDbType.Decimal).Value = lvltem.PostId; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 90; if (connection.State == ConnectionState.Closed) { connection.Open(); } int i = cmd.ExecuteNonQuery(); connection.Close(); } catch (Exception ex) { Log.Error("Error Inside Loop", ex); } } Thread.Sleep(1000); } } } } catch (Exception ex) { Log.Error(ex); } }
public ActionResult LoginUser(Users _user) { using (NewsPortalEntities dBEntities = new NewsPortalEntities()) { var userexist = dBEntities.tblUses.Where(x => x.UserName == _user.UserName && x.Password == _user.Password).ToList(); if (userexist.Count == 0) { return(View("Home", "About")); } var identity = new ClaimsIdentity(new[] { new Claim(ClaimTypes.Sid, userexist.FirstOrDefault().UserName), new Claim(ClaimTypes.Email, userexist.FirstOrDefault().EmailId), new Claim(ClaimTypes.MobilePhone, userexist.FirstOrDefault().PhoneNo), }, "ApplicationCookie"); var ctx = Request.GetOwinContext(); var authManager = ctx.Authentication; authManager.SignIn(identity); } return(View()); }
public decimal NewsPost(ClsPost objclsPost) { try { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { NewsPost newsPost = new NewsPost(); newsPost.EnglishTitle = objclsPost.EnglishTitle; newsPost.OdiaTitle = objclsPost.OdiaTitle; newsPost.EngShortDesc = objclsPost.EngShortDesc; newsPost.ODShortDesc = objclsPost.ODShortDesc; newsPost.SeoMeta = objclsPost.SeoMeta; newsPost.Tags = objclsPost.Tags; newsPost.CategoryId = objclsPost.CategoryId; newsPost.HeaderImageName = objclsPost.ImageName; newsPost.ODContent = objclsPost.ODContent; newsPost.IsActive = true; newsPost.IsDeleted = false; newsPost.IsReviewed = objclsPost.IsReviewed; newsPost.CreatedBy = objclsPost.CreatedBy; newsPost.ReviewedBy = objclsPost.ReviewedBy; newsPost.PostedDate = objclsPost.PostedDate; newsPost.PostedOn = objclsPost.PostedOn; newsPost.PostedMonth = objclsPost.PostedMonth; newsPost.PostedYear = objclsPost.PostedYear; newsPost.SlugUrl = objclsPost.SlugUrl; newsPost.Thumbnail86 = objclsPost.ImageName.Replace("Img", "Thumbnail_86x64"); newsPost.Thumbnail210 = objclsPost.ImageName.Replace("Img", "Thumbnail_210x136"); newsPost.Thumbnail279 = objclsPost.ImageName.Replace("Img", "Thumbnail_279x220"); newsPost.Frequency = 0; portalEntities.NewsPosts.Add(newsPost); portalEntities.SaveChanges(); return(newsPost.Id); } } catch (Exception ex) { Log.Error(ex.ToString()); } return(0); }
public OpertionClass(NewsPortalEntities context) { this._context = context; this._table = _context.Set <T>(); }
public OpertionClass() { this._context = new NewsPortalEntities(); this._table = _context.Set <T>(); }
public ContentResult HeaderImageUpload() { NewsPost nps = new NewsPost(); try { int NewsId = 0; string FolderName = ""; string path = ""; if (Request.Params["newsID"] == "0") { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { NewsId = portalEntities.NewsPosts.Where(x => x.PostedDate.Value.Year == DateTime.Now.Year && x.PostedDate.Value.Month == DateTime.Now.Month && x.PostedDate.Value.Day == DateTime.Now.Day).ToList().Count; } NewsId = NewsId + 1; FolderName = DateTime.Now.Date.ToString("ddMMyyyy"); path = Server.MapPath("~/Uploads/" + FolderName + "/" + NewsId); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } } else { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { decimal newsID = Convert.ToDecimal(Request.Params["newsID"]); nps = portalEntities.NewsPosts.Where(x => x.Id == newsID).FirstOrDefault(); string ImageName = ""; if (nps != null) { DeleteImage(nps.HeaderImageName); ImageName = nps.HeaderImageName; FolderName = ImageName.Split('/')[0]; NewsId = int.Parse(ImageName.Split('/')[1]); } } path = Server.MapPath("~/Uploads/" + FolderName + "/" + NewsId); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } } string ImageUrl = ""; string filename = ""; string imgId = DateTime.Now.Hour + "" + DateTime.Now.Minute; foreach (string key in Request.Files) { HttpPostedFileBase postedFile = Request.Files[key]; ImageUrl = Path.Combine(path, "Img_" + imgId + ".jpg"); Stream strm = postedFile.InputStream; int flstatus = GenerateThumbnails(0.2, strm, ImageUrl, 400, 210); filename = postedFile.FileName; CreateThumbnail(postedFile, NewsId, FolderName, imgId); CreateThumbnail279(postedFile, NewsId, FolderName, imgId); CreateThumbnail210(postedFile, NewsId, FolderName, imgId); } if (Request.Params["newsID"] != "0") { string Image = FolderName + "/" + NewsId + "/" + "Img_" + imgId + ".jpg"; using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { decimal newsID = Convert.ToDecimal(Request.Params["newsID"]); NewsPost newsPost = portalEntities.NewsPosts.Where(x => x.Id == newsID).FirstOrDefault(); newsPost.HeaderImageName = Image; newsPost.Thumbnail86 = Image.Replace("Img", "Thumbnail_86x64"); newsPost.Thumbnail210 = Image.Replace("Img", "Thumbnail_210x136"); newsPost.Thumbnail279 = Image.Replace("Img", "Thumbnail_279x220"); portalEntities.NewsPosts.Attach(newsPost); portalEntities.Entry(newsPost).State = EntityState.Modified; portalEntities.SaveChanges(); } } return(Content(FolderName + "/" + NewsId + "/" + "Img_" + imgId + ".jpg")); } catch (Exception ex) { Log.Error(ex.ToString()); } return(null); }
public JsonResult UploadFile() { string ImageUrl = string.Empty; string filename = string.Empty; NewsPost nps = new NewsPost(); try { int NewsId = 0; string FolderName = ""; string path = ""; if (Request.Params["NewsId"] == "0") { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { NewsId = portalEntities.NewsPosts.Where(x => x.PostedDate.Value.Year == DateTime.Now.Year && x.PostedDate.Value.Month == DateTime.Now.Month && x.PostedDate.Value.Day == DateTime.Now.Day).ToList().Count; } NewsId = NewsId + 1; FolderName = DateTime.Now.Date.ToString("ddMMyyyy"); path = Server.MapPath("~/Uploads/" + FolderName + "/" + NewsId + "/Content"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } } else { using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { decimal newsID = Convert.ToDecimal(Request.Params["NewsId"]); nps = portalEntities.NewsPosts.Where(x => x.Id == newsID).FirstOrDefault(); string ImageName = ""; if (nps != null) { ImageName = nps.HeaderImageName; FolderName = ImageName.Split('/')[0]; NewsId = int.Parse(ImageName.Split('/')[1]); } } path = Server.MapPath("~/Uploads/" + FolderName + "/" + NewsId + "/Content"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } } string imgId = DateTime.Now.Minute + "" + DateTime.Now.Second; if (System.Web.HttpContext.Current.Request.Files.AllKeys.Any()) { var postedFile = System.Web.HttpContext.Current.Request.Files["Image"]; if (postedFile.ContentLength > 0) { ImageUrl = Path.Combine(path, "Img_" + imgId + ".jpg"); Stream strm = postedFile.InputStream; int flstatus = GenerateThumbnails(0.2, strm, ImageUrl, 400, 210); filename = HttpContext.Request.Url.Scheme + "://" + HttpContext.Request.Url.Authority + "/Uploads/" + FolderName + "/" + NewsId + "/Content/Img_" + imgId + ".jpg"; } } } catch (Exception ex) { Log.Error(ex.ToString()); } return(Json(Convert.ToString(filename), JsonRequestBehavior.AllowGet)); }
public JsonResult UpdatePost(ClsPost clsPost) { try { var currentUser = (ClaimsPrincipal)Thread.CurrentPrincipal; var UserId = currentUser.Claims.Where(x => x.Type == ClaimTypes.PrimarySid).Select(c => c.Value).SingleOrDefault(); var Role = currentUser.Claims.Where(x => x.Type == ClaimTypes.Role).Select(c => c.Value).SingleOrDefault(); clsPost.IsReviewed = false; if (clsPost.IsSchedule == false) { if (Role == "SuperAdmin" || Role == "Admin") { clsPost.ReviewedBy = int.Parse(UserId); clsPost.IsReviewed = true; } } clsPost.Modified = DateTime.Now; bool IsReviewed = false; using (NewsPortalEntities portalEntities = new NewsPortalEntities()) { NewsPost newsPost = portalEntities.NewsPosts.Where(x => x.Id == clsPost.Id).FirstOrDefault(); IsReviewed = newsPost.IsReviewed.Value; newsPost.EnglishTitle = clsPost.EnglishTitle; newsPost.OdiaTitle = clsPost.OdiaTitle; newsPost.EngShortDesc = clsPost.EngShortDesc; newsPost.ODShortDesc = clsPost.ODShortDesc; newsPost.SeoMeta = clsPost.SeoMeta; newsPost.Tags = clsPost.Tags; newsPost.CategoryId = clsPost.CategoryId; newsPost.HeaderImageName = clsPost.ImageName; newsPost.ODContent = clsPost.ODContent; newsPost.IsReviewed = clsPost.IsReviewed; newsPost.ReviewedBy = clsPost.ReviewedBy; newsPost.ModifiedOn = clsPost.Modified; newsPost.Thumbnail86 = clsPost.ImageName.Replace("Img", "Thumbnail_86x64"); newsPost.Thumbnail210 = clsPost.ImageName.Replace("Img", "Thumbnail_210x136"); newsPost.Thumbnail279 = clsPost.ImageName.Replace("Img", "Thumbnail_279x220"); newsPost.SlugUrl = UrlGenerator.GetUrl(clsPost.EnglishTitle); portalEntities.NewsPosts.Attach(newsPost); portalEntities.Entry(newsPost).State = EntityState.Modified; portalEntities.SaveChanges(); //if(IsReviewed==false) { if (Role == "SuperAdmin" || Role == "Admin") { string category = newsType.GetByID(x => x.Id == newsPost.CategoryId).NewsType; var webadrs = ConfigurationManager.AppSettings["webid"]; Task.Factory.StartNew(() => new apiPlugin().pagePublish(newsPost.OdiaTitle, (webadrs + "/News/" + category + "/" + newsPost.PostedYear + "/" + newsPost.PostedMonth + "/" + clsPost.Id + "/" + newsPost.SlugUrl))); } } } Task.Factory.StartNew(() => new NewsOprations().UpdateData()); if (clsPost.IsSchedule == true) { try { SchdulePostConfig schPostConfig = schulepostconfig.GetByID(x => x.PostId == clsPost.Id); if (schPostConfig != null) { schPostConfig.PostId = clsPost.Id; schPostConfig.PostedOn = DateTime.Now; schPostConfig.ScheduleTime = DateTime.Now.AddHours(clsPost.Delay); schPostConfig.TimeDelay = clsPost.Delay; schulepostconfig.Edit(schPostConfig); schulepostconfig.Save(); } else { SchdulePostConfig scPostConfig = new SchdulePostConfig(); scPostConfig.PostId = clsPost.Id; scPostConfig.PostedOn = DateTime.Now; scPostConfig.ScheduleTime = DateTime.Now.AddHours(clsPost.Delay); scPostConfig.TimeDelay = clsPost.Delay; schulepostconfig.Insert(scPostConfig); schulepostconfig.Save(); } } catch (Exception ex) { Log.Error("Update News schdule issue", ex); } } else { try { SchdulePostConfig schPostConfig = schulepostconfig.GetByID(x => x.PostId == clsPost.Id); if (schPostConfig != null) { schulepostconfig.Delete(x => x.PostId == clsPost.Id); schulepostconfig.Save(); } } catch (Exception ex) { Log.Error("Delete News schdule issue", ex); } } return(Json(new { msg = "Post Updated Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Log.Error(ex.ToString()); } return(Json(new { msg = "Post Updation Unsucessful" }, JsonRequestBehavior.AllowGet)); }