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