/// <summary>
 /// This method insert a supplier and return the supplier id
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 public int InsertRetrievingID(Supplier entity)
 {
     //   
     DbContext.Suppliers.InsertOnSubmit(entity);
     DbContext.SubmitChanges();
     return entity.SupplierId;
 }
 /// <summary>
 /// This method updates a record in the table.
 /// Change this method to alter how records are updated.
 /// </summary>
 /// <param name=original_entity>original_entity</param>
 /// <param name=entity>entity</param>
 public void Update(Supplier original_entity, Supplier entity)
 {
     original_entity.CopyPropertiesFrom(entity);
     original_entity.ModifiedDate = DateTime.Now;
     DbContext.SubmitChanges();
 }
 public void Add(Supplier supplier)
 {
     this.supplier = supplier;
 }