public JsonResult Get()
{
int totalRows = 0;
string exception = "Ok";
bool rezult = true;
object rows = new { };
try
{
rows = dbList(ref totalRows);
}
catch (Exception ex)
{
rezult = false;
exception = ex.Message;
Console.WriteLine(ex.Message);
rows = new {
message = exception
};
GIxUtils.Log(ex);
}
return(new JsonResult(new
{
success = rezult,
message = exception,
code = 0,
total = totalRows,
data = rows
})); //, new JsonSerializerOptions { PropertyNamingPolicy = null }
}
public JsonResult Delete()
{
int totalRows = 0;
string exception = "Ok";
bool rezult = true;
object rows = new { };
try
{
rows = dbGetList(ref totalRows);
}
catch (Exception ex)
{
rezult = false;
exception = ex.Message;
Console.WriteLine(ex.Message);
rows = new
{
message = exception
};
GIxUtils.Log(ex);
}
return(new JsonResult(new
{
success = rezult,
message = exception,
code = 0,
total = totalRows,
data = rows
}));
}
public JsonResult Get()
{
int totalRows = 0;
bool rezult = true;
string rezultMessage = string.Empty;
object rows = new { };
try
{
rows = dbList(ref totalRows);
}
catch (TokenExpiredException ex)
{
rezult = false;
rezultMessage = "Token has expired";
GIxUtils.Log(ex);
}
catch (SignatureVerificationException ex)
{
rezult = false;
rezultMessage = "Token has invalid signature";
GIxUtils.Log(ex);
}
catch (Exception ex)
{
rezult = false;
rezultMessage = ex.Message;
GIxUtils.Log(ex);
}
return(new JsonResult(new
{
success = rezult,
code = 0,
message = rezultMessage,
total = totalRows,
data = rows
}));;
//var rng = new Random();
//return new JsonResult( new { success = true, status = "success", Data = Enumerable.Range(1, 5).Select(index => new WeatherForecast
//{
// Date = DateTime.Now.AddDays(index),
// TemperatureCC = rng.Next(-20, 55),
// Summary = Summaries[rng.Next(Summaries.Length)]
//}) });
/*
* var rng = new Random();
* return Enumerable.Range(1, 5).Select(index => new WeatherForecast
* {
* Date = DateTime.Now.AddDays(index),
* TemperatureCC = rng.Next(-20, 55),
* Summary = Summaries[rng.Next(Summaries.Length)]
* })
* .ToArray();
*/
}
public JsonResult Put(string userId, string activationToken, string newpassword, string repassword)
{
int totalRows = 0;
string exception = "Ok";
bool rezult = true;
object rows = new { };
try
{
var options = new JsonSerializerOptions
{
PropertyNamingPolicy = JsonNamingPolicy.CamelCase,
WriteIndented = true
};
UserModel user = new UserModel()
{
ActivationToken = Request.Form["ActivationToken"],
UserId = Convert.ToInt32(Request.Form["UserId"]),
NewPassword = Request.Form["NewPassword"],
RePassword = Request.Form["RePassword"]
};//JsonSerializer.Deserialize<UserModel>(vs, options);
rows = dbSetUserUser(user, ref totalRows);
}
catch (TokenExpiredException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (SignatureVerificationException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (Exception ex)
{
rezult = false;
exception = ex.Message;
Console.WriteLine(ex.Message);
rows = new
{
message = exception
};
GIxUtils.Log(ex);
}
return(new JsonResult(new
{
success = rezult,
message = exception,
code = 0,
total = 0,
data = rows
}));
}
private bool dbDelete(ref int totalRecordCount)
{
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string signatureId = Request.Form["SignatureId"];
List <dynamic> rows = new List <dynamic>();
GIGridInitModel giGridInitModel = new GIGridInitModel()
{
ColumnList = new List <GIGridColumn>()
};
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_DeleteSignature]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@SignatureId", signatureId);
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
sqlCommand.ExecuteNonQuery();
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
return(true);
}
public JsonResult Post([FromBody] object content)
{
int totalRows = 0;
string exception = "Ok";
bool rezult = true;
object rows = new { };
//UserModel user = new UserModel();
try
{
string vs = content.ToString();
var options = new JsonSerializerOptions
{
PropertyNamingPolicy = JsonNamingPolicy.CamelCase,
WriteIndented = true
};
TaskModel task = JsonSerializer.Deserialize <TaskModel>(vs, options);
rows = dbSetTask(task, ref totalRows);
}
catch (TokenExpiredException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (SignatureVerificationException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (Exception ex)
{
rezult = false;
exception = ex.Message;
Console.WriteLine(ex.Message);
rows = new
{
message = exception
};
GIxUtils.Log(ex);
}
return(new JsonResult(new
{
success = rezult,
message = exception,
code = 0,
total = 0,
data = rows
}));
}
public JsonResult Get()
{
int totalRows = 0;
string exception = "Ok";
bool rezult = true;
object rows = new { };
try
{
//dynamic car = new Object();
//car.AddProperty("TopSpeed", 180);
rows = dbGetUserLeftMenuList(ref totalRows);
rows = MakePlanTree(rows);
}
catch (TokenExpiredException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (SignatureVerificationException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (Exception ex)
{
rezult = false;
exception = ex.Message;
Console.WriteLine(ex.Message);
rows = new {
message = exception
};
GIxUtils.Log(ex);
}
return(new JsonResult(new { success = rezult, message = exception, records = 1, root = ".", children = rows }));
//return new JsonResult(new
//{
// success = rezult,
// message = exception,
// code = 0,
// total = totalRows,
// data = rows
//});
}
public JsonResult Get()
{
int totalRows = 0;
string exception = "Ok";
bool rezult = true;
object rows = new { };
try
{
rows = dbGetClaimsList(ref totalRows);
}
catch (TokenExpiredException ex)
{
rezult = false;
exception = ex.Message;
//Console.WriteLine("Token has expired");
GIxUtils.Log(ex);
}
catch (SignatureVerificationException ex)
{
rezult = false;
exception = ex.Message;
//Console.WriteLine("Token has invalid signature");
GIxUtils.Log(ex);
}
catch (Exception ex)
{
rezult = false;
exception = ex.Message;
//Console.WriteLine(ex.Message);
rows = new
{
message = exception
};
GIxUtils.Log(ex);
}
return(new JsonResult(new
{
success = rezult,
message = exception,
code = 0,
total = totalRows,
data = rows
}));
}
public JsonResult Get()
{
int totalRows = 0;
string exception = "Ok";
bool rezult = true;
object rows = new { };
try
{
rows = dbGetUserUser(ref totalRows);
}
catch (TokenExpiredException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (SignatureVerificationException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (Exception ex)
{
rezult = false;
exception = ex.Message;
Console.WriteLine(ex.Message);
rows = new {
message = exception
};
GIxUtils.Log(ex);
}
//return new JsonResult(new { success= rezult, message = exception, records = 1, root = ".", children = rows });
return(new JsonResult(new
{
success = rezult,
message = exception,
code = 0,
total = totalRows,
data = rows
}));
}
public JsonResult Get()
{
int totalRows = 0;
bool rezult = true;
string rezultMessage = string.Empty;
object rows = new { };
try
{
rows = dbList(ref totalRows);
}
catch (TokenExpiredException ex)
{
rezult = false;
rezultMessage = "Token has expired";
GIxUtils.Log(ex);
}
catch (SignatureVerificationException ex)
{
rezult = false;
rezultMessage = "Token has invalid signature";
GIxUtils.Log(ex);
}
catch (Exception ex)
{
rezult = false;
rezultMessage = ex.Message;
GIxUtils.Log(ex);
}
return(new JsonResult(new
{
success = rezult,
code = 0,
message = rezultMessage,
total = totalRows,
data = rows
}));;
}
private dynamic dbSetUserUser(UserModel user, ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
//*********************************************************
// If new userd and needs to activate Account
if (!string.IsNullOrWhiteSpace(user.ActivationToken))
{
return(dbActivateAccountToken(user, ref totalRecordCount));
}
UserModel model = new UserModel();
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_SetUser]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@FirstName", user.FirstName);
sqlCommand.Parameters.AddWithValue("@LastName", user.LastName);
sqlCommand.Parameters.AddWithValue("@DOB", user.DOB);
sqlCommand.Parameters.AddWithValue("@Address", user.Address);
sqlCommand.Parameters.AddWithValue("@BirthPlace", user.BirthPlace);
sqlCommand.Parameters.AddWithValue("@PIN", user.PIN);
sqlCommand.Parameters.AddWithValue("@PassportNom", user.PassportNom);
sqlCommand.Parameters.AddWithValue("@CitizenshipId", user.CitizenshipId);
sqlCommand.Parameters.AddWithValue("@ContractNom", user.ContractNom);
sqlCommand.Parameters.AddWithValue("@DateStart", user.DateStart);
sqlCommand.Parameters.AddWithValue("@DateEnd", user.DateEnd);
sqlCommand.Parameters.AddWithValue("@StatusId", user.StatusId);
sqlCommand.Parameters.AddWithValue("@DepartmentId", user.DepartmentId);
sqlCommand.Parameters.AddWithValue("@PositionId", user.PositionId);
sqlCommand.Parameters.AddWithValue("@UserId", user.UserId);
sqlCommand.Parameters.AddWithValue("@StaffId", user.StaffId);
sqlCommand.Parameters.AddWithValue("@IsMed", user.IsMed == null ? false : Convert.ToBoolean(user.IsMed.ToString()));
sqlCommand.Parameters.AddWithValue("@IsBlocked", user.IsBlocked == null ? false : Convert.ToBoolean(user.IsBlocked.ToString()));
sqlCommand.Parameters.AddWithValue("@IsSales", user.IsSales == null ? false : Convert.ToBoolean(user.IsSales.ToString()));
sqlCommand.Parameters.AddWithValue("@Code", user.Code);
sqlCommand.Parameters.AddWithValue("@Permissions", user.Permissions);
sqlCommand.Parameters.AddWithValue("@Email", user.Email);
sqlCommand.Parameters.AddWithValue("@ResetOnly", user.ResetOnly);
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
if (recordSet.Read())
{
if ((value = recordSet[recordSet.GetOrdinal("UserId")]) != System.DBNull.Value)
{
model.UserId = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("StaffId")]) != System.DBNull.Value)
{
model.StaffId = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("FirstName")]) != System.DBNull.Value)
{
model.FirstName = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("LastName")]) != System.DBNull.Value)
{
model.LastName = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("DOB")]) != System.DBNull.Value)
{
model.DOB = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Address")]) != System.DBNull.Value)
{
model.Address = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("PIN")]) != System.DBNull.Value)
{
model.PIN = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("PassportNom")]) != System.DBNull.Value)
{
model.PassportNom = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("CitizenshipId")]) != System.DBNull.Value)
{
model.CitizenshipId = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Citizenship")]) != System.DBNull.Value)
{
model.Citizenship = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("ContractNom")]) != System.DBNull.Value)
{
model.ContractNom = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("DateStart")]) != System.DBNull.Value)
{
model.DateStart = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("DateEnd")]) != System.DBNull.Value)
{
model.DateEnd = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("StatusId")]) != System.DBNull.Value)
{
model.StatusId = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("StatusDescription")]) != System.DBNull.Value)
{
model.StatusDescription = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("DepartmentId")]) != System.DBNull.Value)
{
model.DepartmentId = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("DepartmentDescription")]) != System.DBNull.Value)
{
model.DepartmentDescription = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("PositionId")]) != System.DBNull.Value)
{
model.PositionId = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("PositionDescription")]) != System.DBNull.Value)
{
model.PositionDescription = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Code")]) != System.DBNull.Value)
{
model.Code = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Username")]) != System.DBNull.Value)
{
model.Username = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsBlocked")]) != System.DBNull.Value)
{
model.IsBlocked = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsMed")]) != System.DBNull.Value)
{
model.IsMed = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsSales")]) != System.DBNull.Value)
{
model.IsSales = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("BirthPlace")]) != System.DBNull.Value)
{
model.BirthPlace = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Email")]) != System.DBNull.Value)
{
model.Email = (string)value;
}
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
return(model);
}
private dynamic dbGetList(ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
bool exportGrid = Request.Query["type"].ToString() == "exportGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string page = Request.Query["page"].ToString();
string start = Request.Query["start"].ToString();
string limit = Request.Query["limit"].ToString();
List <dynamic> rows = new List <dynamic>();
GIGridInitModel giGridInitModel = new GIGridInitModel()
{
ColumnList = new List <GIGridColumn>()
};
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_CallCenterGetDocList]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@ExportGrid", exportGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@page", page);
sqlCommand.Parameters.AddWithValue("@start", start);
sqlCommand.Parameters.AddWithValue("@limit", limit);
sqlCommand.Parameters.AddWithValue("@sort", Request.Query["sort"].ToString());
//sqlCommand.Parameters.AddWithValue("@saxeobaId", Request.Query["saxeobaId"].ToString());
//sqlCommand.Parameters.AddWithValue("@docId", Request.Query["docId"].ToString());
//sqlCommand.Parameters.AddWithValue("@policyNo", Request.Query["policyNo"].ToString());
//sqlCommand.Parameters.AddWithValue("@pin", Request.Query["pin"].ToString());
//sqlCommand.Parameters.AddWithValue("@policyHolder", Request.Query["policyHolder"].ToString());
//sqlCommand.Parameters.AddWithValue("@policyHolderParent", Request.Query["policyHolderParent"].ToString());
//sqlCommand.Parameters.AddWithValue("@organizationName", Request.Query["organizationName"].ToString());
//sqlCommand.Parameters.AddWithValue("@contractNom", Request.Query["contractNom"].ToString());
//sqlCommand.Parameters.AddWithValue("@docCreateDateStart", Request.Query["docCreateDateStart"].ToString());
//sqlCommand.Parameters.AddWithValue("@docCreateDateStart", Request.Query["docCreateDateStart"].ToString());
//sqlCommand.Parameters.AddWithValue("@operatorId", Request.Query["operatorId"].ToString());
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
while (recordSet.Read())
{
dynamic model = null;
GIGridColumn model_c = new GIGridColumn();
CallCenterDocListModel model_r = new CallCenterDocListModel();
if (initGrid == true)
{
model = model_c;
}
else
{
model = model_r;
}
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
}
}
}
if (initGrid == true)
{
giGridInitModel.ColumnList.Add(model);
}
else
{
rows.Add(model);
}
}
if (initGrid == true && recordSet.NextResult() && recordSet.Read())
{
if ((value = recordSet[recordSet.GetOrdinal("Title")]) != System.DBNull.Value)
{
giGridInitModel.Title = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Toolbar")]) != System.DBNull.Value)
{
giGridInitModel.Toolbar = (string)value;
}
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
if (initGrid == false)
{
return(rows);
}
return(giGridInitModel);
}
public async Task <JsonResult> Login()
{
LoginRequestJson reqObj = new LoginRequestJson();
LoginResponseJson respObj = new LoginResponseJson()
{
success = false,
message = "",
code = 0,
token = string.Empty
};
try
{
//Request.Headers["Authorization"]
string bearer = Request.Headers["Authorization"];
if (Request == null || Request.Headers == null || Request.Headers.Count == 0 || string.IsNullOrWhiteSpace(Request.Headers["Authorization"]) == true)
{
Response.StatusCode = StatusCodes.Status401Unauthorized;
object respojseObj_MissingBearer = new
{
success = false,
message = "Authorization header is not provided",
code = -401,
token = ""
};
return(new JsonResult(respojseObj_MissingBearer));
}
string[] bearers = bearer.Split("Bearer ");
if (bearers == null || bearers.Length != 2)
{
Response.StatusCode = StatusCodes.Status401Unauthorized;
object respojseObj_MissingBearer = new
{
success = false,
message = "Missing bearer token",
code = -401,
token = ""
};
return(new JsonResult(respojseObj_MissingBearer));
}
using (var reader = new StreamReader(Request.Body))
{
string body = string.Empty;
body = await reader.ReadToEndAsync();
dynamic jbody = JsonConvert.DeserializeObject(body);
if (jbody == null)
{
object respojseObj_MissingBearer = new
{
success = false,
message = "Missing request body",
code = -401,
token = ""
};
return(new JsonResult(respojseObj_MissingBearer));
}
foreach (dynamic item in jbody)
{
//int rowCount = 0;
//foreach (dynamic col in rows)
{
string name = item.Name;
string val = item.Value.ToString();
switch (name)
{
case "username":
reqObj.username = val;
break;
case "password":
reqObj.password = val;
break;
}
}
}
}
if (reqObj == null || string.IsNullOrWhiteSpace(reqObj.username) == true || string.IsNullOrWhiteSpace(reqObj.password))
{
Response.StatusCode = StatusCodes.Status401Unauthorized;
object respojseObj_MissingBearer = new
{
success = false,
message = "No credentials provided",
code = -401,
token = ""
};
return(new JsonResult(respojseObj_MissingBearer));
}
reqObj.apiKey = bearers[1];
dbCheckAPIKey(ref reqObj, ref respObj);
dbIssueSessionToken(ref reqObj, ref respObj);
}
catch (Exception ex)
{
GIxUtils.Log(ex);
Response.StatusCode = StatusCodes.Status401Unauthorized;
object respojseObj_CheckBearer = new
{
success = false,
message = $"{ex.Message}",
code = -401,
token = ""
};
return(new JsonResult(respojseObj_CheckBearer));
}
return(new JsonResult(respObj));
}
private IEnumerable <dynamic> dbGetUserLeftMenuList(ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string page = Request.Query["page"].ToString();
string start = Request.Query["start"].ToString();
string limit = Request.Query["limit"].ToString();
List <dynamic> rows = new List <dynamic>();
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_GetUserLeftMenuList]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
//sqlCommand.Parameters.AddWithValue("@page", page);
//sqlCommand.Parameters.AddWithValue("@start", start);
//sqlCommand.Parameters.AddWithValue("@limit", limit);
//sqlCommand.Parameters.AddWithValue("@sort", Request.Query["sort"].ToString());
//sqlCommand.Parameters.AddWithValue("@userDescription", Request.Query["userDescription"].ToString());
//sqlCommand.Parameters.AddWithValue("@userCode", Request.Query["userCode"].ToString());
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
while (recordSet.Read())
{
//if (initGrid == true)
//{
// GIGridColumn column = new GIGridColumn();
// if ((value = recordSet[recordSet.GetOrdinal("Title")]) != System.DBNull.Value) column.Title = (string)value;
// rows.Add(column);
//}
//else
{
LeftMenu model = new LeftMenu();
if ((value = recordSet[recordSet.GetOrdinal("rootId")]) != System.DBNull.Value)
{
model.rootId = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("id")]) != System.DBNull.Value)
{
model.id = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("pid")]) != System.DBNull.Value)
{
model.pid = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("leaf")]) != System.DBNull.Value)
{
model.leaf = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("expanded")]) != System.DBNull.Value)
{
model.expanded = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("loaded")]) != System.DBNull.Value)
{
model.loaded = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("text")]) != System.DBNull.Value)
{
model.text = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("iconCls")]) != System.DBNull.Value)
{
model.iconCls = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("isMenuGroup")]) != System.DBNull.Value)
{
model.isMenuGroup = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("isDashboard")]) != System.DBNull.Value)
{
model.isDashboard = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("reference")]) != System.DBNull.Value)
{
model.reference = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("url")]) != System.DBNull.Value)
{
model.url = (string)value;
}
rows.Add(model);
}
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
return(rows);
}
private bool dbCheckAPIKey(ref LoginRequestJson req, ref LoginResponseJson resp)
{
bool rezult = false;
try
{
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
//string localHost = HttpContext.Features.Get()?.RemoteIpAddress?.ToString();
//var a = HttpContext.Features.Get();
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_ChekAPIKey]";
sqlCommand.Parameters.AddWithValue("@APIKey", req.apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@Username", req.username);
//sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
//sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
if (recordSet.Read())
{
if ((value = recordSet[recordSet.GetOrdinal("IsOk")]) != System.DBNull.Value)
{
rezult = (bool)value;
}
}
recordSet.Close();
recordSet.Dispose();
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
if (!rezult)
{
throw new Exception("ავტორიზაციის შეცდომა! Invalid access token.");
}
return(rezult);
}
private dynamic dbList(ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
bool exportGrid = Request.Query["type"].ToString() == "exportGrid" ? true : false;
bool isUtil = Request.Query["subtype"].ToString() == "isUtil" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string page = Request.Query["page"].ToString();
string start = Request.Query["start"].ToString();
string limit = Request.Query["limit"].ToString();
List <dynamic> rows = new List <dynamic>();
GIGridInitModel giGridInitModel = new GIGridInitModel()
{
ColumnList = new List <GIGridColumn>()
};
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_lookup_GetPositionList]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@ExportGrid", exportGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@page", page);
sqlCommand.Parameters.AddWithValue("@start", start);
sqlCommand.Parameters.AddWithValue("@limit", limit);
sqlCommand.Parameters.AddWithValue("@utilityFilter", Request.Query["utilityFilter"].ToString()); // when typing in dropdown
sqlCommand.Parameters.AddWithValue("@sort", Request.Query["sort"].ToString());
//sqlCommand.Parameters.AddWithValue("@userDescription", Request.Query["userDescription"].ToString());
//sqlCommand.Parameters.AddWithValue("@userCode", Request.Query["userCode"].ToString());
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
while (recordSet.Read())
{
if (initGrid == true)
{
GIGridColumn column = new GIGridColumn();
if ((value = recordSet[recordSet.GetOrdinal("Title")]) != System.DBNull.Value)
{
column.Title = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("DataIndex")]) != System.DBNull.Value)
{
column.DataIndex = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("ValueType")]) != System.DBNull.Value)
{
column.ValueType = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Width")]) != System.DBNull.Value)
{
column.Width = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Flex")]) != System.DBNull.Value)
{
column.Flex = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Renderer")]) != System.DBNull.Value)
{
column.Renderer = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsFilter")]) != System.DBNull.Value)
{
column.IsFilter = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsNotColumn")]) != System.DBNull.Value)
{
column.IsNotColumn = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsHidden")]) != System.DBNull.Value)
{
column.IsHidden = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsMenuDisabled")]) != System.DBNull.Value)
{
column.IsMenuDisabled = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsGridSummaryRow")]) != System.DBNull.Value)
{
column.IsGridSummaryRow = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsLocked")]) != System.DBNull.Value)
{
column.IsLocked = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("SummaryRenderer")]) != System.DBNull.Value)
{
column.SummaryRenderer = (string)value;
}
giGridInitModel.ColumnList.Add(column);
}
else
{
GILookupModel model = new GILookupModel();
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
}
}
}
rows.Add(model);
}
}
if (initGrid == true && recordSet.NextResult() && recordSet.Read())
{
if ((value = recordSet[recordSet.GetOrdinal("Title")]) != System.DBNull.Value)
{
giGridInitModel.Title = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Toolbar")]) != System.DBNull.Value)
{
giGridInitModel.Toolbar = (string)value;
}
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
if (initGrid == false)
{
return(rows);
}
return(giGridInitModel);
}
private bool dbIssueSessionToken(ref LoginRequestJson req, ref LoginResponseJson resp)
{
try
{
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
//string passwordEncr = GIxUtils.EncryptString(req.password);
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_IssueSessionToken]";
sqlCommand.Parameters.AddWithValue("@APIKey", req.apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@Username", req.username);
sqlCommand.Parameters.AddWithValue("@Password", req.password);
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
if (recordSet.Read())
{
if ((value = recordSet[recordSet.GetOrdinal("IsOk")]) != System.DBNull.Value)
{
resp.success = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("UniqueID")]) != System.DBNull.Value)
{
req.salt = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("UserWho")]) != System.DBNull.Value)
{
resp.userWho = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Email")]) != System.DBNull.Value)
{
resp.email = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Avatar")]) != System.DBNull.Value)
{
resp.avatar = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Version")]) != System.DBNull.Value)
{
resp.version = (string)value;
}
resp.user = _loginRequest.username;
req.version = resp.version;
}
recordSet.Close();
recordSet.Dispose();
}
}
/////
/// JWT Base64 user credentials as sessionvarialbelHas + guid from DB
var token = new JwtBuilder()
.WithAlgorithm(new HMACSHA256Algorithm()) // symmetric
.WithSecret(GIxUtils.DecyptString(_configuration["JWTSecretEncypted"]))
.AddClaim("exp", DateTimeOffset.UtcNow.AddDays(1).ToUnixTimeSeconds()) //
.AddClaim("LoginRequest", req)
.Encode();
//Console.WriteLine(token);
resp.token = token;
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
if (!resp.success)
{
throw new Exception("პაროლი ან მომხმარებლის სახელი არასწორად არის შეყვანილი.");
}
return(resp.success);
}
private dynamic dbList(ref int totalRecordCount)
{
//bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
//bool exportGrid = Request.Query["type"].ToString() == "exportGrid" ? true : false;
//bool isUtil = Request.Query["subtype"].ToString() == "isUtil" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string src = Request.Query["src"].ToString();
string page = Request.Query["page"].ToString();
string start = Request.Query["start"].ToString();
string limit = Request.Query["limit"].ToString();
DashboardModel dashboardModel = new DashboardModel()
{
SaxeobaList = new List <SaxeobaModel>(),
PieDataList = new List <PieDataModel>(),
ActivityList = new List <ActivityModel> (),
EntityList = new List <EntityModel>(),
PieColorList = new List <PieColorModel>()
};
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_GetDashboard]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@Src", src);
//sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
//sqlCommand.Parameters.AddWithValue("@ExportGrid", exportGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@page", page);
sqlCommand.Parameters.AddWithValue("@start", start);
sqlCommand.Parameters.AddWithValue("@limit", limit);
//sqlCommand.Parameters.AddWithValue("@utilityFilter", Request.Query["query"].ToString()); // when typing in dropdown
//sqlCommand.Parameters.AddWithValue("@sort", Request.Query["sort"].ToString());
//sqlCommand.Parameters.AddWithValue("@userDescription", Request.Query["userDescription"].ToString());
//sqlCommand.Parameters.AddWithValue("@userCode", Request.Query["userCode"].ToString());
//SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
//outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
// 1. SaxeobaList
while (recordSet.Read())
{
dynamic model = new SaxeobaModel();
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
case "Decimal":
el.SetValue(model, (decimal)value);
break;
case "DateTime":
el.SetValue(model, (DateTime)value);
break;
}
}
}
dashboardModel.SaxeobaList.Add(model);
}
// 2. PieChartData
recordSet.NextResult();
while (recordSet.Read())
{
dynamic model = new PieDataModel();
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
case "Decimal":
el.SetValue(model, (decimal)value);
break;
case "DateTime":
el.SetValue(model, (DateTime)value);
break;
}
}
}
dashboardModel.PieDataList.Add(model);
}
// 3. ActivityData
recordSet.NextResult();
while (recordSet.Read())
{
dynamic model = new ActivityModel();
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
case "Decimal":
el.SetValue(model, (decimal)value);
break;
case "DateTime":
el.SetValue(model, (DateTime)value);
break;
}
}
}
dashboardModel.ActivityList.Add(model);
}
// 4. Entity
recordSet.NextResult();
while (recordSet.Read())
{
dynamic model = new EntityModel();
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
case "Decimal":
el.SetValue(model, (decimal)value);
break;
case "DateTime":
el.SetValue(model, (DateTime)value);
break;
}
}
}
dashboardModel.EntityList.Add(model);
}
// 4. Entity
recordSet.NextResult();
while (recordSet.Read())
{
dynamic model = new PieColorModel();
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
case "Decimal":
el.SetValue(model, (decimal)value);
break;
case "DateTime":
el.SetValue(model, (DateTime)value);
break;
}
}
}
dashboardModel.PieColorList.Add(model);
}
recordSet.Close();
recordSet.Dispose();
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
return(dashboardModel);
}
//private IEnumerable<dynamic> dbGetAgentList(ref int totalRecordCount )
private dynamic dbGetAgentList(ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
bool exportGrid = Request.Query["type"].ToString() == "exportGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string page = Request.Query["page"].ToString();
string start = Request.Query["start"].ToString();
string limit = Request.Query["limit"].ToString();
List <dynamic> rows = new List <dynamic>();
GIGridInitModel giGridInitModel = new GIGridInitModel()
{
ColumnList = new List <GIGridColumn>()
};
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_GetAgentBrokerList]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@ExportGrid", exportGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@page", page);
sqlCommand.Parameters.AddWithValue("@start", start);
sqlCommand.Parameters.AddWithValue("@limit", limit);
sqlCommand.Parameters.AddWithValue("@sort", Request.Query["sort"].ToString());
sqlCommand.Parameters.AddWithValue("@code", Request.Query["ode"].ToString());
sqlCommand.Parameters.AddWithValue("@description", Request.Query["description"].ToString());
sqlCommand.Parameters.AddWithValue("@pin", Request.Query["pin"].ToString());
sqlCommand.Parameters.AddWithValue("@address", Request.Query["address"].ToString());
sqlCommand.Parameters.AddWithValue("@phone", Request.Query["phone"].ToString());
sqlCommand.Parameters.AddWithValue("@isBroker", Request.Query["isBroker"].ToString());
sqlCommand.Parameters.AddWithValue("@isIndMetsarme", Request.Query["isIndMetsarme"].ToString());
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
while (recordSet.Read())
{
if (initGrid == true)
{
#region helper properties
GIGridColumn column = new GIGridColumn();
if ((value = recordSet[recordSet.GetOrdinal("Title")]) != System.DBNull.Value)
{
column.Title = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("DataIndex")]) != System.DBNull.Value)
{
column.DataIndex = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("DisplayField")]) != System.DBNull.Value)
{
column.DisplayField = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("ValueField")]) != System.DBNull.Value)
{
column.ValueField = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("ValueType")]) != System.DBNull.Value)
{
column.ValueType = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Width")]) != System.DBNull.Value)
{
column.Width = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Flex")]) != System.DBNull.Value)
{
column.Flex = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Renderer")]) != System.DBNull.Value)
{
column.Renderer = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsFilter")]) != System.DBNull.Value)
{
column.IsFilter = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsNotColumn")]) != System.DBNull.Value)
{
column.IsNotColumn = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsHidden")]) != System.DBNull.Value)
{
column.IsHidden = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsMenuDisabled")]) != System.DBNull.Value)
{
column.IsMenuDisabled = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsGridSummaryRow")]) != System.DBNull.Value)
{
column.IsGridSummaryRow = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsLocked")]) != System.DBNull.Value)
{
column.IsLocked = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("SummaryRenderer")]) != System.DBNull.Value)
{
column.SummaryRenderer = (string)value;
}
giGridInitModel.ColumnList.Add(column);
#endregion
}
else
{
AgentBrokerListModel model = new AgentBrokerListModel();
if ((value = recordSet[recordSet.GetOrdinal("RowNum")]) != System.DBNull.Value)
{
model.RowNum = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Id")]) != System.DBNull.Value)
{
model.Id = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Code")]) != System.DBNull.Value)
{
model.Code = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Description")]) != System.DBNull.Value)
{
model.Description = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Pin")]) != System.DBNull.Value)
{
model.Pin = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Address")]) != System.DBNull.Value)
{
model.Address = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Phone")]) != System.DBNull.Value)
{
model.Phone = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsBroker")]) != System.DBNull.Value)
{
model.IsBroker = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("IsIndMetsarme")]) != System.DBNull.Value)
{
model.IsIndMetsarme = (bool)value;
}
if ((value = recordSet[recordSet.GetOrdinal("EntityType")]) != System.DBNull.Value)
{
model.EntityType = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("clrfg")]) != System.DBNull.Value)
{
model.clrfg = (int)value;
}
rows.Add(model);
}
}
if (initGrid == true && recordSet.NextResult() && recordSet.Read())
{
if ((value = recordSet[recordSet.GetOrdinal("Title")]) != System.DBNull.Value)
{
giGridInitModel.Title = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Toolbar")]) != System.DBNull.Value)
{
giGridInitModel.Toolbar = (string)value;
}
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
if (initGrid == false)
{
return(rows);
}
return(giGridInitModel);
}
private IEnumerable<dynamic> dbGetUserTaskPermissionList(ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string page = Request.Query["page"].ToString();
string start = Request.Query["start"].ToString();
string limit = Request.Query["limit"].ToString();
string taskId = Request.Query["TaskId"];
List<dynamic> rows = new List<dynamic>();
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_GetTaskPermisionList]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@TaskId", taskId);
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
while (recordSet.Read())
{
UserPermissionModel model = new UserPermissionModel();
//if ((value = recordSet[recordSet.GetOrdinal("rootId")]) != System.DBNull.Value) model.rootId = (int)value;
//if ((value = recordSet[recordSet.GetOrdinal("id")]) != System.DBNull.Value) model.id = (int)value;
//if ((value = recordSet[recordSet.GetOrdinal("pid")]) != System.DBNull.Value) model.pid = (int)value;
//if ((value = recordSet[recordSet.GetOrdinal("leaf")]) != System.DBNull.Value) model.leaf = (bool)value;
//if ((value = recordSet[recordSet.GetOrdinal("hasAccess")]) != System.DBNull.Value) model.hasAccess = (bool)value;
//if ((value = recordSet[recordSet.GetOrdinal("expanded")]) != System.DBNull.Value) model.expanded = (bool)value;
//if ((value = recordSet[recordSet.GetOrdinal("loaded")]) != System.DBNull.Value) model.loaded = (bool)value;
//if ((value = recordSet[recordSet.GetOrdinal("text")]) != System.DBNull.Value) model.text = (string)value;
//if ((value = recordSet[recordSet.GetOrdinal("cls")]) != System.DBNull.Value) model.cls = (string)value;
//if ((value = recordSet[recordSet.GetOrdinal("iconCls")]) != System.DBNull.Value) model.iconCls = (string)value;
//if ((value = recordSet[recordSet.GetOrdinal("reference")]) != System.DBNull.Value) model.reference = (string)value;
//if ((value = recordSet[recordSet.GetOrdinal("url")]) != System.DBNull.Value) model.url = (string)value;
//rows.Add(model);
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
}
}
}
rows.Add(model);
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
totalRecordCount = (int)outputValue.Value;
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
return rows;
}
private dynamic dbActivateAccountToken(UserModel user, ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
UserModel model = new UserModel();
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_ActivateAccountToken]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@UserId", user.UserId);
sqlCommand.Parameters.AddWithValue("@ActivationToken", user.ActivationToken);
sqlCommand.Parameters.AddWithValue("@NewPassword", user.NewPassword);
sqlCommand.Parameters.AddWithValue("@RePassword", user.RePassword);
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
//object value;
if (recordSet.Read())
{
//if ((value = recordSet[recordSet.GetOrdinal("UserId")]) != System.DBNull.Value) model.UserId = (int)value;
//if ((value = recordSet[recordSet.GetOrdinal("Username")]) != System.DBNull.Value) model.Username = (string)value;
//if ((value = recordSet[recordSet.GetOrdinal("FirstName")]) != System.DBNull.Value) model.FirstName = (string)value;
//if ((value = recordSet[recordSet.GetOrdinal("LastName")]) != System.DBNull.Value) model.LastName = (string)value;
//if ((value = recordSet[recordSet.GetOrdinal("Email")]) != System.DBNull.Value) model.Email = (string)value;
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
return(model);
}
public async void Get()
{
bool isEncrypted = Convert.ToBoolean(_configuration["ConnectionStrings:Encrypted"]);
if (isEncrypted)
{
/*
* In order to decrypt using this certificate, IIS_IUSRS has to have access to private key
* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
* WinHttpCertCfg.exe -g -c LOCAL_MACHINE\WebHosting -s "webgi.app" -a "HOMEVM10PRO\IIS_IUSRS"
*
*/
/*
* X509Store store = new X509Store("WebHosting", StoreLocation.LocalMachine);
* store.Open(OpenFlags.ReadOnly | OpenFlags.OpenExistingOnly);
* X509Certificate2Collection foundCertificates =
* store.Certificates.Find(
* X509FindType.FindByThumbprint,
* "7970ca8de61cae007db15dfb01cf6f961397ef02",
* true);
* store.Close();
* if (foundCertificates.Count == 0)
* return;
*
* X509Certificate2 cert = foundCertificates[0];
*/
string encr = GIxUtils.EncryptString("Data Source=172.22.22.12;Initial Catalog=GI_TEST;User ID=WebGi;Password=P@$$w0rd4W3bG1;Persist Security Info=True;TrustServerCertificate=true;");
string decr = GIxUtils.DecyptString(encr);
encr = GIxUtils.EncryptString("Barjakuzu010203");
//X509Certificate2 cert = new X509Certificate2(@"C:\webgi\webgi-app.pfx");
/*
* byte[] data = Encrypt(cert);
* byte[] data2 = Decrypt(cert, data);
* string decrString = Encoding.ASCII.GetString(data2);
*
* string base64Encoded = Convert.ToBase64String(data);
* byte[] data3 = Convert.FromBase64String(base64Encoded);
*
* byte[] data4 = Decrypt(cert, data3);
* string decrString3 = Encoding.ASCII.GetString(data4);
*/
//_configuration["ConnectionStrings:DefaultConnection"] = "OK";
}
//"<title>Service Hub</title><br/>**** " + _configuration["ConnectionStrings:DefaultConnection"] + "*****<br/>"+
await Response.WriteAsync("<!DOCTYPE html>" +
"<html lang=\"en\">" +
"<head>" +
"<meta charset=\"UTF - 8\">" +
"<meta name=\"viewport\" content=\"width = device - width, initial - scale = 1.0\">" +
"<style>body{font-family: Segoe UI,SegoeUI,Segoe WP,Helvetica Neue,Helvetica,Tahoma,Arial,sans-serif;font-weight: 400;}</style></head>" +
"<body>" +
"<center><h1>Service Hub - " + _configuration["Environmet"] + "</h1><hr><p>Nothing to see here</p></center>" +
"</body>" +
"</html>");
}
//private IEnumerable<dynamic> dbGetProviderList(ref int totalRecordCount )
private dynamic dbGetClaimsList(ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
bool exportGrid = Request.Query["type"].ToString() == "exportGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
List <dynamic> rows = new List <dynamic>();
GIGridInitModel giGridInitModel = new GIGridInitModel()
{
ColumnList = new List <GIGridColumn>()
};
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_GetAutoPolicyList]";
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
if (Request != null && Request.Query != null && Request.Query.Keys != null && Request.Query.Keys.Count > 0)
{
foreach (string key in Request.Query.Keys)
{
if (!key.StartsWith("_"))
{
string param = $"@{key}";
sqlCommand.Parameters.AddWithValue(param, Request.Query[key].ToString());
}
}
}
;
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
while (recordSet.Read())
{
dynamic model = null;
if (initGrid == true)
{
model = new GIGridColumn();
}
else
{
model = new ContractListModel(); ///////////////// !!!!!!!! //////////
}
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
case "Decimal":
el.SetValue(model, (decimal)value);
break;
case "DateTime":
el.SetValue(model, (DateTime)value);
break;
}
}
}
if (initGrid == true)
{
giGridInitModel.ColumnList.Add(model);
}
else
{
rows.Add(model);
}
}
if (initGrid == true && recordSet.NextResult() && recordSet.Read())
{
if ((value = recordSet[recordSet.GetOrdinal("Title")]) != System.DBNull.Value)
{
giGridInitModel.Title = (string)value;
}
if ((value = recordSet[recordSet.GetOrdinal("Toolbar")]) != System.DBNull.Value)
{
giGridInitModel.Toolbar = (string)value;
}
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
if (initGrid == false)
{
return(rows);
}
return(giGridInitModel);
}
public JsonResult Post([FromBody] object content)
{
int totalRows = 0;
string exception = "Ok";
bool rezult = true;
object rows = new { };
//UserModel user = new UserModel();
//dynamic ob001 = new ExpandoObject();
var ob001 = new MyDynObject(new Dictionary <string, object>()
{
{
"prop1", 12
},
});
//Console.WriteLine(dyn.prop1);
//ob001.prop1 = 150;
//dynamic ob002 = new ExpandoObject();
//ob002 = ob001;
try
{
string vs = content.ToString();
var options = new JsonSerializerOptions
{
PropertyNamingPolicy = JsonNamingPolicy.CamelCase,
WriteIndented = true
};
UserModel user = JsonSerializer.Deserialize <UserModel>(vs, options);
rows = dbSetUserUser(user, ref totalRows);
}
catch (TokenExpiredException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (SignatureVerificationException ex)
{
rezult = false;
exception = ex.Message;
GIxUtils.Log(ex);
}
catch (Exception ex)
{
rezult = false;
exception = ex.Message;
Console.WriteLine(ex.Message);
rows = new
{
message = exception,
set = ob001
};
GIxUtils.Log(ex);
}
return(new JsonResult(new
{
success = rezult,
message = exception,
code = 0,
total = 0,
data = rows
}));
}
private dynamic dbGetTask(ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string page = Request.Query["page"].ToString();
string start = Request.Query["start"].ToString();
string limit = Request.Query["limit"].ToString();
string taskId = Request.Query["taskId"];
TaskModel model = new TaskModel();
//List<dynamic> rows = new List<dynamic>();
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_GetTask]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@TaskId", taskId);
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
if (recordSet.Read())
{
if ((value = recordSet[recordSet.GetOrdinal("TaskId")]) != System.DBNull.Value)
{
model.TaskId = (int)value;
}
if ((value = recordSet[recordSet.GetOrdinal("TaskName")]) != System.DBNull.Value)
{
model.TaskName = (string)value;
}
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
return(model);
}
private dynamic dbGetSignature(ref int totalRecordCount)
{
bool initGrid = Request.Query["type"].ToString() == "initGrid" ? true : false;
string remoteIP = this.HttpContext.Connection.RemoteIpAddress.ToString();
string localIP = this.HttpContext.Connection.LocalIpAddress.ToString();
string page = Request.Query["page"].ToString();
string start = Request.Query["start"].ToString();
string limit = Request.Query["limit"].ToString();
string signatureId = Request.Query["SignatureId"];
SignatureModel model = new SignatureModel();
try
{
using (SqlConnection sqlConnection = new SqlConnection(
GIxUtils.DecodeConnectionString(
_configuration,
ref _loginRequest,
Request.Headers["X-WebGI-Authentication"],
Request.Headers["X-WebGI-Version"])))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "dbo.[usp_WebGI_GetSignature]";
//sqlCommand.Parameters.AddWithValue("@APIKey", apiKey);
sqlCommand.Parameters.AddWithValue("@IP_Local", localIP);
sqlCommand.Parameters.AddWithValue("@IP_Remote", remoteIP);
sqlCommand.Parameters.AddWithValue("@InitGrid", initGrid);
sqlCommand.Parameters.AddWithValue("@Salt", _loginRequest.salt);
sqlCommand.Parameters.AddWithValue("@Version", _loginRequest.version);
sqlCommand.Parameters.AddWithValue("@SignatureId", signatureId);
SqlParameter outputValue = sqlCommand.Parameters.Add("@totalCount", SqlDbType.Int);
outputValue.Direction = ParameterDirection.Output;
SqlDataReader recordSet = sqlCommand.ExecuteReader();
using (recordSet)
{
object value;
if (recordSet.Read())
{
var properties = model.GetType().GetProperties();
foreach (var el in properties)
{
string name = el.Name;
value = recordSet[recordSet.GetOrdinal(name)];
if (value != System.DBNull.Value)
{
switch (el.PropertyType.Name)
{
case "Int32":
el.SetValue(model, (int)value);
break;
case "String":
el.SetValue(model, (string)value);
break;
case "Boolean":
el.SetValue(model, (bool)value);
break;
case "Decimal":
//case "Nullable'1":
el.SetValue(model, (decimal)value);
break;
}
}
}
}
recordSet.Close();
recordSet.Dispose();
if (outputValue.Value != null)
{
totalRecordCount = (int)outputValue.Value;
}
}
}
sqlConnection.Close();
sqlConnection.Dispose();
}
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
return(model);
}
