public void EmailAutomation() { using (var context = new SidejobEntities()) { var message = (from c in context.AutomatedMessages select c).ToList(); if (message.Count != 0) { foreach (var e in message) { try { SendEmail(e.EmailAddress, e.Title, e.MessageID.ToString(CultureInfo.InvariantCulture), Server.MapPath("~/EmailTemplates/AutomatedMessage.aspx"), Message.Automated); } catch (Exception emailexception) { var emailProblem = new AutomationEmailProblem { MessageID = e.MessageID, EmailAddress = e.EmailAddress, Title = e.Title, Message = e.Message }; context.AddToAutomationEmailProblems(emailProblem); } } } context.DeleteObject(message); context.SaveChanges(); } }
//private void GetValue(SidejobEntities context) //{ // var projectsecondchance = (from c in context.ProjectSecondChances // where c.ProjectID == ProjectID // select c).ToList(); // if (projectsecondchance.Count != 0) // { // foreach (var psc in projectsecondchance) // { // context.DeleteObject(psc); // context.SaveChanges(); // } // } //} private void GetValue(SidejobEntities context, ICollection somelist) { if (somelist.Count <= 0) return; foreach (var item in somelist) { context.DeleteObject(item); context.SaveChanges(); } }
public void DeleteFromResponseDelay(SidejobEntities context) { var rd = (from c in context.ResponseDelays where c.ProjectID == ProjectID select c).FirstOrDefault(); if ( rd != null) { context.DeleteObject(rd); context.SaveChanges(); } }
public void DeleteAllBids(SidejobEntities context, int projectId, int bidderid) { var bids = (from c in context.Bids where c.ProjectID == projectId orderby c.AmountOffered descending select c).ToList(); if (bids.Count != 0) { foreach (var b in bids) { context.DeleteObject(b); } } context.SaveChanges(); }
protected void AutomatedEmailProblemGridViewSelectedIndexChanged(object sender, EventArgs e) { //Issue is fixed, then delete it if (AutomatedEmailProblemGridView.SelectedDataKey == null) return; var selected = (int)AutomatedEmailProblemGridView.SelectedDataKey.Value; using (var context = new SidejobEntities()) { var current = (from c in context.AutomationEmailProblems where c.MessageID == selected select c).FirstOrDefault(); if (current != null) { context.DeleteObject(current); context.SaveChanges(); } } }
protected void EmailSentExceptionGridViewSelectedIndexChanged(object sender, EventArgs e) { //Issue is fixed, then delete it if (EmailSentExceptionGridView.SelectedDataKey == null) return; var selected = (int)EmailSentExceptionGridView.SelectedDataKey.Value; using (var context = new SidejobEntities()) { var current = (from c in context.EmailSentExceptions where c.ID == selected select c).FirstOrDefault(); if (current != null) { context.DeleteObject(current); context.SaveChanges(); Response.Redirect(Context.Request.Url.ToString()); } } }
protected void ArchiveRefund(int pdtid) { using (var context = new SidejobEntities()) { var currentrefund = (from c in context.RefundCustomerSuccessfulPDTs where c.PDTID == pdtid select c).FirstOrDefault(); if(currentrefund != null) { var archivedrefund = new ArchivedRefundCustomerSuccessfulPDT { PDTID = currentrefund.PDTID, GrossTotal = currentrefund.GrossTotal, Invoice = currentrefund.Invoice, PaymentStatus = currentrefund.PaymentStatus, FirstName = currentrefund.FirstName, LastName = currentrefund.LastName, PaymentFee = currentrefund.PaymentFee, BusinessEmail = currentrefund.BusinessEmail, TxToken = currentrefund.TxToken, ReceiverEmail = currentrefund.ReceiverEmail, ItemName = currentrefund.ItemName, CurrencyCode = currentrefund.CurrencyCode, TransactionId = currentrefund.TransactionId, Custom = currentrefund.Custom, subscriberId = currentrefund.subscriberId, CustomerID = currentrefund.CustomerID, ProjectID = currentrefund.ProjectID }; context.AddToArchivedRefundCustomerSuccessfulPDTs(archivedrefund); context.DeleteObject(currentrefund); context.SaveChanges(); Response.Redirect(Context.Request.Url.ToString()); } } }
public void AutomatedMessageProcessStart() { using (var context = new SidejobEntities()) { var message = (from c in context.AutomatedMessages select c).ToList(); if (message.Count == 0) return; foreach (var m in message) { try { SendEmail(m.EmailAddress, "http://www.my-side-job.com/Schedule/MySideJob/EmailTemplates/AutomatedMessage.aspx", m.MessageID.ToString(CultureInfo.InvariantCulture)); context.DeleteObject(m); } catch (Exception) { CatchMessage(context, m); } } } }
public void RefundCustomer(int customerId) { //Check Successful PDT and Check ArchivedSuccessful PDT using (var context = new SidejobEntities()) { //Check Successful PDT var e = (from c in context.CustomerSuccessfulPDTs where c.CustomerID == customerId && c.ProjectID == ProjectID select c).FirstOrDefault(); if (e == null) { CheckCustomerArchivedPDT(customerId, context); } else { CheckRefundedCustomerPDT(customerId, e, context); context.DeleteObject(e); context.SaveChanges(); } } }
public void CustomerWin(Bid bidder) { var context = new SidejobEntities(); var customerwinbid = new CustomerWinBid { BidID = bidder.BidID, CustomerID = bidder.BidderID, NumberofBids = GetCustomerNumberofBids(bidder.BidderID) }; context.AddToCustomerWinBids(customerwinbid); context.DeleteObject(bidder); context.SaveChanges(); }
public void ProWin(Bid bidder) { var context = new SidejobEntities(); var professionalwinbid = new ProfessionalWinBid { BidID = bidder.BidID, ProID = bidder.BidderID, NumberofBids = GetProfessionalNumberofBids(bidder.BidderID) }; context.AddToProfessionalWinBids(professionalwinbid); context.DeleteObject(bidder); context.SaveChanges(); }
public static void PosterResponseDelayUpdate(int projectid) { using (var context = new SidejobEntities()) { var rd = (from c in context.ResponseDelays where c.ProjectID == projectid select c).FirstOrDefault(); context.DeleteObject(rd); } }
private void Process() { using (var context = new SidejobEntities()) { var newopportunity = (from cp in context.ProjectSecondChances where cp.ProjectID == ProjectID select cp); if (newopportunity.Count() == 2) { //Save to ArchivedProjectSecondChance SavedToArchivedProjectSecondChance(context, newopportunity); //Delete Previous BidderWin and Bids DeletePreviousBidderWin(context, ProjectID); //Add Current BidderWin AddNewBidderWin(context, ProjectID); //update project Updateproject(context); //delete from Response Delay DeleteFromResponseDelay(context); foreach (ProjectSecondChance o in newopportunity.ToList()) { context.DeleteObject(o); } } context.SaveChanges(); } }
private static void ExtendProject(int projectid) { using (var context = new SidejobEntities()) { //Extend Project ( Make statusInt = 0 and ouput message) // Delete the previous bidder in Project var newBidProcess = new NewProjectBidProcess(PreviousBidderID, ProjectID); newBidProcess.DeleteAllBids(context, ProjectID, PreviousBidderID); //Delete From ClosedProject var closedproject = (from c in context.ClosedProjects where c.ProjectID == projectid select c).FirstOrDefault(); if (closedproject != null) { context.DeleteObject(closedproject); } //Delete From ResponseDelay var rd = (from c in context.ResponseDelays where c.ProjectID == projectid select c).FirstOrDefault(); if (rd != null) { context.DeleteObject(rd); context.SaveChanges(); } //Update Project Requirement End Date to Today + 7 days var projectrequirement = (from c in context.ProjectRequirements where c.ProjectID == projectid select c).FirstOrDefault(); if (projectrequirement != null) { projectrequirement.DatePosted = DateTime.UtcNow.Date.AddDays(7); context.SaveChanges(); } //Clear Project Winning Bid var project = (from c in context.Projects where c.ProjectID == projectid select c).FirstOrDefault(); if (project == null) return; project.StatusInt = 0; project.Status = Resources.Resource.OPEN; project.HighestBid = null; project.HighestBidderID = null; project.HighestBidUsername = null; project.NumberofBids = 0; context.SaveChanges(); } }
public void ArchiveCancelledProject(SidejobEntities context) { //Insert into archived var currentproject = (from c in context.Projects where c.ProjectID == ProjectID select c).FirstOrDefault(); var currentprojectphoto = (from c in context.ProjectPhotoes where c.ProjectID == ProjectID select c).ToList(); var currentprojectpicture = (from c in context.ProjectPictures where c.ProjectID == ProjectID select c).FirstOrDefault(); var currentprojectrequirement = (from c in context.ProjectRequirements where c.ProjectID == ProjectID select c).FirstOrDefault(); if (currentproject != null) { if (currentprojectrequirement != null) { if ((from c in context.ArchievedCancelledProjects where c.ProjectID == ProjectID select c).FirstOrDefault() == null) { var acp = new ArchievedCancelledProject { ProjectID = (int)currentproject.ProjectID, DateFinished = DateTime.Now.Date, PosterID = PosterID, PosterRole = PosterRole, BidderID = BidderID, BidderRole = BidderRole, HighestBid = currentproject.HighestBid, Currency = currentprojectrequirement.CurrencyID, Status = currentproject.StatusInt }; context.AddToArchievedCancelledProjects(acp); } } } //for each record foreach (var cp in currentprojectphoto) { if ((from c in context.ArchievedCancelledProjectPhotoes where c.PhotoID == cp.PhotoID select c).FirstOrDefault() == null) { var ac = new ArchievedCancelledProjectPhoto { PhotoID = cp.PhotoID, ProjectID = cp.ProjectID, PhotoPath = cp.PhotoPath, Caption = cp.Caption, AlbumID = cp.AlbumID, PhotoRank = cp.PhotoRank }; context.AddToArchievedCancelledProjectPhotoes(ac); } } if (currentprojectpicture != null) { if ((from c in context.ArchievedCancelledProjectPictures where c.AlbumID == currentprojectpicture.AlbumID select c).FirstOrDefault() == null) { var acpi = new ArchievedCancelledProjectPicture { AlbumID = currentprojectpicture.AlbumID, AlbumCaption = currentprojectpicture.AlbumCaption, Numberofimages = currentprojectpicture.Numberofimages, ProjectID = currentprojectpicture.ProjectID }; context.AddToArchievedCancelledProjectPictures(acpi); } } if (currentprojectrequirement != null) { if ((from c in context.ArchievedCancelledProjectRequirements where c.ProjectID == currentprojectpicture.AlbumID select c).FirstOrDefault() == null) { var acpr = new ArchievedCancelledProjectRequirement { ProjectID = currentprojectrequirement.ProjectID, LCID = currentprojectrequirement.LCID, CategoryID = currentprojectrequirement.CategoryID, CategoryName = currentprojectrequirement.CategoryName, JobID = currentprojectrequirement.JobID, JobTitle = currentprojectrequirement.JobTitle, ExperienceID = currentprojectrequirement.ExperienceID, CrewNumberID = currentprojectrequirement.CrewNumberID, LicensedID = currentprojectrequirement.LicensedID, InsuredID = currentprojectrequirement.InsuredID, RelocationID = currentprojectrequirement.RelocationID, ProjectTitle = currentprojectrequirement.ProjectTitle, StartDate = currentprojectrequirement.StartDate, EndDate = currentprojectrequirement.EndDate, AmountOffered = currentprojectrequirement.AmountOffered, CurrencyID = currentprojectrequirement.CurrencyID, Description = currentprojectrequirement.Description, SpecialNotes = currentprojectrequirement.SpecialNotes, Address = currentprojectrequirement.Address, CountryID = currentprojectrequirement.CountryID, CountryName = currentprojectrequirement.CountryName, RegionID = currentprojectrequirement.RegionID, RegionName = currentprojectrequirement.RegionName, CityID = currentprojectrequirement.CityID, CityName = currentprojectrequirement.CityName, Zipcode = currentprojectrequirement.Zipcode, DatePosted = currentprojectrequirement.DatePosted, TimeLeft = currentprojectrequirement.TimeLeft }; context.AddToArchievedCancelledProjectRequirements(acpr); } } context.SaveChanges(); //delete from current project if (currentprojectrequirement != null) context.DeleteObject(currentproject); if (currentprojectphoto.Count != 0) { foreach (var cp in currentprojectphoto) { context.DeleteObject(cp); } } if (currentprojectpicture != null) context.DeleteObject(currentprojectpicture); if (currentprojectrequirement != null) context.DeleteObject(currentprojectrequirement); context.SaveChanges(); }
private void MessageProperties() { //GET THE PDTID FORM ARCHIVE REFUND const string singlespace = " "; const string startofBoldRed = "<span class='DarkRed'><strong>"; const string lastofBoldRed = "</strong></span>"; PDTID = Convert.ToInt32(Request.QueryString["pdtid"]); ProjectID = Convert.ToInt32(Request.QueryString["prid"]); ProfessionalID = Convert.ToInt32(Request.QueryString["pid"]); if (ProjectID == 0) return; ProjectNotification.Text = Resources.Resource.Project + singlespace + ProjectID + singlespace + Resources.Resource.Notification; ConfirmationEmail.Text = Resources.Resource.RefundEmailMessage1 + singlespace + startofBoldRed + ProjectID + lastofBoldRed + singlespace + Resources.Resource.RefundEmailMessage2; using (var context = new SidejobEntities()) { var currentrefund = (from c in context.RefundProfessionalSuccessfulPDTs where c.PDTID == PDTID select c).FirstOrDefault(); if (currentrefund == null) return; Amount.Text = currentrefund.GrossTotal.ToString(CultureInfo.InvariantCulture) + singlespace + currentrefund.CurrencyCode.ToString(CultureInfo.InvariantCulture) + singlespace; Transaction.Text = currentrefund.TransactionId; NameLabel.Text = currentrefund.FirstName + singlespace + currentrefund.LastName; context.DeleteObject(currentrefund); context.SaveChanges(); } }
public void CleanProjectData(SidejobEntities context) { var cp = (from c in context.ClosedProjects where c.ProjectID == ProjectID select c).ToList(); if (cp.Count != 0) { foreach (var ccp in cp) { context.DeleteObject(ccp); } } context.SaveChanges(); var rd = (from c in context.ResponseDelays where c.ProjectID == ProjectID select c).ToList(); if (rd.Count != 0) { foreach (var crd in rd) { context.DeleteObject(crd); } } context.SaveChanges(); }
public void UpdateResponseDelay(int action, ClosedProject cp, SidejobEntities context) { if (action == 0) return; switch (action) { case 1: var rd = new ResponseDelay { BidderID = BidderID, CurrencyID = cp.CurrencyID, BidderRole = BidderRole, DateFinished = DateTime.UtcNow.Date, HighestBid = cp.HighestBid, PosterID = PosterID, ReminderLevel = 1, Status = 3 }; context.AddToResponseDelays(rd); context.SaveChanges(); break; case 2: var rd2 = (from c in context.ResponseDelays where c.BidderID == BidderID && c.PosterID == PosterID && c.Status == 3 select c).FirstOrDefault(); if (rd2 != null) { rd2.Status = 4; context.SaveChanges(); } break; case 3: ArchiveProject(context); var rd3 = (from c in context.ResponseDelays where c.BidderID == BidderID && c.PosterID == PosterID select c).FirstOrDefault(); if (rd3 != null) { context.DeleteObject(rd3); context.DeleteObject(cp); var p = (from c in context.Projects where c.ProjectID == ProjectID select c).FirstOrDefault(); if (p != null) { p.StatusInt = 6; context.SaveChanges(); } } break; } }
public void DeletePreviousBidderWin(SidejobEntities context, int projectId) { var previous = (from c in context.ClosedProjects where c.ProjectID == projectId select c.BidderID).FirstOrDefault(); if (previous != null) { var bids = (from c in context.Bids where c.ProjectID == projectId && c.BidderID == previous orderby c.AmountOffered descending select c).FirstOrDefault(); if (bids != null) { int previousbidid = bids.BidID; context.DeleteObject(bids); var previouswinnerbid = (from c in context.ProfessionalWinBids where c.ProID == previous && c.BidID == previousbidid select c).FirstOrDefault(); if (previouswinnerbid != null) { context.DeleteObject(previouswinnerbid); } } context.SaveChanges(); } }
public void RefundProfessional(int professionalId) { //Check Successful PDT and Check ArchivedSuccessful PDT using (var context = new SidejobEntities()) { //Check Successful PDT var e = (from c in context.ProfessionalSuccessfulPDTs where c.ProID == professionalId && c.ProjectID == ProjectID select c).FirstOrDefault(); if (e == null) { CheckProfessionalArchivedPDT(professionalId, context); } else { CheckRefundedProfessionalPDT(context, e); context.DeleteObject(e); context.SaveChanges(); } } }
/// <summary> /// Delete All References to this project /// </summary> public void CleanUpProjectReferences(SidejobEntities context) { //ProjectSecondChance //ClosedProject //ResponseDelay //Bids //// Archives //// /////Cancelled//// //////Project///// //// Archives //// //ProfessionalWinBid CleanUpTables(context, (from c in context.ProjectSecondChances where c.ProjectID == ProjectID select c).ToList()); CleanUpTables(context, (from c in context.ClosedProjects where c.ProjectID == ProjectID select c).ToList()); CleanUpTables(context, (from c in context.ResponseDelays where c.ProjectID == ProjectID select c).ToList()); CleanUpTables(context, (from c in context.Bids where c.ProjectID == ProjectID && c.BidderID == BidderID select c).ToList()); ArchiveCancelledProject(context); var pwb = (from c in context.ProfessionalWinBids where c.ProID == BidderID select c).FirstOrDefault(); if (pwb == null) return; context.DeleteObject(pwb); context.SaveChanges(); }
public void PosterDelay(SidejobEntities context, int status, SidejobModel.ResponseDelay t1) { if (status == 4) { var reminderLevel = t1.ReminderLevel; if (reminderLevel == 0) { // Email Poster. Email Bidder // Warn Poster with reminder 1 //Update Time Delay to Reminder level 1 EmailPoster(t1, Message.Warning); EmailBidder(t1, Message.Notification); t1.ReminderLevel = 1; } if (reminderLevel == 1) { // Email Poster. Email Bidder // Warn Poster with reminder 2 //Update Time Delay to Reminder level 2 EmailPoster(t1, Message.Warning); EmailBidder(t1, Message.Notification); t1.ReminderLevel = 2; } if (reminderLevel == 2) { // Email Poster. Email Bidder // Warn Poster with reminder 3 //Update Time Delay to Reminder level 3 EmailPoster(t1, Message.Warning); EmailBidder(t1, Message.Notification); t1.ReminderLevel = 3; } if (reminderLevel == 3) { ////////////////////////////////Poster no payment//////////////////////////// // Add The Poster to blocked poster BlockPoster(context); // Email Bidder & Email Poster //Throught Button in CustomerRefund or ProfessionalRefund // EmailBidder(t1, Message.Refund); EmailPoster(t1, Message.Blocked); //Refund Bidder RefundBidder(); //Through PayPalAPI inthe future //////////////////////////////////////// //Delete from ClosedProject var closedproject = (from c in context.ClosedProjects where c.ProjectID == ProjectID select c).FirstOrDefault(); if (closedproject != null) { context.DeleteObject(closedproject); } context.SaveChanges(); //Insert into archived var currentproject = (from c in context.Projects where c.ProjectID == ProjectID select c).FirstOrDefault(); var currentprojectphoto = (from c in context.ProjectPhotoes where c.ProjectID == ProjectID select c).ToList(); var currentprojectpicture = (from c in context.ProjectPictures where c.ProjectID == ProjectID select c).FirstOrDefault(); var currentprojectrequirement = (from c in context.ProjectRequirements where c.ProjectID == ProjectID select c).FirstOrDefault(); if (currentproject != null) { if (currentprojectrequirement != null) { if ((from c in context.ArchievedCancelledProjects where c.ProjectID == ProjectID select c).FirstOrDefault() == null) { var acp = new ArchievedCancelledProject { ProjectID = (int)currentproject.ProjectID, DateFinished = DateTime.Now.Date, PosterID = PosterID, PosterRole = PosterRole, BidderID = BidderID, BidderRole = BidderRole, HighestBid = currentproject.HighestBid, Currency = currentprojectrequirement.CurrencyID, Status = currentproject.StatusInt }; context.AddToArchievedCancelledProjects(acp); } } } //for each record foreach (var cp in currentprojectphoto) { if ((from c in context.ArchievedCancelledProjectPhotoes where c.PhotoID == cp.PhotoID select c).FirstOrDefault() == null) { var ac = new ArchievedCancelledProjectPhoto { PhotoID = cp.PhotoID, ProjectID = cp.ProjectID, PhotoPath = cp.PhotoPath, Caption = cp.Caption, AlbumID = cp.AlbumID, PhotoRank = cp.PhotoRank }; context.AddToArchievedCancelledProjectPhotoes(ac); } } if (currentprojectpicture != null) { if ((from c in context.ArchievedCancelledProjectPictures where c.AlbumID == currentprojectpicture.AlbumID select c).FirstOrDefault() == null) { var acpi = new ArchievedCancelledProjectPicture { AlbumID = currentprojectpicture.AlbumID, AlbumCaption = currentprojectpicture.AlbumCaption, Numberofimages = currentprojectpicture.Numberofimages, ProjectID = currentprojectpicture.ProjectID }; context.AddToArchievedCancelledProjectPictures(acpi); } } if (currentprojectrequirement != null) { if ((from c in context.ArchievedCancelledProjectRequirements where c.ProjectID == currentprojectpicture.AlbumID select c).FirstOrDefault() == null) { var acpr = new ArchievedCancelledProjectRequirement { ProjectID = currentprojectrequirement.ProjectID, LCID = currentprojectrequirement.LCID, CategoryID = currentprojectrequirement.CategoryID, CategoryName = currentprojectrequirement.CategoryName, JobID = currentprojectrequirement.JobID, JobTitle = currentprojectrequirement.JobTitle, ExperienceID = currentprojectrequirement.ExperienceID, CrewNumberID = currentprojectrequirement.CrewNumberID, LicensedID = currentprojectrequirement.LicensedID, InsuredID = currentprojectrequirement.InsuredID, RelocationID = currentprojectrequirement.RelocationID, ProjectTitle = currentprojectrequirement.ProjectTitle, StartDate = currentprojectrequirement.StartDate, EndDate = currentprojectrequirement.EndDate, AmountOffered = currentprojectrequirement.AmountOffered, CurrencyID = currentprojectrequirement.CurrencyID, Description = currentprojectrequirement.Description, SpecialNotes = currentprojectrequirement.SpecialNotes, Address = currentprojectrequirement.Address, CountryID = currentprojectrequirement.CountryID, CountryName = currentprojectrequirement.CountryName, RegionID = currentprojectrequirement.RegionID, RegionName = currentprojectrequirement.RegionName, CityID = currentprojectrequirement.CityID, CityName = currentprojectrequirement.CityName, Zipcode = currentprojectrequirement.Zipcode, DatePosted = currentprojectrequirement.DatePosted, TimeLeft = currentprojectrequirement.TimeLeft }; context.AddToArchievedCancelledProjectRequirements(acpr); } } context.SaveChanges(); //delete from current project if (currentprojectrequirement != null) context.DeleteObject(currentproject); if (currentprojectphoto.Count != 0) { foreach (var cp in currentprojectphoto) { context.DeleteObject(cp); } } if (currentprojectpicture != null) context.DeleteObject(currentprojectpicture); if (currentprojectrequirement != null) context.DeleteObject(currentprojectrequirement); t1.ReminderLevel = 4; context.SaveChanges(); ///////////////////////////////Poster no payment//////////////////////////// } } }
private static void CleanUpTables(SidejobEntities context, ICollection entityList) { if (entityList.Count <= 0) return; foreach (var item in entityList) { context.DeleteObject(item); context.SaveChanges(); } }
private void DeletePreviousBidderWin(SidejobEntities context, int projectId) { var previous = (from c in context.ClosedProjects where c.ProjectID == projectId select c.PosterID).FirstOrDefault(); if (previous != 0) { var bids = (from c in context.Bids where c.ProjectID == projectId && c.BidderID == previous orderby c.AmountOffered select c).FirstOrDefault(); if (bids != null) { int previousbidid = bids.BidID; var previouswinnerbid = from c in context.ProfessionalWinBids where c.ProID == previous && c.BidID == previousbidid select c; context.DeleteObject(bids); context.DeleteObject(previouswinnerbid); } } }
private void Updateproject(SidejobEntities context) { //Delete From ClosedProject var closedproject = (from c in context.ClosedProjects where c.ProjectID == ProjectID select c).FirstOrDefault(); if (closedproject != null) { context.DeleteObject(closedproject); } //Update Project Requirement End Date to Today var projectrequirement = (from c in context.ProjectRequirements where c.ProjectID == ProjectID select c).FirstOrDefault(); if (projectrequirement != null) { projectrequirement.EndDate = DateTime.Now.Date; projectrequirement.AmountOffered = (double)GetCurrentNewBid(ProjectID, NewProID).AmountOffered; context.SaveChanges(); } //Update HighestBid and BidderID var project = (from c in context.Projects where c.ProjectID == ProjectID select c).FirstOrDefault(); if (project != null) { project.HighestBid = GetCurrentNewBid(ProjectID, NewProID).AmountOffered; project.HighestBidderID = NewProID; project.HighestBidUsername = GetProfessional().UserName; project.StatusInt = 0; context.SaveChanges(); } }