public IEnumerable <UserRequestItem> GetUserDetailsAll()
{
List <UserRequestItem> request = new List <UserRequestItem>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("UsersSelectAllDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
UserRequestItem currentRow = new UserRequestItem();
currentRow.UserId = dr["UserId"].ToString();
currentRow.EmployeeId = (int)dr["EmployeeId"];
currentRow.FirstName = dr["FirstName"].ToString();
currentRow.LastName = dr["LastName"].ToString();
currentRow.Email = dr["Email"].ToString();
currentRow.RoleId = dr["RoleId"].ToString();
currentRow.Role = dr["Role"].ToString();
request.Add(currentRow);
}
}
}
return(request);
}
public UserRequestItem UserInfoService(string context)
{
UserRequestItem userRequestItem = null;
string responseContext = string.Empty;
int privateKey = CryptographyHelper.AES.CreateKeyIndex();
//암호화
//string decryptContext = CryptographyHelper.AES.Encrypt(context, privateKey);
//평문
string decryptContext = context;
UserRequestItem requestVO = new UserRequestItem
{
privateKey = privateKey.ToString(),
encData = decryptContext,
};
string requestContext = JsonHelper.JsonSerizlizer <UserRequestItem>(requestVO);
try
{
using (HttpRequestHelper client = new HttpRequestHelper(ApplicationConfig.ServiceHost))
{
var response = client.PostASJsonAsync(ApplicationConfig.Service.USERINFO[1], ApplicationConfig.Service.USERINFO[0], requestContext);
if (response.IsSuccessStatusCode)
{
responseContext = client.GetHttpResponseMessage(response);
userRequestItem = JsonHelper.JsonDeserizlizer <UserRequestItem>(responseContext);
}
else
{
responseContext = client.GetHttpResponseMessage(response);
}
}
}
catch
{
userRequestItem = new UserRequestItem();
}
return(userRequestItem);
}
public RequestItem GetUserInfo(string corrinstt, string usrid)
{
RequestItem request = null;
try
{
UserRequestItem Request = new UserRequestItem
{
corrInsttCd = corrinstt,
usrId = usrid,
};
string requestContext = JsonHelper.JsonSerizlizer <UserRequestItem>(Request);
UserRequestItem userRequestItem = UserInfoService(requestContext);
if (userRequestItem == null || string.IsNullOrEmpty(userRequestItem.ENC_DATA))
{
request = new RequestItem();
}
else
{
//암호화
//string responseContext = CryptographyHelper.AES.Decrypt(userRequestItem.ENC_DATA, Convert.ToInt32(userRequestItem.privateKey));
//List<RequestItem> requestData = JsonHelper.JsonDeserizlizer<List<RequestItem>>(responseContext);
//평문
//string responseContext = CryptographyHelper.AES.Decrypt(userRequestItem.ENC_DATA, Convert.ToInt32(userRequestItem.privateKey));
List <RequestItem> requestData = JsonHelper.JsonDeserizlizer <List <RequestItem> >(userRequestItem.ENC_DATA);
if (requestData != null && requestData.Count == 1)
{
request = requestData[0];
}
}
}
catch
{
request = new RequestItem();
}
return(request);
}
