public JsonResult InsertNewAccount(Account obj)
{
CallStatus status = new CallStatus();
try
{
if (GenericHelper.IsAuthenticToken(obj.LoginId, obj.Token))
{
using (var context = new SpiralDomeDbContext())
{
context.Accounts.Add(obj);
context.SaveChanges();
}
status.IsSuccess = true;
}
else
{
throw new Exception("Invalid Authentication Token");
}
}
catch (Exception ex)
{
status.IsSuccess = false;
status.Message = ex.Message;
}
return(Json(status));
}
public JsonResult AddDocuments(Login login)
{
CallStatus status = new CallStatus();
try
{
string[] fileList = Directory.GetFiles(ConfigurationManager.AppSettings["DocumentPath"],
ConfigurationManager.AppSettings["DocumentType"]);
for (int i = 0; i < fileList.Length; i++)
{
var imageData = GenericHelper.ImageToByteArray(fileList[i]);
using (var context = new SpiralDomeDbContext())
{
DocumentImage obj = new DocumentImage()
{
ImageData = imageData,
Name = fileList[i].Split('\\')[fileList[i].Split('\\').Length - 1],
LoginId = login.LoginId
};
context.DocumentImages.Add(obj);
context.SaveChanges();
}
}
status.IsSuccess = true;
}
catch (Exception ex)
{
status.IsSuccess = false;
status.Message = ex.Message;
}
return(Json(status));
}
public JsonResult DeleteReminder(Reminder obj)
{
CallStatus status = new CallStatus();
try
{
if (GenericHelper.IsAuthenticToken(obj.LoginId, obj.Token))
{
using (var context = new SpiralDomeDbContext())
{
var res = (from reminder in context.Reminders
where reminder.Name.Trim() == obj.Name.Trim() && reminder.LoginId == obj.LoginId
select reminder).SingleOrDefault();
if (res != null)
{
context.Reminders.Remove(res);
context.SaveChanges();
status.IsSuccess = true;
}
}
}
else
{
throw new Exception("Invalid Authentication Token");
}
}
catch (Exception ex)
{
status.IsSuccess = false;
status.Message = ex.Message;
}
return(Json(status));
}
public JsonResult GetAccountDatabyLoginId(Login obj)
{
CallStatus status = new CallStatus();
try
{
if (GenericHelper.IsAuthenticToken(obj.LoginId, obj.Token))
{
using (var context = new SpiralDomeDbContext())
{
obj.SearchByName = obj.SearchByName == null ? "" : obj.SearchByName;
var res = (from account in context.Accounts
where account.LoginId == obj.LoginId && account.Name.Contains(obj.SearchByName)
select account).OrderBy(x => x.Name).ToList();
status.IsSuccess = true;
status.JsonObject = Json(res);
}
}
else
{
throw new Exception("Invalid Authentication Token");
}
}
catch (Exception ex)
{
status.IsSuccess = false;
status.Message = ex.Message;
}
return(Json(status));
}
public JsonResult GetDocumentsbyLoginId(Login obj)
{
CallStatus status = new CallStatus();
try
{
if (GenericHelper.IsAuthenticToken(obj.LoginId, obj.Token))
{
using (var context = new SpiralDomeDbContext())
{
obj.SearchByName = obj.SearchByName == null ? "" : obj.SearchByName;
var res =
obj.SearchByName == "" ?
(from document in context.DocumentImages
where document.LoginId == obj.LoginId && document.Name.Contains("Divorce") == false
select document).OrderBy(x => x.Name).ToList()
:
(from document in context.DocumentImages
where document.LoginId == obj.LoginId && document.Name.Contains(obj.SearchByName)
select document).OrderBy(x => x.Name).ToList()
;
foreach (var doc in res)
{
doc.ImageBase64 = Convert.ToBase64String(doc.ImageData);
}
status.IsSuccess = true;
status.JsonObject = Json(res);
}
}
else
{
throw new Exception("Invalid Authentication Token");
}
}
catch (Exception ex)
{
status.IsSuccess = false;
status.Message = ex.Message;
}
return(Json(status));
}
public JsonResult IsValidLogin(Login login)
{
var result = new CallStatus();
try
{
using (var context = new SpiralDomeDbContext())
{
var loginObj = (from user in context.Logins
where user.LoginId == login.LoginId.Trim() &&
user.Password == login.Password
select user).SingleOrDefault();
var isUserExists = loginObj != null;
if (isUserExists)
{
loginObj.LastModified = DateTime.UtcNow;
loginObj.Token = DateTime.Now.Ticks.ToString();
context.SaveChanges();
loginObj.LastModified = null;
loginObj.Password = null;
result.IsSuccess = true;
result.Message = "";
result.JsonObject = Json(loginObj);
}
else
{
throw new Exception("Invalid Username or Password");
}
}
}
catch (DbEntityValidationException e)
{
result.IsSuccess = false;
result.Message = Helper.GenericHelper.GetValidationMessage(e);
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(Json(result));
}
public JsonResult UpdateAccount(Account obj)
{
CallStatus status = new CallStatus();
try
{
if (GenericHelper.IsAuthenticToken(obj.LoginId, obj.Token))
{
using (var context = new SpiralDomeDbContext())
{
var res = (from account in context.Accounts
where account.Name.Trim() == obj.Name.Trim() && account.LoginId == obj.LoginId
select account).SingleOrDefault();
if (res != null)
{
res.Name = obj.Name;
res.Username = obj.Username;
res.Password = obj.Password;
res.Url = obj.Url;
res.Comment = obj.Comment;
context.SaveChanges();
}
else
{
return(InsertNewAccount(obj));
}
}
status.IsSuccess = true;
}
else
{
throw new Exception("Invalid Authentication Token");
}
}
catch (Exception ex)
{
status.IsSuccess = false;
status.Message = ex.Message;
}
return(Json(status));
}
public JsonResult UpdateReminder(Reminder obj)
{
CallStatus status = new CallStatus();
try
{
if (GenericHelper.IsAuthenticToken(obj.LoginId, obj.Token))
{
using (var context = new SpiralDomeDbContext())
{
var res = (from reminder in context.Reminders
where reminder.Name.Trim() == obj.Name.Trim() && reminder.LoginId == obj.LoginId
select reminder).SingleOrDefault();
if (res != null)
{
res.Name = obj.Name;
res.StartDate = obj.StartDate;
res.EndDate = obj.EndDate;
res.Group = obj.Group;
res.Comment = obj.Comment;
context.SaveChanges();
}
else
{
return(InsertNewReminder(obj));
}
}
status.IsSuccess = true;
}
else
{
throw new Exception("Invalid Authentication Token");
}
}
catch (Exception ex)
{
status.IsSuccess = false;
status.Message = ex.Message;
}
return(Json(status));
}
public JsonResult InsertLogin(Login login)
{
var result = new CallStatus();
try
{
using (var context = new SpiralDomeDbContext())
{
if (login.Password != login.ConfirmPassword)
{
throw new Exception("Passwords do not match");
}
var isUserExists = (from user in context.Logins
where user.LoginId == login.LoginId.Trim()
select user).SingleOrDefault() != null;
if (isUserExists)
{
throw new Exception("Login Id is already taken, please try again.");
}
context.Logins.Add(login);
context.SaveChanges();
result.IsSuccess = true;
}
}
catch (DbEntityValidationException e)
{
result.IsSuccess = false;
result.Message = Helper.GenericHelper.GetValidationMessage(e);
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(Json(result));
}
public JsonResult GetReminderDatabyLoginId(Login obj)
{
CallStatus status = new CallStatus();
try
{
if (GenericHelper.IsAuthenticToken(obj.LoginId, obj.Token))
{
using (var context = new SpiralDomeDbContext())
{
obj.SearchByName = obj.SearchByName == null ? "" : obj.SearchByName;
var res = (from account in context.Reminders
where account.LoginId == obj.LoginId && account.Name.Contains(obj.SearchByName)
select account).OrderBy(x => x.Group).ThenBy(x => x.Name).ToList();
for (int i = 0; i < res.Count(); i++)
{
res[i].StartDateGUI = String.Format("{0:MM/dd/yyyy}", res[i].StartDate);
res[i].EndDateGUI = String.Format("{0:MM/dd/yyyy}", res[i].EndDate);
}
status.IsSuccess = true;
status.JsonObject = Json(res);
}
}
else
{
throw new Exception("Invalid Authentication Token");
}
}
catch (Exception ex)
{
status.IsSuccess = false;
status.Message = ex.Message;
}
return(Json(status));
}
public static bool IsAuthenticToken(string loginid, string token)
{
var retVal = false;
using (var context = new SpiralDomeDbContext())
{
var res = (from login in context.Logins
where login.LoginId == loginid && login.Token == token
select login).SingleOrDefault();
if (res == null)
{
retVal = false;
}
else
{
retVal = true;
res.LastModified = DateTime.UtcNow;
context.SaveChanges();
}
}
return retVal;
}
