private static void getAllNotQualifiedDocs(int appId) { using (DocDataContext dd = new DocDataContext()) { List <tblDocument> docs = dd.tblDocuments.Where(x => x.ApplicationId == appId).Select(x => x).ToList(); foreach (tblDocument doc in docs) { // list all document who doesn't include sub-document tracking history List <tblDocTrack> tracks = dd.tblDocTracks.Where(x => (x.DocumentId == doc.Id && x.DocStatus == "Received & Qualifiying" && x.SubDocumentId == null)).Select(x => x).ToList(); foreach (tblDocTrack track in tracks) { Console.WriteLine("Requested on: {0}\t received on: {1}, Issues: {2}\t {3} status: {4}", track.RequstDate, track.ReceivedDate, doc.DocName, track.Issues, track.DocStatus); } if (dd.tblSubDocuments.Where(x => x.DocumentId == doc.Id).Select(x => x) != null) { // list all sub document tracking history List <tblSubDocument> subdocs = dd.tblSubDocuments.Where(x => x.DocumentId == doc.Id).Select(x => x).ToList(); foreach (tblSubDocument subdoc in subdocs) { List <tblDocTrack> subtracks = dd.tblDocTracks.Where(x => (x.DocumentId == doc.Id && x.SubDocumentId == subdoc.Id && x.DocStatus == "Received & Qualifiying")).Select(x => x).ToList(); foreach (tblDocTrack subtrack in subtracks) { Console.WriteLine("{0} received on: {1}, {2},it's in process of {3}", doc.DocName, subtrack.ReceivedDate, subtrack.Issues, subtrack.DocStatus); } } } } } }
private static void getAllDocList(int appId) { using (DocDataContext dd = new DocDataContext()) { List <tblDocument> docs = dd.tblDocuments.Where(x => x.ApplicationId == appId).Select(x => x).ToList(); foreach (tblDocument doc in docs) { Console.WriteLine("Doc Number: {0}\tDoc Name: {1}\tDoc owner: {2}\tRemark: {3}", doc.DocNumber, doc.DocName, doc.DocOwner, doc.Remark); if (dd.tblSubDocuments.Where(x => x.DocumentId == doc.Id).Select(x => x) != null) { List <tblSubDocument> subdocs = dd.tblSubDocuments.Where(x => x.DocumentId == doc.Id).Select(x => x).ToList(); foreach (tblSubDocument subdoc in subdocs) { Console.WriteLine("\tSub Doc Id: {0}\tDoc Name: {1}\tRemark: {2}", subdoc.Id, subdoc.DocName, subdoc.Remark); } } } Console.WriteLine(); } }
//private static void getAllDocTrack(int appId) //{ // using(DocDataContext dd = new DocDataContext()) // { // List<tblDocument> docs = dd.tblDocuments.Where(x => x.ApplicationId == appId).Select(x => x).ToList(); // foreach(tblDocument doc in docs) // { // List<tblDocTrack> tracks = dd.tblDocTracks.Where(x =>( x.DocumentId == doc.Id && x.SubDocumentId==null)).Select(x => x).ToList(); // foreach(tblDocTrack track in tracks) // { // setupColor(track); // Console.WriteLine("{0} received on: {1}\t{2}\tIssues: {3} ", doc.DocName, track.ReceivedDate, track.DocStatus, track.Issues); // } // if(dd.tblSubDocuments.Where(x => x.DocumentId == doc.Id).Select(x => x) != null) // { // List<tblSubDocument> subdocs = dd.tblSubDocuments.Where(x => x.DocumentId == doc.Id).Select(x => x).ToList(); // foreach(tblSubDocument subdoc in subdocs) // { // List<tblDocTrack> subtracks = dd.tblDocTracks.Where(x => (x.DocumentId == doc.Id && x.SubDocumentId == subdoc.Id)).Select(x => x).ToList(); // foreach(tblDocTrack subtrack in subtracks) // { // // setupColor(subtrack); // Console.ForegroundColor = ConsoleColor.White; // Console.WriteLine("{0} received on: {1}\t{2}\tIssues:{3}", doc.DocName, subtrack.ReceivedDate, subtrack.DocStatus, subtrack.Issues); // } // } // } // } // } //} private static void getAllDocTrack(int appId) { using (DocDataContext dd = new DocDataContext()) { List <tblDocTrack> tracks = dd.tblDocTracks.Where(x => x.ApplicationId == 1).Select(x => x).OrderBy(x => x.DocStatus).ToList(); foreach (tblDocTrack t in tracks) { string dn = dd.tblDocuments.Where(x => x.Id == t.DocumentId).Select(x => x.DocName).FirstOrDefault(); string sdn = dd.tblSubDocuments.Where(x => x.Id == t.SubDocumentId).Select(x => x.DocName).FirstOrDefault(); setupColor(t); if (t.SubDocumentId == null) { Console.WriteLine("{0} received on: {1}\t{2}\tIssues:{3}", dn, t.ReceivedDate, t.DocStatus, t.Issues); } else { Console.WriteLine("\t{0} received on: {1}\t{2}\tIssues:{3}", sdn, t.ReceivedDate, t.DocStatus, t.Issues); } } } }