protected void btnAdd_Click(object sender, EventArgs e)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@au_fname", txtfName.Text),
new SqlParameter("@au_lname", txtLName.Text),
new SqlParameter("@phone", txtPhone.Text),
new SqlParameter("@address", txtAddress.Text),
new SqlParameter("@city", txtCity.Text),
new SqlParameter("@state", txtState.Text),
new SqlParameter("@zip", txtZip.Text)
};
DataAccessSQL daSQL = new DataAccessSQL();
bool retVal = daSQL.ExecuteNonQuery("AddNewAuthor", CommandType.StoredProcedure, parameter);
if (retVal == true)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('Save Successful!');</script>");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('Save Failed!');</script>");
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string insertCommand = "insert into titles values(@title, @type, @pubid, @price, @advance, @royalty , @ytd, @notes, GetDate())";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@title", txtTitle.Text),
new SqlParameter("@type", txtType.Text),
new SqlParameter("@pubid", ddlPublisher.SelectedValue.ToString()),
new SqlParameter("@price", txtPrice.Text),
new SqlParameter("@advance", txtAdvance.Text),
new SqlParameter("@royalty", txtRoyalty.Text),
new SqlParameter("@ytd", txtYtd.Text),
new SqlParameter("@notes", txtNotes.Text)
};
bool insertAuthor = daSQL.ExecuteNonQuery(insertCommand, CommandType.Text, param);
if (insertAuthor == true)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('Save Successful!'); window.location : 'Title.aspx'; </script>");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('Save Failed!');</script>");
}
}
