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<T> 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; }