protected void saveAppointment_Click(object sender, EventArgs e)
{
VetID = vetIDList.SelectedValue.ToString();
PetID = petIDList.SelectedValue.ToString();
VetApptTime = year.SelectedItem.ToString() + month.SelectedItem.ToString() + day.SelectedItem.ToString() + time.SelectedItem.ToString();
VetApptNote = note.Text;
VetApptPrice = price.Text;
VetAppointment newVetAppointment = new VetAppointment(VetID, PetID, VetApptTime, VetApptNote, VetApptPrice);
try
{
ConnectionClass.ConfirmNewAppointment(newVetAppointment);
Response.Write("<script type='text/javascript'>");
Response.Write("alert('New Appointment Saved Successfully! ');");
Response.Write("</script>");
}
catch
{
Response.Write("<script type='text/javascript'>");
Response.Write("alert('Please check required fields again. ');");
Response.Write("</script>");
}
finally
{
}
}
public static void ConfirmNewAppointment(VetAppointment newappt)
{
string jQuery = string.Format(@"INSERT INTO VET_APPOINTMENT (ID,VET_ID,PET_ID,DATE_TIME,NOTES,PRICE,DISCOUNT)
VALUES(VETAPPT_ID_SEQ.nextval,'{0}','{1}',TO_DATE('{2}','YYYYMONDDHH24:MI'),'{3}','{4}',SEARCHDISCOUNT({1}))", newappt.VetID, newappt.PetID, newappt.VetApptTime, newappt.VetApptNote, newappt.VetApptPrice);
// Convert.ToInt64
// SEARCHDISCOUNT : function
cmdString = new OracleCommand(jQuery, cntString);
try
{
cntString.Open();
cmdString.ExecuteNonQuery();
}
finally
{
cntString.Close();
}
}