public Constraints ReadConstraints(out List <int> IDs)
{
Constraints constraints = new Constraints();
IDs = new List <int>();
if (connect.State == ConnectionState.Open)
{
command = new SqlCommand("Select * from Constraints order by c_type", connect);
try
{
reader = command.ExecuteReader();
while (reader.Read())
{
Data.Model.Constraint constraint = new Data.Model.Constraint();
IDs.Add(Convert.ToInt32(reader[0]));
constraint.type = reader[1].ToString();
constraint.course = reader[2].ToString();
constraints.constraint.Add(constraint);
}
reader.Close();
}
catch (Exception)
{
reader.Close();
}
}
return(constraints);
}
public bool InsertConstraint(int id, Data.Model.Constraint constraint)
{
bool rez = false;
if (constraint.type == "room")
{
foreach (var item in constraint.room)
{
cmd = new SqlCommand("Insert into Constraintt(constraint_id, c_type, course_id, room_id)" + "values(@id, @type, @course, @room)", connect);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@type", SqlDbType.VarChar, 10).Value = constraint.type;
cmd.Parameters.Add("@course", SqlDbType.VarChar, 10).Value = constraint.course;
cmd.Parameters.Add("@room", SqlDbType.VarChar, 5).Value = item.@ref;
try
{
cmd.ExecuteNonQuery();
rez = true;
}
catch (Exception ex)
{
rez = false;
}
}
}
else
{
foreach (var item in constraint.timeslot)
{
cmd = new SqlCommand("Insert into Constraintt(constraint_id, c_type, course_id, timeslot_day, timeslot_period)" + "values(@id, @type, @course, @day, @period)", connect);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@type", SqlDbType.VarChar, 10).Value = constraint.type;
cmd.Parameters.Add("@course", SqlDbType.VarChar, 10).Value = constraint.course;
cmd.Parameters.Add("@day", SqlDbType.VarChar, 5).Value = item.day;
cmd.Parameters.Add("@period", SqlDbType.VarChar, 5).Value = item.period;
try
{
cmd.ExecuteNonQuery();
rez = true;
}
catch (Exception ex)
{
rez = false;
}
}
}
return(rez);
}
private bool InsertIdInConstraints(Data.Model.Constraint constraint)
{
bool rez = false;
cmd = new SqlCommand("Insert into Constraints(c_type, c_course_id)" + "values(@type, @course)", connect);
cmd.Parameters.Add("@type", SqlDbType.VarChar, 10).Value = constraint.type;
cmd.Parameters.Add("@course", SqlDbType.VarChar, 10).Value = constraint.course;
try
{
cmd.ExecuteNonQuery();
rez = true;
}
catch (Exception)
{
rez = false;
}
return(rez);
}
public int SelectIdFromConstraints(Data.Model.Constraint constraint)
{
int rez = 0;
cmd = new SqlCommand("Select id from Constraints where c_type='" + constraint.type + "' and c_course_id='" + constraint.course + "'", connect);
try
{
reader = cmd.ExecuteReader();
if (reader.Read() == true)
{
rez = Convert.ToInt32(reader[0]);
reader.Close();
}
}
catch (Exception)
{
reader.Close();
}
return(rez);
}
