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); }