using ExpressBase.Common;

using ExpressBase.Common.Data;

using ExpressBase.Common.LocationNSolution;

using ExpressBase.Common.Objects;

using ExpressBase.Common.ServiceClients;

using ExpressBase.Common.Singletons;

using ExpressBase.Common.Structures;

using ExpressBase.Objects;

using ExpressBase.Objects.Objects.DVRelated;

using ExpressBase.Objects.ServiceStack_Artifacts;

using ExpressBase.Security.Core;

using ExpressBase.Web.BaseControllers;

using ExpressBase.Web.Filters;

using Microsoft.AspNetCore.Mvc;

using Newtonsoft.Json;

using ServiceStack;

using ServiceStack.Redis;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Reflection;

using ExpressBase.Common.Extensions;

namespace ExpressBase.Web.Controllers

{

public class SecurityController : EbBaseIntCommonController

{

public SecurityController(IServiceClient _client, IRedisClient _redis, IEbMqClient _mqc) : base(_client, _redis, _mqc) { }

[EbBreadCrumbFilter("Security/type")]

public IActionResult CommonList(string type, string show)

{

if (!HasPemissionToSecurity())

return Redirect("/StatusCode/401");

type = type.ToLower();

ViewBag.ListType = type;

if (type == "users")

{

ViewBag.DisableNewUser = "false";

GetUsersResponse1 fr = this.ServiceClient.Get<GetUsersResponse1>(new GetUsersRequest1() { Show = show });

ViewBag.dict = JsonConvert.SerializeObject(fr.Data);

Eb_Solution _solu = GetSolutionObject(ViewBag.Cid);

//if (_solu.PlanUserCount <= _solu.NumberOfUsers)

// ViewBag.DisableNewUser = "true";

string puFormRefid = _solu?.SolutionSettings?.ProvisionUserFormRefid;

if (!string.IsNullOrWhiteSpace(puFormRefid))

{

EbWebForm WebForm = EbFormHelper.GetEbObject<EbWebForm>(puFormRefid, this.ServiceClient, this.Redis, null);

ViewBag.ProvUserFormName = WebForm.DisplayName;

ViewBag.ProvUserFormRefid = puFormRefid;

}

}

else if (type == "roles")

{

GetRolesResponse1 fr = this.ServiceClient.Get<GetRolesResponse1>(new GetRolesRequest1());

ViewBag.dict = JsonConvert.SerializeObject(fr.Data);

}

else if (type == "usergroups")

{

GetUserGroupResponse1 fr = this.ServiceClient.Get<GetUserGroupResponse1>(new GetUserGroupRequest1());

ViewBag.dict = JsonConvert.SerializeObject(fr.Data);

}

else if (type == "anonymoususers")

{

GetAnonymousUserResponse fr = this.ServiceClient.Get<GetAnonymousUserResponse>(new GetAnonymousUserRequest());

ViewBag.dict = JsonConvert.SerializeObject(fr.Data);

}

else if (type == "usertypes")

{

GetUserTypesResponse fr = this.ServiceClient.Get<GetUserTypesResponse>(new GetUserTypesRequest());

ViewBag.dict = JsonConvert.SerializeObject(fr.UserTypes);

}

if (ViewBag.isAjaxCall)

return PartialView();

else

return View();

}

private bool HasPemissionToSecurity()

{

if (ViewBag.wc == RoutingConstants.UC)

{

if (this.LoggedInUser.Roles.Contains(SystemRoles.SolutionOwner.ToString()))

return true;

if (this.LoggedInUser.Roles.Contains(SystemRoles.SolutionAdmin.ToString()))

return true;

if (this.LoggedInUser.Roles.Contains(SystemRoles.SolutionPM.ToString()))

return true;

}

return false;

}

//--------------MY PROFILE------------------------------------------

[EbBreadCrumbFilter("Security")]

public IActionResult MyProfile()

{

if (ViewBag.wc == RoutingConstants.TC)

return Redirect("/MyProfile");

string mode = "user";

if (isTenant())

mode = "tenant";

GetMyProfileResponse fr = this.ServiceClient.Get<GetMyProfileResponse>(new GetMyProfileRequest

{

WC = ViewBag.wc,

DBIds = this.LoggedInUser.GetDashBoardIds(),

IsSolutionOwner = HasPemissionToSecurity()

});

Eb_Solution _solu = GetSolutionObject(ViewBag.Cid);

Dictionary<string, int> _locs = new Dictionary<string, int>();

if (this.LoggedInUser.LocationIds.Contains(-1))

{

foreach (KeyValuePair<int, EbLocation> entry in _solu.Locations)

{

string st = entry.Value.ShortName + " - " + entry.Value.LongName;

if (!_locs.ContainsKey(st))

_locs.Add(st, entry.Key);

else if (!_locs.ContainsKey($"{st}[{entry.Key}]"))

_locs.Add($"{st}[{entry.Key}]", entry.Key);

}

}

else

{

foreach (int id in this.LoggedInUser.LocationIds)

{

if (_solu.Locations.ContainsKey(id))

{

string st = _solu.Locations[id].ShortName + " - " + _solu.Locations[id].LongName;

if (!_locs.ContainsKey(st))

_locs.Add(st, id);

else if (!_locs.ContainsKey($"{st}[{id}]"))

_locs.Add($"{st}[{id}]", id);

}

}

}

ViewBag.LocsData = _locs;

ViewBag.UserData = fr.UserData;

ViewBag.RefIds = fr.RefIds;

ViewBag.Mode = mode;

ViewBag.Cultures = CultureHelper.Cultures;

ViewBag.TimeZones = CultureHelper.Timezones;

return View();

}

[EbBreadCrumbFilter("My Profile")]

[HttpGet("MyProfile")]

public IActionResult MyProfile_Tenant()

{

if (ViewBag.wc == RoutingConstants.TC)

{

GetMyProfileResponse fr = this.ServiceClient.Get<GetMyProfileResponse>(new GetMyProfileRequest { WC = ViewBag.wc });

ViewBag.UserData = fr.UserData;

ViewBag.Title = "My Profile";

ViewBag.Cultures = CultureHelper.Cultures;

ViewBag.TimeZones = CultureHelper.Timezones;

return View();

}

return Redirect("/StatusCode/404");

}

public bool SaveMyProfile(string UserData)

{

bool isTenantAsUser = false;

if (isTenant() && (ViewBag.wc == RoutingConstants.UC || ViewBag.wc == RoutingConstants.DC))

isTenantAsUser = true;

SaveMyProfileResponse fr = this.ServiceClient.Get<SaveMyProfileResponse>(new SaveMyProfileRequest { UserData = UserData, WC = ViewBag.wc, PreferenceOnly = isTenantAsUser });

return (fr.RowsAffectd > 0);

}

public bool ChangeUserPassword(string OldPwd, string NewPwd)

{

if ((isTenant() && (ViewBag.wc == RoutingConstants.UC || ViewBag.wc == RoutingConstants.DC)) || this.LoggedInUser.UserId <= 1)

return false;

ChangeUserPasswordResponse resp = this.ServiceClient.Post<ChangeUserPasswordResponse>(new ChangeUserPasswordRequest { OldPwd = OldPwd, NewPwd = NewPwd, Email = ViewBag.email, WC = ViewBag.wc });

return resp.isSuccess;

}

private bool isTenant()

{

foreach (var item in Enum.GetNames(typeof(SystemRoles)))

if (this.LoggedInUser.Roles.Contains(item))

return true;

return false;

}

//--------------MANAGE USER START------------------------------------

[EbBreadCrumbFilter("Security")]

public IActionResult ManageUser(int itemid, int Mode, string AnonymousUserInfo)

{

if (!HasPemissionToSecurity())

return Redirect("/StatusCode/401");

Eb_Solution _solu = GetSolutionObject(ViewBag.Cid);

string puFormRefid = _solu?.SolutionSettings?.ProvisionUserFormRefid;

List<string> disableCtrls = new List<string>();

if (!string.IsNullOrWhiteSpace(puFormRefid))

{

EbWebForm WebForm = EbFormHelper.GetEbObject<EbWebForm>(puFormRefid, this.ServiceClient, this.Redis, null);

EbProvisionUser puCtrl = (EbProvisionUser)WebForm.Controls.GetAllControlsRecursively().Find(e => e is EbProvisionUser);

if (puCtrl != null)

{

foreach (UsrLocField fd in puCtrl.Fields)

{

if (!string.IsNullOrWhiteSpace(fd.ControlName))

disableCtrls.Add(fd.Name);

}

}

}

ViewBag.disableCtrls = disableCtrls;

//Mode - CreateEdit = 1, View = 2, MyProfileView = 3

ViewBag.Culture = CultureHelper.CulturesAsJson;

ViewBag.TimeZone = CultureHelper.TimezonesAsJson;

ViewBag.MU_Mode = Mode == 0 ? 1 : Mode;

GetManageUserResponse fr = this.ServiceClient.Get<GetManageUserResponse>(new GetManageUserRequest { Id = itemid, RqstMode = Mode, SolnId = ViewBag.cid });

foreach (var role in Enum.GetValues(typeof(SystemRoles)))

{

fr.Roles.Add(new EbRole()

{

Name = role.ToString(),

Description = "SYSTEM ROLE",

Id = (int)role

});

}

ViewBag.Roles = JsonConvert.SerializeObject(fr.Roles);

ViewBag.EBUserGroups = JsonConvert.SerializeObject(fr.EbUserGroups);

ViewBag.Role2RoleList = JsonConvert.SerializeObject(fr.Role2RoleList);

ViewBag.UserTypes = fr.UserTypes;

List<string> UserStatus = new List<string>();

foreach (var status in Enum.GetValues(typeof(EbUserStatus)))

UserStatus.Add(status.ToString());

ViewBag.UserStatusList = UserStatus;

if (Mode == 3)

itemid = Convert.ToInt32(fr.UserData["id"]);

if (itemid == 1)

ViewBag.U_Info = JsonConvert.DeserializeObject<Dictionary<string, string>>(AnonymousUserInfo);

else if (itemid > 1)

{

if (fr.UserData.Count > 0)

{

ViewBag.U_Info = fr.UserData;

ViewBag.U_Roles = JsonConvert.SerializeObject(fr.UserRoles);

ViewBag.U_Groups = JsonConvert.SerializeObject(fr.UserGroups);

ViewBag.LocConstraint = JsonConvert.SerializeObject(fr.LocConstraint);

}

else

{

ViewBag.U_Roles = "";

ViewBag.U_Groups = "";

itemid = 0;

}

}

else

{

ViewBag.U_Roles = "";

ViewBag.U_Groups = "";

}

ViewBag.itemid = itemid;

////for showing login activity log

Type[] typeArray = typeof(EbDataVisualizationObject).GetTypeInfo().Assembly.GetTypes();

Context2Js _jsResult = new Context2Js(typeArray, BuilderType.DVBuilder, typeof(EbDataVisualizationObject));

ViewBag.Meta = _jsResult.AllMetas;

ViewBag.JsObjects = _jsResult.JsObjects;

ViewBag.EbObjectTypes = _jsResult.EbObjectTypes;

string query = string.Empty;

List<Param> _params = new List<Param>();

query = @"SELECT

signin.ip_address, signin.signin_at,

signin.signin_at AS signin_time, signin.signout_at,

signin.signout_at AS signout_time,

age(date_trunc('second', signout_at),date_trunc('second', signin_at))::text AS duration

FROM

eb_signin_log signin,

eb_users users

WHERE

is_attempt_failed = :islg

AND signin.user_id = :usrid

AND users.id = :usrid

ORDER BY

signin.signin_at DESC;";

_params.Add(new Param { Name = "islg", Type = ((int)EbDbTypes.String).ToString(), Value = "F" });

_params.Add(new Param { Name = "usrid", Type = ((int)EbDbTypes.Int32).ToString(), Value = itemid.ToString() });

DVColumnCollection DVColumnCollection = GetColumnsForLoginActivitySuser();

EbDataVisualization Visualization = new EbTableVisualization { Sql = query, ParamsList = _params, Columns = DVColumnCollection, AutoGen = false, IsPaging = true };

string VisualObj = EbSerializers.Json_Serialize(Visualization);

ViewBag.VisualObj = VisualObj;

return View();

}

public int SaveUser(int userid, string roles, string usergroups, string usrinfo)

{

Dictionary<string, string> Dict = JsonConvert.DeserializeObject<Dictionary<string, string>>(usrinfo);

if (!HasPemissionToSecurity())

{

return 0;

}

else//temp fix

{

List<int> roleids = new List<int>();

if (this.LoggedInUser.UserId == userid)

{

if (!string.IsNullOrEmpty(Dict["roles"]))//for avoiding format exception in next line

roleids = Array.ConvertAll(Dict["roles"].Split(','), int.Parse).ToList();

if (!roleids.Contains((int)SystemRoles.SolutionOwner))

{

roleids.Add((int)SystemRoles.SolutionOwner);

Dict["roles"] = String.Join(",", roleids);

}

}

}

//if (userid <= 0 && ViewBag.Env == "Production")

//{

// Eb_Solution _solu = GetSolutionObject(ViewBag.Cid);

// if (_solu.PlanUserCount <= _solu.NumberOfUsers)

// return -1;

//}

SaveUserResponse res = this.ServiceClient.Post<SaveUserResponse>(new SaveUserRequest

{

Id = userid,

FullName = Dict["fullname"],

NickName = Dict["nickname"],

EmailPrimary = Dict["email"].Trim().ToLower(),

Password = Dict["pwd"],

EmailSecondary = Dict["alternateemail"],

DateOfBirth = Dict["dob"],

Sex = Dict["sex"],

PhonePrimary = Dict["phoneprimary"],

PhoneSecondary = Dict["phonesecondary"],

LandPhone = Dict["landline"],

PhoneExtension = Dict["extension"],

FbId = Dict["fbid"],

FbName = Dict["fbname"],

Roles = string.IsNullOrEmpty(Dict["roles"]) ? string.Empty : Dict["roles"],

UserGroups = string.IsNullOrEmpty(Dict["usergroups"]) ? string.Empty : Dict["usergroups"],

StatusId = Dict["statusid"],

Hide = Dict["hide"],

AnonymousUserId = Convert.ToInt32(Dict["anonymoususerid"]),

Preference = Dict["preference"],

UserType = Convert.ToInt32(Dict["eb_user_types_id"]),

LocationAdd = Dict["loc_add"],

LocationDelete = Dict["loc_delete"],

ForceResetPassword = (Dict["forceresetpw"] == "true") ? "T" : "F"

});

return res.id;

}

public bool IsUnique(string val, int id, int mode)

{

//val = value to be checked

//id = check except this id// for edit purpose

//mode = to select the query// see ss

if (string.IsNullOrEmpty(val) || mode <= 0)

return false;

UniqueCheckResponse temp = this.ServiceClient.Post<UniqueCheckResponse>(new UniqueCheckRequest

{

Value = val,

Id = id,

QryId = (UniqueCheckQueryId)mode

});

return temp.unrespose;

}

public bool ResetUserPassword(int userid, string username, string NewPwd)

{

if (!HasPemissionToSecurity())

return false;

else

{

ResetUserPasswordResponse resp = this.ServiceClient.Post<ResetUserPasswordResponse>(new ResetUserPasswordRequest { Id = userid, Email = username, NewPwd = NewPwd });

return resp.isSuccess;

}

}

public int DeleteUser(int userid)

{

if (!HasPemissionToSecurity())

return 0;

else

{

DeleteUserResponse resp = this.ServiceClient.Post<DeleteUserResponse>(new DeleteUserRequest { Id = userid });

return resp.Status;

}

}

public string IsApiKeyExists(int userId)

{

IsApiKeyExistsResponse resp = new IsApiKeyExistsResponse() { KeyId = -1 };

if (userId <= 0)

{

resp.ResponseStatus.Message = "Invalid user id";

}

else if (!HasPemissionToSecurity())

{

resp.ResponseStatus.Message = "Unauthorized access";

}

else

{

try

{

resp = this.ServiceClient.Post<IsApiKeyExistsResponse>(new IsApiKeyExistsRequest { Id = userId });

}

catch (Exception ex)

{

Console.WriteLine("Exception in IsApiKeyExists : " + ex.Message);

resp.ResponseStatus.Message = ex.Message;

}

}

return JsonConvert.SerializeObject(resp);

}

public string ViewApiKey(int userId)

{

ViewApiKeyResponse resp = new ViewApiKeyResponse();

if (userId <= 0)

{

resp.ResponseStatus.Message = "Invalid user id";

}

else if (!HasPemissionToSecurity())

{

resp.ResponseStatus.Message = "Unauthorized access";

}

else

{

try

{

resp = this.ServiceClient.Post<ViewApiKeyResponse>(new ViewApiKeyRequest { Id = userId });

}

catch (Exception ex)

{

Console.WriteLine("Exception in ViewApiKey: " + ex.Message);

resp.ResponseStatus.Message = ex.Message;

}

}

return JsonConvert.SerializeObject(resp);

}

public string DeleteApiKey(int userId)

{

DeleteApiKeyResponse resp = new DeleteApiKeyResponse();

if (userId <= 0)

{

resp.ResponseStatus.Message = "Invalid user id";

}

else if (!HasPemissionToSecurity())

{

resp.ResponseStatus.Message = "Unauthorized access";

}

else

{

try

{

resp = this.ServiceClient.Post<DeleteApiKeyResponse>(new DeleteApiKeyRequest { Id = userId });

}

catch (Exception ex)

{

Console.WriteLine("Exception in DeleteApiKey: " + ex.Message);

resp.ResponseStatus.Message = ex.Message;

}

}

return JsonConvert.SerializeObject(resp);

}

public string GenerateApiKey(int userId)

{

GenerateApiKeyResponse resp = new GenerateApiKeyResponse();

if (userId <= 0)

{

resp.ResponseStatus.Message = "Invalid user id";

}

else if (!HasPemissionToSecurity())

{

resp.ResponseStatus.Message = "Unauthorized access";

}

else

{

try

{

resp = this.ServiceClient.Post<GenerateApiKeyResponse>(new GenerateApiKeyRequest { Id = userId });

}

catch (Exception ex)

{

Console.WriteLine("Exception in GenerateApiKey : " + ex.Message);

resp.ResponseStatus.Message = ex.Message;

}

}

return JsonConvert.SerializeObject(resp);

}

//--------------MANAGE ANONYMOUS USER START------------------------------------

[EbBreadCrumbFilter("Security")]

public IActionResult ManageAnonymousUser(int itemid)

{

if (!HasPemissionToSecurity())

return Redirect("/StatusCode/401");

return View();

}

public string GetAnonymousUserInfo(int userid)

{

if (!HasPemissionToSecurity())

return string.Empty;

GetManageAnonymousUserResponse temp = this.ServiceClient.Post<GetManageAnonymousUserResponse>(new GetManageAnonymousUserRequest { Id = userid });

return JsonConvert.SerializeObject(temp.UserData);

}

public int UpdateAnonymousUserInfo(int itemid, string name, string email, string phone, string remarks)

{

if (!HasPemissionToSecurity())

return 0;

UpdateAnonymousUserResponse temp = this.ServiceClient.Post<UpdateAnonymousUserResponse>(new UpdateAnonymousUserRequest { Id = itemid, FullName = name.IsNullOrEmpty() ? "" : name, EmailID = email.IsNullOrEmpty() ? "" : email, PhoneNumber = phone.IsNullOrEmpty() ? "" : phone, Remarks = remarks.IsNullOrEmpty() ? "" : remarks });

return temp.RowAffected;

}

public string GetUserTypes(int typeid)

{

if (!HasPemissionToSecurity())

return string.Empty;

GetUserTypesResponse temp = this.ServiceClient.Get<GetUserTypesResponse>(new GetUserTypesRequest { Id = typeid });

return JsonConvert.SerializeObject(temp.UserTypes);

}

public string GetUsersList(string searchtxt)

{

GetUserDetailsResponse temp = this.ServiceClient.Get<GetUserDetailsResponse>(new GetUserDetailsRequest { SearchText = searchtxt });

return JsonConvert.SerializeObject(temp.UserList);

}

[EbBreadCrumbFilter("Security")]

public IActionResult ManageUserTypes(int itemid)

{

if (!HasPemissionToSecurity())

return Redirect("/StatusCode/401");

GetManageUserGroupResponse fr = this.ServiceClient.Get<GetManageUserGroupResponse>(new GetManageUserGroupRequest { id = itemid, SolnId = ViewBag.cid, Timezone = this.LoggedInUser.Preference.TimeZone });

ViewBag.SelectedUserGroupInfo = JsonConvert.SerializeObject(fr.SelectedUserGroupInfo);

ViewBag.UsersList = JsonConvert.SerializeObject(fr.UsersList);

ViewBag.IpConsList = JsonConvert.SerializeObject(fr.IpConsList);

ViewBag.DtConsList = JsonConvert.SerializeObject(fr.DtConsList);

return View();

}

//----------------MANAGE USERGROUPS START----------------------------

//[HttpGet]

//public IActionResult ManageUserGroups()

//{

// return View();

//}

//[HttpPost]

[EbBreadCrumbFilter("Security")]

public IActionResult ManageUserGroups(int itemid)

{

if (!HasPemissionToSecurity())

return Redirect("/StatusCode/401");

GetManageUserGroupResponse fr = this.ServiceClient.Get<GetManageUserGroupResponse>(new GetManageUserGroupRequest { id = itemid, SolnId = ViewBag.cid, Timezone = this.LoggedInUser.Preference.TimeZone });

ViewBag.SelectedUserGroupInfo = JsonConvert.SerializeObject(fr.SelectedUserGroupInfo);

ViewBag.UsersList = JsonConvert.SerializeObject(fr.UsersList);

ViewBag.IpConsList = JsonConvert.SerializeObject(fr.IpConsList);

ViewBag.DtConsList = JsonConvert.SerializeObject(fr.DtConsList);

ViewBag.UsersListAll = JsonConvert.SerializeObject(fr.UsersListAll);

return View();

}

public int SaveUserGroup(int _id, string _userGroupInfo)

{

if (!HasPemissionToSecurity())

return 0;

Dictionary<string, string> Dict = JsonConvert.DeserializeObject<Dictionary<string, string>>(_userGroupInfo);

SaveUserGroupResponse res = this.ServiceClient.Post<SaveUserGroupResponse>(new SaveUserGroupRequest

{

Id = _id,

Name = Dict["name"],

Description = Dict["description"],

Users = string.IsNullOrEmpty(Dict["users"]) ? string.Empty : Dict["users"],

IpConstraintNw = Dict["new_constraint_ip"],

IpConstraintOld = Dict["deleted_ipconst_id"],

DtConstraintNw = Dict["new_constraint_dt"],

DtConstraintOld = Dict["deleted_ipconst_dt"],

UsersTimezone = this.LoggedInUser.Preference.TimeZone

});

return res.id;

}

//---------------MANAGE ROLES START----------------------------------

[EbBreadCrumbFilter("Security")]

public IActionResult ManageRoles(int itemid)

{

if (!HasPemissionToSecurity())

return Redirect("/StatusCode/401");

ViewBag.itemid = itemid;

return View();

}

//GET PERMISSION OPERATIONS AS JS

private string GetPermissionOperationsAsJs()

{

Assembly assembly = Assembly.GetAssembly(typeof(EbWebForm)); //DO NOT CHANGE

List<Eb_ObjectTypeOperations> _listObj = new List<Eb_ObjectTypeOperations>();

foreach (EbObjectType objectType in EbObjectTypes.Enumerator)

{

if (objectType.IsUserFacing)

{

var eOperations = assembly.GetType(string.Format("ExpressBase.Objects.Eb{0}", objectType.Name))

.GetField("Operations").GetValue(null);

if (eOperations != null)

{

Eb_ObjectTypeOperations _obj = new Eb_ObjectTypeOperations { Op_Id = objectType.IntCode, Op_Name = objectType.Name, Operations = new List<string>() };

foreach (EbOperation Op in (eOperations as EbOperations).Enumerator)

_obj.Operations.Add(Op.ToString());

_listObj.Add(_obj);

}

}

}

return EbSerializers.Json_Serialize(_listObj);

}

public string SaveRole(int _roleId, string _roleName, string _roleDesc, bool _isAnonymous, bool _isPrimary, int _appId, string _permission, string _role2role, string _users, string _locations)

{

if (!HasPemissionToSecurity())

return "Failed";

if (Enum.TryParse(typeof(SystemRoles), _roleName.Trim().ToLower(), true, out object r))

return "Failed";

Dictionary<string, object> Dict = new Dictionary<string, object>();

string return_msg;

Dict["roleid"] = _roleId;

Dict["applicationid"] = _appId;

Dict["role_name"] = _roleName;

Dict["Description"] = _roleDesc;

Dict["IsAnonymous"] = _isAnonymous ? "T" : "F";

Dict["IsPrimary"] = _isPrimary ? "T" : "F";

Dict["users"] = string.IsNullOrEmpty(_users) ? string.Empty : _users;

Dict["permission"] = string.IsNullOrEmpty(_permission) ? string.Empty : _permission;

Dict["dependants"] = string.IsNullOrEmpty(_role2role) ? string.Empty : _role2role;

Dict["locations"] = string.IsNullOrEmpty(_locations) ? string.Empty : _locations;

SaveRoleResponse res = this.ServiceClient.Post<SaveRoleResponse>(new SaveRoleRequest { Colvalues = Dict });

if (res.id == 0)

return_msg = "Success";

else if (res.id == -1)

return_msg = "Duplicate";

else

return_msg = "Failed";

return return_msg;

}

public bool isValidRoleName(string reqRoleName)

{

try

{

if (!HasPemissionToSecurity())

return false;

if (Enum.TryParse(typeof(SystemRoles), reqRoleName.ToLower(), true, out object r))

return true;//role name is already exists

UniqueCheckResponse result = this.ServiceClient.Post<UniqueCheckResponse>(new UniqueCheckRequest { Value = reqRoleName, QryId = UniqueCheckQueryId.eb_roles__role_name });

return !result.unrespose;///////////////////

}

catch (Exception ex)

{

Console.WriteLine("Exception in isValidRoleName : " + ex.Message);

return false;

}

}

//--------------------- TEST IP -------------------------------------------

//public string GetRequestIP(bool tryUseXForwardHeader = true)

//{

// string ip = null;

// // todo support new "Forwarded" header (2014) https://en.wikipedia.org/wiki/X-Forwarded-For

// // X-Forwarded-For (csv list): Using the First entry in the list seems to work

// // for 99% of cases however it has been suggested that a better (although tedious)

// // approach might be to read each IP from right to left and use the first public IP.

// // http://stackoverflow.com/a/43554000/538763

// //

// if (tryUseXForwardHeader)

// ip = SplitCsv(GetHeaderValueAs<string>("X-Forwarded-For")).FirstOrDefault();

// // RemoteIpAddress is always null in DNX RC1 Update1 (bug).

// if (String.IsNullOrWhiteSpace(ip) && this.Request.HttpContext?.Connection?.RemoteIpAddress != null)

// ip = this.Request.HttpContext.Connection.RemoteIpAddress.ToString();

// if (String.IsNullOrWhiteSpace(ip))

// ip = GetHeaderValueAs<string>("REMOTE_ADDR");

// // _httpContextAccessor.HttpContext?.Request?.Host this is the local host.

// if (String.IsNullOrWhiteSpace(ip))

// throw new Exception("Unable to determine caller's IP.");

// return ip;

//}

//public T GetHeaderValueAs<T>(string headerName)

//{

// StringValues values;

// if (this.Request.HttpContext?.Request?.Headers?.TryGetValue(headerName, out values) ?? false)

// {

// string rawValues = values.ToString(); // writes out as Csv when there are multiple.

// if (!rawValues.IsNullOrEmpty())

// return (T)Convert.ChangeType(values.ToString(), typeof(T));

// }

// return default(T);

//}

//public static List<string> SplitCsv(string csvList, bool nullOrWhitespaceInputReturnsNull = false)

//{

// if (string.IsNullOrWhiteSpace(csvList))

// return nullOrWhitespaceInputReturnsNull ? null : new List<string>();

// return csvList

// .TrimEnd(',')

// .Split(',')

// .AsEnumerable<string>()

// .Select(s => s.Trim())

// .ToList();

//}

//public static bool IsNullOrWhitespace(string s)

//{

// return String.IsNullOrWhiteSpace(s);

//}

public IActionResult LoginActivity()

{

Type[] typeArray = typeof(EbDataVisualizationObject).GetTypeInfo().Assembly.GetTypes();

Context2Js _jsResult = new Context2Js(typeArray, BuilderType.DVBuilder, typeof(EbDataVisualizationObject));

ViewBag.Meta = _jsResult.AllMetas;

ViewBag.JsObjects = _jsResult.JsObjects;

ViewBag.EbObjectTypes = _jsResult.EbObjectTypes;

string query = string.Empty;

List<Param> _params = new List<Param>();

query = @"SELECT

users.fullname, signin.device_info ::json -> 'WC' AS usertype, signin.ip_address, signin.signin_at,

signin.signin_at AS signin_time, signin.signout_at,

signin.signout_at AS signout_time,

age(date_trunc('second', signout_at),date_trunc('second', signin_at))::text AS duration

FROM

eb_signin_log signin,

eb_users users

WHERE

is_attempt_failed = :islg

AND signin.user_id = users.id

AND signin.device_info != ''

ORDER BY

signin.signin_at DESC;";

_params.Add(new Param { Name = "islg", Type = ((int)EbDbTypes.String).ToString(), Value = "F" });

string[] arrayy = new string[] { "fullname", "usertype", "ip_address", "signin_at", "signin_time", "signout_at", "signout_time", "duration" };

DVColumnCollection DVColumnCollection = GetColumnsForLoginActivity(arrayy);

EbDataVisualization Visualization = new EbTableVisualization { Sql = query, ParamsList = _params, Columns = DVColumnCollection, AutoGen = false, IsPaging = true };

string VisualObj = EbSerializers.Json_Serialize(Visualization);

ViewBag.VisualObj = VisualObj;

return View();

}

public DVColumnCollection GetColumnsForLoginActivity(string[] strArray)

{

var Columns = new DVColumnCollection();

try

{

foreach (string str in strArray)

{

DVBaseColumn _col = null;

if (str == "fullname")

_col = new DVStringColumn { Data = 0, Name = str, sTitle = "Full name", Type = EbDbTypes.String, bVisible = true };

if (str == "usertype")

_col = new DVStringColumn { Data = 1, Name = str, sTitle = "User type", Type = EbDbTypes.String, bVisible = true };

if (str == "ip_address")

_col = new DVStringColumn { Data = 2, Name = str, sTitle = "Ip address", Type = EbDbTypes.String, bVisible = true };

if (str == "signin_at")

_col = new DVDateTimeColumn { Data = 3, Name = str, sTitle = "SignIn at", Type = EbDbTypes.DateTime, bVisible = true, Format = DateFormat.Date, ConvretToUsersTimeZone = true };

if (str == "signin_time")

_col = new DVDateTimeColumn { Data = 4, Name = str, sTitle = "SignIn time", Type = EbDbTypes.DateTime, bVisible = true, Format = DateFormat.Time, ConvretToUsersTimeZone = true };

if (str == "signout_at")

_col = new DVDateTimeColumn { Data = 5, Name = str, sTitle = "SignOut at", Type = EbDbTypes.DateTime, bVisible = true, Format = DateFormat.Date, ConvretToUsersTimeZone = true };

if (str == "signout_time")

_col = new DVDateTimeColumn { Data = 6, Name = str, sTitle = "SignOut time", Type = EbDbTypes.DateTime, bVisible = true, Format = DateFormat.Time, ConvretToUsersTimeZone = true };

if (str == "duration")

_col = new DVStringColumn { Data = 7, Name = str, sTitle = "Duration", Type = EbDbTypes.String, bVisible = true };

_col.Name = str;

_col.RenderType = _col.Type;

_col.ClassName = "tdheight";

_col.Font = null;

_col.Align = Align.Left;

Columns.Add(_col);

}

}

catch (Exception e)

{

Console.WriteLine("no coloms" + e.StackTrace);

}

return Columns;

}

public DVColumnCollection GetColumnsForLoginActivitySuser()

{

var Columns = new DVColumnCollection();

try

{

Columns.Add(new DVStringColumn { Data = 0, Name = "ip_address", sTitle = "Ip address", Type = EbDbTypes.String, RenderType = EbDbTypes.String, bVisible = true, ClassName = "tdheight", Font = null });

Columns.Add(new DVDateTimeColumn { Data = 1, Name = "signin_at", sTitle = "SignIn at", Type = EbDbTypes.DateTime, RenderType = EbDbTypes.DateTime, bVisible = true, Format = DateFormat.Date, ConvretToUsersTimeZone = true, ClassName = "tdheight", Font = null });

Columns.Add(new DVDateTimeColumn { Data = 2, Name = "signin_time", sTitle = "SignIn time", Type = EbDbTypes.DateTime, RenderType = EbDbTypes.DateTime, bVisible = true, Format = DateFormat.Time, ConvretToUsersTimeZone = true, ClassName = "tdheight", Font = null });

Columns.Add(new DVDateTimeColumn { Data = 3, Name = "signout_at", sTitle = "SignOut at", Type = EbDbTypes.DateTime, RenderType = EbDbTypes.DateTime, bVisible = true, Format = DateFormat.Date, ConvretToUsersTimeZone = true, ClassName = "tdheight", Font = null });

Columns.Add(new DVDateTimeColumn { Data = 4, Name = "signout_time", sTitle = "SignOut time", Type = EbDbTypes.DateTime, RenderType = EbDbTypes.DateTime, bVisible = true, Format = DateFormat.Time, ConvretToUsersTimeZone = true, ClassName = "tdheight", Font = null });

Columns.Add(new DVStringColumn { Data = 5, Name = "duration", sTitle = "Duration", Type = EbDbTypes.String, RenderType = EbDbTypes.String, bVisible = true, ClassName = "tdheight", Font = null });

}

catch (Exception e)

{

Console.WriteLine("no coloms" + e.StackTrace);

}

return Columns;

}

public bool UpdateUserType(int itemid, string name)

{

UpdateUserTypeResponse resp = this.ServiceClient.Post(new UpdateUserTypeRequset { Id = itemid, Name = name });

if (resp != null && resp.Status)

return true;

else

return false;

}

public bool BrowserExceptions(string errorMsg)

{

try

{

BrowserExceptionResponse Ber = this.MqClient.Post<BrowserExceptionResponse>(new BrowserExceptionMqRequest

{

Device_info = this.UserAgent,

Ip_address = this.RequestSourceIp,

Error_msg = errorMsg

});

if (Ber.Status)

return true;

else

return false;

}

catch (Exception ex)

{

Console.WriteLine(ex.Message + ex.StackTrace);

}

return false;

}

}

}