/// <summary>
/// Update the history of the local user table
/// </summary>
/// <param name="userId"></param>
public static void updateLogUser(string userId)
{
UsersAutDataContext context = new UsersAutDataContext();
LocalUser Base = context.LocalUsers.Single(a => a.Email == userId);
Base.Updated_at = DateTime.Now;
context.SubmitChanges();
}
/// <summary>
/// Change password
/// </summary>
public static bool ChangePassword(string userId, string password)
{
password = GetMD5(password);
UsersAutDataContext context = new UsersAutDataContext();
LocalUser Base = context.LocalUsers.Single(a => a.Email == userId);
Base.Password = password;
context.SubmitChanges();
return true;
}
/// <summary>
/// Return the list of bookmarked donors by user
/// using Linq datacontext and expression for the specific query
/// </summary>
/// <param name="idUser">Represents the user id</param>
/// <returns>A list of bookmarked donors by user id</returns>
public List<BookmarkedDonor> BookmarkedByUser(string idUser)
{
UsersAutDataContext context = new UsersAutDataContext();
var items = (from a in context.BookmarkedDonors
where
(a.User_ID == idUser)
select a).ToList<BookmarkedDonor>();
return items;
}
/// <summary>
/// Change password
/// </summary>
public static bool ChangePassword(string userId, string password)
{
password = GetMD5(password);
UsersAutDataContext context = new UsersAutDataContext();
LocalUser Base = context.LocalUsers.Single(a => a.Email == userId);
Base.Password = password;
context.SubmitChanges();
return(true);
}
/// <summary>
/// Returns the user to update log tables
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static LocalUser LocalUser(string username, string password)
{
UsersAutDataContext context = new UsersAutDataContext();
var items = (from a in context.LocalUsers
where
(a.Email == username && a.Password == password)
select a).Single();
return(items);
}
/// <summary>
/// Save in the LogSessions table
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
public static void SaveLogIn(string userId)
{
UsersAutDataContext context = new UsersAutDataContext();
LogSession ses = new LogSession();
ses.SessionDate = DateTime.Now;
ses.UserId = userId;
context.LogSessions.InsertOnSubmit(ses);
context.SubmitChanges();
}
/// <summary>
/// Return the list of bookmarked donors by user
/// using Linq datacontext and expression for the specific query
/// </summary>
/// <param name="idUser">Represents the user id</param>
/// <returns>A list of bookmarked donors by user id</returns>
public List <BookmarkedDonor> BookmarkedByUser(string idUser)
{
UsersAutDataContext context = new UsersAutDataContext();
var items = (from a in context.BookmarkedDonors
where
(a.User_ID == idUser)
select a).ToList <BookmarkedDonor>();
return(items);
}
/// <summary>
/// Save in the logAction table
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
public static void SaveAction(string action)
{
UsersAutDataContext context = new UsersAutDataContext();
LogAction actions = new LogAction();
actions.Action = action;
actions.UserId = HttpContext.Current.User.Identity.Name;
actions.ActionDate = DateTime.Now;
context.LogActions.InsertOnSubmit(actions);
context.SubmitChanges();
}
/// <summary>
/// Save donors in Bookmarked table by user id using Linq datacontext to connect with MPX database
/// </summary>
/// <param name="bookmark">Bookmarked Donor object</param>
/// <returns>If the transaction has been succesfull</returns>
public bool BookmarkDonor(BookmarkedDonor bookmark)
{
try
{
UsersAutDataContext context = new UsersAutDataContext();
context.BookmarkedDonors.InsertOnSubmit(bookmark);
context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// Create User
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
public static bool CreateUser(LocalUser user)
{
try
{
UsersAutDataContext context = new UsersAutDataContext();
context.LocalUsers.InsertOnSubmit(user);
context.SubmitChanges();
return true;
}
catch
{
return false;
}
}
/// <summary>
/// Create User
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
public static bool CreateUser(LocalUser user)
{
try
{
UsersAutDataContext context = new UsersAutDataContext();
context.LocalUsers.InsertOnSubmit(user);
context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// Verify if User exists
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static LocalUser VerifyUser(string username)
{
UsersAutDataContext context = new UsersAutDataContext();
try
{
var items = (from a in context.LocalUsers
where
(a.Email == username)
select a).Single();
return(items);
}
catch
{
return(null);
}
}
/// <summary>
/// Validate the user credentials with the local db
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static LocalUser UserAut(string username, string password)
{
password = GetMD5(password);
UsersAutDataContext context = new UsersAutDataContext();
try
{
var items = (from a in context.LocalUsers
where
(a.Email == username && a.Password == password)
select a).Single();
return(items);
}
catch
{
return(null);
}
}
public bool UnBookmarkDonor(string idUser, long donorID)
{
try
{
UsersAutDataContext context = new UsersAutDataContext();
List <BookmarkedDonor> list = (from a in context.BookmarkedDonors
where
(a.User_ID == idUser && a.Donor_ID == donorID)
select a).ToList <BookmarkedDonor>();
if (list != null && list.Count > 0)
{
context.BookmarkedDonors.DeleteOnSubmit(list[0]);
context.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
return(false);
}
/// <summary>
/// Save donors in Bookmarked table by user id using Linq datacontext to connect with MPX database
/// </summary>
/// <param name="bookmark">Bookmarked Donor object</param>
/// <returns>If the transaction has been succesfull</returns>
public bool BookmarkDonor(BookmarkedDonor bookmark)
{
var list = BookmarkedByUser(bookmark.User_ID);
if (list.Where(r => r.Donor_ID == bookmark.Donor_ID).Count() == 0)
{
try
{
UsersAutDataContext context = new UsersAutDataContext();
context.BookmarkedDonors.InsertOnSubmit(bookmark);
context.SubmitChanges();
Models.Util.SaveAction(Util.Actions.BookMarked + ":" + bookmark.Donor_ID + " status:true");
return true;
}
catch
{
Models.Util.SaveAction(Util.Actions.BookMarked + ":" + bookmark.Donor_ID + " status:false");
return false;
}
}
return false;
}
/// <summary>
/// Save donors in Bookmarked table by user id using Linq datacontext to connect with MPX database
/// </summary>
/// <param name="bookmark">Bookmarked Donor object</param>
/// <returns>If the transaction has been succesfull</returns>
public bool BookmarkDonor(BookmarkedDonor bookmark)
{
var list = BookmarkedByUser(bookmark.User_ID);
if (list.Where(r => r.Donor_ID == bookmark.Donor_ID).Count() == 0)
{
try
{
UsersAutDataContext context = new UsersAutDataContext();
context.BookmarkedDonors.InsertOnSubmit(bookmark);
context.SubmitChanges();
Models.Util.SaveAction(Util.Actions.BookMarked + ":" + bookmark.Donor_ID + " status:true");
return(true);
}
catch
{
Models.Util.SaveAction(Util.Actions.BookMarked + ":" + bookmark.Donor_ID + " status:false");
return(false);
}
}
return(false);
}
/// <summary>
/// Returns the user to update log tables
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static LocalUser LocalUser(string username, string password)
{
UsersAutDataContext context = new UsersAutDataContext();
var items = (from a in context.LocalUsers
where
(a.Email == username && a.Password == password)
select a).Single();
return items;
}
/// <summary>
/// Save donors in Bookmarked table by user id using Linq datacontext to connect with MPX database
/// </summary>
/// <param name="bookmark">Bookmarked Donor object</param>
/// <returns>If the transaction has been succesfull</returns>
public bool BookmarkDonor(BookmarkedDonor bookmark)
{
try
{
UsersAutDataContext context = new UsersAutDataContext();
context.BookmarkedDonors.InsertOnSubmit(bookmark);
context.SubmitChanges();
return true;
}
catch
{
return false;
}
}
public bool UnBookmarkDonor(string idUser, long donorID)
{
try
{
UsersAutDataContext context = new UsersAutDataContext();
List<BookmarkedDonor> list = (from a in context.BookmarkedDonors
where
(a.User_ID == idUser && a.Donor_ID == donorID)
select a).ToList<BookmarkedDonor>();
if (list != null && list.Count > 0)
{
context.BookmarkedDonors.DeleteOnSubmit(list[0]);
context.SubmitChanges();
}
return true;
}
catch
{
return false;
}
return false;
}
/// <summary>
/// Verify if User exists
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static LocalUser VerifyUser(string username)
{
UsersAutDataContext context = new UsersAutDataContext();
try
{
var items = (from a in context.LocalUsers
where
(a.Email == username)
select a).Single();
return items;
}
catch
{
return null;
}
}
/// <summary>
/// Validate the user credentials with the local db
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static LocalUser UserAut(string username, string password)
{
password = GetMD5(password);
UsersAutDataContext context = new UsersAutDataContext();
try
{
var items = (from a in context.LocalUsers
where
(a.Email == username && a.Password == password)
select a).Single();
return items;
}
catch
{
return null;
}
}
/// <summary>
/// Update the history of the local user table
/// </summary>
/// <param name="userId"></param>
public static void updateLogUser(string userId)
{
UsersAutDataContext context = new UsersAutDataContext();
if (context.LocalUsers.Count() > 0)
{
LocalUser Base = context.LocalUsers.Single(a => a.Email == userId);
Base.Updated_at = DateTime.Now;
context.SubmitChanges();
}
}
/// <summary>
/// Save in the LogSessions table
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
public static void SaveLogIn(string userId)
{
UsersAutDataContext context = new UsersAutDataContext();
LogSession ses = new LogSession();
ses.SessionDate = DateTime.Now;
ses.UserId = userId;
context.LogSessions.InsertOnSubmit(ses);
context.SubmitChanges();
}
/// <summary>
/// Save in the logAction table
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
public static void SaveAction(string action)
{
UsersAutDataContext context = new UsersAutDataContext();
LogAction actions = new LogAction();
actions.Action = action;
actions.UserId = HttpContext.Current.User.Identity.Name;
actions.ActionDate = DateTime.Now;
context.LogActions.InsertOnSubmit(actions);
context.SubmitChanges();
}
