public bool ValidateUser(string username, string password, out long userId)
{
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password))
{
userId = 0;
return(false);
}
using (TradeBulkEntities dbContext = new TradeBulkEntities())
{
//here is the issue
string cipher = Security.Encrypt(password);
var user = (from us in dbContext.Users
where string.Compare(username, us.Username, StringComparison.OrdinalIgnoreCase) == 0 &&
string.Compare(cipher, us.Password, StringComparison.OrdinalIgnoreCase) == 0 &&
us.IsActive == true
select us).FirstOrDefault();
if (user == null)
{
userId = 0;
return(false);
}
var userDetails = dbContext.UserDetails.Where(x => x.UserPID == user.UserId);
userId = userDetails.FirstOrDefault <UserDetail>().UserdetailPID;
return((user != null) ? true : false);
}
}
public override string GetUserNameByEmail(string email)
{
using (TradeBulkEntities dbContext = new TradeBulkEntities())
{
string username = (from u in dbContext.Users
where string.Compare(email, u.Email) == 0
select u.Username).FirstOrDefault();
return(!string.IsNullOrEmpty(username) ? username : string.Empty);
}
}
public ActionResult Registration(RegistrationView registrationView)
{
bool statusRegistration = false;
string messageRegistration = string.Empty;
if (ModelState.IsValid)
{
// Email Verification
string userName = Membership.GetUserNameByEmail(registrationView.Email);
if (!string.IsNullOrEmpty(userName))
{
ModelState.AddModelError("Warning Email", "Sorry: Email already Exists");
return(View(registrationView));
}
//Save User Data
using (TradeBulkEntities dbContext = new TradeBulkEntities())
{
var user = new User()
{
Username = registrationView.Username,
FirstName = registrationView.FirstName,
LastName = registrationView.LastName,
Email = registrationView.Email,
Password = Security.Encrypt(registrationView.Password),
ActivationCode = Guid.NewGuid(),
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
var RoleInfo = (from roles in dbContext.Roles select roles.RoleName).ToList <string>();
ViewBag.AvailableRoles = new SelectList(RoleInfo.ToList(), "Name", "Name");
}
//Verification Email
VerificationEmail(registrationView.Email, registrationView.ActivationCode.ToString());
messageRegistration = "Your account has been created successfully. ^_^";
statusRegistration = true;
}
else
{
messageRegistration = "Something Wrong!";
}
ViewBag.Message = messageRegistration;
ViewBag.Status = statusRegistration;
return(View(registrationView));
}
// POST: api/ManageAdmin
//public void Post([FromBody]string value)
//{
//}
public List <NewUserRegistrationSupport> Post(string selectIndex)
{
List <NewUserRegistrationSupport> ls = new List <NewUserRegistrationSupport>();
if (Convert.ToInt32(selectIndex) == 1)
{
//Current Users
TradeBulkEntities db = new TradeBulkEntities();
}
else
{
ManageAdminHelper MAdminhelper = new ManageAdminHelper();
ls = MAdminhelper.GetNewUser();
}
return(ls);
}
/// <summary>
///
/// </summary>
/// <param name="username"></param>
/// <param name="userIsOnline"></param>
/// <returns></returns>
public override MembershipUser GetUser(string username, bool userIsOnline)
{
using (TradeBulkEntities dbContext = new TradeBulkEntities())
{
var user = (from us in dbContext.Users
where string.Compare(username, us.Username, StringComparison.OrdinalIgnoreCase) == 0
select us).FirstOrDefault();
if (user == null)
{
return(null);
}
var selectedUser = new CustomMembershipUser(user);
return(selectedUser);
}
}
/// <summary>
///
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public override bool ValidateUser(string username, string password)
{
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password))
{
return(false);
}
using (TradeBulkEntities dbContext = new TradeBulkEntities())
{
//here is the issue
string cipher = Security.Encrypt(password);
var user = (from us in dbContext.Users
where string.Compare(username, us.Username, StringComparison.OrdinalIgnoreCase) == 0 &&
string.Compare(cipher, us.Password, StringComparison.OrdinalIgnoreCase) == 0 &&
us.IsActive == true
select us).FirstOrDefault();
return((user != null) ? true : false);
}
}
//password is not required
public bool isUserExists(string username, out long userId)
{
if (string.IsNullOrEmpty(username))
{
userId = 0;
return(false);
}
using (TradeBulkEntities dbContext = new TradeBulkEntities())
{
var user = (from us in dbContext.Users
where string.Compare(username, us.Username, StringComparison.OrdinalIgnoreCase) == 0 &&
us.IsActive == true
select us).FirstOrDefault();
var userDetails = dbContext.UserDetails.Where(x => x.UserPID == user.UserId);
userId = userDetails.FirstOrDefault <UserDetail>().UserdetailPID;
return((user != null) ? true : false);
}
}
public ActionResult ActivationAccount(string id)
{
bool statusAccount = false;
using (TradeBulkEntities dbContext = new TradeBulkEntities())
{
var userAccount = dbContext.Users.Where(u => u.ActivationCode.ToString().Equals(id)).FirstOrDefault();
if (userAccount != null)
{
userAccount.IsActive = true;
dbContext.SaveChanges();
statusAccount = true;
}
else
{
ViewBag.Message = "Something Wrong !!";
}
}
ViewBag.Status = statusAccount;
return(View());
}
private bool isAlreadyExists(UnitOfWork unitOfWork, string EmailID)
{
try
{
TradeBulkEntities db = new TradeBulkEntities();
var varible = from x in db.Users select x;
var v2 = from x in db.UserDetails select x;
GenericRepository <User> ApprvedUserRepository;
ApprvedUserRepository = unitOfWork.GetRepoInstance <User>();
if (ApprvedUserRepository.GetAllExpressions(x => x.Email == EmailID).Count <User>() == 0)
{
return(false);
}
}
catch (Exception ex)
{
LogHelper.WriteErrorLog(ex);
}
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public override string[] GetRolesForUser(string username)
{
if (!HttpContext.Current.User.Identity.IsAuthenticated)
{
return(null);
}
var userRoles = new string[] { };
using (TradeBulkEntities dbContext = new TradeBulkEntities())
{
var selectedUser = (from us in dbContext.Users.Include("Roles")
where string.Compare(us.Username, username, StringComparison.OrdinalIgnoreCase) == 0
select us).FirstOrDefault();
if (selectedUser != null)
{
// userRoles = new[] { selectedUser.Roles.Select(r => r.RoleName).ToString() };
}
return(userRoles.ToArray());
}
}
public GenericRepository(TradeBulkEntities context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
