public IActionResult getUserById(int id) { var projectController = new ProjectController(_db); projectController.RefreshDate(); var usProfile = _db.UserProfile.FirstOrDefault(p => p.Id == id); List <Project> projects = new List <Project>(); //followedProjects List <FollowsUser> followedProjects = new List <FollowsUser>(); projects = _db.Project.ToList(); followedProjects = _db.FollowsUser.ToList(); var proj = projects.FindAll(z => z.CreateUserId == id); var follow = followedProjects.ToList().FindAll(p => p.UserId == id); var followproj = new List <Project>(); foreach (var fol in follow) { followproj.Add(projects.FirstOrDefault(p => p.Id == fol.ProjectId)); } var userInfo = new getUser { Id = usProfile.Id, FirstName = usProfile.FirstName, SecondName = usProfile.SecondName, LastLogInDate = usProfile.LastLogInDate, RegistrationDate = usProfile.RegistrationDate, urlPhoto = usProfile.UrlPhoto, projects = proj, followedProjects = followproj }; return(new ObjectResult(userInfo)); }
public async Task <IActionResult> Post([FromBody] getUser body) { using (var db = new AppDb()) { await db.Connection.OpenAsync(); body.Db = db; await body.GetUserAsync(); return(new OkObjectResult(body.respuesta)); } }
public IActionResult selectUserById(int userId) { List <getUser> userList = new List <getUser>(); try { DataTable dt = Data.User.selectUserById(userId); getUser user = new getUser(); if (dt.Rows.Count > 0) { var DecryptPassword = Common.DecryptData(dt.Rows[0]["password"] == DBNull.Value ? "" : dt.Rows[0]["password"].ToString()); user.userId = (int)dt.Rows[0]["userId"]; user.firstName = (dt.Rows[0]["firstName"] == DBNull.Value ? "" : dt.Rows[0]["firstName"].ToString()); user.lastName = (dt.Rows[0]["lastName"] == DBNull.Value ? "" : dt.Rows[0]["lastName"].ToString()); user.gender = (dt.Rows[0]["gender"] == DBNull.Value ? "" : dt.Rows[0]["gender"].ToString()); user.dob = (dt.Rows[0]["dob"] == DBNull.Value ? "" : dt.Rows[0]["dob"].ToString()); user.email = (dt.Rows[0]["email"] == DBNull.Value ? "" : dt.Rows[0]["email"].ToString()); user.password = DecryptPassword; user.phoneNumber = (dt.Rows[0]["phoneNumber"] == DBNull.Value ? "" : dt.Rows[0]["phoneNumber"].ToString()); user.countryId = (dt.Rows[0]["countryId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["countryId"]); user.stateId = (dt.Rows[0]["stateId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["stateId"]); user.city = (dt.Rows[0]["city"] == DBNull.Value ? "" : dt.Rows[0]["city"].ToString()); user.address = (dt.Rows[0]["address"] == DBNull.Value ? "" : dt.Rows[0]["address"].ToString()); user.pinCode = (dt.Rows[0]["pinCode"] == DBNull.Value ? "" : dt.Rows[0]["pinCode"].ToString()); user.profileImage = (dt.Rows[0]["profileImage"] == DBNull.Value ? "" : dt.Rows[0]["profileImage"].ToString()); user.userType = (dt.Rows[0]["userType"] == DBNull.Value ? "" : dt.Rows[0]["userType"].ToString()); user.isEmailNotification = (dt.Rows[0]["isEmailNotification"] == DBNull.Value ? false : (bool)dt.Rows[0]["isEmailNotification"]); user.isEmailVerified = (dt.Rows[0]["isEmailVerified"] == DBNull.Value ? false : (bool)dt.Rows[0]["isEmailVerified"]); user.isSMSNotification = (dt.Rows[0]["isSMSNotification"] == DBNull.Value ? false : (bool)dt.Rows[0]["isSMSNotification"]); user.userCreatedDate = (dt.Rows[0]["userCreatedDate"] == DBNull.Value ? "" : dt.Rows[0]["userCreatedDate"].ToString()); user.isPublicProfile = (dt.Rows[0]["isPublicProfile"] == DBNull.Value ? false : (bool)dt.Rows[0]["isPublicProfile"]); user.userUpdatedDate = (dt.Rows[0]["userUpdatedDate"] == DBNull.Value ? "" : dt.Rows[0]["userUpdatedDate"].ToString()); user.passwordUpdatedDate = (dt.Rows[0]["passwordUpdatedDate"] == DBNull.Value ? "" : dt.Rows[0]["passwordUpdatedDate"].ToString()); userList.Add(user); return(StatusCode((int)HttpStatusCode.OK, new { user })); } else { string[] data = new string[0]; return(StatusCode((int)HttpStatusCode.OK, data)); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("selectUserById", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message } })); } }
public IActionResult Login([FromBody] Login login) { //string GetConnectionString = UsersController.GetConnectionString(); IActionResult response = Unauthorized(); //var user = AuthenticateUser(login); List <getUser> userList = new List <getUser>(); try { Regex regex = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$"); Match match = regex.Match(login.email); if (match.Success) { if (login.userTypeid > 0) { DataSet ds = Data.User.login(login); DataTable dt0 = ds.Tables[0]; if (dt0.Rows[0]["ErrorMessage"].ToString() == "Success") { DataTable dt = ds.Tables[1]; getUser user = new getUser(); user.userId = (int)dt.Rows[0]["userId"]; user.firstName = (dt.Rows[0]["firstName"] == DBNull.Value ? "" : dt.Rows[0]["firstName"].ToString()); user.lastName = (dt.Rows[0]["lastName"] == DBNull.Value ? "" : dt.Rows[0]["lastName"].ToString()); user.gender = (dt.Rows[0]["gender"] == DBNull.Value ? "" : dt.Rows[0]["gender"].ToString()); user.userType = (dt.Rows[0]["userType"] == DBNull.Value ? "" : dt.Rows[0]["userType"].ToString()); user.email = (dt.Rows[0]["email"] == DBNull.Value ? "" : dt.Rows[0]["email"].ToString()); //user.password = (dt.Rows[0]["password"] == DBNull.Value ? "" : dt.Rows[0]["password"].ToString()); user.phoneNumber = (dt.Rows[0]["phoneNumber"] == DBNull.Value ? "" : dt.Rows[0]["phoneNumber"].ToString()); user.countryId = (dt.Rows[0]["countryId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["countryId"]); user.stateId = (dt.Rows[0]["stateId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["stateId"]); user.city = (dt.Rows[0]["city"] == DBNull.Value ? "" : dt.Rows[0]["city"].ToString()); user.address = (dt.Rows[0]["address"] == DBNull.Value ? "" : dt.Rows[0]["address"].ToString()); user.pinCode = (dt.Rows[0]["pinCode"] == DBNull.Value ? "" : dt.Rows[0]["pinCode"].ToString()); user.profileImage = (dt.Rows[0]["profileImage"] == DBNull.Value ? "" : dt.Rows[0]["profileImage"].ToString()); user.isEmailNotification = (dt.Rows[0]["isEmailNotification"] == DBNull.Value ? false : (bool)dt.Rows[0]["isEmailNotification"]); user.isEmailVerified = (dt.Rows[0]["isEmailVerified"] == DBNull.Value ? false : (bool)dt.Rows[0]["isEmailVerified"]); user.isSMSNotification = (dt.Rows[0]["isSMSNotification"] == DBNull.Value ? false : (bool)dt.Rows[0]["isSMSNotification"]); user.userCreatedDate = (dt.Rows[0]["userCreatedDate"] == DBNull.Value ? "" : dt.Rows[0]["userCreatedDate"].ToString()); user.isPublicProfile = (dt.Rows[0]["isPublicProfile"] == DBNull.Value ? false : (bool)dt.Rows[0]["isPublicProfile"]); user.userUpdatedDate = (dt.Rows[0]["userUpdatedDate"] == DBNull.Value ? "" : dt.Rows[0]["userUpdatedDate"].ToString()); user.passwordUpdatedDate = (dt.Rows[0]["passwordUpdatedDate"] == DBNull.Value ? "" : dt.Rows[0]["passwordUpdatedDate"].ToString()); userList.Add(user); var token = GenerateJSONWebToken(); //var encrypt = Common.EncryptData(token); return(StatusCode((int)HttpStatusCode.OK, new { user, token })); } else { return(StatusCode((int)HttpStatusCode.Forbidden, new { error = new { message = dt0.Rows[0]["ErrorMessage"].ToString() } })); } } else { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter a userTypeId" } })); } } else { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter a valid Email" } })); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("Login", e.Message); //return StatusCode((int)HttpStatusCode.InternalServerError, new { Data = e.Message.ToString() }); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message } })); } }
public EditUserForm() { InitializeComponent(); getter = new getConnection(getConn); userGetter = new getUser(getUserData); }