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();
 }
示例#3
0
    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);
    }
示例#4
0
    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();
    }