/// <summary>
/// TO GET CLIENT DETAIL BY LOCATION
/// </summary>
/// <CreatedBy>Manoj jaswal</CreatedBy>
/// <CreatedDate>17 April 2015</CreatedDate>
/// <param name="LocationID"></param>
/// <returns></returns>
public UserModelList GetClientByLocation(long LocationID)
{
try
{
LocationClientMappingRepository obj_LocationClientMappingRepository = new LocationClientMappingRepository();
UserRegistration Client = obj_LocationClientMappingRepository.GetSingleOrDefault(x => x.LocationId == LocationID && x.IsDeleted == false).UserRegistration;
UserModelList obj_UserModel = new UserModelList();
obj_UserModel.UserId = Client.UserId;
obj_UserModel.UserEmail = Client.UserEmail;
obj_UserModel.Name = Client.FirstName + " " + Client.LastName;
obj_UserModel.JobTitle = Client.JobTitle;
if (Client.DOB != null)
{
obj_UserModel.DOB = Client.DOB.Value.ToClientTimeZoneinDateTime();
}
if (Client.HiringDate != null)
{
obj_UserModel.HiringDate = Client.HiringDate.Value.ToClientTimeZoneinDateTime();
}
obj_UserModel.RoleId = Client.UserType;
return(obj_UserModel);
}
catch (Exception)
{
throw;
}
}
public UserModelList SelectUsersAll()
{
var cs = "Server=localhost\\SQLEXPRESS;Database=HospitalDB;Trusted_Connection=True;";
using var con = new SqlConnection(cs); //Using Class SqlConnection for COnnent to database
con.Open();
string sql = "SELECT Id, Username, Name, Surname, CreateDate FROM UserTbl";
using var cmd = new SqlCommand(sql, con); //Using Class SqlCommand for query data
using SqlDataReader rdr = cmd.ExecuteReader();
// string output = "";
UserModelList output = new UserModelList();
output.Usertable = new List <UserModel>();
while (rdr.Read())
{
output.Usertable.Add(
new UserModel()
{
id = rdr.GetInt32(0),
username = rdr.GetString(1),
name = rdr.GetString(2),
surname = rdr.GetString(3),
createdate = rdr.GetDateTime(4),
}
);
}
return(output);
}
public void NewAsync()
{
try
{
// Mock for saving into Database
if (UserModelList == null)
{
UserModelList = new List <UserModel>();
}
UserModelList.AddRange(UserModelForTest);
Assert.IsNotEmpty(UserModelList);
}
catch (Exception e)
{
Assert.Fail(e.Message);
}
}
public JsonResult GetUserInfo(GetUserInfoRequest body)
{
_log.WriteInfo("开始请求接口【user/info】");
UserModelList result = new UserModelList();
try
{
var request = GetFilterRequest.GetParams(HttpContext.ApplicationInstance.Request);
if (!request.Status)
{
result.code = request.code;
result.message = request.message;
result.details = request.details;
result.hint = request.hint;
}
else
{
result.users = new List <UserModel>();
result.users.Add(new UserModel
{
id = "1000",
name = "天玺",
avatar_url = $"{ConfigurationManager.AppSettings["WPSTokenUrl"]}/Images/photo1.jpg",
});
result.users.Add(new UserModel
{
id = "1001",
name = "兆丰",
avatar_url = $"{ConfigurationManager.AppSettings["WPSTokenUrl"]}/Images/photo2.jpg"
});
}
}
catch (Exception ex)
{
_log.WriteError("【系统异常】-【" + ex.Message + "】", ex);
result.code = (int)Enumerator.ErrorCode.ServerError;
result.message = Enumerator.ErrorCode.ServerError.ToString();
result.details = result.hint = EnumExtension.GetDescription(Enumerator.ErrorCode.ServerError);
}
_log.WriteInfo("请求接口【user/info】完成,返回数据：" + JsonConvert.SerializeObject(result));
return(Json(result));
}
public UserModelList QueryUsers(UserModelRequest requestSerach)
{
var cs = "Server=localhost\\SQLEXPRESS;Database=HospitalDB;Trusted_Connection=True;";
using var con = new SqlConnection(cs); //Using Class SqlConnection for COnnent to database
con.Open();
string sql = string.Format(@"SELECT a.Id, a.Username, a.Name, a.Surname, a.CreateDate, b.Role
FROM UserTbl a LEFT JOIN RoleTbl b ON a.RoleId = b.Id
WHERE (a.Name LIKE '%{0}%' OR a.Surname LIKE '%{0}%' OR a.Username LIKE '%{0}%')
", requestSerach.SearchText);
using var cmd = new SqlCommand(sql, con); //Using Class SqlCommand for query data
using SqlDataReader rdr = cmd.ExecuteReader();
UserModelList output = new UserModelList();
output.Usertable = new List <UserModel>();
while (rdr.Read())
{
output.Usertable.Add(
new UserModel()
{
id = rdr.GetInt32(0),
username = rdr.GetString(1),
name = rdr.GetString(2),
surname = rdr.GetString(3),
createdate = rdr.GetDateTime(4),
roleName = rdr.GetString(5)
}
);
}
return(output);
}
private void SavedUserSelectedEventReceived(UserModel userModel)
{
// Track saved user selection in the SavedTweetsModule
_selectedSavedUserModel = UserModelList?.FirstOrDefault(x => x.UserId == userModel.UserId);
}
public UserModelList GetQueryUserList([FromQuery] UserModelRequest request)
{
UserModelList result = _userService.SelectUserList(request);
return(result);
}
public UserModelList GetUserList()
{
UserModelList result = _userService.SelectUsers();
return(result);
}
public object GetUserList()
{
try
{
using (newconecommerce dataContext = new newconecommerce())
{
UserModelList _userList = new UserModelList();
List <CountryList> _listCountry = new List <CountryList>();
List <CityList> _listCity = new List <CityList>();
List <StateList> _listState = new List <StateList>();
List <UserTypeList> _listUserType = new List <UserTypeList>();
dataContext.Database.Connection.Open();
_listCity = (from _city in dataContext.tbl_Cities.AsEnumerable()
where _city.b_flag == true
select new CityList
{
int_id = _city.int_Id,
v_name = _city.v_City
}).ToList();
_listState = (from _state in dataContext.tbl_States.AsEnumerable()
where _state.b_IsActive == true
select new StateList
{
int_id = _state.int_Id,
v_name = _state.v_State
}).ToList();
_listCountry = (from _country in dataContext.tbl_Countries.AsEnumerable()
where _country.b_IsActive == true
select new CountryList
{
int_id = _country.int_Id,
v_name = _country.v_country
}).ToList();
_listUserType = (from _usertype in dataContext.tbl_User_Types.AsEnumerable()
select new UserTypeList
{
int_id = _usertype.int_Id,
v_User_Type = _usertype.v_name
}).ToList();
_listState.Insert(0, new StateList {
v_name = "--Select State--", int_id = 0
});
_listCity.Insert(0, new CityList {
v_name = "--Select City--", int_id = 0
});
_listCountry.Insert(0, new CountryList {
v_name = "--Select Country--", int_id = 0
});
_listUserType.Insert(0, new UserTypeList {
v_User_Type = "--Select User Type--", int_id = 0
});
_userList._listUserType = _listUserType;
_userList._listCity = _listCity;
_userList._listState = _listState;
_userList._listCountry = _listCountry;
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = _userList
});
}
}
catch (Exception ex)
{
throw ex;
}
}
public UserModelList SelectUserList(UserModelRequest requestSerach)
{
UserModelList result = _userRepository.QueryUsers(requestSerach);
return(result);
}
public UserModelList SelectUsers()
{
UserModelList result = _userRepository.SelectUsersAll();
return(result);
}
private void LiveUserSelectedEventReceived(UserModel userModel)
{
// Track live user selection in LiveTweetsModule
_currentLiveSelectedUserModel = UserModelList?.FirstOrDefault(x => x.UserId == userModel.UserId);
}
