public bool Delete(string userId)
{
bool result = false;
UserProfile profile = UserProfile.GetByUserId(userId);
if (profile != null)
{
int addressId = profile.AddressId;
profile.Delete();
Address addr = Address.GetById(addressId);
addr.Delete();
}
UserRole roles = new UserRole();
roles.DeleteUserRoles(userId);
result = deleteUser(userId);
return result;
}
public static List<UserRole> GetAllUserRoles()
{
List<UserRole> roles = new List<UserRole>();
string sql = @"select * from AspNetRoles";
try
{
using (SqlConnection conn = new SqlConnection(DataConnection.AppData))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
UserRole role = new UserRole();
role.RoleId = reader["Id"].ToString();
role.RoleName = reader["Name"].ToString();
roles.Add(role);
}
}
}
}
catch (Exception e)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrLogger.Log(_className, methodName, e.Message);
roles.Clear();
}
return roles;
}
// Check if a User assigned to specific role or any
public static bool IsInRole(string userId, string roleName = null)
{
bool result = false;
string sql = @"select u.UserId, u.RoleId, r.Name as RoleName from AspNetUserRoles u
left join AspNetRoles r on r.Id=u.RoleId
where u.UserId=@UserId" + ( roleName == null ? "" : " and r.Name=@RoleName");
try
{
using (SqlConnection conn = new SqlConnection(DataConnection.AppData))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@UserId", userId);
cmd.Parameters.AddWithValue("@RoleName", roleName);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
UserRole userRole = new UserRole(reader);
result = userRole != null;
}
}
}
}
catch (Exception e)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrLogger.Log(_className, methodName, e.Message);
result = false;
}
return result;
}
private bool CheckHasUserRole(int userId, UserRole role)
{
lock (loggedInUsersLockObject)
{
UserContextEntity user = loggedInUsers.FirstOrDefault(c => c.Id.Equals(userId));
if (user == null)
return false;
return (user.Role & role) != 0;
}
}
private UserContext AddUserToDatabase(string firstName, string lastName, string login, string password, UserRole role)
{
if (String.IsNullOrEmpty(firstName))
throw new ArgumentNullException("firstName is null");
if (String.IsNullOrEmpty(lastName))
throw new ArgumentNullException("lastName is null");
if (String.IsNullOrEmpty(login))
throw new ArgumentNullException("login is null");
if (String.IsNullOrEmpty(password))
throw new ArgumentNullException("password is null");
UserContextEntity newUser = null;
using (var db = new DataAccessProvider())
{
//sprawdzenie czy dany login już istnieje
var userSameLogin = db.Users.FirstOrDefault(u => u.Role == role && u.Login == login);
if (userSameLogin != null)
throw new ArgumentException(String.Format("There already is an user with login = {0}.", login));
newUser = new UserContextEntity()
{
Login = login,
FirstName = firstName,
LastName = lastName,
Role = role
};
newUser = db.Users.Add(newUser);
db.SaveChanges();
var userPassword = new PasswordEntity() { UserId = newUser.Id, Hash = HashClass.CreateSecondHash(password) };
db.Passwords.Add(userPassword);
db.SaveChanges();
}
return new UserContext(newUser);
}
public ActionResult CreateUser(LoanViewModel lvm, FormCollection form)
{
GLobalClient cc = new GLobalClient();
try
{
if (lvm != null)
{
string value = lvm.AccountsModel.Email;
string password = lvm.AccountsModel.pasword;
string confirmpass = lvm.AccountsModel.confirmPassword;
bool validatePass = ValidatePassword(password, confirmpass);
var EncrypPassword = new CryptographyManager().ComputeHash(password, HashName.SHA256);
password = EncrypPassword;
lvm.AccountsModel.confirmPassword = password;
lvm.AccountsModel.pasword = password;
lvm.AccountsModel.Email = value;
lvm.AccountsModel.Referal = Convert.ToString(form["Referal"]);
if (validatePass == false)
{
TempData["Message"] = "Password And Confirm Password Must Match";
}
else if (validatePass == true)
{
bool val = DataReaders.Validate(value);
if (val == true)
{
TempData["Message"] = "User Already Exist";
// return RedirectToAction("Signup", "Home", new { area = "" });
ViewBag.channel = db.MarketingChannels;
return(View("Signup"));
}
else if (val == false)
{
lvm.AccountsModel.Date = DateTime.Now;
lvm.AccountsModel.DateTim = DateTime.Today;
lvm.AccountsModel.isVissibles = 1;
// This is For the Api
// cc.CreateUser(lvm.AccountsModel);
User users = new DataAccess.User();
users.confirmPassword = lvm.AccountsModel.confirmPassword;
users.pasword = lvm.AccountsModel.pasword;
users.Email = lvm.AccountsModel.Email;
users.Date = lvm.AccountsModel.Date;
users.DateTim = lvm.AccountsModel.DateTim;
users.isVissibles = lvm.AccountsModel.isVissibles;
users.firstname = lvm.AccountsModel.firstname;
users.lastname = lvm.AccountsModel.lastname;
users.Phone = lvm.AccountsModel.Phone;
users.Referal = lvm.AccountsModel.Referal;
//string lastid = "0";
//users.MyReferalCode = MyUtility.getReferralCode(lastid);
users.ReferralLevel = MyUtility.getRefferalLevel(users.Referal);
// users.MyReferalCode =
int id = DataCreators.CreateUser(users);
var channellist = Request["checkboxName"];
if (channellist != null)
{
string[] arr = channellist.Split(',');
var chanList = removestring(arr);
if (arr.Length > 0)
{
for (var i = 0; i < arr.Length; i++)
{
string arrc = Convert.ToString(arr[i]);
insertMarketChannel(arrc, id);
}
}
}
if (id != 0)
{
string lastid = id.ToString();
users.MyReferalCode = MyUtility.getReferralCode(lastid);
DataCreators.updatelastID(users);
DataAccess.UserRole userroles = new DataAccess.UserRole();
userroles.UserId = id;
userroles.RoleId = Convert.ToInt16(ConfigurationManager.AppSettings["DefaultUser"]);
userroles.IsVissible = 1;
userroles.dates = DateTime.Now;
DataCreators.InsertUserRoles(userroles);
TempData["Message"] = "User Created Succesfully";
//For LoggedIn User
Session["id"] = lvm.AccountsModel.Email;
Session["User"] = Session["id"];
var LoggedInuser = new LogginHelper();
user = LoggedInuser.LoggedInUser();
SendEmail(lvm);
string Regpage = ConfigurationManager.AppSettings["DefaultRegister"];
return(Redirect(Regpage));
//return RedirectToAction("Index", "Dashboard");
// return RedirectToAction("Dashboard", "Dashboard");
}
else
{
TempData["Message"] = "Registration Not Succesful Please Try Again!";
ViewBag.channel = db.MarketingChannels;
}
}
}
}
else
{
TempData["Message"] = "Error Creating User";
ViewBag.channel = db.MarketingChannels;
}
return(RedirectToAction("Signup", "Home", new { area = "" }));
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
return(null);
}
}
