public MyProjectBiddingUpdate(int projectID) { var project = _db.Sales_JobMasterList.Find(projectID); _quote = project.Sales_JobMasterList_QuoteRev.LastOrDefault(); IsBiddingJob = project.isBidToProject; _bid = project.Sales_JobMaster_BiddingJob.FirstOrDefault(); if (_bid == null) { IsBiddingJob = false; } }
public void GenerateMySelfSerialID() { if (_quoteItemID == 0) { return; } Sales_JobMasterList_QuoteRev quote = _db.Sales_JobMasterList_QuoteRev.Find(_quoteRevID); int jobID = quote.jobID; Sales_JobMasterList project = _db.Sales_JobMasterList.Find(jobID); int lastItemID = project.LastQuoteItemID; project.LastQuoteItemID = lastItemID + 1; _db.Entry(project).State = EntityState.Modified; Quote_Item item = _db.Quote_Item.Find(_quoteItemID); item.SerialID = "Q" + (lastItemID + 1).ToString("D2"); _db.Entry(item).State = EntityState.Modified; _db.SaveChanges(); }