public ConstraintSetting readSettingFromDatabase()
{
ConstraintSetting setting = new ConstraintSetting();
/*Step 2: Create Sql Search statement and Sql Search Object*/
strSearch = "Select * from dbo.ConstraintSetting where settingID = @SettingID";
cmdSearch = new SqlCommand(strSearch, conn);
cmdSearch.Parameters.AddWithValue("@SettingID", 1);
/*Step 3: Execute command to retrieve data*/
SqlDataReader dtr = cmdSearch.ExecuteReader();
if (dtr.Read())
{
/*Step 4: Get result set from the query*/
bool AssignToExaminerBool = convertToBool(Convert.ToChar(dtr["AssignToExaminer"]));
setting.AssignToExaminer = AssignToExaminerBool;
setting.MaxEveningSession = Convert.ToInt16(dtr["MaxEveningSession"]);
setting.MaxExtraSession = Convert.ToInt16(dtr["MaxExtraSession"]);
setting.MaxReliefSession = Convert.ToInt16(dtr["MaxReliefSession"]);
setting.MaxSaturdaySession = Convert.ToInt16(dtr["MaxSaturdaySession"]);
setting.MaxConsecutiveDayDuty = Convert.ToInt16(dtr["MaxConsecutiveDayDuty"]);
setting.MaxInvigilatorAssignToOwnFaculty = Convert.ToInt16(dtr["MaxInvigilatorAssignToOwnFaculty"]);
setting.DayOfExemptionForExaminer = Convert.ToInt16(dtr["DayOfExemptionForExaminer"]);
dtr.Close();
}
return(setting);
}
protected void Button1_Click(object sender, EventArgs e)
{
MaintainConstraintSettingControl mConstraintSetting = new MaintainConstraintSettingControl();
ConstraintSetting setting = new ConstraintSetting();
setting.AssignToExaminer = true;
setting.MaxEveningSession = 2;
mConstraintSetting.saveIntoDatabase(setting);
mConstraintSetting.shutDown();
}
public void saveIntoDatabase(ConstraintSetting setting)
{
constraintSetting.saveIntoDatabase(setting);
}
// can be used for save and update setting
public void saveIntoDatabase(ConstraintSetting setting)
{
int count = 0;
try
{
/*Step 2: Create Sql Search statement and Sql Search Object*/
strSearch = "Select Count(*) from dbo.ConstraintSetting";
cmdSearch = new SqlCommand(strSearch, conn);
/*Step 3: Execute command to retrieve data*/
count = (int)cmdSearch.ExecuteScalar();
}
catch (SqlException ex)
{
throw;
}
if (count != 0)//update if already exist
{
try
{
strUpdate = "update ConstraintSetting set AssignToExaminer = @AssignToExaminer, MaxExtraSession = @MaxExtraSession, MaxSaturdaySession = @MaxSaturdaySession, MaxEveningSession = @MaxEveningSession, MaxConsecutiveDayDuty = @MaxConsecutiveDayDuty, MaxInvigilatorAssignToOwnFaculty = @MaxInvigilatorAssignToOwnFaculty, DayOfExemptionForExaminer = @DayOfExemptionForExaminer where SettingID = 1";
cmdUpdate = new SqlCommand(strUpdate, conn);
cmdUpdate.Parameters.AddWithValue("@AssignToExaminer", convertToChar(setting.AssignToExaminer));
cmdUpdate.Parameters.AddWithValue("@MaxExtraSession", setting.MaxExtraSession);
cmdUpdate.Parameters.AddWithValue("@MaxReliefSession", setting.MaxReliefSession);
cmdUpdate.Parameters.AddWithValue("@MaxSaturdaySession", setting.MaxSaturdaySession);
cmdUpdate.Parameters.AddWithValue("@MaxEveningSession", setting.MaxEveningSession);
cmdUpdate.Parameters.AddWithValue("@MaxInvigilatorAssignToOwnFaculty", setting.MaxInvigilatorAssignToOwnFaculty);
cmdUpdate.Parameters.AddWithValue("MaxConsecutiveDayDuty", setting.MaxConsecutiveDayDuty);
cmdUpdate.Parameters.AddWithValue("@DayOfExemptionForExaminer", setting.DayOfExemptionForExaminer);
cmdUpdate.ExecuteNonQuery();
}
catch (SqlException)
{
throw;
}
}
else//insert
{
try
{
/*Step 2: Create Sql Search statement and Sql Search Object*/
string strInsert = "INSERT INTO ConstraintSetting(AssignToExaminer,MaxExtraSession,MaxReliefSession,MaxSaturdaySession,MaxEveningSession,MaxInvigilatorAssignToOwnFaculty,MaxConsecutiveDayDuty,DayOfExemptionForExaminer) VALUES (@AssignToExaminer,@MaxExtraSession,@MaxReliefSession,@MaxSaturdaySession,@MaxEveningSession,@MaxInvigilatorAssignToOwnFaculty,@MaxConsecutiveDayDuty,@DayOfExemptionForExaminer)";
{
cmdInsert = new SqlCommand(strInsert, conn);
cmdInsert.Parameters.AddWithValue("@AssignToExaminer", convertToChar(setting.AssignToExaminer));
cmdInsert.Parameters.AddWithValue("@MaxExtraSession", setting.MaxExtraSession);
cmdInsert.Parameters.AddWithValue("@MaxReliefSession", setting.MaxReliefSession);
cmdInsert.Parameters.AddWithValue("@MaxSaturdaySession", setting.MaxSaturdaySession);
cmdInsert.Parameters.AddWithValue("@MaxEveningSession", setting.MaxEveningSession);
cmdUpdate.Parameters.AddWithValue("@MaxInvigilatorAssignToOwnFaculty", setting.MaxInvigilatorAssignToOwnFaculty);
cmdUpdate.Parameters.AddWithValue("@MaxConsecutiveDayDuty", setting.MaxConsecutiveDayDuty);
cmdUpdate.Parameters.AddWithValue("@DayOfExemptionForExaminer", setting.DayOfExemptionForExaminer);
cmdInsert.ExecuteNonQuery();
}
}
catch (SqlException)
{
throw;
}
}
}
