internal static List <RuntimeData> loadDataFromBook(int sheetNo, string stockStart, string stockEnd) { BillingDataDataContext db = new BillingDataDataContext(); db.sp_LoadToRuntimeFromBookNo(stockStart, stockEnd, SecurityModule.currentUserName, sheetNo); return(db.RuntimeDatas.Where(x => x.SheetNo == sheetNo && x.UserId == SecurityModule.currentUserName).OrderBy(y => y.ConsignmentNo).ToList()); }