public IActionResult InsertUser(Users _User)
{
var res = 0;
var user = HttpContext.Session.GetObjectFromJson <Users>("User");
if (user == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
if (!dbContext.CheckUserName(_User.Username))
{
_User.Password = Cipher.Encrypt(_User.Password, _User.Username);
res = dbContext.InsertUser(_User);
}
else
{
res = -69;
}
}
catch (Exception ex)
{
HandleException(user.UserId, "InsertUser", ex);
}
return(Ok(res.ToString()));
}
}
public IActionResult UpdateUser(Users _User)
{
var res = 0;
var user = HttpContext.Session.GetObjectFromJson <Users>("User");
if (user == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
dbContext.UpdateUser(_User);
}
catch (Exception ex)
{
HandleException(user.UserId, "UpdateUser", ex);
}
return(Ok(res));
}
}
public IActionResult SaveNews(News news)
{
var res = "";
var user = HttpContext.Session.GetObjectFromJson <Users>("User");
if (user == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
if (news.Mode.Equals("add"))
{
news.CreationUserId = user.UserId;
dbContext.InsertNews(news);
}
else if (news.Mode.Equals("edit"))
{
news.UpdateUserId = user.UserId;
dbContext.UpdateNews(news);
}
}
catch (Exception ex)
{
HandleException(user.UserId, "SaveNews", ex);
}
}
return(Ok(res));
}
public bool DeleteVideo(News news)
{
var deleted = false;
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
//var rootPath = hostingEnvironment.ContentRootPath;
var wwwPath = hostingEnvironment.WebRootPath;
var videoPath = news.VideoPath.Replace(_baseURL, "");
//videoPath = videoPath.Replace("/", "\\");
//var physicalPath = wwwPath + videoPath;
var provider = new PhysicalFileProvider(wwwPath);
var fileInfo = provider.GetFileInfo(videoPath);
if (fileInfo.Exists)
{
System.IO.File.Delete(fileInfo.PhysicalPath);
dbContext.DeleteVideo(news.Id);
deleted = true;
}
}
catch (Exception ex)
{
var _User = HttpContext.Session.GetObjectFromJson <Users>("User");
HandleException(_User.UserId, "DeleteVideo", ex);
}
return(deleted);
}
public DatatableData <News> GetNewsRecords(Nullable <int> start, Nullable <int> length, string sortDirVal, string sortCol)
{
using (var ctx = new TimesOfLebanonContext())
{
return(ctx.GetNewsRecords(start, length, sortDirVal, sortCol));
}
}
public JsonResult GetNewsRecords()
{
var lst = new DatatableData <News>();
var vdata = new DatatableData <News>();
try
{
dynamic obj = null;
int start = 0;
int length = 0;
string searchVal = "";
string sortDirVal = "";
int sortVal = 0;
string sortCol = "";
int tableLength = 0;
MemoryStream stream = new MemoryStream();
Request.Body.CopyTo(stream);
stream.Position = 0;
using (StreamReader reader = new StreamReader(stream))
{
string requestBody = reader.ReadToEnd();
if (requestBody.Length > 0)
{
obj = JsonConvert.DeserializeObject(requestBody);
if (obj != null)
{
searchVal = obj.parameters.search.value;
start = obj.parameters.start;
length = obj.parameters.length;
sortDirVal = obj.parameters.order.First.dir;
sortVal = obj.parameters.order.First.column;
sortCol = obj.parameters.columns[sortVal].name;
if (sortCol == "")
{
sortCol = "CreationDate";
}
tableLength = obj.parameters.columns.Count;
}
}
}
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
var Helper = new Helper();
lst = Helper.GetNewsRecords(start, length, sortDirVal, sortCol);
vdata = lst;
vdata.draw = obj.parameters.draw;
}
catch (Exception ex)
{
var _User = HttpContext.Session.GetObjectFromJson <Users>("User");
HandleException(_User.UserId, "GetNewsRecords", ex);
}
return(new JsonResult(vdata));
}
public void HandleException(Int32 UserId, string ActionName, Exception ex)
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
ExceptionModel model = new ExceptionModel();
model.ActionName = ActionName;
model.Exception = ex.StackTrace;
model.Message = ex.Message;
model.UserId = UserId;
dbContext.InsertException(model);
}
public IActionResult GetNewsById(News news)
{
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
news = dbContext.GetNewsById(news.Id);
}
catch (Exception ex)
{
throw ex;
}
return(Ok(news));
}
public JsonResult GetNewsById(News news)
{
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
news = dbContext.GetNewsById(news.Id);
}
catch (Exception ex)
{
var _User = HttpContext.Session.GetObjectFromJson <Users>("User");
HandleException(_User.UserId, "GetNewsById", ex);
}
return(new JsonResult(news));
}
public IActionResult GetTodayNews()
{
List <News> list = null;
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
list = dbContext.GetTodayNews();
}
catch (Exception ex)
{
throw ex;
}
return(Ok(list));
}
public IActionResult GetCategories()
{
List <Category> list = null;
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
list = dbContext.GetCategories();
}
catch (Exception ex)
{
var _User = HttpContext.Session.GetObjectFromJson <Users>("User");
HandleException(_User.UserId, "GetCategories", ex);
}
return(Ok(list));
}
public IActionResult GetUsersList()
{
var list = new List <Users>();
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
list = dbContext.GetUsersList();
}
catch (Exception ex)
{
var user = HttpContext.Session.GetObjectFromJson <Users>("User");
HandleException(user.UserId, "GetUsersList", ex);
}
return(Ok(list));
}
public IActionResult GetUser()
{
var UserId = Convert.ToInt32(Request.Query["UserId"]);
Users user = null;
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
user = dbContext.GetUser(UserId);
}
catch (Exception ex)
{
var _User = HttpContext.Session.GetObjectFromJson <Users>("User");
HandleException(_User.UserId, "GetUser", ex);
}
return(Ok(user));
}
public bool DeletePhoto(News news)
{
var deleted = false;
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
dbContext.DeletePhoto(news.Id);
deleted = true;
}
catch (Exception ex)
{
var _User = HttpContext.Session.GetObjectFromJson <Users>("User");
HandleException(_User.UserId, "DeletePhoto", ex);
}
return(deleted);
}
public IActionResult ChangeUserPassword(UserCriteria criteria)
{
var res = "";
var user = HttpContext.Session.GetObjectFromJson <Users>("User");
if (user == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
try
{
if (!Cipher.Encrypt(criteria.OldPassword, user.Username).Equals(user.Password))
{
res = "Error: your old password is incorrect!";
}
else
{
if (!criteria.NewPassword.Equals(criteria.ConfirmPassword))
{
res = "Passwords don't match!";
}
else
{
string password = criteria.NewPassword;
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
dbContext.ChangePassword(user.UserId, Cipher.Encrypt(password, user.Username));
res = "true";
}
}
}
catch (Exception ex)
{
res = ex.Message;
}
return(Ok(res));
}
}
public IActionResult SetPassword(Users _User)
{
var user = HttpContext.Session.GetObjectFromJson <Users>("User");
if (user == null)
{
return(RedirectToAction("Login", "Login"));
}
else
{
try
{
TimesOfLebanonContext dbContext = new TimesOfLebanonContext();
_User.Password = Cipher.Encrypt(_User.Password, _User.Username);
dbContext.SetPassword(_User);
}
catch (Exception ex)
{
HandleException(user.UserId, "SetPassword", ex);
}
return(Ok(null));
}
}
