public IList <ClientCRMGroup> Get(int clientId)
{
try
{
Logger.LogInfo("Get: Client festival process start");
IList <ClientCRMGroup> lstClientCRMGroup = new List <ClientCRMGroup>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL_BY_CLIENT_ID, clientId));
foreach (DataRow dr in dtAppConfig.Rows)
{
ClientCRMGroup ClientCRMGroup = convertToClientCRMGroupObject(dr);
lstClientCRMGroup.Add(ClientCRMGroup);
}
Logger.LogInfo("Get: Client festival process completed.");
return(lstClientCRMGroup);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
private ClientCRMGroup convertToClientCRMGroupObject(DataRow dr)
{
ClientCRMGroup ClientCRMGroup = new ClientCRMGroup();
ClientCRMGroup.Id = dr.Field <int>("ID");
ClientCRMGroup.Cid = dr.Field <int>("CID");
ClientCRMGroup.Festival = dr.Field <string>("CRMGroup");
return(ClientCRMGroup);
}