/// <summary> /// check login for a user/password, single result is authenticated /// </summary> /// <param name="userName"></param> /// <param name="password"></param> /// <returns> /// sets user's picture to specified image in the database /// </returns> public void SaveImage(Int32 userId, byte[] image) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@userId", userId)); sqlCommand.Parameters.Add(new SqlParameter("@image", image)); string sqlText = @"UPDATE [sukotto1_skypath2008].[dbo].[Teacher] SET [picture] = @image where [sukotto1_skypath2008].[dbo].[Teacher].id_User = @userId "; sqlCommand.CommandText = sqlText; SQLHelper sqlHelper = new SQLHelper(); sqlHelper.SQL_Insert(sqlCommand); }
public DataTable InsertNewAppointment(DateTime newAppointmentStart, DateTime newAppointmentEnd, int idTeacher) { DataTable dtResults = new DataTable(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Parameters.Add(new SqlParameter("@appointmentStart", newAppointmentStart)); sqlCommand.Parameters.Add(new SqlParameter("@appointmentEnd", newAppointmentEnd)); sqlCommand.Parameters.Add(new SqlParameter("@idTeacher", idTeacher)); string sqlText = @"Insert into [sukotto1_skypath2008].[dbo].[Appointment] (appointmentStart, appointmentEnd, id_Teacher) values(@appointmentStart, @appointmentEnd, @idTeacher) "; sqlCommand.CommandText = sqlText; SQLHelper sqlHelper = new SQLHelper(); sqlHelper.SQL_Insert(sqlCommand); return dtResults; }