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