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)
{
}
