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