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; } } }