public IList <Common.Model.PlanOption> GetAll(int plannerId)
{
try
{
Logger.LogInfo("Get: Plan option process start");
IList <Common.Model.PlanOption> lstPlanOption = new List <Common.Model.PlanOption>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, plannerId));
foreach (DataRow dr in dtAppConfig.Rows)
{
Common.Model.PlanOption planoption = convertToPlanOptionObject(dr);
lstPlanOption.Add(planoption);
}
Logger.LogInfo("Get: Plan option process completed.");
return(lstPlanOption);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
public void Update(Common.Model.PlanOption planOption)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, planOption.Pid));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_QUERY,
planOption.Name,
planOption.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"),
planOption.UpdatedBy, planOption.RiskProfileId, planOption.Id), true);
Activity.ActivitiesService.Add(ActivityType.UpdatePlannerOption, EntryStatus.Success,
Source.Server, planOption.UpdatedByUserName, planOption.Name, planOption.MachineName);
DataBase.DBService.CommitTransaction();
}
catch (Exception ex)
{
DataBase.DBService.RollbackTransaction();
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
private Common.Model.PlanOption convertToPlanOptionObject(DataRow dr)
{
Common.Model.PlanOption planOpt = new Common.Model.PlanOption();
planOpt.Id = dr.Field <int>("ID");
planOpt.Pid = dr.Field <int>("PID");
planOpt.Name = dr.Field <string>("Name");
planOpt.RiskProfileId = dr.Field <int>("RiskProfileId");
planOpt.UpdatedOn = dr.Field <DateTime>("UpdatedOn");
planOpt.UpdatedBy = dr.Field <int>("UpdatedBy");
return(planOpt);
}
