public static void ProfessionalContract(ProfessionalGeneral professionalposter, ProfessionalGeneral professionalbidder, ClosedProject cp) { if (professionalbidder == null) return; if (cp.HighestBid == null) return; var context = new SidejobEntities(); if (cp.CurrencyID == null) return; var professionalcontract = new ProfessionalContract { BidderID = professionalbidder.ProID, BidderFirstName = professionalbidder.FirstName, BidderLastName = professionalbidder.LastName, BidderUsername = professionalbidder.UserName, ContractDate = DateTime.Now, ProjectID = cp.ProjectID, ContractID = GetNextContractID(), CurrencyID = (int)cp.CurrencyID, HighestBid = (double)cp.HighestBid, PosterID = professionalposter.ProID, PosterUsername = professionalposter.UserName, PosterFirstName = professionalposter.FirstName, PosterLastName = professionalposter.LastName }; context.AddToProfessionalContracts(professionalcontract); }
public static void Contract(ProfessionalGeneral professionalbidder, CustomerGeneral customerposter, ClosedProject cp) { var context = new SidejobEntities(); var project = (from c in context.ProjectRequirements where c.ProjectID == cp.ProjectID select c).FirstOrDefault(); if (project != null) { var contract = new Contract { ContractID = GetNextContractID(), ProjectID = cp.ProjectID, ContractDate = DateTime.Now.Date, BidderID = customerposter.CustomerID, BidderRole = "CUS", BidderUsername = customerposter.UserName, BidderFirstName = customerposter.FirstName, BidderLastName = customerposter.LastName, BidderAddress = customerposter.Address, BidderCountryID = customerposter.CountryID, BidderCountryName = customerposter.CountryName, BidderRegionID = customerposter.RegionID, BidderRegionName = customerposter.RegionName, BidderHomePhoneNumber = customerposter.HomePhoneNumber, PosterID = professionalbidder.ProID, PosterRole = "PRO", PosterUsername = professionalbidder.UserName, PosterFirstName = professionalbidder.FirstName, PosterLastName = professionalbidder.LastName, PosterAddress = professionalbidder.Address, PosterCountryID = professionalbidder.CountryID, PosterCountryName = professionalbidder.CountryName, PosterRegionID = professionalbidder.RegionID, PosterRegionName = professionalbidder.RegionName, PosterZipcode = professionalbidder.Zipcode, LCID = project.LCID, ProjectCategoryID = project.CategoryID, ProjectCategoryName = project.CategoryName, ProjectJobID = project.JobID, ProjectExperienceID = project.ExperienceID, ProjectCrewNumberID = project.CrewNumberID, ProjectLicensedID = project.LicensedID, ProjectInsuredID = project.InsuredID, ProjectRelocationID = project.RelocationID, ProjectStartDate = project.StartDate, ProjectEndDate = project.EndDate, ProjectAddress = project.Address, ProjectCountryID = project.CountryID, ProjectCountryName = project.CountryName, ProjectRegionID = project.RegionID, ProjectRegionName = project.RegionName, }; context.AddToContracts(contract); } }
/// <summary> /// Create a new ProfessionalGeneral object. /// </summary> /// <param name="proID">Initial value of the ProID property.</param> /// <param name="firstName">Initial value of the FirstName property.</param> /// <param name="lastName">Initial value of the LastName property.</param> /// <param name="userName">Initial value of the UserName property.</param> /// <param name="address">Initial value of the Address property.</param> /// <param name="countryID">Initial value of the CountryID property.</param> /// <param name="countryName">Initial value of the CountryName property.</param> /// <param name="regionID">Initial value of the RegionID property.</param> /// <param name="regionName">Initial value of the RegionName property.</param> /// <param name="zipcode">Initial value of the Zipcode property.</param> /// <param name="age">Initial value of the Age property.</param> /// <param name="gender">Initial value of the Gender property.</param> /// <param name="emailAddress">Initial value of the EmailAddress property.</param> /// <param name="photoPath">Initial value of the PhotoPath property.</param> public static ProfessionalGeneral CreateProfessionalGeneral(global::System.Int32 proID, global::System.String firstName, global::System.String lastName, global::System.String userName, global::System.String address, global::System.Int32 countryID, global::System.String countryName, global::System.Int32 regionID, global::System.String regionName, global::System.String zipcode, global::System.Int32 age, global::System.Int32 gender, global::System.String emailAddress, global::System.String photoPath) { ProfessionalGeneral professionalGeneral = new ProfessionalGeneral(); professionalGeneral.ProID = proID; professionalGeneral.FirstName = firstName; professionalGeneral.LastName = lastName; professionalGeneral.UserName = userName; professionalGeneral.Address = address; professionalGeneral.CountryID = countryID; professionalGeneral.CountryName = countryName; professionalGeneral.RegionID = regionID; professionalGeneral.RegionName = regionName; professionalGeneral.Zipcode = zipcode; professionalGeneral.Age = age; professionalGeneral.Gender = gender; professionalGeneral.EmailAddress = emailAddress; professionalGeneral.PhotoPath = photoPath; return professionalGeneral; }
/// <summary> /// Deprecated Method for adding a new object to the ProfessionalGenerals EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToProfessionalGenerals(ProfessionalGeneral professionalGeneral) { base.AddObject("ProfessionalGenerals", professionalGeneral); }
public static void CustomerContract(CustomerGeneral customer, ProfessionalGeneral professional, ClosedProject cp) { if (customer == null) return; if (cp.HighestBid == null) return; var context = new SidejobEntities(); if (cp.CurrencyID == null) return; var customercontract = new CustomerContract { BidderID = professional.ProID, BidderFirstName = professional.FirstName, BidderLastName = professional.LastName, BidderUsername = professional.UserName, ContractDate = DateTime.UtcNow, ProjectID = cp.ProjectID, ContractID = GetNextContractID(), CurrencyID = (int)cp.CurrencyID, CustomerID = customer.CustomerID, HighestBid = (double)cp.HighestBid, PosterID = customer.CustomerID, PosterUsername = customer.UserName, PosterFirstName = customer.FirstName, PosterLastName = customer.LastName }; context.AddToCustomerContracts(customercontract); context.SaveChanges(); }