public static bool IsRetrievalFormEditable(int RetrievalNo) { LussisEntities context = new LussisEntities(); bool result = false; Retrieval selectedRetrieval = context.Retrievals.Where(ret => ret.RetrievalNo == RetrievalNo).FirstOrDefault(); List <RetrievalDetail> details = null; if (selectedRetrieval != null) { details = context.RetrievalDetails.Where(retDetail => retDetail.RetrievalNo == selectedRetrieval.RetrievalNo).ToList(); if (details != null) { foreach (RetrievalDetail detail in details) { if (detail.Actual == 0) { result = true; } else { result = false; break; } } } } return(result); }
public static List <RetrievalDetail> GetRetrievalDetailsOf(int RetrievalNo) { LussisEntities context = new LussisEntities(); List <RetrievalDetail> result = new List <RetrievalDetail>(); Retrieval selectedRetrieval = context.Retrievals.Where(ret => ret.RetrievalNo == RetrievalNo).FirstOrDefault(); if (selectedRetrieval != null) { result = context.RetrievalDetails.Where(retDetail => retDetail.RetrievalNo == selectedRetrieval.RetrievalNo).ToList(); } return(result); }
public static Retrieval GetLatestRetrieval() { Retrieval result = null; try { LussisEntities context = new LussisEntities(); result = context.Retrievals.OrderByDescending(x => x.RetrievalNo).First(); } catch (Exception) { result = null; } return(result); }