public void UpdateCustomer(Customer customer) { SqlCommand cmd = new SqlCommand("sp_UpdateCustomer"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@SSN", customer.SSN)); cmd.Parameters.Add(new SqlParameter("@FirstName", customer.FirstName)); cmd.Parameters.Add(new SqlParameter("@LastName", customer.LastName)); cmd.Parameters.Add(new SqlParameter("@MiddleInitial", customer.MiddleInitial)); cmd.Parameters.Add(new SqlParameter("@PhoneNumber", customer.PhoneNumber)); cmd.Parameters.Add(new SqlParameter("@DateofBirth", customer.DOB)); cmd.Parameters.Add(new SqlParameter("@Street", customer.Address)); cmd.Parameters.Add(new SqlParameter("@City", customer.Town)); cmd.Parameters.Add(new SqlParameter("@State", customer.State)); cmd.Parameters.Add(new SqlParameter("@ZipCode", customer.ZipCode)); cmd.Parameters.Add(new SqlParameter("@County", customer.County)); cmd.Parameters.Add(new SqlParameter("@CustomerNotes", customer.Notes)); cmd.Parameters.Add(new SqlParameter("@SpousefName", customer.SpouseFirst)); cmd.Parameters.Add(new SqlParameter("@SpouselName", customer.SpouseLast)); cmd.Parameters.Add(new SqlParameter("@PrimaryKey", customer.ID)); ExecuteNonQuery(cmd); }
public string AddCustomer(Customer customer) { SqlCommand cmd = new SqlCommand("sp_AddCustomer"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@SSN", customer.SSN)); cmd.Parameters.Add(new SqlParameter("@FirstName", customer.FirstName)); cmd.Parameters.Add(new SqlParameter("@LastName", customer.LastName)); cmd.Parameters.Add(new SqlParameter("@MiddleInitial", customer.MiddleInitial)); cmd.Parameters.Add(new SqlParameter("@PhoneNumber", customer.PhoneNumber)); cmd.Parameters.Add(new SqlParameter("@DateofBirth", customer.DOB)); cmd.Parameters.Add(new SqlParameter("@Street", customer.Address)); cmd.Parameters.Add(new SqlParameter("@City", customer.Town)); cmd.Parameters.Add(new SqlParameter("@State", customer.State)); cmd.Parameters.Add(new SqlParameter("@ZipCode", customer.ZipCode)); cmd.Parameters.Add(new SqlParameter("@County", customer.County)); cmd.Parameters.Add(new SqlParameter("@CustomerNotes", customer.Notes)); cmd.Parameters.Add(new SqlParameter("@SpousefName", customer.SpouseFirst)); cmd.Parameters.Add(new SqlParameter("@SpouselName", customer.SpouseLast)); SqlParameter param = new SqlParameter("@CustomerKey", SqlDbType.Int); param.Direction = ParameterDirection.Output; cmd.Parameters.Add(param); String Temp = ExecuteNonQuery(cmd); AppData.Instance.customer.CustomerID = Convert.ToInt32(cmd.Parameters["@CustomerKey"].Value); return Temp; }