public int DoConfirmRegisMember(Entities.User e)
{
try
{
using (MyDBDataContext db = new MyDBDataContext())
{
DataLayer.User user = (from u in db.Users
where u.Id == e.Id
select u).FirstOrDefault();
if (user == null)
{
return((int)Enums.Errors.NOT_EXIST);
}
user.Status = e.Status;
db.UserInRoles
.Where(u => u.UserId == e.Id)
.ToList()
.ForEach(u => u.State = true);
db.SubmitChanges();
}
return(e.Id);
}
catch (Exception ex)
{
string data = className + " " + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.UPDATE_ERROR);
}
}
public void GetSpecificUser()
{
var mockObj = new Mock <IRepository>();
var businessLayer = new BusinessLayer.ProjectManagerCore(mockObj.Object);
var users = new DataLayer.User()
{
FirstName = "Test", LastName = "Test", Employee_ID = 459430
};
mockObj.Setup(x => x.GetSpecificUser(It.IsAny <int>())).Returns(users);
//Assert
var actualUsers = businessLayer.GetSpecificUser(It.IsAny <int>());
Assert.AreEqual(users.FirstName, actualUsers.FirstName);
}
public int Delete(int entityId)
{
try
{
DataLayer.User user = (from u in Context.Users
where u.Id == entityId
select u).FirstOrDefault();
Context.Users.DeleteOnSubmit(user);
Context.SubmitChanges();
return(entityId);
}
catch (Exception ex)
{
string data = className + " " + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.DELETE_ERROR);
}
}
private void AddUser()
{
User newUser = new User();
newUser.UserID = Guid.NewGuid();
newUser.Password = MD5Hasher.MD5Hash(Password);
newUser.UserName = UserName;
newUser.Email = Email;
newUser.CreationDate = DateTime.Now;
newUser.LastLogin = newUser.CreationDate;
WcfResponse response = Client.AddUser(newUser, App.CurrentUser.UserID, App.CurrentUser.Password);
if(response.success == WcfResponseStatus.Succes)
ViewClose();
else
{
Xceed.Wpf.Toolkit.MessageBox.Show(response.message);
}
}
public WcfResponse AddUser(User newUser, Guid adminID, string adminPwd)
{
WcfResponse response = new WcfResponse();
//TODO add check for admin role
User admin = DataEntities.User.FirstOrDefault(u => u.UserID == adminID && u.Password == adminPwd);
if (admin != null)
{
if (newUser != null)
{
User existingUser = DataEntities.User.FirstOrDefault(u => u.UserName == newUser.UserName);
if (existingUser == null)
{
try
{
DataEntities.User.Add(newUser);
DataEntities.SaveChanges();
}
catch (Exception ex)
{
response.success = WcfResponseStatus.Failed;
response.message = ex.Message;
}
}
else
{
response.success = WcfResponseStatus.UserNameAlreadyUsed;
response.message = "Username already exists";
}
}
else
{
response.success = WcfResponseStatus.Failed;
response.message = "No user data provided";
}
}
else
{
response.success = WcfResponseStatus.Failed;
response.message = "Incorrect admin data";
}
return response;
}
public int Update(Entities.User e)
{
DataLayer.User user = (from u in Context.Users
where u.Id == e.Id
select u).FirstOrDefault();
user.DisplayName = e.DisplayName;
user.FirstName = e.FirstName;
user.LastName = e.LastName;
user.Gender = e.Gender;
user.DateOfBirth = DateTime.ParseExact(e.DateOfBirth, "dd/MM/yyyy", null);
user.UserName = e.UserName;
user.Email = e.Email;
user.Password = e.Password;
user.Status = e.Status;
user.Description = e.Description;
user.Delete = false;
user.DateCreate = DateTime.Now;
user.DateUpdate = DateTime.Now;
user.DateLogin = DateTime.Now;
user.PlaceId = e.PlaceId;
user.Address = e.Address;
user.Zipcode = e.Zipcode;
user.CompanyLogo = e.CompanyLogo;
user.CodeActive = e.CodeActive;
user.CompanyName = e.CompanyName;
user.Phone = e.Phone;
user.Avatar = e.Avatar;
user.IsUpdated = true;
try
{
Context.SubmitChanges();
return(e.Id);
}
catch (Exception ex)
{
string data = className + " " + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.UPDATE_ERROR);
}
}
public int InsertPersonalInformation(MyDBDataContext db, Entities.User e)
{
try
{
DataLayer.User user = new DataLayer.User();
user.DisplayName = e.DisplayName;
user.FirstName = e.FirstName;
user.LastName = e.LastName;
user.Gender = e.Gender;
user.DateOfBirth = DateTime.ParseExact(e.DateOfBirth, "dd/MM/yyyy", null);
user.UserName = e.UserName;
user.Email = e.Email;
user.Password = e.Password;
user.Status = e.Status;
user.Description = e.Description;
user.Delete = e.Delete;
user.DateCreate = DateTime.Now;
user.DateUpdate = DateTime.Now;
user.DateLogin = DateTime.Now;
user.PlaceId = e.PlaceId;
user.Address = e.Address;
user.Zipcode = e.Zipcode;
user.CompanyLogo = e.CompanyLogo;
user.CodeActive = e.CodeActive;
user.CompanyName = e.CompanyName;
user.Phone = e.Phone;
user.Avatar = e.Avatar;
user.IsUpdated = false;
db.Users.InsertOnSubmit(user);
db.SubmitChanges();
return(user.Id);
}
catch (Exception ex)
{
string data = className + " " + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.INSERT_ERROR);
}
}
public int CheckLogin(string username_email, string password, out string username)
{
DataLayer.User user = null;
password = EncryptionHelper.Encrypt(password);
username = "";
if (MailHelper.IsEmail(username_email))
{
user = (from u in Context.Users
where u.Email == username_email && u.Password == password &&
u.Delete == false
select u).FirstOrDefault();
}
else
{
user = (from u in Context.Users
where u.UserName == username_email && u.Password == password &&
u.Delete == false
select u).FirstOrDefault();
}
if (user != null)
{
if (user.Status)
{
username = user.UserName;
return(user.Id);
}
else
{
return((int)Enums.Errors.BLOCK);
}
}
else
{
return((int)Enums.Errors.NOT_EXIST);
}
}
public async Task<ActionResult> ExternalLoginConfirmation(ExternalLoginConfirmationViewModel model, string returnUrl)
{
if (User.Identity.IsAuthenticated)
{
return RedirectToAction("Index", "Manage");
}
if (ModelState.IsValid)
{
// Get the information about the user from the external login provider
var info = await AuthenticationManager.GetExternalLoginInfoAsync();
if (info == null)
{
return View("ExternalLoginFailure");
}
var user = new ApplicationUser { UserName = model.Email, Email = model.Email };
var result = await UserManager.CreateAsync(user);
if (result.Succeeded)
{
result = await UserManager.AddLoginAsync(user.Id, info.Login);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent: false, rememberBrowser: false);
using (var dbContext = new YATContext())
{
var YATuser = new User
{
Id = user.Id,
FirstName = model.FirstName,
LastName = model.LastName,
Age = model.Age,
Gender = model.Gender,
Address = model.Address,
InterestedIn = model.InterestedIn,
Deleted = false,
Photo=(model.Gender==true)?"male.jpg":"female.jpg",
RegistrationDate = DateTime.Now,
LastLoginDate = DateTime.Now,
};
dbContext.User.Add(YATuser);
dbContext.SaveChanges();
}
return RedirectToLocal(returnUrl);
}
}
AddErrors(result);
}
ViewBag.ReturnUrl = returnUrl;
return View(model);
}
public async Task<ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser { UserName = model.Email, Email = model.Email};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent:false, rememberBrowser:false);
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
using(var dbContext = new YATContext())
{
var YATuser = new User
{
Id=user.Id,
FirstName = model.FirstName,
LastName = model.LastName,
Age = model.Age,
Gender = model.Gender,
Address = model.Address,
InterestedIn = model.InterestedIn,
Deleted = false,
Photo = (model.Gender == true) ? "male.jpg" : "female.jpg",
RegistrationDate = DateTime.Now,
LastLoginDate = DateTime.Now,
};
dbContext.User.Add(YATuser);
dbContext.SaveChanges();
}
return RedirectToAction("Index", "Home");
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return View(model);
}
public static AdminUser GetCurrentUser(User user)
{
return new AdminUser { UserId = user.UserId, UserName = user.UserName, EmailId = user.EmailId };
}
/// <summary>
/// Create a new User object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="emailAddress">Initial value of the EmailAddress property.</param>
/// <param name="loginName">Initial value of the LoginName property.</param>
/// <param name="createdAt">Initial value of the CreatedAt property.</param>
/// <param name="password">Initial value of the Password property.</param>
public static User CreateUser(global::System.Int64 id, global::System.String name, global::System.String emailAddress, global::System.String loginName, global::System.DateTime createdAt, global::System.String password)
{
User user = new User();
user.Id = id;
user.Name = name;
user.EmailAddress = emailAddress;
user.LoginName = loginName;
user.CreatedAt = createdAt;
user.Password = password;
return user;
}
public void AddUser(User user)
{
Users.Insert(user);
}
private bool isUserFollowed(string username, User currUser)
{
bool result = false;
foreach (var followed in currUser.Following)
{
if (username.CompareTo(followed.Username) == 0)
{
result = true;
}
}
return result;
}
/// <summary>
/// Create a new User object.
/// </summary>
/// <param name="user_id">Initial value of the user_id property.</param>
public static User CreateUser(global::System.Int32 user_id)
{
User user = new User();
user.user_id = user_id;
return user;
}
/// <summary>
/// Deprecated Method for adding a new object to the Users EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToUsers(User user)
{
base.AddObject("Users", user);
}
//public int SyncCustomer()
public void SyncCustomer()
{
ProgressUpdateArgs e = new ProgressUpdateArgs();
e.StatusString = "Syncing Customers - Reading data";
this.ProgressUpdate(e);
_UnitOfWorkAPL = new UnitOfWork(_sessionHelper.GetSessionFactory("APL"));
_UnitOfWorkFHG = new UnitOfWork(_sessionHelper.GetSessionFactory("FHG"));
//// Game Table
DataLayer.Repository<Guid, CusCustomer> _fhgCustomerRepo = new Repository<Guid, CusCustomer>(_UnitOfWorkFHG.Session);
DataLayer.Repository<Guid, MemMembership> _fhgMembershipRepo = new Repository<Guid, MemMembership>(_UnitOfWorkFHG.Session);
Repository<Guid, User> _aplUserRepo = new Repository<Guid, User>(_UnitOfWorkFHG.Session);
IList<object[]> fhgCustomers = _sessionHelper.GetStatelessSession("FHG").QueryOver<CusCustomer>()
.Select(c => c.Customerguid,
c => c.Updateversion).List<object[]>();
IList<object[]> aplCustomerResult = _sessionHelper.GetStatelessSession("APL").QueryOver<User>()
.Select(c => c.Id,
c => c.FHGID,
c => c.FHGUpdateID).List<object[]>();
Dictionary<Guid, object> aplCustomers = new Dictionary<Guid, object>();
foreach (object[] o in aplCustomerResult)
{
aplCustomers.Add(Guid.Parse(o[1].ToString()), o);
}
// Add Missing data
int itemCount = 1;
foreach (object[] fhgCustomerObject in fhgCustomers)
{
Guid fhgCustomerGuid = Guid.Parse(fhgCustomerObject[0].ToString());
Guid fhgCustomerUpdateVersion = Guid.Parse(fhgCustomerObject[1].ToString());
e.TotalWorkItems = fhgCustomers.Count();
e.CurrentWorkItem = itemCount;
e.StatusString = "Syncing Customers - (" + itemCount.ToString() + "/" + e.TotalWorkItems.ToString() + ")";
this.ProgressUpdate(e);
if (!aplCustomers.ContainsKey(fhgCustomerGuid))
{
CusCustomer c = _fhgCustomerRepo.FindBy(fhgCustomerGuid);
User u = new User();
u.ContactEmail = c.Emailaddress;
u.ContactMobile = CleanPhoneNumber(c.Phonemobile);
u.ContactPhone = CleanPhoneNumber(c.Phonenumber);
if (c.Membership != null)
u.APLNumber = c.Membership.Membershipnumber;
u.Enabled = true;
u.FHGID = c.Id;
u.Surname = c.Lastname;
u.FirstName = c.Firstname;
u.Username = c.Username;
u.FHGUpdateID = c.Updateversion;
_aplUserRepo.Add(u);
}
else
{
object[] aplComparison = (object[])aplCustomers[fhgCustomerGuid];
Guid aplUserId = Guid.Parse(aplComparison[0].ToString());
Guid aplfhgCustomerId = Guid.Parse(aplComparison[1].ToString());
Guid aplfhgCustomerUpdateVersion = Guid.Parse(aplComparison[2].ToString());
// Check for updates.
if (fhgCustomerUpdateVersion != aplfhgCustomerUpdateVersion)
{
CusCustomer c = _fhgCustomerRepo.FindBy(fhgCustomerGuid);
User u = _aplUserRepo.FindBy(aplUserId);
u.ContactEmail = c.Emailaddress;
u.ContactMobile = CleanPhoneNumber(c.Phonemobile);
u.ContactPhone = CleanPhoneNumber(c.Phonenumber);
u.Enabled = true;
u.FHGID = c.Id;
u.Surname = c.Lastname;
u.FirstName = c.Firstname;
u.Username = c.Username;
u.FHGUpdateID = c.Updateversion;
_aplUserRepo.Update(u);
}
}
itemCount++;
}
_UnitOfWorkAPL.Commit();
_UnitOfWorkFHG.Commit();
}
