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