/// <summary>
/// Add new customer
/// </summary>
/// <param name="username">Customer username</param>
/// <param name="password">Customer password</param>
/// <param name="firstName">First name of customer</param>
/// <param name="lastName">Last name of customer</param>
/// <param name="address">Home address of customer</param>
/// <param name="city">Home city of customer</param>
/// <param name="state">Home state of customer</param>
/// <param name="email">Email of customer</param>
/// <param name="dob">Customer date of birth</param>
/// <returns></returns>
public static customer add(string username, string password, string firstName, string lastName, string address, string city, string state, string email, DateTime dob, int zip) //Add DOB To Database and retrieve it
{
customer newCust = new customer();
if (newCust.addUser(username, password))
{
string[] newTXT = commaSwitch(firstName, lastName, address, city, email);
firstName = newTXT[0];
lastName = newTXT[1];
address = newTXT[2];
city = newTXT[3];
email = newTXT[4];
SqlCommand newCommand = new SqlCommand("INSERT INTO Customer (Id, FirstName, LastName, StreetAddress, City, State, Email, EmailAuthenticated, DOB, Zip, NumSeen) VALUES (" + newCust.id + ", '" + firstName + "', '" + lastName + "', '" + address + "', '" + city + "', '" + state + "', '" + email + "', 0, @value, " + zip + ", 0)", newCust.dbConnect);
newCommand.Parameters.AddWithValue("@value", dob.Date);
lock (theLock)
{
newCust.dbConnect.Open();
newCommand.ExecuteNonQuery();
newCust.dbConnect.Close();
}
newCust.retrieve();
return(newCust);
}
else
{
return(null);
}
}
