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(); }