//private IEnumerable<dynamic> dbGetTaskList(ref int totalRecordCount )
private dynamic dbGetTaskList(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_GetTaskList]";
//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("@taskName", Request.Query["TaskName"].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 model = new GIGridColumn();
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;
}
}
}
giGridInitModel.ColumnList.Add(model);
}
else
{
TaskListModel model = new TaskListModel();
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 IEnumerable<dynamic> dbGetUserList(ref int totalRecordCount )
private dynamic dbList(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();
string withDeleteStr = Request.Query["withDelete"].ToString();
string userIdStr = Request.Query["userId"].ToString();
bool withDelete = !string.IsNullOrWhiteSpace(withDeleteStr) ? Convert.ToBoolean(withDeleteStr) : false;
int userId = !string.IsNullOrWhiteSpace(userIdStr) ? Convert.ToInt32(userIdStr) : 0;
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_GetUserList]";
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("@userName", Request.Query["userName"].ToString());
sqlCommand.Parameters.AddWithValue("@userDescription", Request.Query["userDescription"].ToString());
sqlCommand.Parameters.AddWithValue("@userCode", Request.Query["userCode"].ToString());
sqlCommand.Parameters.AddWithValue("@email", Request.Query["email"].ToString());
sqlCommand.Parameters.AddWithValue("@withDelete", withDelete);
sqlCommand.Parameters.AddWithValue("@userId", userId);
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("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;
* //rows.Add(column);
* giGridInitModel.ColumnList.Add(column);
*/
GIGridColumn model = new GIGridColumn();
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;
}
}
}
giGridInitModel.ColumnList.Add(model);
}
else
{
UserListModel model = new UserListModel();
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 (TokenExpiredException ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
catch (SignatureVerificationException ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
catch (Exception ex)
{
GIxUtils.Log(ex);
throw new Exception(ex.Message);
}
if (initGrid == false)
{
return(rows);
}
return(giGridInitModel);
}