//gets the current address ID that was just made from the first stored procedure so not to cause an error
private static void getCurrentAddId(RowData rd)
{
using (SqlConnection conn = new SqlConnection(DB.getConnection()))
{
SqlCommand cmd = new SqlCommand("getlastaddID", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
rd.addID = dr.GetInt32(0);
}
}
private static void updateAddress(RowData rd)
{
using (SqlConnection conn = new SqlConnection(DB.getConnection()))
{
SqlCommand cmd = new SqlCommand("InsertCustomerAddress", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@custID", rd.custID);
cmd.Parameters.AddWithValue("@addID", rd.addID);
cmd.Parameters.AddWithValue("@addressType", rd.addType);
cmd.Parameters.AddWithValue("@modifiedDate", rd.modDate);
conn.Open();
cmd.ExecuteNonQuery();
}
}
private static void insertCustomersAddress(RowData rd)
{
using (SqlConnection conn = new SqlConnection(DB.getConnection()))
{
SqlCommand cmd = new SqlCommand("InsertAddress", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@addressLine1", rd.addLine1);
cmd.Parameters.AddWithValue("@addressLine2", rd.addLine2);
cmd.Parameters.AddWithValue("@city", rd.city);
cmd.Parameters.AddWithValue("@stateProvince", rd.stateProv);
cmd.Parameters.AddWithValue("@countryRegion", rd.country);
cmd.Parameters.AddWithValue("@postalCode", rd.postalc);
cmd.Parameters.AddWithValue("@modifiedDate", rd.modDate);
conn.Open();
cmd.ExecuteNonQuery();
}
}
private static void insertCustomers(RowData rd)
{
using (SqlConnection conn = new SqlConnection(DB.getConnection()))
{
SqlCommand cmd = new SqlCommand("InsertCustomers", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Title", rd.title);
cmd.Parameters.AddWithValue("@firstName", rd.firstName);
cmd.Parameters.AddWithValue("@lastName", rd.lastName);
cmd.Parameters.AddWithValue("@middleName", rd.middleName);
cmd.Parameters.AddWithValue("@suffix", rd.suffex);
cmd.Parameters.AddWithValue("@companyName", rd.companyName);
cmd.Parameters.AddWithValue("@salesPerson", rd.salesPerson);
cmd.Parameters.AddWithValue("@emailAddress", rd.email);
cmd.Parameters.AddWithValue("@phone", rd.phone);
cmd.Parameters.AddWithValue("@PasswordHash", rd.passhash);
cmd.Parameters.AddWithValue("@PasswordSalt", rd.passSalt);
cmd.Parameters.AddWithValue("@modifydate", rd.modDate);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public static void updateRow(RowData rd)
{
updateCustomers(rd);
updateCustomersAddress(rd);
updateAddress(rd);
}