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);
}
