public void EditAppointment(string appointmentToken, string oldAppointmentDate, string newAppointmentDate, string newAppointmentTime) { EditAppointmentBO objEditAppointmentBO = new EditAppointmentBO(); objEditAppointmentBO.appointmentToken = appointmentToken; objEditAppointmentBO.oldAppointmentDate = oldAppointmentDate; objEditAppointmentBO.newAppointmentDate = newAppointmentDate; objEditAppointmentBO.newAppointmentTime = newAppointmentTime; EditAppointmentDL objEditAppointmentDL = new EditAppointmentDL(); objEditAppointmentDL.EditAppointment(objEditAppointmentBO); }
public void EditAppointment(EditAppointmentBO objEditAppointmentBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spEditAppointment", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@appointmentToken", objEditAppointmentBO.appointmentToken); cmd.Parameters.Add("@oldAppointmentDate", objEditAppointmentBO.oldAppointmentDate); cmd.Parameters.Add("@newAppointmentDate", objEditAppointmentBO.newAppointmentDate); cmd.Parameters.Add("@newAppointmentTime", objEditAppointmentBO.newAppointmentTime); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }