public ActionResult Search(string searchText) { var response = new JsonResponse(); List <NewsItem> model = new List <NewsItem>(); try { using (var cxt = new NewsDataContext()) { model = Mapper.Map <List <News>, List <NewsItem> >(cxt.News.ToList() .Where(x => x.Name.Contains(searchText)).ToList()); if (model.Count != 0) { response.Success = true; response.Result = "Success"; } else { response.Result = "List is empty"; } } } catch (Exception e) { response.Result = e.Message; } return(PartialView("ListNews", model)); }
private void RSSForNews(int UserModuleID, string URL, XmlTextWriter RssWriter, int TotalCount) { NewsDataContext db = new NewsDataContext(SystemSetting.SageFrameConnectionString); var Newslist = db.sp_NewsRSSList(UserModuleID, GetPortalID, TotalCount); foreach (sp_NewsRSSListResult News in Newslist) { //Build Item tags with the data from database RssWriter.WriteStartElement("item"); RssWriter.WriteElementString("title", News.NewsTitle + Environment.NewLine); // RssWriter.WriteElementString("Short Description", News.NewsShortDescription + Environment.NewLine); RssWriter.WriteElementString("description", News.NewsLongDescription + Environment.NewLine); if (URL.Contains("?")) { RssWriter.WriteElementString("link", URL + "&NewsID=" + News.NewsID); } else { RssWriter.WriteElementString("link", URL + "?NewsID=" + News.NewsID); } RssWriter.WriteElementString("pubDate", News.NewsDate.ToString()); // RssWriter.WriteElementString("Added By", News.AddedBy); RssWriter.WriteEndElement(); } }
public JsonResult CreateNews(NewsModel model) { var response = new JsonResponse(); News newModel = null; try { using (var cxt = new NewsDataContext()) { newModel = Mapper.Map <NewsModel, News>(model); newModel.Theme = new Theme() { Name = model.ThemeName }; cxt.News.Add(newModel); response.Success = true; response.Result = "Success"; cxt.SaveChanges(); } } catch (Exception e) { response.Result = e.Message; } RedirectToAction("Index"); return(Json(response)); }
public void GetRelatedPics() { string newsCode = Request["Code"]; int NewsCode; Int32.TryParse(newsCode, out NewsCode); if (NewsCode != 0) { op_result _op_result = new op_result(); NewsDataContext dataContext = new NewsDataContext(); var Result = (from p in dataContext.vRelatedNews where p.EntityCode.Equals(NewsCode) && p.PicName != null && p.PicName != "" select new { p.Code, p.Title, p.ImgUrl }).Take(16); string strResult = ""; foreach (var item in Result) { strResult += "<li><a href='https://www.khabardaan.ir/News/" + item.Code + ".html' ><img class='img-fluid' title='" + item.Title + "' alt='" + item.Title + "' src='" + item.ImgUrl + "'/></a></li>"; } _op_result.result = strResult; _op_result.success = "1"; JavaScriptSerializer serializer = new JavaScriptSerializer(); string json = serializer.Serialize((object)_op_result); Response.Write(json); Response.End(); } }
public JsonResult DeleteNews(long id) { var response = new JsonResponse(); try { using (var cxt = new NewsDataContext()) { News newsModel = null; newsModel = cxt.News.Find(id); if (newsModel != null) { cxt.News.Remove(newsModel); response.Success = true; response.Result = "Success"; cxt.SaveChanges(); } response.Result = "Элемент не найден"; } } catch (Exception e) { response.Result = "Error" + e.Message; } return(Json(response)); }
public ActionResult Index(int page = 1) { var pageSize = 3; List <NewsItem> newsList = new List <NewsItem>(); try { using (var ctx = new NewsDataContext()) { newsList = Mapper.Map <IEnumerable <News>, List <NewsItem> >(ctx.News.ToList()); } } catch (Exception e) { Console.WriteLine(e); throw; } IEnumerable <NewsItem> newsPerPages = newsList.Skip((page - 1) * pageSize).Take(pageSize); PageInfo pageInfo = new PageInfo { PageNumber = page, PageSize = pageSize, TotalItems = newsList.Count }; IndexViewModel model = new IndexViewModel { PageInfo = pageInfo, News = newsPerPages }; return(View(model)); }
public ActionResult NewsEdit(long id) { var model = new NewsModel(); try { using (var ctx = new NewsDataContext()) { var entityNew = ctx.News .Include("Source") .Include("Theme") .FirstOrDefault(s => s.Id == id); if (entityNew == null) { throw new Exception(""); } model = Mapper.Map <News, NewsModel>(entityNew); model.Source = ctx.Sources.ToDictionary(key => key.Id, value => value.Name); } } catch (Exception) { throw; } return(View(model)); }
public int InsertfromResourceSites(int?ZoneCode, int?SiteCode, int?HCResourceSiteCatCode, string Title, string Url, DateTime NewsDate, string Contents, string ImgUrl, string PicName, int LanguageCode) { int? ReturnNewsCode = 0; NewsDataContext dc = new NewsDataContext(); dc.spInsertNews(SiteCode, HCResourceSiteCatCode, Title, Url, NewsDate, Contents, ImgUrl, PicName, LanguageCode, ref ReturnNewsCode); return((int)ReturnNewsCode); }
// GET: Angular public JsonResult getAll() { using (NewsDataContext dataContext = new NewsDataContext()) { var listGhichu = dataContext.GhiChus.ToList(); return(Json(listGhichu, JsonRequestBehavior.AllowGet)); } }
public bool CheckNewsExists(string NewsUrl, int ResourceSiteCatCode) { NewsDataContext dc = new NewsDataContext(); IQueryable <News> Result = from n in dc.News where n.Url.Equals(NewsUrl) && n.ResouceSiteCatCode.Equals(ResourceSiteCatCode) select n; return(Result.Count() > 0); }
protected void btnDelete_Click(object sender, EventArgs e) { if (ViewState["Code"] != null) { int Code = Convert.ToInt32(ViewState["Code"]); NewsDataContext dc = new NewsDataContext(); dc.spDeleteNews(Code); msgBox.Text = "خبر مورد نظر حذف شد"; } }
internal object GetLatest10News() { HttpContext context = HttpContext.Current; if (context.Cache["GetLatest10News"] == null) { dataContext = new NewsDataContext(); IQueryable <vLatestNews> Result = dataContext.vLatestNews.OrderByDescending(p => p.Code).Take(30); context.Cache.Insert("GetLatest10News", Result, null, DateTime.Now.AddMinutes(CachingTime), TimeSpan.Zero); } return((IQueryable <vLatestNews>)context.Cache["GetLatest10News"]); }
public int InsertNewRecord(int NewsCode, int NewsFlowCode) { NewsDataContext dc = new NewsDataContext(); NewsNewsFlows ObjTable = new NewsNewsFlows(); dc.NewsNewsFlows.InsertOnSubmit(ObjTable); ObjTable.NewsCode = NewsCode; ObjTable.NewsFlowCode = NewsFlowCode; dc.SubmitChanges(); return(ObjTable.Code); }
// GET: rssNews //public ActionResult Index() //{ // return View(); //} public ActionResult LoadData() { try { //Creating instance of DatabaseContext class using (NewsDataContext _context = new NewsDataContext()) { var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault(); //Paging Size (10,20,50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; // Getting all Customer data var customerData = (from tempcustomer in _context.rssNews select tempcustomer); //Sorting if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir))) { customerData = customerData.OrderBy(o => o.Title); } //Search if (!string.IsNullOrEmpty(searchValue)) { customerData = customerData.Where(m => m.Title.Equals(searchValue)); } //total number of rows count recordsTotal = customerData.Count(); //Paging var data = customerData.Skip(skip).Take(pageSize).ToList(); //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data })); } } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { NewsDataContext dc = new NewsDataContext(); var NList = from n in dc.News select n; foreach (News CurNews in NList) { CurNews.ConvertedContent = ChangeText(CurNews.Contents); dc.SubmitChanges(); } string Text = "متن تستی برای آزمایش"; string r = ChangeText(Text); }
private String GetPageName() { NewsDataContext db = new NewsDataContext(SystemSetting.SageFrameConnectionString); string pageName = string.Empty; var News = db.sp_NewsSettingGetAll(usermoduleID, GetPortalID); foreach (sp_NewsSettingGetAllResult setting in News) { switch (setting.SettingKey) { case "MoreNewsPageName": pageName = setting.SettingValue; break; } } return(pageName); }
protected void Page_Load(object sender, EventArgs e) { string strCode = Request["Code"]; int Code = 0; Int32.TryParse(strCode, out Code); if (Code != 0) { NewsDataContext dc = new NewsDataContext(); Khabardaan.Code.DAL.News CurNews = dc.News.Single(p => p.Code.Equals(Code)); if (CurNews != null) { ViewState["Code"] = Code; txtTitle.Text = CurNews.Title; } } }
private string ReadNewsDateFormatSetting(DateTime NewsDate) { NewsDataContext db = new NewsDataContext(SystemSetting.SageFrameConnectionString); string newsDateFormat = string.Empty; var News = db.sp_NewsSettingGetAll(usermoduleID, GetPortalID); foreach (sp_NewsSettingGetAllResult setting in News) { switch (setting.SettingKey) { case "NewsDateFormat": newsDateFormat = setting.SettingValue; newsDateFormat = NewsDate.ToString(newsDateFormat); break; } } return(newsDateFormat); }
public ActionResult CreateNews() { var model = new NewsModel(); try { using (var ctx = new NewsDataContext()) { model.Source = ctx.Sources.ToDictionary(key => key.Id, value => value.Name); } } catch (Exception e) { Console.WriteLine(e); throw; } return(View(model)); }
//private void AddImageUrls() //{ // imgltr.ImageUrl = GetTemplateImageUrl("lt-r.gif", true); // imbrtr.ImageUrl = GetTemplateImageUrl("rt-r.gif", true); // imblbr.ImageUrl = GetTemplateImageUrl("lb-r.gif", true); // imbrbr.ImageUrl = GetTemplateImageUrl("rb-r.gif", true); //} private void BindNews() { try { NewsDataContext db = new NewsDataContext(SystemSetting.SageFrameConnectionString); HiddenField hdnMoreNewsText = new HiddenField(); var newSetting = db.sp_NewsSettingGetAll(usermoduleID, GetPortalID); foreach (sp_NewsSettingGetAllResult setting in newSetting) { switch (setting.SettingKey) { case "NewsModuleTitle": lblNewsModuleTitle.Text = setting.SettingValue.Trim(); break; case "MoreNewsText": hdnMoreNewsText.Value = setting.SettingValue.Trim(); break; } } StringBuilder strContent = new StringBuilder(); var news = db.sp_NewsList(usermoduleID, GetPortalID); DataTable dt = comm.LINQToDataTable(news); for (int i = 0; i < dt.Rows.Count; i++) { HiddenField hdfNewsID = new HiddenField(); hdfNewsID.Value = dt.Rows[i]["NewsID"].ToString(); //strContent.Append("<div class=\"cssClassnews\">"); strContent.Append("<div class=\"cssClassNewsItem\">"); strContent.Append("<h2><a href='" + SetNewsUrl(hdfNewsID.Value) + "'>" + dt.Rows[i]["NewsTitle"].ToString() + "</a></h2>"); strContent.Append("<span>" + ReadNewsDateFormatSetting(DateTime.Parse(dt.Rows[i]["NewsDate"].ToString())) + "</span>"); strContent.Append("<p>" + ReadMoreContent(dt.Rows[i]["NewsShortDescription"].ToString()) + "</p>"); strContent.Append("</div>"); } strContent.Append("<p class=\"cssClassMore\">"); strContent.Append("<a href='" + SetNewsUrl(string.Empty) + "'>" + hdnMoreNewsText.Value + "</a>"); strContent.Append("</p>"); lblNews.Text = strContent.ToString(); } catch (Exception ex) { ProcessException(ex); } }
internal object GetMostVisited24h(int TakeCount) { HttpContext context = HttpContext.Current; int CachingTime = 120; try{ if (context.Cache["GetMostVisited24h" + TakeCount] == null) { dataContext = new NewsDataContext(); IQueryable <vMVNews24h> Result = dataContext.vMVNews24hs.Take(TakeCount); context.Cache.Insert("GetMostVisited24h" + TakeCount, Result, null, DateTime.Now.AddMinutes(CachingTime), TimeSpan.Zero); } return((IQueryable <vMVNews24h>)context.Cache["GetMostVisited24h" + TakeCount]); } catch { context.Cache["GetMostVisited4h" + TakeCount] = null; return(null); } }
internal IQueryable <vNews> LoadPicNews(int TakeCount) { HttpContext context = HttpContext.Current; int CachingTime = 120; try { if (context.Cache["LoadPicNews" + TakeCount] == null) { dataContext = new NewsDataContext(); IQueryable <vNews> Result = dataContext.vNews.Where(p => p.PicName != null && p.PicName != "").OrderByDescending(p => p.Code).Take(TakeCount); context.Cache.Insert("LoadPicNews" + TakeCount, Result, null, DateTime.Now.AddMinutes(CachingTime), TimeSpan.Zero); } return((IQueryable <vNews>)context.Cache["LoadPicNews" + TakeCount]); } catch { context.Cache["LoadPicNews" + TakeCount] = null; return(null); } }
//private void AddImageUrls() //{ // imgltr.ImageUrl = GetTemplateImageUrl("lt-r.gif", true); // imbrtr.ImageUrl = GetTemplateImageUrl("rt-r.gif", true); // imblbr.ImageUrl = GetTemplateImageUrl("lb-r.gif", true); // imbrbr.ImageUrl = GetTemplateImageUrl("rb-r.gif", true); //} private void BindNews() { try { NewsDataContext db = new NewsDataContext(SystemSetting.SageFrameConnectionString); HiddenField hdnMoreNewsText = new HiddenField(); var newSetting = db.sp_NewsSettingGetAll(usermoduleID, GetPortalID); foreach (sp_NewsSettingGetAllResult setting in newSetting) { switch (setting.SettingKey) { case "MoreNewsText": hdnMoreNewsText.Value = setting.SettingValue.Trim(); break; } } StringBuilder strContent = new StringBuilder(); var news = db.sp_NewsList(usermoduleID, GetPortalID); DataTable dt = comm.LINQToDataTable(news); for (int i = 0; i < dt.Rows.Count; i++) { HiddenField hdfNewsID = new HiddenField(); hdfNewsID.Value = dt.Rows[i]["NewsID"].ToString(); //strContent.Append("<div class=\"cssClassnews\">"); strContent.Append("<div class=\"sfNewsitem\">"); strContent.Append("<h3><a href='" + SetNewsUrl(hdfNewsID.Value) + "'>" + dt.Rows[i]["NewsTitle"].ToString() + "</a></h3>"); strContent.Append("<span class='sfNewsdate'>" + ReadNewsDateFormatSetting(DateTime.Parse(dt.Rows[i]["NewsDate"].ToString())) + "</span>"); strContent.Append("<p>" + ReadMoreContent(dt.Rows[i]["NewsShortDescription"].ToString()) + "</p>"); strContent.Append("</div>"); } strContent.Append("<a class='sfBtn' href='" + SetNewsUrl(string.Empty) + "'>" + hdnMoreNewsText.Value + "</a>"); lblNews.Text = strContent.ToString(); } catch (Exception ex) { ProcessException(ex); } }
public JsonResult NewsEdit(NewsModel model) { var response = new JsonResponse(); var newModel = new News(); try { using (var ctx = new NewsDataContext()) { newModel = Mapper.Map <NewsModel, News>(model); ctx.Entry(newModel).State = EntityState.Modified; response.Success = true; response.Result = "Success"; ctx.SaveChanges(); } } catch (Exception e) { response.Result = "Error" + e.Message; } RedirectToAction("Index"); return(Json(response)); }
private String GetPageName() { NewsDataContext db = new NewsDataContext(SystemSetting.SageFrameConnectionString); string pageName = string.Empty; var News = db.sp_NewsSettingGetAll(usermoduleID, GetPortalID); foreach (sp_NewsSettingGetAllResult setting in News) { switch (setting.SettingKey) { case "MoreNewsPageName": pageName = setting.SettingValue; break; } } return pageName; }
private string ReadNewsDateFormatSetting(DateTime NewsDate) { NewsDataContext db = new NewsDataContext(SystemSetting.SageFrameConnectionString); string newsDateFormat = string.Empty; var News = db.sp_NewsSettingGetAll(usermoduleID, GetPortalID); foreach (sp_NewsSettingGetAllResult setting in News) { switch (setting.SettingKey) { case "NewsDateFormat": newsDateFormat = setting.SettingValue; newsDateFormat = NewsDate.ToString(newsDateFormat); break; } } return newsDateFormat; }
public GetAllRssSourselHendler(NewsDataContext dbContext, IMapper mapper) { _dbContext = dbContext; _mapper = mapper; }
public CategoryRepository(NewsDataContext newsDataContext) : base(newsDataContext) { }
public RepositoryUnitOfWork(NewsDataContext newsDataContextWrapper) { _newsDataContextWrapper = newsDataContextWrapper; }
public CountryRepository(NewsDataContext newsDataContext) : base(newsDataContext) { }
public PhoneRepository(NewsDataContext newsDataContext) : base(newsDataContext) { }
public GetRoleByUserQueryHendler(NewsDataContext dbContext) { _dbContext = dbContext; }
public UserRepository(NewsDataContext newsDataContext) : base(newsDataContext) { }