Наследование: TersoConnectEntity, IDisposable
 /// <summary>
 /// Method to get user detail by user id
 /// </summary>
 /// <param name="userId"></param>
 /// <returns></returns>
 public UsersModel GetUserModelList(int userId)
 {
     ServiceData serviceData = new ServiceData();
     try
     {
         UsersModel lstUser;
         using (DBUsers objDbUser = new DBUsers())
         {
             lstUser = objDbUser.GetUserModelList(userId);
         }
         return lstUser;
     }
     catch (Exception ex)
     {
         serviceData.Result = false;
         serviceData.ErrorMessage = ex.Message;
         serviceData.ErrorDetails = ex.ToString();
         throw new FaultException<ServiceData>(serviceData);
     }
 }
 /// <summary>
 /// Method to update user detail
 /// </summary>
 /// <param name="userMl"></param>
 /// <returns></returns>
 public int UpdateUserDetails(UsersModel userMl)
 {
     ServiceData serviceData = new ServiceData();
     try
     {
         int result;
         using (DBUsers objDbUsers = new DBUsers())
         {
             result = objDbUsers.UpdateUserDetails(userMl);
         }
         return result;
     }
     catch (Exception ex)
     {
         serviceData.Result = false;
         serviceData.ErrorMessage = ex.Message;
         serviceData.ErrorDetails = ex.ToString();
         throw new FaultException<ServiceData>(serviceData);
     }
 }
 /// <summary>
 /// Method to filter the user list by search text
 /// </summary>
 /// <param name="searchText"></param>
 /// <returns></returns>
 public List<UsersModel> GetFilterUserModelList(string searchText)
 {
     ServiceData serviceData = new ServiceData();
     try
     {
         List<UsersModel> lstUsersModel;
         using (DBUsers objDbUser = new DBUsers())
         {
             lstUsersModel = objDbUser.GetFilterUserModelList(searchText);
         }
         return lstUsersModel;
     }
     catch (Exception ex)
     {
         serviceData.Result = false;
         serviceData.ErrorMessage = ex.Message;
         serviceData.ErrorDetails = ex.ToString();
         throw new FaultException<ServiceData>(serviceData);
     }
 }
 /// <summary>
 /// search user by search text for server side searching and paging
 /// </summary>
 /// <param name="searchText"></param>
 /// <param name="pageNumber"></param>
 /// <param name="pageSize"></param>
 /// <returns></returns>
 public List<UsersModel> SearchUserList(string searchText, int pageNumber, int pageSize)
 {
     ServiceData serviceData = new ServiceData();
     try
     {
         List<UsersModel> lstUsersModel;
         using (DBUsers objDbUser = new DBUsers())
         {
             lstUsersModel = objDbUser.SearchUserList(searchText, pageNumber, pageSize);
         }
         return lstUsersModel;
     }
     catch (Exception ex)
     {
         serviceData.Result = false;
         serviceData.ErrorMessage = ex.Message;
         serviceData.ErrorDetails = ex.ToString();
         throw new FaultException<ServiceData>(serviceData);
     }
 }
 /// <summary>
 /// Method to get the user be email id
 /// </summary>
 /// <param name="emailId"></param>
 /// <returns></returns>
 public UsersModel GetUserModelListByEmail(string emailId)
 {
     ServiceData serviceData = new ServiceData();
     try
     {
         UsersModel objUser;
         using (DBUsers objDbUsers = new DBUsers())
         {
             objUser = objDbUsers.GetUserModelListByEmail(emailId);
         }
         return objUser;
     }
     catch (Exception ex)
     {
         serviceData.Result = false;
         serviceData.ErrorMessage = ex.Message;
         serviceData.ErrorDetails = ex.ToString();
         throw new FaultException<ServiceData>(serviceData);
     }
 }
 /// <summary>
 /// Method to delete the user by user id
 /// </summary>
 /// <param name="userId"></param>
 /// <returns></returns>
 public void DeleteUserDetails(int userId)
 {
     ServiceData serviceData = new ServiceData();
     try
     {
         using (DBUsers objDbUsers = new DBUsers())
         {
             objDbUsers.DeleteUserDetails(userId);
         }
     }
     catch (Exception ex)
     {
         serviceData.Result = false;
         serviceData.ErrorMessage = ex.Message;
         serviceData.ErrorDetails = ex.ToString();
         throw new FaultException<ServiceData>(serviceData);
     }
 }