public RBACRolesResponse Post(RBACRolesRequest request)
{
RBACRolesResponse resp;
using (var con = this.TenantDbFactory.ObjectsDB.GetNewConnection())
{
con.Open();
string sql = "SELECT eb_create_or_update_rbac_manageroles(@role_id, @applicationid, @createdby, @role_name, @description, @users, @dependants,@permission );";
var cmd = this.TenantDbFactory.ObjectsDB.GetNewCommand(con, sql);
int[] emptyarr = new int[] { };
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("role_id", System.Data.DbType.Int32, request.Colvalues["roleid"]));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("description", System.Data.DbType.String, request.Colvalues["Description"]));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("role_name", System.Data.DbType.String, request.Colvalues["role_name"]));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("applicationid", System.Data.DbType.Int32, request.Colvalues["applicationid"]));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("createdby", System.Data.DbType.Int32, request.UserId));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("permission", NpgsqlTypes.NpgsqlDbType.Array | NpgsqlTypes.NpgsqlDbType.Text, (request.Colvalues["permission"].ToString() != string.Empty) ? request.Colvalues["permission"].ToString().Replace("[", "").Replace("]", "").Split(',').Select(n => n.ToString()).ToArray() : new string[] { }));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("users", NpgsqlTypes.NpgsqlDbType.Array | NpgsqlTypes.NpgsqlDbType.Integer, (request.Colvalues["users"].ToString() != string.Empty) ? request.Colvalues["users"].ToString().Split(',').Select(n => Convert.ToInt32(n)).ToArray() : emptyarr));
cmd.Parameters.Add(this.TenantDbFactory.ObjectsDB.GetNewParameter("dependants", NpgsqlTypes.NpgsqlDbType.Array | NpgsqlTypes.NpgsqlDbType.Integer, (request.Colvalues["dependants"].ToString() != string.Empty) ? request.Colvalues["dependants"].ToString().Replace("[", "").Replace("]", "").Split(',').Select(n => Convert.ToInt32(n)).ToArray() : emptyarr));
resp = new RBACRolesResponse
{
id = Convert.ToInt32(cmd.ExecuteScalar())
};
}
return(resp);
}
public string SaveRoles(int RoleId, int ApplicationId, string RoleName, string Description, string users, string Permissions, string subrolesid)
{
var req = this.HttpContext.Request.Form;
Dictionary <string, object> Dict = new Dictionary <string, object>();
string return_msg;
Dict["roleid"] = RoleId;
Dict["applicationid"] = ApplicationId;
Dict["role_name"] = RoleName;
Dict["Description"] = Description;
Dict["users"] = string.IsNullOrEmpty(users) ? string.Empty : users;
Dict["permission"] = string.IsNullOrEmpty(Permissions) ? string.Empty : Permissions;
Dict["dependants"] = string.IsNullOrEmpty(subrolesid) ? string.Empty : subrolesid;
// IServiceClient client = this.EbConfig.GetServiceStackClient(ViewBag.token, ViewBag.rToken);
RBACRolesResponse res = this.ServiceClient.Post <RBACRolesResponse>(new RBACRolesRequest {
Colvalues = Dict
});
if (res.id == 0)
{
return_msg = "Success";
}
else
{
return_msg = "Failed";
}
return(return_msg);
}
