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