private void btnOk_Click(object sender, RoutedEventArgs e) { try { Shipper shipper = new Shipper(); int nextIden = ShipperBLL.GetCurrentIden() + 1; shipper.ShipperID = nextIden; shipper.Name = txtName.Text; int PlaceID = ((District)cbbPlace.SelectedItem).DistrictID; shipper.PlaceID = PlaceID; shipper.Phone = txtPhone.Text; ShipperBLL.AddShipper(shipper); System.Windows.Forms.MessageBox.Show("Successfully"); if (AddFinished != null) { AddFinished(shipper); } } catch (Exception g) { System.Windows.Forms.MessageBox.Show("Error: " + g.Message); } finally { this.Close(); } }
public static bool AddShipperName(Shipper shipper) { string sql = "spAddShipper"; SqlParameter Name = new SqlParameter("Name", shipper.Name); SqlParameter PlaceID = new SqlParameter("PlaceID", shipper.PlaceID); SqlParameter Phone = new SqlParameter("Phone", shipper.Phone); return DataProvider.ExecuteNonQuery(sql, System.Data.CommandType.StoredProcedure,Name,PlaceID,Phone); }
public static List<Shipper> SelectAllShipper() { List<Shipper> list = new List<Shipper>(); string sql = "spSelectAllShipper"; SqlDataReader rd= DataProvider.ExecuteQueryWithDataReader(sql, System.Data.CommandType.StoredProcedure); DataTable dt = new DataTable(); if (rd.HasRows) { while (rd.Read()) { Shipper a = new Shipper(); a.ShipperID = rd.GetInt32(0); a.Name = rd.GetString(1); a.PlaceID = rd.GetInt32(2); a.Phone = rd.GetString(3); list.Add(a); } } return list; }
public static bool AddShipper(Shipper shipper) { return ShipperData.AddShipperName(shipper); }
public void UpdateTable(Shipper shipper) { dt.Rows.Add(shipper.ShipperID, shipper.Name, shipper.PlaceID, shipper.Phone, true); }