protected void btnSave_Click(object sender, EventArgs e)
{
if (hidPrimaryKey.Value == string.Empty)
{
if (ValidateData(out strValidationFailedItem, HBS_Utility.CRUDOperation.Insert))
{
string[] proceduresArr = Convert.ToString(hidSelectedProcedure.Value).Split(',');
BO_Appointment[] boAppointmentArr = new BO_Appointment[proceduresArr.Length];
for (int i = 0; i < proceduresArr.Length; i++)
{
boAppointmentArr[i] = new BO_Appointment();
boAppointmentArr[i].Patientid = Convert.ToInt64(hidSelectedPatient.Value);
boAppointmentArr[i].Doctorid = Convert.ToInt64(hidSelectedDoctor.Value);
boAppointmentArr[i].Procedureid = Convert.ToInt64(proceduresArr[i].ToString());
boAppointmentArr[i].Appointmentdate = DateTime.ParseExact(txtAppointmentDate.Text.ToString(), "dd-MM-yyyy", CultureInfo.InvariantCulture);
boAppointmentArr[i].Appointmenttime = txtAppointmentTime.Text;
boAppointmentArr[i].Datecreated = System.DateTime.Now;
boAppointmentArr[i].Createdby = boAppointment.SKEY;
boAppointmentArr[i].Paid = "N";
}
int appointmentId = daAppointment.InsertAppointment(boAppointmentArr);
if (appointmentId > 0)
{
showMessage(HBS_Utility.ReturnMessage.Success, HBS_Utility.ReturnMessage.InsertSuccess, HBS_Utility.ReturnCode.Success);
}
}
}
else
{
if (ValidateData(out strValidationFailedItem, HBS_Utility.CRUDOperation.Update))
{
string[] proceduresArr = Convert.ToString(hidSelectedProcedure.Value).Split(',');
BO_Appointment[] boAppointmentArr = new BO_Appointment[proceduresArr.Length];
for (int i = 0; i < proceduresArr.Length; i++)
{
boAppointmentArr[i] = new BO_Appointment();
boAppointmentArr[i].Appointmentid = Convert.ToInt64(hidPrimaryKey.Value);
boAppointmentArr[i].Patientid = Convert.ToInt64(hidSelectedPatient.Value);
boAppointmentArr[i].Doctorid = Convert.ToInt64(hidSelectedDoctor.Value);
boAppointmentArr[i].Procedureid = Convert.ToInt64(proceduresArr[i].ToString());
boAppointmentArr[i].Appointmentdate = DateTime.ParseExact(txtAppointmentDate.Text.ToString(), "dd-MM-yyyy", CultureInfo.InvariantCulture);
boAppointmentArr[i].Appointmenttime = txtAppointmentTime.Text;
boAppointmentArr[i].Datemodified = System.DateTime.Now;
boAppointmentArr[i].Modifiedby = boAppointment.SKEY;
boAppointmentArr[i].Paid = "N";
}
int appointmentId = daAppointment.UpdateAppointment(boAppointmentArr);
if (appointmentId > 0)
{
showMessage(HBS_Utility.ReturnMessage.Success, HBS_Utility.ReturnMessage.UpdateSuccess, HBS_Utility.ReturnCode.Success);
}
}
}
}
public void DeleteAppointment(BO_Appointment DataObjectAppointment)
{
#region APPOINTMENT_DETAILS
boAppointmentDetails = new BO_AppointmentDetails();
boAppointmentDetails.Appointmentid = DataObjectAppointment.Appointmentid;
daAppointmentDetails.DeleteAppointmentDetails(boAppointmentDetails);
#endregion
string query = "delete from appointment where appointment_id=@appointment_id";
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add("@appointment_id", SqlDbType.Int, 20, "appointment_id");
cmd.Parameters["@appointment_id"].Value = DataObjectAppointment.Appointmentid;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
