/**
* method btnDoAddContact_Click
* insert a new Contact when clicked
* On success redirect to home page
*/
protected void btnDoAddContact_Click(object sender, EventArgs e)
{
MomentumTest.lib.Contact co = new MomentumTest.lib.Contact();
int res = co.insertContact(int.Parse(Request.QueryString["customerid"].ToString()), DateTime.Parse(txtAddContactDateTime.Text), txtAddContactNotes.Text);
if (res == 0)
{
//error
lblError.Text = co.errorMessage;
lblError.Visible = true;
}
else
{
Response.Redirect("Default.aspx");
}
}
/**
* method insertCustomer
* insert a new Customer into the database
* and return the (newly created) id of that Customer
* as well as populate its properties
* returns 0 on error
*
* NOTE Every newly created Customer get a new Contact
* record with the DateTime of now and a note of "Created"
*/
public int insertCustomer(string pFirstName, string pLastName, string pPhoneNumber, string pEmail)
{
SqlServer sqlsvr = new SqlServer();
string sql;
try
{
SqlCommand comm = new SqlCommand();
sql = "INSERT INTO Customer ";
sql += "(FirstName, LastName, PhoneNumber, Email) ";
sql += "VALUES ";
sql += "(@FirstName, @LastName, @PhoneNumber, @Email)";
sql += ";SELECT @@IDENTITY AS new_id FROM Customer";
comm.CommandText = sql;
comm.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar,70));
comm.Parameters["@FirstName"].Value = pFirstName;
comm.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 70));
comm.Parameters["@LastName"].Value = pLastName;
comm.Parameters.Add(new SqlParameter("@PhoneNumber", SqlDbType.VarChar, 50));
comm.Parameters["@PhoneNumber"].Value = pPhoneNumber;
comm.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 50));
comm.Parameters["@Email"].Value = pEmail;
DataSet ds = sqlsvr.runCommandReturnDataSet(comm);
if (ds == null)
{
errorMessage = "Sql Server error in Customer.insertCustomer:" + sqlsvr.errorMessage;
return 0;
}
id = int.Parse(ds.Tables[0].Rows[0]["new_id"].ToString());
firstName = pFirstName;
lastName = pLastName;
phoneNumber = pPhoneNumber;
email = pEmail;
DateTime now = DateTime.Now;
Contact co = new Contact();
int res = co.insertContact(id, now, "Created");
if (res == 0)
{
errorMessage = "Customer.insertCustomer error creating initial Contact:" + co.errorMessage;
return 0;
}
lastContact = now;
return id;
}
catch (Exception ex)
{
errorMessage = "Exception in Customer.insertCustomer:" + ex.Message + ex.StackTrace;
return 0;
}
}
