public Event SearchEvent(int evID)
{
Event ev = new Event();
ev.IdEvent = evID;
string searchString = "SELECT * FROM EVENTS where id = " + ev.IdEvent;
using (conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand command = new SqlCommand(searchString, conn);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ev.Period = reader.GetString(reader.GetOrdinal("Period"));
ev.Remarks = reader.GetString(reader.GetOrdinal("Remarks"));
ev.Task = reader.GetString(reader.GetOrdinal("Task"));
ev.Department = reader.GetString(reader.GetOrdinal("Departament"));
ev.Event_Type_ID = reader.GetInt32(reader.GetOrdinal("event_Types_ID"));
}
}
conn.Close();
}
return ev;
}
public void InsertEvent(Event ev)
{
string insertString = @"INSERT INTO Events(
Period,
Department,Task,
Remarks,event_Type_ID)
values(
@period,@departament,
@task,@remarks,@event_Type_ID
)";
using (conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand command = new SqlCommand(insertString, conn);
command.Parameters.Add("@period", ev.Period);
command.Parameters.Add("@departament", ev.Department);
command.Parameters.Add("@task", ev.Task);
command.Parameters.Add("@remarks", ev.Remarks);
command.Parameters.Add("@event_Type_ID", ev.Event_Type_ID);
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
conn.Close();
}
}
public List()
{
InitializeComponent();
CreateDataTable();
CreateEventTable();
stud = new Student();
event1 = new Event();
studComm = new StudentCommands(Properties.Settings.Default.connection);
}
public EditEvent(Event event1)
{
InitializeComponent();
this.event1 = event1;
eventComm = new EventCommands(Properties.Settings.Default.connection);
PeriodTextEdit.Text = event1.Period;
DepartmentTextEdit.Text = event1.Department;
TaskTextEdit.Text = event1.Task;
RemarksTextEdit.Text = event1.Remarks;
EventTypeTextEdit.Text = (event1.Event_Type_ID).ToString();
}
public void DeleteEvent(Event ev)
{
string deleteString = "DELETE FROM EVENTS WHERE id = '" + ev.IdEvent + "'";
using (conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand command = new SqlCommand(deleteString, conn);
command.ExecuteNonQuery();
conn.Close();
}
}
public void UpdateEvent(Event ev)
{
string updateString = @"UPDATE EVENTS
SET
Period=@period,
Department=@departament,
Task=@task,
Remarks=@remarks ,
event_Type_ID = @event_Type_ID
WHERE id = '" + ev.IdEvent + "'";
using (conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand command = new SqlCommand(updateString, conn);
command.Parameters.Add("@period", ev.Period);
command.Parameters.Add("@departament", ev.Department);
command.Parameters.Add("@task", ev.Task);
command.Parameters.Add("@remarks", ev.Remarks);
command.Parameters.Add("@event_Type_ID", ev.Event_Type_ID);
command.ExecuteNonQuery();
conn.Close();
}
}
