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