public bool InsertRecord_UserProfile(tblUserProfile rec)
{
try
{
MentorJEntities context = new MentorJEntities();
tblUserProfile existingRec = ReadRecord_UserProfile(rec.UserID);
if (existingRec == null)
{
//generate profile URL;
//if (isUserNameTaken(rec) == true) //if check fails, then username already taken.
//{
// return false;
//}
//if (isEmailTaken(rec) == true) //if check fails, then username already taken.
//{
// return false;
//}
rec.Modified = DateTime.Now;
context.tblUserProfiles.Add(rec);
context.SaveChangesAsync();
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
public ArrayList getUserProfiles(string username)
{
try
{
MentorJEntities context = new MentorJEntities();
var query = from n in context.tblUserInfoes
where n.UserName.Contains(username)
orderby n.UserName.IndexOf(username),
n.UserName.Length ascending
select n.UserID;
ArrayList list = new ArrayList();
int count = 0;
foreach (var id in query)
{
count++;
list.Add(id);
if (count > 100)
{
break;
}
}
return(list);
//return query;
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertRecord_UserInfo(tblUserInfo rec)
{
try
{
MentorJEntities context = new MentorJEntities();
tblUserInfo existingRec = ReadRecord_UserInfo(rec.UserID);
if (existingRec == null)
{
if (isUserNameTaken_UserInfo(rec) == true) //if check fails, then username already taken.
{
return(false);
}
if (isEmailTaken_UserInfo(rec) == true) //if check fails, then username already taken.
{
return(false);
}
rec.AccountCreationDate = DateTime.Now;
rec.LastUpdatedDate = DateTime.Now;
rec.FailedLoginAttempts = 0;
rec.LastFailedLoginDate = DateTime.Now;
context.tblUserInfoes.Add(rec);
context.SaveChangesAsync();
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
public long assignUserID_UserInfo()
{
try
{
MentorJEntities context = new MentorJEntities();
var item = context.tblUserInfoes.OrderByDescending(i => i.UserID).FirstOrDefault();
if (item != null)
{
return(item.UserID + 1);
}
return(-1);
}
catch (Exception ex)
{
throw ex;
}
}
public bool DeleteRecord_UserProfile(long ID)
{
try
{
MentorJEntities context = new MentorJEntities();
tblUserProfile existingRec = ReadRecord_UserProfile(ID);
if (existingRec != null) //there is a record
{
context.tblUserProfiles.Remove(existingRec);
context.SaveChangesAsync();
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
//private tblUserInfo TranslatetblUserInfoTotblUserInfo(tblUserInfo user)
//{
// tblUserInfo newuser = new tblUserInfo();
// newuser.UserID = user.UserID;
// newuser.UserName = user.UserName;
// newuser.UserID = user.UserID;
// newuser.UserName = user.UserName;
// newuser.Email = user.Email;
// newuser.Password = user.Password;
// newuser.First_Name = user.First_Name;
// newuser.Middle_Name = user.Middle_Name;
// newuser.Last_Name = user.Last_Name;
// newuser.UserName = user.UserName;
// newuser.Sex = user.Sex;
// newuser.Birthday = user.Birthday;
// newuser.Age = user.Age;
// newuser.Street_Address = user.Street_Address;
// newuser.City = user.City;
// newuser.State = user.State;
// newuser.ZipCode = user.ZipCode;
// newuser.Country = user.Country;
// newuser.PhoneNumber = user.PhoneNumber;
// newuser.isPremium = user.isPremium;
// newuser.isMentor = user.isMentor;
// newuser.isAdmin = user.isAdmin;
// newuser.LastUpdatedDate = user.LastUpdatedDate;
// newuser.LastLoginDate = user.LastLoginDate;
// newuser.LastActiveDate = user.LastActiveDate;
// newuser.AccountCreationDate = user.AccountCreationDate;
// newuser.FailedLoginAttempts = user.FailedLoginAttempts;
// newuser.LastFailedLoginDate = user.LastFailedLoginDate;
// newuser.AccountLocked = user.AccountLocked;
// return newuser;
//}
//private tblUserInfo TranslatetblUserInfoTotblUserInfo(tblUserInfo user)
//{
// tblUserInfo newuser = new tblUserInfo();
// newuser.UserID = user.UserID;
// newuser.UserName = user.UserName;
// newuser.UserID = user.UserID;
// newuser.UserName = user.UserName;
// newuser.Email = user.Email;
// newuser.Password = user.Password;
// newuser.First_Name = user.First_Name;
// newuser.Middle_Name = user.Middle_Name;
// newuser.Last_Name = user.Last_Name;
// newuser.UserName = user.UserName;
// newuser.Sex = user.Sex;
// newuser.Birthday = user.Birthday;
// newuser.Age = user.Age;
// newuser.Street_Address = user.Street_Address;
// newuser.City = user.City;
// newuser.State = user.State;
// newuser.ZipCode = user.ZipCode;
// newuser.Country = user.Country;
// newuser.PhoneNumber = user.PhoneNumber;
// newuser.isPremium = user.isPremium;
// newuser.isMentor = user.isMentor;
// newuser.isAdmin = user.isAdmin;
// newuser.LastUpdatedDate = user.LastUpdatedDate;
// newuser.LastLoginDate = user.LastLoginDate;
// newuser.LastActiveDate = user.LastActiveDate;
// newuser.AccountCreationDate = user.AccountCreationDate;
// newuser.FailedLoginAttempts = user.FailedLoginAttempts;
// newuser.LastFailedLoginDate = user.LastFailedLoginDate;
// newuser.AccountLocked = user.AccountLocked;
// return newuser;
//}
public tblUserInfo ReadRecord_UserInfo(long ID)
{
try
{
MentorJEntities context = new MentorJEntities();
var query = from n in context.tblUserInfoes
where n.UserID == ID
select n;
if (query != null && query.Count() > 0)
{
//return TranslatetblUserInfoTotblUserInfo(query.First());
return(query.First());
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateRecord_UserProfile(tblUserProfile rec)
{
try
{
MentorJEntities context = new MentorJEntities();
tblUserProfile existingRec = ReadRecord_UserProfile(rec.UserID);
if (existingRec != null)
{
rec.Modified = DateTime.Now;
Serializer.Clone <tblUserProfile>(rec, existingRec);
context.SaveChangesAsync();
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddUpdateRecord_UserProfile(tblUserProfile rec)
{
try
{
MentorJEntities context = new MentorJEntities();
tblUserProfile existingRec = ReadRecord_UserProfile(rec.UserID);
if (existingRec == null) //new record
{
return(InsertRecord_UserProfile(rec));
}
else //found existing, update
{
return(UpdateRecord_UserProfile(rec));
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool isEmailTaken_UserInfo(tblUserInfo rec)
{
try
{
MentorJEntities context = new MentorJEntities();
var query = from n in context.tblUserInfoes
select n;
foreach (var users in query)
{
if (users.Email == rec.Email)
{
return(true);
}
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
public tblUserInfo ValidateLogin_UserInfo(string email, string password)
{
try
{
MentorJEntities context = new MentorJEntities();
var query = from n in context.tblUserInfoes
where n.Email == email
where n.Password == password
select n;
if (query != null && query.Count() > 0)
{
//return TranslatetblUserInfoTotblUserInfo(query.First());
return(query.First());
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
