///<summary>Inserts one SchoolCourse into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(SchoolCourse schoolCourse, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO schoolcourse (";
if (!useExistingPK && isRandomKeys)
{
schoolCourse.SchoolCourseNum = ReplicationServers.GetKeyNoCache("schoolcourse", "SchoolCourseNum");
}
if (isRandomKeys || useExistingPK)
{
command += "SchoolCourseNum,";
}
command += "CourseID,Descript) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(schoolCourse.SchoolCourseNum) + ",";
}
command +=
"'" + POut.String(schoolCourse.CourseID) + "',"
+ "'" + POut.String(schoolCourse.Descript) + "')";
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command);
}
else
{
schoolCourse.SchoolCourseNum = Db.NonQ(command, true, "SchoolCourseNum", "schoolCourse");
}
return(schoolCourse.SchoolCourseNum);
}
///<summary>Inserts one SchoolCourse into the database. Provides option to use the existing priKey.</summary>
public static long Insert(SchoolCourse schoolCourse, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
schoolCourse.SchoolCourseNum = ReplicationServers.GetKey("schoolcourse", "SchoolCourseNum");
}
string command = "INSERT INTO schoolcourse (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "SchoolCourseNum,";
}
command += "CourseID,Descript) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(schoolCourse.SchoolCourseNum) + ",";
}
command +=
"'" + POut.String(schoolCourse.CourseID) + "',"
+ "'" + POut.String(schoolCourse.Descript) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
schoolCourse.SchoolCourseNum = Db.NonQ(command, true, "SchoolCourseNum", "schoolCourse");
}
return(schoolCourse.SchoolCourseNum);
}
///<summary>Updates one SchoolCourse in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables. Returns true if an update occurred.</summary>
public static bool Update(SchoolCourse schoolCourse, SchoolCourse oldSchoolCourse)
{
string command = "";
if (schoolCourse.CourseID != oldSchoolCourse.CourseID)
{
if (command != "")
{
command += ",";
}
command += "CourseID = '" + POut.String(schoolCourse.CourseID) + "'";
}
if (schoolCourse.Descript != oldSchoolCourse.Descript)
{
if (command != "")
{
command += ",";
}
command += "Descript = '" + POut.String(schoolCourse.Descript) + "'";
}
if (command == "")
{
return(false);
}
command = "UPDATE schoolcourse SET " + command
+ " WHERE SchoolCourseNum = " + POut.Long(schoolCourse.SchoolCourseNum);
Db.NonQ(command);
return(true);
}
///<summary>Updates one SchoolCourse in the database.</summary>
public static void Update(SchoolCourse schoolCourse){
string command="UPDATE schoolcourse SET "
+"CourseID = '"+POut.String(schoolCourse.CourseID)+"', "
+"Descript = '"+POut.String(schoolCourse.Descript)+"' "
+"WHERE SchoolCourseNum = "+POut.Long(schoolCourse.SchoolCourseNum);
Db.NonQ(command);
}
///<summary>Inserts one SchoolCourse into the database. Returns the new priKey.</summary>
public static long Insert(SchoolCourse schoolCourse)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
schoolCourse.SchoolCourseNum = DbHelper.GetNextOracleKey("schoolcourse", "SchoolCourseNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(schoolCourse, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
schoolCourse.SchoolCourseNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(schoolCourse, false));
}
}
///<summary></summary>
private static void Insert(SchoolCourse sc)
{
if (PrefB.RandomKeys)
{
sc.SchoolCourseNum = MiscData.GetKey("schoolcourse", "SchoolCourseNum");
}
string command = "INSERT INTO schoolcourse (";
if (PrefB.RandomKeys)
{
command += "SchoolCourseNum,";
}
command += "CourseID,Descript) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(sc.SchoolCourseNum) + "', ";
}
command +=
"'" + POut.PString(sc.CourseID) + "', "
+ "'" + POut.PString(sc.Descript) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
sc.SchoolCourseNum = General.NonQ(command, true);
}
}
///<summary>Inserts one SchoolCourse into the database. Returns the new priKey.</summary>
internal static long Insert(SchoolCourse schoolCourse)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
schoolCourse.SchoolCourseNum=DbHelper.GetNextOracleKey("schoolcourse","SchoolCourseNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(schoolCourse,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
schoolCourse.SchoolCourseNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(schoolCourse,false);
}
}
private void FilterAssignments(string course)
{
SchoolCourse currentcourse = currentCoursesJson.First(item => item.Name.Equals(course));
List <Assignment> classRelated = FilterClasses.FilteAssignments(currentcourse, currentAssignmentsJson);
List <Assignment> particpation = FilterClasses.FilterParticaption(classRelated);
List <Assignment> classRelatedFilter = new List <Assignment>();
GradeViewModel classGrade = new GradeViewModel();
foreach (Assignment task in classRelated)
{
if (!particpation.Contains(task))
{
classRelatedFilter.Add(task);
}
}
foreach (GradeViewModel grade in currentGrades)
{
if (grade.ID == currentcourse.Id)
{
classGrade = grade;
}
}
UpdateListViews(classRelatedFilter, particpation, classGrade);
}
public async Task <IActionResult> Edit(string id, [Bind("Id,Name")] SchoolCourse schoolCourse)
{
if (id != schoolCourse.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(schoolCourse);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SchoolCourseExists(schoolCourse.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(schoolCourse));
}
private void FilterForListBox(string course)
{
SchoolCourse currentcourse = classes.First(item => item.Name.Equals(course));
List <Assignment> classRelated = FilterClasses.FilteAssignments(currentcourse, totalAssignments);
List <Assignment> particpation = FilterClasses.FilterParticaption(classRelated);
UpdateListBoxes(classRelated, particpation);
}
///<summary></summary>
public FormSchoolCourseEdit(SchoolCourse courseCur)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
CourseCur = courseCur.Copy();
Lan.F(this);
}
///<summary></summary>
public static void Delete(SchoolCourse sc)
{
//todo: check for dependencies
string command = "DELETE from schoolcourse WHERE SchoolCourseNum = '"
+ POut.PInt(sc.SchoolCourseNum) + "'";
General.NonQ(command);
}
///<summary></summary>
private static void Update(SchoolCourse sc)
{
string command = "UPDATE schoolcourse SET "
+ "SchoolCourseNum = '" + POut.PInt(sc.SchoolCourseNum) + "'"
+ ",CourseID = '" + POut.PString(sc.CourseID) + "'"
+ ",Descript = '" + POut.PString(sc.Descript) + "'"
+ " WHERE SchoolCourseNum = '" + POut.PInt(sc.SchoolCourseNum) + "'";
General.NonQ(command);
}
public async Task <IActionResult> Create([Bind("Id,Name")] SchoolCourse schoolCourse)
{
if (ModelState.IsValid)
{
_context.Add(schoolCourse);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(schoolCourse));
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<SchoolCourse> TableToList(DataTable table){
List<SchoolCourse> retVal=new List<SchoolCourse>();
SchoolCourse schoolCourse;
for(int i=0;i<table.Rows.Count;i++) {
schoolCourse=new SchoolCourse();
schoolCourse.SchoolCourseNum= PIn.Long (table.Rows[i]["SchoolCourseNum"].ToString());
schoolCourse.CourseID = PIn.String(table.Rows[i]["CourseID"].ToString());
schoolCourse.Descript = PIn.String(table.Rows[i]["Descript"].ToString());
retVal.Add(schoolCourse);
}
return retVal;
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<SchoolCourse> TableToList(DataTable table){
List<SchoolCourse> retVal=new List<SchoolCourse>();
SchoolCourse schoolCourse;
for(int i=0;i<table.Rows.Count;i++) {
schoolCourse=new SchoolCourse();
schoolCourse.SchoolCourseNum= PIn.Long (table.Rows[i]["SchoolCourseNum"].ToString());
schoolCourse.CourseID = PIn.String(table.Rows[i]["CourseID"].ToString());
schoolCourse.Descript = PIn.String(table.Rows[i]["Descript"].ToString());
retVal.Add(schoolCourse);
}
return retVal;
}
///<summary>Returns true if Update(SchoolCourse,SchoolCourse) would make changes to the database.
///Does not make any changes to the database and can be called before remoting role is checked.</summary>
public static bool UpdateComparison(SchoolCourse schoolCourse, SchoolCourse oldSchoolCourse)
{
if (schoolCourse.CourseID != oldSchoolCourse.CourseID)
{
return(true);
}
if (schoolCourse.Descript != oldSchoolCourse.Descript)
{
return(true);
}
return(false);
}
private void butOK_Click(object sender, EventArgs e)
{
if (gridMain.GetSelectedIndex() == -1)
{
MsgBox.Show(this, "Please select a course.");
return;
}
if (IsSelectionMode)
{
CourseSelected = _listSchoolCourses[gridMain.GetSelectedIndex()];
DialogResult = DialogResult.OK;
}
}
///<summary></summary>
public static void InsertOrUpdate(SchoolCourse sc, bool isNew)
{
//if(IsRepeating && DateTask.Year>1880){
// throw new Exception(Lan.g(this,"Task cannot be tagged repeating and also have a date."));
//}
if (isNew)
{
Insert(sc);
}
else
{
Update(sc);
}
}
//method to filter assignments based on classes
public static List <Assignment> FilteAssignments(SchoolCourse course, List <Assignment> totalAssignment)
{
List <Assignment> ClassAssignments = new List <Assignment>();
foreach (Assignment task in totalAssignment)
{
if (task.Course_id.Equals(course.Id))
{
ClassAssignments.Add(task);
}
}
return(ClassAssignments);
}
private void butAdd_Click(object sender, System.EventArgs e)
{
SchoolCourse cur = new SchoolCourse();
FormSchoolCourseEdit FormS = new FormSchoolCourseEdit(cur);
FormS.IsNew = true;
FormS.ShowDialog();
if (FormS.DialogResult != DialogResult.OK)
{
return;
}
changed = true;
FillGrid();
}
///<summary>Inserts one SchoolCourse into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(SchoolCourse schoolCourse)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(schoolCourse, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
schoolCourse.SchoolCourseNum = DbHelper.GetNextOracleKey("schoolcourse", "SchoolCourseNum"); //Cacheless method
}
return(InsertNoCache(schoolCourse, true));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SchoolCourse> TableToList(DataTable table)
{
List <SchoolCourse> retVal = new List <SchoolCourse>();
SchoolCourse schoolCourse;
foreach (DataRow row in table.Rows)
{
schoolCourse = new SchoolCourse();
schoolCourse.SchoolCourseNum = PIn.Long(row["SchoolCourseNum"].ToString());
schoolCourse.CourseID = PIn.String(row["CourseID"].ToString());
schoolCourse.Descript = PIn.String(row["Descript"].ToString());
retVal.Add(schoolCourse);
}
return(retVal);
}
///<summary>Refreshes all SchoolCourses.</summary>
public static void Refresh()
{
string command =
"SELECT * FROM schoolcourse "
+ "ORDER BY CourseID";
DataTable table = General.GetTable(command);
List = new SchoolCourse[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new SchoolCourse();
List[i].SchoolCourseNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].CourseID = PIn.PString(table.Rows[i][1].ToString());
List[i].Descript = PIn.PString(table.Rows[i][2].ToString());
}
}
private void FilterForListBox(string course)
{
SchoolCourse currentcourse = classes.First(item => item.Name.Equals(course));
List <Assignment> classRelated = FilterClasses.FilteAssignments(currentcourse, totalAssignments);
List <Assignment> particpation = FilterClasses.FilterParticaption(classRelated);
List <Assignment> classRelatedFilter = new List <Assignment>();
foreach (Assignment task in classRelated)
{
if (!particpation.Contains(task))
{
classRelatedFilter.Add(task);
}
}
UpdateListBoxes(classRelatedFilter, particpation);
}
private void gridMain_CellDoubleClick(object sender, ODGridClickEventArgs e)
{
if (gridMain.GetSelectedIndex() == -1)
{
return;
}
if (IsSelectionMode)
{
CourseSelected = _listSchoolCourses[gridMain.GetSelectedIndex()];
DialogResult = DialogResult.OK;
return;
}
FormSchoolCourseEdit FormS = new FormSchoolCourseEdit(_listSchoolCourses[gridMain.GetSelectedIndex()]);
FormS.ShowDialog();
if (FormS.DialogResult != DialogResult.OK)
{
return;
}
changed = true;
FillGrid();
}
///<summary>Inserts one SchoolCourse into the database. Provides option to use the existing priKey.</summary>
public static long Insert(SchoolCourse schoolCourse,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
schoolCourse.SchoolCourseNum=ReplicationServers.GetKey("schoolcourse","SchoolCourseNum");
}
string command="INSERT INTO schoolcourse (";
if(useExistingPK || PrefC.RandomKeys) {
command+="SchoolCourseNum,";
}
command+="CourseID,Descript) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(schoolCourse.SchoolCourseNum)+",";
}
command+=
"'"+POut.String(schoolCourse.CourseID)+"',"
+"'"+POut.String(schoolCourse.Descript)+"')";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
schoolCourse.SchoolCourseNum=Db.NonQ(command,true);
}
return schoolCourse.SchoolCourseNum;
}
///<summary>Inserts one SchoolCourse into the database. Returns the new priKey.</summary>
public static long Insert(SchoolCourse schoolCourse)
{
return(Insert(schoolCourse, false));
}
public static string GetDescript(SchoolCourse course)
{
return(course.CourseID + " " + course.Descript);
}
///<summary>Updates one SchoolCourse in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables. Returns true if an update occurred.</summary>
public static bool Update(SchoolCourse schoolCourse,SchoolCourse oldSchoolCourse){
string command="";
if(schoolCourse.CourseID != oldSchoolCourse.CourseID) {
if(command!=""){ command+=",";}
command+="CourseID = '"+POut.String(schoolCourse.CourseID)+"'";
}
if(schoolCourse.Descript != oldSchoolCourse.Descript) {
if(command!=""){ command+=",";}
command+="Descript = '"+POut.String(schoolCourse.Descript)+"'";
}
if(command==""){
return false;
}
command="UPDATE schoolcourse SET "+command
+" WHERE SchoolCourseNum = "+POut.Long(schoolCourse.SchoolCourseNum);
Db.NonQ(command);
return true;
}
///<summary>Updates one SchoolCourse in the database.</summary>
public static void Update(SchoolCourse schoolCourse){
string command="UPDATE schoolcourse SET "
+"CourseID = '"+POut.String(schoolCourse.CourseID)+"', "
+"Descript = '"+POut.String(schoolCourse.Descript)+"' "
+"WHERE SchoolCourseNum = "+POut.Long(schoolCourse.SchoolCourseNum);
Db.NonQ(command);
}
