Esempio n. 1
0
        public DataSet getRows(AppointmentDTO a)
        {
            c.sqlConn.Open();
            string query = "select * from Appointment where Name='" + a.Name + "' and Date='" + a.Date + "'";

            c.sqlComm = new SqlCommand(query, c.sqlConn);
            c.sqlAdap = new SqlDataAdapter(c.sqlComm);

            c.dataSet = new DataSet();
            c.sqlAdap.Fill(c.dataSet);
            c.sqlConn.Close();
            return(c.dataSet);
        }
Esempio n. 2
0
        public bool updateAppointment(AppointmentDTO a)
        {
            c.sqlConn.Open();
            string query = "update Appointment set date='" + a.Date + "', time='" + a.Time + "', name='" + a.Name + "' where appointmentID=" + a.AppointmentId;

            try
            {
                c.sqlComm = new SqlCommand(query, c.sqlConn);
                c.sqlComm.ExecuteNonQuery();
                c.sqlConn.Close();
                return(true);
            }
            catch (Exception e)
            {
                c.sqlConn.Close();
                return(false);
            }
        }
Esempio n. 3
0
        public bool getApp(AppointmentDTO a)
        {
            c.sqlConn.Open();
            string query = "update Appointment set id=" + a.Id + " where Name='" + a.Name + "' and Date='" + a.Date + "' and time='" + a.Time + "'";

            try
            {
                c.sqlComm = new SqlCommand(query, c.sqlConn);
                c.sqlComm.ExecuteNonQuery();
                c.sqlConn.Close();
                return(true);
            }
            catch (Exception e)
            {
                c.sqlConn.Close();
                return(false);
            }
        }