internal static async Task <List <AddEditNewUser> > GetUserAsync(TeamHttpContext httpContext, int userid)
{
string connString = Utility.GetConnectionString("PgAdmin4ConnectionString");
List <AddEditNewUser> returnValue = new List <AddEditNewUser>();
PostgresService postgresService = new PostgresService();
List <User> objUser = new List <User>();
using (TeamDbContext dbContext = new TeamDbContext())
{
if (userid != -1)
{
objUser = dbContext.Users.Where(x => x.Deleted == false && x.Id == userid).ToList();
}
else
{
objUser = dbContext.Users.Where(x => x.Deleted == false && x.UserType != UserType.Admin).ToList();
}
}
if (objUser.Count != 0)
{
foreach (var item in objUser)
{
var userstatus = (item.Status == UserStatus.Active) ? true : false;
AddEditNewUser newItem = new AddEditNewUser
{
UserId = item.UserId,
Password = "******",
UserEmail = item.Email,
TableId = item.Id,
IsActive = userstatus,
IsAddPermission = item.IsAdd,
IsEditPermission = item.IsEdit,
IsDeletePermission = item.IsDelete
};
returnValue.Add(newItem);
}
return(returnValue);
}
else
{
return(null);
}
}
internal async static Task <ResponseBase> EditUser(TeamHttpContext httpContext, AddEditNewUser details)
{
try
{
List <User> objUser = new List <User>();
using (TeamDbContext dbContext = new TeamDbContext())
{
if (dbContext.Users.AsNoTracking().FirstOrDefault(e => e.Id == details.TableId) != null)
{
objUser = dbContext.Users.Where(x => x.Id == details.TableId).ToList();
}
}
var userstatus = (details.IsActive) ? 1 : 2;
if (objUser.Count != 0)
{
EditUserDatabase(new User
{
Id = details.TableId,
UserId = details.UserId.ToUpper(CultureInfo.InvariantCulture),
Password = (details.Password.Contains("*******")) ? objUser[0].Password : Utility.GetMd5Hash(details.Password),
Email = details.UserEmail,
ModifiedBy = httpContext.ContextUserId,
//ModifiedBy = "Admin",
ModifiedOn = DateTime.Now,
UserType = UserType.Client,
CreatedBy = objUser[0].CreatedBy,
CreatedOn = objUser[0].CreatedOn,
Status = (UserStatus)userstatus,
IsAdd = details.IsAddPermission,
IsEdit = details.IsEditPermission,
IsDelete = details.IsDeletePermission,
});
return(GetResponse(httpContext, HttpStatusCode.OK, "Available"));
}
return(null);
}
catch (Exception ex)
{
return(GetResponse(httpContext, HttpStatusCode.BadRequest, ex.Message.ToString()));
}
}
internal static async Task <ResponseBase> AddUser(TeamHttpContext teamHttpContext, AddEditNewUser details)
{
try
{
AddUserDatabase(new User
{
UserId = details.UserId.ToUpper(CultureInfo.InvariantCulture),
Password = Utility.GetMd5Hash(details.Password),
UserType = UserType.Client,
Email = details.UserEmail,
CreatedBy = teamHttpContext.ContextUserId,
//CreatedBy = "Admin",
CreatedOn = DateTime.Now,
Status = UserStatus.Active,
IsAdd = details.IsAddPermission,
IsEdit = details.IsEditPermission,
IsDelete = details.IsDeletePermission
});
return(GetResponse(teamHttpContext, HttpStatusCode.OK, "Available"));
}
catch (Exception ex)
{
return(GetResponse(teamHttpContext, HttpStatusCode.BadRequest, ex.Message.ToString()));
}
}
