protected void SubmitButton_Click(object sender, EventArgs e)
        {
            Supplier supplier = new Supplier();
            supplier.SupplierCode = SupplierCodeTextBox.Text;
            supplier.CompanyName = NameTextBox.Text;
            supplier.TenderedYear = TenderYearCalender.SelectedDate;
            supplier.PreferredRank = Convert.ToInt32(RankingDDL.SelectedValue);

            CatalogManager manager = new CatalogManager();

            try
            {
                manager.CreateSupplier(supplier);
                SupplierGridView.DataBind();
            }
            catch (Exception)
            {
                ErrorLabel.Text = "Create Supplier Failed";
            }
        }
        public Supplier UpdateSupplier(Supplier supplier)
        {
            try
            {
                Supplier tempSupplier = (from r in context.Suppliers
                                         where r.SupplierID == supplier.SupplierID
                                         select r).First<Supplier>();

                tempSupplier.SupplierCode = supplier.SupplierCode;
                tempSupplier.CompanyName = supplier.CompanyName;
                tempSupplier.TenderedYear = supplier.TenderedYear;
                tempSupplier.PreferredRank = supplier.PreferredRank;

                using (TransactionScope ts = new TransactionScope())
                {

                    context.SaveChanges();
                    ts.Complete();
                    return tempSupplier;
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
        public void DeleteSupplier(Supplier supplier)
        {
            try
            {
                Supplier persistedSupplier = (from r in context.Suppliers
                                              where r.SupplierID == supplier.SupplierID
                                              select r).First<Supplier>();

                using (TransactionScope ts = new TransactionScope())
                {
                    context.Suppliers.DeleteObject(persistedSupplier);
                    context.SaveChanges();
                    ts.Complete();
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
 public Supplier CreateSupplier(Supplier supplier)
 {
     try
     {
         using (TransactionScope ts = new TransactionScope())
         {
             context.Suppliers.AddObject(supplier);
             context.SaveChanges();
             ts.Complete();
             return supplier;
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
 /// <summary>
 /// Create a new Supplier object.
 /// </summary>
 /// <param name="supplierID">Initial value of the SupplierID property.</param>
 /// <param name="supplierCode">Initial value of the SupplierCode property.</param>
 /// <param name="companyName">Initial value of the CompanyName property.</param>
 /// <param name="tenderedYear">Initial value of the TenderedYear property.</param>
 /// <param name="preferredRank">Initial value of the PreferredRank property.</param>
 public static Supplier CreateSupplier(global::System.Int32 supplierID, global::System.String supplierCode, global::System.String companyName, global::System.DateTime tenderedYear, global::System.Int32 preferredRank)
 {
     Supplier supplier = new Supplier();
     supplier.SupplierID = supplierID;
     supplier.SupplierCode = supplierCode;
     supplier.CompanyName = companyName;
     supplier.TenderedYear = tenderedYear;
     supplier.PreferredRank = preferredRank;
     return supplier;
 }
 /// <summary>
 /// Deprecated Method for adding a new object to the Suppliers EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToSuppliers(Supplier supplier)
 {
     base.AddObject("Suppliers", supplier);
 }
 public Supplier UpdateSupplier(Supplier supplier)
 {
     try
     {
         if (supplier != null)
         {
             catalogDAO.UpdateSupplier(supplier);
         }
     }
     catch (Exception)
     {
         throw new Exceptions.UserException("Update Supplier failed.");
     }
     return supplier;
 }
 public void DeleteSupplier(Supplier supplier)
 {
     try
     {
         if (supplier != null)
         {
             catalogDAO.DeleteSupplier(supplier);
         }
     }
     catch (Exception)
     {
         //throw new Exceptions.UserException("Catalog supplier deletion failed.");
     }
 }
 public Supplier CreateSupplier(Supplier supplier)
 {
     try
     {
         if (supplier != null)
         {
             catalogDAO.CreateSupplier(supplier);
         }
     }
     catch (Exception)
     {
         throw new Exceptions.UserException("Catalog supplier creation failed.");
     }
     return supplier;
 }