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