public ClientInfoResult Search(JQueryDataTableParamModel param, DateTime?asOfDate, int?clientTypeID, string clientCode, bool?clientStatus, string ipAddress, string location) { try { int totalRecord; BSL.ClientService cs = new BSL.ClientService(); List <ClientInfo> clientInfos = cs.SearchClient(param, asOfDate, clientTypeID, clientCode, clientStatus, ipAddress, location, out totalRecord); var sr = new ClientInfoResult { IsSuccess = true, ListClients = clientInfos, TotalRecords = totalRecord }; return(sr); } catch (Exception ex) { new RMSWebException(this, "0500", "Search failed. " + ex.Message, ex, true); var sr = new ClientInfoResult { IsSuccess = false, ErrorMessage = "Search errors. " + ex.Message }; return(sr); } }
public ClientInfoResult GetClientInfo(int clientID) { try { using (var db = new MyDbContext()) { SqlParameter p1 = new SqlParameter("ClientID", clientID); var listOfType = db.Database.SqlQuery <ClientInfo>("RMS_GetClientInfoforReport " + "@ClientID", p1); List <ClientInfo> lClientIfnInfos = new List <ClientInfo>(listOfType.ToList()); if (lClientIfnInfos.Count > 0) { ClientInfoResult cr = new ClientInfoResult { IsSuccess = true, Client = lClientIfnInfos[0] }; return(cr); } else { ClientInfoResult cr = new ClientInfoResult { IsSuccess = false, ErrorMessage = "Client Not Found." }; return(cr); } } } catch (Exception ex) { new RMSWebException(this, "0500", "GetClientInfo failed. " + ex.Message, ex, true); return(new ClientInfoResult { IsSuccess = false, ErrorMessage = ex.Message }); } }