public List <InvigilationDuty> searchInvigilationDuty2(int staffID)
{
List <InvigilationDuty> invDutyList = new List <InvigilationDuty>();
try
{
/*Step 2: Create Sql Search statement and Sql Search Object*/
strSearch = "Select TimeslotID, VenueID, Location, CatOfInvi, Duration from dbo.InvigilationDuty where StaffID = @StaffID";
cmdSearch = new SqlCommand(strSearch, conn);
cmdSearch.Parameters.AddWithValue("@StaffID", staffID.ToString());
/*Step 3: Execute command to retrieve data*/
SqlDataReader dtr = cmdSearch.ExecuteReader();
/*Step 4: Get result set from the query*/
if (dtr.HasRows)
{
while (dtr.Read())
{
InvigilationDuty invDuty = new InvigilationDuty(dtr["TimeslotID"].ToString(), dtr["VenueID"].ToString(), dtr["Location"].ToString(), staffID.ToString(), dtr["CatOfInvi"].ToString(), Int32.Parse(dtr["Duration"].ToString()));
invDutyList.Add(invDuty);
}
dtr.Close();
}
}
catch (SqlException)
{
throw;
}
return(invDutyList);
}
public Constraint3(InvigilationDuty invigilationDuty, Staff invigilator, Examination examination, bool?isHardConstraint, bool?isCnblPaper, bool?isDoubleSeating)
{
this.invigilationDuty = invigilationDuty;
this.invigilator = invigilator;
this.examination = examination;
this.isHardConstraint = isHardConstraint;
this.isCnblPaper = isCnblPaper;
this.isDoubleSeating = isDoubleSeating;
}
public int addInvigilationDuty(Staff staff, InvigilationDuty invigilationDuty)
{
int n = 0;
try
{
/*Step 2: Create Sql Insert statement and Sql Insert Object*/
strInsert = "Insert Into InvigilationDuty (TimeslotID, VenueID, Location, StaffID, CatOfInvi, Duration) Values (@TimeslotID, @VenueID, @Location, @StaffID, @CategoryOfInvigilator, @Duration)";
cmdInsert = new SqlCommand(strInsert, conn);
cmdInsert.Parameters.AddWithValue("@TimeslotID", invigilationDuty.Session + invigilationDuty.Date.Date.ToString("ddMMyy"));
if (invigilationDuty.VenueID.Equals(""))
{
cmdInsert.Parameters.AddWithValue("@VenueID", DBNull.Value);
}
else
{
cmdInsert.Parameters.AddWithValue("@VenueID", invigilationDuty.VenueID);
}
if (invigilationDuty.Location.Equals("") && invigilationDuty.CategoryOfInvigilator.Equals("Relief"))
{
cmdInsert.Parameters.AddWithValue("@Location", "West Campus");
}
else
{
cmdInsert.Parameters.AddWithValue("@Location", invigilationDuty.Location);
}
cmdInsert.Parameters.AddWithValue("@StaffID", staff.StaffID);
cmdInsert.Parameters.AddWithValue("@CategoryOfInvigilator", invigilationDuty.CategoryOfInvigilator);
cmdInsert.Parameters.AddWithValue("@Duration", invigilationDuty.Duration);
/*Step 3: Execute command to insert*/
n = cmdInsert.ExecuteNonQuery();
if (invigilationDuty.Date.DayOfWeek == DayOfWeek.Saturday)
{
updateNoOfSatSession(staff.StaffID);
}
}
catch (SqlException)
{
throw;
}
return(n);
}
public List <InvigilationDuty> searchInvigilationDuty(string staffID)
{
List <InvigilationDuty> invigilationDutiesList = new List <InvigilationDuty>();
try
{
/*Step 2: Create Sql Search statement and Sql Search Object*/
strSearch = "Select T.Date, T.Session, I.VenueID, I.Location, I.Duration, I.CatOfInvi From dbo.Timeslot T, dbo.InvigilationDuty I Where I.StaffID = @StaffID And I.TimeSlotID = T.TimeSlotID";
cmdSearch = new SqlCommand(strSearch, conn);
cmdSearch.Parameters.AddWithValue("@StaffID", staffID);
/*Step 3: Execute command to retrieve data*/
SqlDataReader dtr = cmdSearch.ExecuteReader();
/*Step 4: Get result set from the query*/
if (dtr.HasRows)
{
while (dtr.Read())
{
string categoryOfInvigilator = dtr["CatOfInvi"].ToString();
string venueID = "";
if (categoryOfInvigilator.Equals("Chief"))
{
venueID = "";
}
else
{
venueID = dtr["VenueID"].ToString();
}
InvigilationDuty invigilationDuty = new InvigilationDuty(DateTime.Parse(dtr["Date"].ToString()), dtr["Session"].ToString(), venueID, dtr["Location"].ToString(), dtr["CatOfInvi"].ToString(), int.Parse(dtr["Duration"].ToString()));
invigilationDutiesList.Add(invigilationDuty);
}
}
dtr.Close();
}
catch (SqlException)
{
throw;
}
return(invigilationDutiesList);
}
public Constraint3()
{
this.invigilationDuty = new InvigilationDuty();
this.invigilator = new Staff();
this.examination = new Examination();
this.isHardConstraint = false;
this.isCnblPaper = null;
this.IsDoubleSeating = null;
this.hasOtherDutyOnSameDay = null;
this.hasSpecificDurationDutyOnSameDay = null;
this.hasSpecificDurationDutyOnSameDayInt = 0;
this.hasSpecificSessionDutyOnSameDay = null;
this.hasSpecificSessionDutyOnSameDayString = "";
this.dayOfWeek = "";
this.constraintImportanceValue = 1;
this.assignExaminerToPaper = null;
this.minExperiencedInvigilator = 0;
this.hasSpecificSessionAndDurationDutyOnSameDay = null;
this.percentageOfInvigilatorAssignedToTheirOwnFacultyDuty = 0;
this.remark = "";
}
public int addInvigilationDuty(Staff staff, InvigilationDuty invigilationDuty)
{
return(invigilationDutyDA.addInvigilationDuty(staff, invigilationDuty));
}