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