public List<Process> ProcessGetDeleted(DateTime startDate)
{
List<Process> ProcessList = new List<Process>();
Process p = new Process();
SqlCommand cmd = new SqlCommand("exec dbo.Atul_ProcessGetDeleted_sp @startdate", this._connection);
cmd.Parameters.Add(new SqlParameter("@startdate", startDate));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "process";
da.Fill(returnTable);
foreach (DataRow r in returnTable.Rows)
{
if (r != null)
{
p.AtulProcessID = Convert.ToInt64(r["AtulProcessID"]);
p.AtulProcessStatusID = (int)r["AtulProcessStatusID"];
p.CreatedBy = Convert.ToInt64(r["CreatedBy"]);
p.CreatedByName = r["CreatedByName"].ToString();
p.CreatedDate = Convert.ToDateTime(r["CreatedDate"]);
p.DeadLineOffset = (int)r["DeadLineOffset"];
p.IsActive = Convert.ToBoolean(r["IsActive"]);
p.ModifiedBy = Convert.ToInt64(r["ModifiedBy"]);
p.ModifiedByName = r["ModifiedByName"].ToString();
if (r["ModifiedDate"] != DBNull.Value)
{
p.ModifiedDate = Convert.ToDateTime(r["ModifiedDate"]);
}
p.OwnedBy = Convert.ToInt64(r["OwnedBy"]);
p.OwnedByName = r["OwnedByName"].ToString();
p.ProcessDescription = r["ProcessDescription"].ToString();
p.ProcessStatus = r["ProcessStatus"].ToString();
p.ProcessSummary = r["ProcessSummary"].ToString();
long providerid;
if (Int64.TryParse(r["SubjectServiceProviderID"].ToString(), out providerid))
{
p.SubjectServiceProviderID = providerid;
}
ProcessList.Add(p);
}
}
return ProcessList;
}