public FinancialPlanner.Common.Model.ApplicationConfiguration Get(int id) { FinancialPlanner.Common.Model.ApplicationConfiguration appConfig = new FinancialPlanner.Common.Model.ApplicationConfiguration(); DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ID, id)); foreach (DataRow dr in dtAppConfig.Rows) { appConfig.Id = dr.Field <int>("ID"); appConfig.Category = dr.Field <string>("Category"); appConfig.SettingName = dr.Field <string>("SettingKey"); appConfig.SettingValue = dr.Field <string>("Value"); appConfig.CreatedOn = dr.Field <DateTime>("CreatedOn"); appConfig.CreatedBy = dr.Field <int>("CreatedBy"); appConfig.UpdatedOn = dr.Field <DateTime>("UpdatedOn"); appConfig.UpdatedBy = dr.Field <int>("UpdatedBy"); appConfig.UpdatedByUserName = dr.Field <string>("UpdatedByUserName"); } return(appConfig); }
public IList <FinancialPlanner.Common.Model.ApplicationConfiguration> Get() { IList <FinancialPlanner.Common.Model.ApplicationConfiguration> lstAppConfig = new List <FinancialPlanner.Common.Model.ApplicationConfiguration>(); DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(SELECT_ALL); foreach (DataRow dr in dtAppConfig.Rows) { FinancialPlanner.Common.Model.ApplicationConfiguration appConfig = new FinancialPlanner.Common.Model.ApplicationConfiguration(); appConfig.Id = dr.Field <int>("ID"); appConfig.Category = dr.Field <string>("Category"); appConfig.SettingName = dr.Field <string>("SettingKey"); appConfig.SettingValue = dr.Field <string>("Value"); appConfig.CreatedOn = dr.Field <DateTime>("CreatedOn"); appConfig.CreatedBy = dr.Field <int>("CreatedBy"); appConfig.UpdatedOn = dr.Field <DateTime>("UpdatedOn"); appConfig.UpdatedBy = dr.Field <int>("UpdatedBy"); appConfig.UpdatedByUserName = dr.Field <string>("UpdatedByUserName"); lstAppConfig.Add(appConfig); } return(lstAppConfig); }