public void updateConstraint(Constraint3 updatedConstraint, int id) { constraint.updateConstraint(id, updatedConstraint); }
public void updateConstraint(int id, Constraint3 constraint) { try { /*Step 2: Create Sql Search statement and Sql Search Object*/ string strInsert = "Update Constraints set IsHardConstraint = @IsHardConstraint ,IsCnblPaper = @IsCnblPaper, IsDoubleSeating = @IsDoubleSeating, MinExperiencedInvigilatorPerVenue = @MinExperiencedInvigilatorPerVenue, ConstraintImportanceValue = @ConstraintImportanceValue, HasOtherDutyOnSameDay = @HasOtherDutyOnSameDay, HasSpecificSessionDutyOnSameDay = @HasSpecificSessionDutyOnSameDay, HasSpecificDurationDutyOnSameDay = @HasSpecificDurationDutyOnSameDay, HasSpecificSessionAndDurationDutyOnSameDay = @HasSpecificSessionAndDurationDutyOnSameDay,HasSpecificSessionString = @HasSpecificSessionString, HasSpecificDurationInt = @HasSpecificDurationInt,DayOfWeek=@DayOfWeek, StaffIsMuslim=@StaffIsMuslim, StaffFacultyCode=@StaffFacultyCode, StaffIsInviAbove2Years=@StaffIsInviAbove2Years, StaffIsChiefInvi=@StaffIsChiefInvi, StaffIsTakingSTSPhd=@StaffIsTakingSTSPhd, StaffTypeOfEmploy=@StaffTypeOfEmploy, ExamFacultyCode=@ExamFacultyCode, ExamPaperType=@ExamPaperType, CategoryOfInvigilationDuty=@CategoryOfInvigilationDuty , DurationOfInvigilationDuty=@DurationOfInvigilationDuty , LocationOfInvigilationDuty= @LocationOfInvigilationDuty, SessionOfInvigilationDuty = @SessionOfInvigilationDuty, Remark=@Remark where ConstraintID = @id"; { cmdInsert = new SqlCommand(strInsert, conn); char?isHardConstraint = convertToChar(constraint.IsHardConstraint); char?isCnblPaper = convertToChar(constraint.IsCnblPaper); char?isDoubleSeating = convertToChar(constraint.IsDoubleSeating); char?hasOtherDutyOnSameDay = convertToChar(constraint.HasOtherDutyOnSameDay); char?hasSpecificSessionDutyOnSameDay = convertToChar(constraint.HasSpecificSessionDutyOnSameDay); char?hasSpecificDurationDutyOnSameDay = convertToChar(constraint.HasSpecificDurationDutyOnSameDay); char?hasSpecificSessionAndDurationDutyOnSameDay = convertToChar(constraint.HasSpecificSessionAndDurationDutyOnSameDay); //char? assignToExaminer = convertToChar(constraint.AssignExaminerToPaper); char?isMuslim = convertToChar(constraint.Invigilator.IsMuslim); char?isChiefInvi = convertToChar(constraint.Invigilator.IsChiefInvi); char?isTakingSTSPhd = convertToChar(constraint.Invigilator.IsTakingSTSPhD); char?isInviAbove2Years = convertToChar(constraint.Invigilator.IsInviAbove2Years); cmdInsert.Parameters.AddWithValue("@id", id); if (isHardConstraint.Equals(null)) { cmdInsert.Parameters.AddWithValue("@IsHardConstraint", DBNull.Value); } else { cmdInsert.Parameters.AddWithValue("@IsHardConstraint", isHardConstraint); } if (!isCnblPaper.Equals(null)) { cmdInsert.Parameters.AddWithValue("@IsCnblPaper", isCnblPaper); } else { cmdInsert.Parameters.AddWithValue("@IsCnblPaper", DBNull.Value); } if (!isDoubleSeating.Equals(null)) { cmdInsert.Parameters.AddWithValue("@IsDoubleSeating", isDoubleSeating); } else { cmdInsert.Parameters.AddWithValue("@IsDoubleSeating", DBNull.Value); } cmdInsert.Parameters.AddWithValue("@ConstraintImportanceValue", constraint.ConstraintImportanceValue); if (!hasOtherDutyOnSameDay.Equals(null)) { cmdInsert.Parameters.AddWithValue("@HasOtherDutyOnSameDay", hasOtherDutyOnSameDay); } else { cmdInsert.Parameters.AddWithValue("@HasOtherDutyOnSameDay", DBNull.Value); } if (!hasSpecificSessionDutyOnSameDay.Equals(null)) { cmdInsert.Parameters.AddWithValue("@HasSpecificSessionDutyOnSameDay", hasSpecificSessionDutyOnSameDay); } else { cmdInsert.Parameters.AddWithValue("@HasSpecificSessionDutyOnSameDay", DBNull.Value); } if (!hasSpecificDurationDutyOnSameDay.Equals(null)) { cmdInsert.Parameters.AddWithValue("@HasSpecificDurationDutyOnSameDay", hasSpecificDurationDutyOnSameDay); } else { cmdInsert.Parameters.AddWithValue("@HasSpecificDurationDutyOnSameDay", DBNull.Value); } if (!hasSpecificSessionAndDurationDutyOnSameDay.Equals(null)) { cmdInsert.Parameters.AddWithValue("@HasSpecificSessionAndDurationDutyOnSameDay", hasSpecificSessionAndDurationDutyOnSameDay); } else { cmdInsert.Parameters.AddWithValue("@HasSpecificSessionAndDurationDutyOnSameDay", DBNull.Value); } if (!constraint.HasSpecificSessionDutyOnSameDayString.Equals(null) && !constraint.HasSpecificSessionDutyOnSameDayString.Equals("")) { cmdInsert.Parameters.AddWithValue("@HasSpecificSessionString", constraint.HasSpecificSessionDutyOnSameDayString); } else { cmdInsert.Parameters.AddWithValue("@HasSpecificSessionString", DBNull.Value); } cmdInsert.Parameters.AddWithValue("@HasSpecificDurationInt", constraint.HasSpecificDurationDutyOnSameDayInt); if (!constraint.DayOfWeek.Equals("")) { cmdInsert.Parameters.AddWithValue("@DayOfWeek", constraint.DayOfWeek); } else { cmdInsert.Parameters.AddWithValue("@DayOfWeek", DBNull.Value); } if (!isMuslim.Equals(null)) { cmdInsert.Parameters.AddWithValue("@StaffIsMuslim", isMuslim); } else { cmdInsert.Parameters.AddWithValue("@StaffIsMuslim", DBNull.Value); } if (!isChiefInvi.Equals(null)) { cmdInsert.Parameters.AddWithValue("@StaffIsChiefInvi", isChiefInvi); } else { cmdInsert.Parameters.AddWithValue("@StaffIsChiefInvi", DBNull.Value); } if (constraint.Invigilator.FacultyCode != '\0') { cmdInsert.Parameters.AddWithValue("@StaffFacultyCode", constraint.Invigilator.FacultyCode); } else { cmdInsert.Parameters.AddWithValue("@StaffFacultyCode", DBNull.Value); } if (!isInviAbove2Years.Equals(null)) { cmdInsert.Parameters.AddWithValue("@StaffIsInviAbove2Years", isInviAbove2Years); } else { cmdInsert.Parameters.AddWithValue("@StaffIsInviAbove2Years", DBNull.Value); } if (!isTakingSTSPhd.Equals(null)) { cmdInsert.Parameters.AddWithValue("@StaffIsTakingSTSPhd", isTakingSTSPhd); } else { cmdInsert.Parameters.AddWithValue("@StaffIsTakingSTSPhd", DBNull.Value); } if (constraint.Invigilator.TypeOfEmploy != '\0') { cmdInsert.Parameters.AddWithValue("@StaffTypeOfEmploy", constraint.Invigilator.TypeOfEmploy); } else { cmdInsert.Parameters.AddWithValue("@StaffTypeOfEmploy", DBNull.Value); } if (!constraint.Examination.Faculty.FacultyCode.Equals('\0')) { cmdInsert.Parameters.AddWithValue("@ExamFacultyCode", constraint.Examination.Faculty.FacultyCode); } else { cmdInsert.Parameters.AddWithValue("@ExamFacultyCode", DBNull.Value); } cmdInsert.Parameters.AddWithValue("@MinExperiencedInvigilatorPerVenue", constraint.MinExperiencedInvigilator); if (constraint.Examination.PaperType != null && constraint.Examination.PaperType != '\0') { cmdInsert.Parameters.AddWithValue("@ExamPaperType", constraint.Examination.PaperType); } else { cmdInsert.Parameters.AddWithValue("@ExamPaperType", DBNull.Value); } if (constraint.InvigilationDuty.CategoryOfInvigilator != null && constraint.InvigilationDuty.CategoryOfInvigilator != "") { cmdInsert.Parameters.AddWithValue("@CategoryOfInvigilationDuty", constraint.InvigilationDuty.CategoryOfInvigilator); } else { cmdInsert.Parameters.AddWithValue("@CategoryOfInvigilationDuty", DBNull.Value); } cmdInsert.Parameters.AddWithValue("@DurationOfInvigilationDuty", constraint.InvigilationDuty.Duration); if (constraint.InvigilationDuty.Location != null && constraint.InvigilationDuty.Location != "") { cmdInsert.Parameters.AddWithValue("@LocationOfInvigilationDuty", constraint.InvigilationDuty.Location); } else { cmdInsert.Parameters.AddWithValue("@LocationOfInvigilationDuty", DBNull.Value); } if (constraint.InvigilationDuty.Session != null && constraint.InvigilationDuty.Session != "") { cmdInsert.Parameters.AddWithValue("@SessionOfInvigilationDuty", constraint.InvigilationDuty.Session); } else { cmdInsert.Parameters.AddWithValue("@SessionOfInvigilationDuty", DBNull.Value); } if (constraint.Remark != "" && constraint.Remark != null) { cmdInsert.Parameters.AddWithValue("@Remark", constraint.Remark); } else { cmdInsert.Parameters.AddWithValue("@Remark", DBNull.Value); } cmdInsert.ExecuteNonQuery(); } } catch (SqlException ex) { throw; } }
public void insertConstraintIntoDatabase(Constraint3 constraints) { constraint.insertConstraintIntoDatabase(constraints); }
public Constraint3 getConstraintById(int id) { Constraint3 constraint = new Constraint3(); try { /*Step 2: Create Sql Search statement and Sql Search Object*/ strSearch = "Select * from dbo.constraints where constraintid = @id"; cmdSearch = new SqlCommand(strSearch, conn); cmdSearch.Parameters.AddWithValue("@id", id); /*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()) { Constraint3 dbConstraint = new Constraint3(); dbConstraint.ConstraintID = Convert.ToInt16(dtr["constraintID"]); if (!(dtr["IsHardConstraint"]).Equals(DBNull.Value)) { dbConstraint.IsHardConstraint = convertToBool(Convert.ToChar(dtr["IsHardConstraint"])); } if (!(dtr["IsCnblPaper"]).Equals(DBNull.Value)) { dbConstraint.IsCnblPaper = convertToBool(Convert.ToChar(dtr["IsCnblPaper"])); } if (!(dtr["IsDoubleSeating"]).Equals(DBNull.Value)) { dbConstraint.IsDoubleSeating = convertToBool(Convert.ToChar(dtr["IsDoubleSeating"])); } if (!(dtr["MinExperiencedInvigilatorPerVenue"]).Equals(DBNull.Value)) { dbConstraint.MinExperiencedInvigilator = Convert.ToInt16(dtr["MinExperiencedInvigilatorPerVenue"]); } if (!(dtr["ConstraintImportanceValue"]).Equals(DBNull.Value)) { dbConstraint.ConstraintImportanceValue = Convert.ToInt16(dtr["ConstraintImportanceValue"]); } if (!(dtr["HasOtherDutyOnSameDay"]).Equals(DBNull.Value)) { dbConstraint.HasOtherDutyOnSameDay = convertToBool(Convert.ToChar(dtr["HasOtherDutyOnSameDay"])); } if (!(dtr["HasSpecificSessionDutyOnSameDay"]).Equals(DBNull.Value)) { dbConstraint.HasSpecificSessionDutyOnSameDay = convertToBool(Convert.ToChar(dtr["HasSpecificSessionDutyOnSameDay"])); } if (!(dtr["HasSpecificDurationDutyOnSameDay"]).Equals(DBNull.Value)) { dbConstraint.HasSpecificDurationDutyOnSameDay = convertToBool(Convert.ToChar(dtr["HasSpecificDurationDutyOnSameDay"])); } if (!(dtr["HasSpecificSessionAndDurationDutyOnSameDay"]).Equals(DBNull.Value)) { dbConstraint.HasSpecificSessionAndDurationDutyOnSameDay = convertToBool(Convert.ToChar(dtr["HasSpecificSessionAndDurationDutyOnSameDay"])); } if (!(dtr["HasSpecificSessionString"]).Equals(DBNull.Value)) { dbConstraint.HasSpecificSessionDutyOnSameDayString = dtr["HasSpecificSessionString"].ToString(); } if (!(dtr["HasSpecificDurationInt"]).Equals(DBNull.Value)) { dbConstraint.HasSpecificDurationDutyOnSameDayInt = Convert.ToInt16(dtr["HasSpecificDurationInt"]); } if (!(dtr["DayOfWeek"]).Equals(DBNull.Value)) { dbConstraint.DayOfWeek = dtr["DayOfWeek"].ToString(); } if (!(dtr["StaffIsMuslim"]).Equals(DBNull.Value)) { dbConstraint.Invigilator.IsMuslim = convertToBool(Convert.ToChar(dtr["StaffIsMuslim"])); } if (!(dtr["StaffFacultyCode"]).Equals(DBNull.Value)) { dbConstraint.Invigilator.FacultyCode = Convert.ToChar(dtr["StaffFacultyCode"]); } if (!(dtr["StaffIsInviAbove2Years"]).Equals(DBNull.Value)) { dbConstraint.Invigilator.IsInviAbove2Years = convertToBool(Convert.ToChar(dtr["StaffIsInviAbove2Years"])); } if (!(dtr["StaffIsChiefInvi"]).Equals(DBNull.Value)) { dbConstraint.Invigilator.IsChiefInvi = convertToBool(Convert.ToChar(dtr["StaffIsChiefInvi"])); } if (!(dtr["StaffIsTakingSTSPhd"]).Equals(DBNull.Value)) { dbConstraint.Invigilator.IsTakingSTSPhD = convertToBool(Convert.ToChar(dtr["StaffIsTakingSTSPhd"])); } if (!(dtr["StaffTypeOfEmploy"]).Equals(DBNull.Value)) { dbConstraint.Invigilator.TypeOfEmploy = Convert.ToChar(dtr["StaffTypeOfEmploy"]); } if (!(dtr["ExamFacultyCode"]).Equals(DBNull.Value)) { dbConstraint.Examination.Faculty.FacultyCode = Convert.ToChar(dtr["ExamFacultyCode"]); } if (!(dtr["ExamPaperType"]).Equals(DBNull.Value)) { dbConstraint.Examination.PaperType = Convert.ToChar(dtr["ExamPaperType"]); } if (!(dtr["CategoryOfInvigilationDuty"]).Equals(DBNull.Value)) { dbConstraint.InvigilationDuty.CategoryOfInvigilator = Convert.ToString(dtr["CategoryOfInvigilationDuty"]); } if (!(dtr["DurationOfInvigilationDuty"]).Equals(DBNull.Value)) { dbConstraint.InvigilationDuty.Duration = Convert.ToInt16(dtr["DurationOfInvigilationDuty"]); } if (!(dtr["LocationOfInvigilationDuty"]).Equals(DBNull.Value)) { dbConstraint.InvigilationDuty.Location = Convert.ToString(dtr["LocationOfInvigilationDuty"]); } if (!(dtr["SessionOfInvigilationDuty"]).Equals(DBNull.Value)) { dbConstraint.InvigilationDuty.Session = Convert.ToString(dtr["SessionOfInvigilationDuty"]); } if (!(dtr["Remark"]).Equals(DBNull.Value)) { dbConstraint.Remark = Convert.ToString(dtr["Remark"]); } constraint = dbConstraint; } dtr.Close(); } } catch (SqlException) { throw; } return(constraint); }