private CurrentClientProcess convertToCurrentClientProcess(DataRow dr) { CurrentClientProcess currentClientProcess = new CurrentClientProcess(); currentClientProcess.ClientId = dr.Field <int>("ID"); currentClientProcess.ClientName = dr.Field <string>("Name"); currentClientProcess.ProcessTitle = dr.Field <string>("Title"); currentClientProcess.ProcessStatus = dr.Field <string>("Status"); currentClientProcess.PrimaryStepId = dr.Field <int>("PrimaryStepId"); currentClientProcess.LinkSubStepId = dr.Field <int>("LinkSubStepId"); currentClientProcess.PrimaryStepNo = dr.Field <int>("PrimaryStepNo"); currentClientProcess.LinkSubStepNo = dr.Field <int>("LinkSubStepNo"); currentClientProcess.RefTaskId = dr.Field <string>("RefTaskId"); currentClientProcess.AssignTo = dr.Field <int>("AssignTo"); currentClientProcess.UserName = dr.Field <string>("UserName"); currentClientProcess.ExpectedCompletionDate = dr.Field <DateTime>("ExpectedCompleDate"); if (dr["ActualCompleteDate"] != DBNull.Value) { currentClientProcess.ActualCompletionDate = DateTime.Parse(dr["ActualCompleteDate"].ToString()); } else { currentClientProcess.ActualCompletionDate = null; } currentClientProcess.TaskStatus = dr.Field <string>("TaskStatus"); return(currentClientProcess); }
public IList <CurrentClientProcess> GetAll() { IList <CurrentClientProcess> currentClientProcesses = new List <CurrentClientProcess>(); DataTable dtCurrentClientProcess = DataBase.DBService.ExecuteCommand(SELECT_ALL_CURRENT_CLIENT_PROCESS); foreach (DataRow dr in dtCurrentClientProcess.Rows) { CurrentClientProcess currentClientProcess = convertToCurrentClientProcess(dr); currentClientProcesses.Add(currentClientProcess); } return(currentClientProcesses); }
public IList <CurrentClientProcess> GetClientProcess(int clientId, int?plannerId) { IList <CurrentClientProcess> currentClientProcesses = new List <CurrentClientProcess>(); string queryString = string.Format(SELECT_CLIENT_PROCESS_BY_CLIENTID_PLANNERID, clientId); if (plannerId != null) { queryString = queryString + " and (ClientProcess.PlannerId is null or ClientProcess.PlannerId = " + plannerId + ")"; } DataTable dtCurrentClientProcess = DataBase.DBService.ExecuteCommand(queryString); foreach (DataRow dr in dtCurrentClientProcess.Rows) { CurrentClientProcess currentClientProcess = convertToCurrentClientProcess(dr); currentClientProcesses.Add(currentClientProcess); } return(currentClientProcesses); }