/// <summary>
 /// Deprecated Method for adding a new object to the LockedCustomers EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToLockedCustomers(LockedCustomer lockedCustomer)
 {
     base.AddObject("LockedCustomers", lockedCustomer);
 }
    public void BlockPoster(SidejobEntities context)
    {
        if (PosterRole == "CUS")
        {
            //Add to BlockedCustomer
            var cg = (from c in context.CustomerGenerals
                      where c.CustomerID == PosterID
                      select c).FirstOrDefault();

            if (cg != null)
            {
                if (((from c in context.LockedCustomers
                      where c.CustomerID == cg.CustomerID
                      select c).FirstOrDefault()) == null)
                {
                    var lockedcustomer = new LockedCustomer
                                             {
                                                 FirstName = cg.FirstName,
                                                 LastName = cg.LastName,
                                                 Country = cg.CountryName,
                                                 Region = cg.RegionName,
                                                 Age = cg.Age,
                                                 Gender = cg.Gender,
                                                 EmailAddress = cg.EmailAddress,
                                                 Reason = "NOT Paying Project" + ProjectID,
                                                 Date = DateTime.Now.Date,
                                                 IP = 0,
                                                 CustomerID = cg.CustomerID,
                                                 ProjectID = ProjectID
                                             };
                    context.AddToLockedCustomers(lockedcustomer);
                }
            }
            context.SaveChanges();
        }
        if (PosterRole == "PRO")
        {
            //Add to BlockedProfessional
            var pg = (from c in context.ProfessionalGenerals
                      where c.ProID == PosterID
                      select c).FirstOrDefault();
            if (pg != null)
            {
                if (((from c in context.LockedProfessionals
                      where c.ProID == pg.ProID
                      select c).FirstOrDefault()) == null)
                {
                    var lockedprofessional = new LockedProfessional
                                                 {
                                                     FirstName = pg.FirstName,
                                                     LastName = pg.LastName,
                                                     Country = pg.CountryName,
                                                     Region = pg.RegionName,
                                                     Age = pg.Age,
                                                     Gender = pg.Gender,
                                                     EmailAddress = pg.EmailAddress,
                                                     Reason = "NOT Paying Project" + ProjectID,
                                                     Date = DateTime.Now.Date,
                                                     IP = 0,
                                                     ProID = pg.ProID,
                                                     ProjectID = ProjectID
                                                 };

                    context.AddToLockedProfessionals(lockedprofessional);
                }
            }

            context.SaveChanges();
        }
    }
 /// <summary>
 /// Create a new LockedCustomer object.
 /// </summary>
 /// <param name="id">Initial value of the ID property.</param>
 public static LockedCustomer CreateLockedCustomer(global::System.Int32 id)
 {
     LockedCustomer lockedCustomer = new LockedCustomer();
     lockedCustomer.ID = id;
     return lockedCustomer;
 }