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