public List<ProcessInstance> ProcessInstanceGetDeleted(DateTime startDate)
{
List<ProcessInstance> InstanceList = new List<ProcessInstance>();
ProcessInstance p = new ProcessInstance();
SqlCommand cmd = new SqlCommand("exec dbo.Atul_InstanceProcessGetDeleted_sp @startdate", this._connection);
cmd.Parameters.Add(new SqlParameter("@startdate", startDate));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "processinstance";
da.Fill(returnTable);
foreach (DataRow r in returnTable.Rows)
{
if (r != null)
{
p.AtulInstanceProcessID = Convert.ToInt64(r["AtulInstanceProcessID"]);
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.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.ProcessStatus = r["ProcessStatus"].ToString();
p.ProcessStatus = r["ProcessStatus"].ToString();
p.ProcessSummary = r["ProcessSummary"].ToString();
long providerid;
if (Int64.TryParse(r["SubjectServiceProviderID"].ToString(), out providerid))
{
p.SubjectServiceProviderID = providerid;
}
p.SubjectSummary = r["SubjectSummary"].ToString();
InstanceList.Add(p);
}
}
return InstanceList;
}