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