public void Create(User_Model model)
{
var data = Connect_Enttity.Users.FirstOrDefault(x => x.Id == model.Id);
if (data == null)
{
var entity = new User();
entity.Name = model.Name;
entity.Username = model.Username;
entity.Password = StringClass.Encrypt(model.Password);
entity.Level = model.Level;
entity.Admin = model.Admin;
entity.Ord = model.Ord;
entity.Active = model.Active;
entity.Role = model.Role;
Connect_Enttity.Users.Add(entity);
Connect_Enttity.SaveChanges();
Dispose();
}
}
public ActionResult _GetUsers()
{
User_Model _Users = new User_Model();
//Create an entity based in the database
Entities Logbook_DB = new Entities();
//Create JSON error model and initialize with 0 values
Error_Model_JSON Date_Parse_Error = new Error_Model_JSON();
Date_Parse_Error.Error_Code = 0;
Date_Parse_Error.Error_Alert = "";
Date_Parse_Error.Error_Message = "";
//Create the JSON alerts table
Error_Model_JSON_Messages Alerts = new Error_Model_JSON_Messages();
//Retrieve all the avaible users
List <USER_PARAMETER_LOGS> Parameter_History_List = Logbook_DB.USER_PARAMETER_LOGS.ToList();
var Users = Parameter_History_List.Select(a => a.Logged_User).Distinct().ToList();
if (User == null)
{
Date_Parse_Error.Error_Code = 200;
Date_Parse_Error.Error_Alert = Alerts.Error_Alerts[4];
Date_Parse_Error.Error_Message = "";
return(Json(Date_Parse_Error));
}
//Copy it to the class
foreach (var item in Users)
{
_Users.User_List.Add(item);
}
//Return the data
return(Json(_Users, JsonRequestBehavior.AllowGet));
}
async private void btnRegister_Clicked(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtName.Text) ||
string.IsNullOrWhiteSpace(txtLastName.Text) ||
string.IsNullOrWhiteSpace(txtEmail.Text) ||
string.IsNullOrWhiteSpace(txtPhone.Text) ||
string.IsNullOrWhiteSpace(txtPwd.Text))
{
await DisplayAlert("Atención", "Debe ingresar todos los campos.", "Ok");
return;
}
if (txtPwd.Text == null || txtPwd.Text.Length < 6)
{
await DisplayAlert("Atención", "La contraseña debe contener al menos 6 caracteres", "Ok");
return;
}
try
{
User_Model user = new User_Model();
user.FirstName = txtName.Text;
user.LastName = txtLastName.Text;
user.Email = txtEmail.Text;
user.PhoneNumber = txtPhone.Text;
user.Password = txtPwd.Text;
Banking_User _user = await userManager.Add(user);
await Navigation.PopModalAsync();
}
catch (Exception ex)
{
await DisplayAlert("Error", "No hemos podido crear su Usuario. " + ex.Message, "Ok");
await Navigation.PopModalAsync();
}
}
public async Task <User_Model> SignUpAsync(User_SignUp_Schema model)
{
var user = new User_Model();
var parameters = _parameterHandler.MakeParameters(model);
var result = await _repository.QueryMultipleAsync(model.GetSchemaName(), param : parameters, commandType : CommandType.StoredProcedure);
if (!result.IsConsumed)
{
user = await result.ReadFirstAsync <User_Model>();
}
if (!result.IsConsumed)
{
var properties = await result.ReadAsync <UserProperty_Model>();
if (properties.Any())
{
user.Properties = properties.ToList();
}
}
_parameterHandler.SetOutputValues(model, parameters);
_parameterHandler.SetReturnValue(model, parameters);
return(user);
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="control"></param>
/// <param name="model"></param>
public TextOutPage(User_Model model, User_Control control)
{
InitializeComponent();
mControl = control;
mModel = model;
}
public ActionResult Index(User_Model um)
{
return(View(um));
}
public async Task <ActionResult> Update(User_Model model)
{
var listError = new List <string>();
//if (ModelState.IsValid)
{
var existUser = await _userService.GetUserByUsernameAsync(model.UserName);
if (existUser == null)
{
listError.Add("Not exist user");
}
else
{
var existUserByEmail = await _userService.GetUserByEmailAsync(model.Email);
if (existUserByEmail != null)
{
if (existUserByEmail.Username == model.UserName)
{
existUserByEmail.FirstName = model.FirstName;
existUserByEmail.LastName = model.LastName;
existUserByEmail.Active = model.Active;
existUserByEmail.PhoneNumber = model.PhoneNumber;
//User departments
if (model.Departments != null && model.Departments.Count() > 0)
{
foreach (var department in existUserByEmail.Departments.ToList())
{
existUserByEmail.Departments.Remove(department);
}
var addedDepartments = await _departmentService.GetDepartmentByIdsAsync(model.Departments.Select(d => d.Id).ToList());// _userRoleService.GetUserRolesByIdsAsync(model.Roles.Where(mr => existUserByEmail.UserRoles.All(r => r.Id != mr.Id)).Select(mr => mr.Id).ToList());
foreach (var department in addedDepartments.ToList())
{
existUserByEmail.Departments.Add(department);
}
}
if (!string.IsNullOrEmpty(model.ResetPassword))
{
string saltKey = _encryptionService.CreateSaltKey(5);
existUserByEmail.PasswordSalt = saltKey;
existUserByEmail.Password = _encryptionService.CreatePasswordHash(model.ResetPassword, saltKey);
}
//User roles
foreach (var role in existUserByEmail.UserRoles.Where(r => r.SystemName != SystemUserRoleNames.MeetingLeaders && model.Roles.All(mr => mr.Id != r.Id)).ToList())
{
existUserByEmail.UserRoles.Remove(role);
}
var addedRoles = await _userRoleService.GetUserRolesByIdsAsync(model.Roles.Where(mr => existUserByEmail.UserRoles.All(r => r.Id != mr.Id)).Select(mr => mr.Id).ToList());
foreach (var role in addedRoles)
{
existUserByEmail.UserRoles.Add(role);
}
await _userService.UpdateUserAsync(existUserByEmail);
return(Json(new
{
status = "success",
}));
}
else
{
listError.Add("This email is belong to another user");
}
}
else
{
existUser.Email = model.Email;
existUser.FirstName = model.FirstName;
existUser.LastName = model.LastName;
existUser.Active = model.Active;
existUser.PhoneNumber = model.PhoneNumber;
foreach (var department in existUser.Departments.ToList())
{
existUser.Departments.Remove(department);
}
var addedDepartments = await _departmentService.GetDepartmentByIdsAsync(model.Departments.Select(d => d.Id).ToList());// _userRoleService.GetUserRolesByIdsAsync(model.Roles.Where(mr => existUserByEmail.UserRoles.All(r => r.Id != mr.Id)).Select(mr => mr.Id).ToList());
foreach (var department in addedDepartments.ToList())
{
existUser.Departments.Add(department);
}
foreach (var role in existUser.UserRoles.Where(r => r.SystemName != SystemUserRoleNames.MeetingLeaders).ToList())
{
existUser.UserRoles.Remove(role);
}
foreach (var role in model.Roles)
{
var userRole = _userService.GetUserRoleByIdAsync(role.Id);
existUser.UserRoles.Add(userRole);
}
await _userService.UpdateUserAsync(existUser);
return(Json(new
{
status = "success",
}));
}
}
}
return(Json(new
{
status = "failed",
listError = listError
}));
}
public IEnumerable <User_Model> ReadID(User_Model model)
{
return(GetId(model));
}
public bool Login(User_Model usr)
{
return((conn.EjecutarConsulta("call logintemp('" + usr.Email + "','" + usr.Password + "');").Rows.Count > 0) ? true : false);
}
public bool UpdateUser(User_Model usermodel)
{
return dao.Update(usermodel)>0;
}
public bool AddUser(User_Model usermodel)
{
return dao.AddUser(usermodel)>0;
}
public AuthResult(AuthStatus status, string message,
string accessToken, string refreshToken, DateTimeOffset?expires, User_Model user)
{
Status = status;
Message = message;
AccessToken = accessToken;
RefreshToken = refreshToken;
TokenExpires = expires;
User = user;
}
public bool SearchUser(ref List <User_Model> lstResult, string UserName, string Fullname, string mLevel, bool?enable)
{
bool result = false;
try
{
string condition = string.Empty;
if (enable != null)
{
condition += "`isenable` = " + enable.ToString() + " and ";
}
if (UserName != string.Empty)
{
condition += "(`username` like '%" + UserName.Replace("\'", "\\\'") + "' ";
condition += " or `username` like '" + UserName.Replace("\'", "\\\'") + "%' ";
condition += " or `username` like '%" + UserName.Replace("\'", "\\\'") + "%') ";
}
if (Fullname != string.Empty)
{
condition += "(`fullname` like '%" + Fullname.Replace("\'", "\\\'") + "' ";
condition += " or `fullname` like '" + Fullname.Replace("\'", "\\\'") + "%' ";
condition += " or `fullname` like '%" + Fullname.Replace("\'", "\\\'") + "%') ";
}
if (mLevel != string.Empty)
{
condition += "(`fullname` like '%" + mLevel.Replace("\'", "\\\'") + "' ";
condition += " or `fullname` like '" + mLevel.Replace("\'", "\\\'") + "%' ";
condition += " or `fullname` like '%" + mLevel.Replace("\'", "\\\'") + "%') ";
}
DataTable dt;
if ((dt = DBHandler.selectDataBase(ref conn,
"`order_user`",
"`username`, `password`, `promosion_money`, `email`, `fullname`, `street_address`, `apt_suite_other`, `city`, `postal_code`, `country_id`, `phone_number`, `province`, `isenable`",
condition)) != null)
{
lstResult = new List <User_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
User_Model item = new User_Model()
{
username = (string)dt.Rows[i]["username"],
password = (string)dt.Rows[i]["password"],
apt_suite_other = (string)dt.Rows[i]["apt_suite_other"],
city = (string)dt.Rows[i]["city"],
country_id = (int)dt.Rows[i]["country_id"],
email = (string)dt.Rows[i]["email"],
fullname = (string)dt.Rows[i]["fullname"],
phone_number = (string)dt.Rows[i]["phone_number"],
postal_code = (string)dt.Rows[i]["postal_code"],
promosion_money = (double)dt.Rows[i]["promosion_money"],
street_address = (string)dt.Rows[i]["street_address"],
province = (string)dt.Rows[i]["province"],
isenable = (bool)dt.Rows[i]["isenable"]
};
lstResult.Add(item);
}
result = true;
}
}
catch (Exception ex)
{
LogFile.writeLog(LogFile.DIR, "Exception" + LogFile.getTimeStringNow() + ".txt", LogFile.Filemode.GHIDE, ex.Message);
}
return(result);
}
public LogIn_ViewModel(UserControl_LogIn logInView)
{
this.logInView = logInView;
LogIn = new GeneralCommands <object>(LogInOrRegister, CanLogIn);
user = new User_Model("", "");
}
