public GetUsersOut GetUsers(GetUsersIn input) { GetUsersOut output = new GetUsersOut() { result = Entities.Common.Result.Error }; using (var dataContext = DataContextHelper.GetDataContext <UserDataContext>()) { var linqResult = dataContext.spr_getUsers(); output.listUsers = new List <Entities.Database.User>(); foreach (var item in linqResult) { var user = new Entities.Database.User() { usrID = item.usrID, usr_code = item.usr_code, usr_userName = item.usr_userName, usr_password = item.usr_password, usr_fullName = item.usr_fullName, usr_documentType = item.usr_documentType, usr_numberDocument = item.usr_numberDocument, usr_email = item.usr_email, usr_balance = item.usr_balance, usr_role = item.usr_role, usr_status = item.usr_status }; output.listUsers.Add(user); } output.result = Entities.Common.Result.Success; } return(output); }
public bool UserLogin(SqlConnection db, string email, string password, ref Entities.Database.User user_db) { user_db = db.QueryFirstOrDefault <Entities.Database.User> ("select * from [User] (nolock) where Email=@email and Password=@password", new { email, password, }); return(user_db != null); }
public bool Exec(SqlConnection db, LoginInformation login, ref AuthenticatedUser loggedUser) { if (string.IsNullOrEmpty(login.Login)) { Error = new ServiceError { Message = "Invalid login" }; return(false); } if (string.IsNullOrEmpty(login.Passwd)) { Error = new ServiceError { Message = "Invalid password" }; return(false); } if (login.Passwd.Length < 6) { Error = new ServiceError { Message = "Invalid password" }; return(false); } var db_user = new Entities.Database.User(); if (!repository.AdminLogin(db, login.Login, login.Passwd, ref db_user)) { Error = new ServiceError { Message = "Invalid User Credentials" }; return(false); } loggedUser = new AuthenticatedUser { Id = db_user.Id, Name = db_user.Name, Email = db_user.Email, Phone = db_user.Phone, Token = "" }; return(true); }
public bool UserLogin(SqlConnection db, string email, string password, ref Entities.Database.User user) { return(false); }