/// <summary>The selected Def from the grid will be copied into a brand new Evaluation and saved to the DB. This includes all EvaluationCriterion as well. Used when creating a new Evaluation.</summary>
private void CopyDefToEvaluation()
{
EvaluationDef evalDef = EvaluationDefs.GetOne(PIn.Long(gridMain.Rows[gridMain.GetSelectedIndex()].Tag.ToString()));
Evaluation evalNew = new Evaluation();
evalNew.DateEval = DateTime.Today;
evalNew.EvalTitle = evalDef.EvalTitle;
evalNew.GradingScaleNum = evalDef.GradingScaleNum;
evalNew.InstructNum = Security.CurUser.ProvNum;
evalNew.SchoolCourseNum = evalDef.SchoolCourseNum;
evalNew.EvaluationNum = Evaluations.Insert(evalNew);
List <EvaluationCriterionDef> evalCritDefs = EvaluationCriterionDefs.GetAllForEvaluationDef(evalDef.EvaluationDefNum);
EvaluationCriterion evalCrit;
for (int i = 0; i < evalCritDefs.Count; i++)
{
evalCrit = new EvaluationCriterion();
evalCrit.CriterionDescript = evalCritDefs[i].CriterionDescript;
evalCrit.EvaluationNum = evalNew.EvaluationNum;
evalCrit.GradingScaleNum = evalCritDefs[i].GradingScaleNum;
evalCrit.IsCategoryName = evalCritDefs[i].IsCategoryName;
evalCrit.ItemOrder = evalCritDefs[i].ItemOrder;
evalCrit.MaxPointsPoss = evalCritDefs[i].MaxPointsPoss;
EvaluationCriterions.Insert(evalCrit);
}
evalNew.IsNew = true;
FormEvaluationEdit FormEE = new FormEvaluationEdit(evalNew);
FormEE.ShowDialog();
}
///<summary>Inserts one EvaluationCriterion into the database. Returns the new priKey.</summary>
public static long Insert(EvaluationCriterion evaluationCriterion)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
evaluationCriterion.EvaluationCriterionNum = DbHelper.GetNextOracleKey("evaluationcriterion", "EvaluationCriterionNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(evaluationCriterion, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
evaluationCriterion.EvaluationCriterionNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(evaluationCriterion, false));
}
}
///<summary>Inserts one EvaluationCriterion into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EvaluationCriterion evaluationCriterion)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(evaluationCriterion, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
evaluationCriterion.EvaluationCriterionNum = DbHelper.GetNextOracleKey("evaluationcriterion", "EvaluationCriterionNum"); //Cacheless method
}
return(InsertNoCache(evaluationCriterion, true));
}
}
///<summary>Inserts one EvaluationCriterion into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EvaluationCriterion evaluationCriterion, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO evaluationcriterion (";
if (!useExistingPK && isRandomKeys)
{
evaluationCriterion.EvaluationCriterionNum = ReplicationServers.GetKeyNoCache("evaluationcriterion", "EvaluationCriterionNum");
}
if (isRandomKeys || useExistingPK)
{
command += "EvaluationCriterionNum,";
}
command += "EvaluationNum,CriterionDescript,IsCategoryName,GradingScaleNum,GradeShowing,GradeNumber,Notes,ItemOrder,MaxPointsPoss) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(evaluationCriterion.EvaluationCriterionNum) + ",";
}
command +=
POut.Long(evaluationCriterion.EvaluationNum) + ","
+ "'" + POut.String(evaluationCriterion.CriterionDescript) + "',"
+ POut.Bool(evaluationCriterion.IsCategoryName) + ","
+ POut.Long(evaluationCriterion.GradingScaleNum) + ","
+ "'" + POut.String(evaluationCriterion.GradeShowing) + "',"
+ POut.Float(evaluationCriterion.GradeNumber) + ","
+ DbHelper.ParamChar + "paramNotes,"
+ POut.Int(evaluationCriterion.ItemOrder) + ","
+ POut.Float(evaluationCriterion.MaxPointsPoss) + ")";
if (evaluationCriterion.Notes == null)
{
evaluationCriterion.Notes = "";
}
OdSqlParameter paramNotes = new OdSqlParameter("paramNotes", OdDbType.Text, POut.StringParam(evaluationCriterion.Notes));
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command, paramNotes);
}
else
{
evaluationCriterion.EvaluationCriterionNum = Db.NonQ(command, true, "EvaluationCriterionNum", "evaluationCriterion", paramNotes);
}
return(evaluationCriterion.EvaluationCriterionNum);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<EvaluationCriterion> TableToList(DataTable table){
List<EvaluationCriterion> retVal=new List<EvaluationCriterion>();
EvaluationCriterion evaluationCriterion;
for(int i=0;i<table.Rows.Count;i++) {
evaluationCriterion=new EvaluationCriterion();
evaluationCriterion.EvaluationCriterionNum= PIn.Long (table.Rows[i]["EvaluationCriterionNum"].ToString());
evaluationCriterion.EvaluationNum = PIn.Long (table.Rows[i]["EvaluationNum"].ToString());
evaluationCriterion.CriterionDescript = PIn.String(table.Rows[i]["CriterionDescript"].ToString());
evaluationCriterion.IsCategoryName = PIn.Bool (table.Rows[i]["IsCategoryName"].ToString());
evaluationCriterion.GradingScaleNum = PIn.Long (table.Rows[i]["GradingScaleNum"].ToString());
evaluationCriterion.GradeShowing = PIn.String(table.Rows[i]["GradeShowing"].ToString());
evaluationCriterion.GradeNumber = PIn.Float (table.Rows[i]["GradeNumber"].ToString());
evaluationCriterion.Notes = PIn.String(table.Rows[i]["Notes"].ToString());
evaluationCriterion.ItemOrder = PIn.Int (table.Rows[i]["ItemOrder"].ToString());
evaluationCriterion.MaxPointsPoss = PIn.Float (table.Rows[i]["MaxPointsPoss"].ToString());
retVal.Add(evaluationCriterion);
}
return retVal;
}
///<summary>Returns true if Update(EvaluationCriterion,EvaluationCriterion) 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(EvaluationCriterion evaluationCriterion, EvaluationCriterion oldEvaluationCriterion)
{
if (evaluationCriterion.EvaluationNum != oldEvaluationCriterion.EvaluationNum)
{
return(true);
}
if (evaluationCriterion.CriterionDescript != oldEvaluationCriterion.CriterionDescript)
{
return(true);
}
if (evaluationCriterion.IsCategoryName != oldEvaluationCriterion.IsCategoryName)
{
return(true);
}
if (evaluationCriterion.GradingScaleNum != oldEvaluationCriterion.GradingScaleNum)
{
return(true);
}
if (evaluationCriterion.GradeShowing != oldEvaluationCriterion.GradeShowing)
{
return(true);
}
if (evaluationCriterion.GradeNumber != oldEvaluationCriterion.GradeNumber)
{
return(true);
}
if (evaluationCriterion.Notes != oldEvaluationCriterion.Notes)
{
return(true);
}
if (evaluationCriterion.ItemOrder != oldEvaluationCriterion.ItemOrder)
{
return(true);
}
if (evaluationCriterion.MaxPointsPoss != oldEvaluationCriterion.MaxPointsPoss)
{
return(true);
}
return(false);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EvaluationCriterion> TableToList(DataTable table)
{
List <EvaluationCriterion> retVal = new List <EvaluationCriterion>();
EvaluationCriterion evaluationCriterion;
foreach (DataRow row in table.Rows)
{
evaluationCriterion = new EvaluationCriterion();
evaluationCriterion.EvaluationCriterionNum = PIn.Long(row["EvaluationCriterionNum"].ToString());
evaluationCriterion.EvaluationNum = PIn.Long(row["EvaluationNum"].ToString());
evaluationCriterion.CriterionDescript = PIn.String(row["CriterionDescript"].ToString());
evaluationCriterion.IsCategoryName = PIn.Bool(row["IsCategoryName"].ToString());
evaluationCriterion.GradingScaleNum = PIn.Long(row["GradingScaleNum"].ToString());
evaluationCriterion.GradeShowing = PIn.String(row["GradeShowing"].ToString());
evaluationCriterion.GradeNumber = PIn.Float(row["GradeNumber"].ToString());
evaluationCriterion.Notes = PIn.String(row["Notes"].ToString());
evaluationCriterion.ItemOrder = PIn.Int(row["ItemOrder"].ToString());
evaluationCriterion.MaxPointsPoss = PIn.Float(row["MaxPointsPoss"].ToString());
retVal.Add(evaluationCriterion);
}
return(retVal);
}
///<summary>Updates one EvaluationCriterion in the database.</summary>
public static void Update(EvaluationCriterion evaluationCriterion)
{
string command = "UPDATE evaluationcriterion SET "
+ "EvaluationNum = " + POut.Long(evaluationCriterion.EvaluationNum) + ", "
+ "CriterionDescript = '" + POut.String(evaluationCriterion.CriterionDescript) + "', "
+ "IsCategoryName = " + POut.Bool(evaluationCriterion.IsCategoryName) + ", "
+ "GradingScaleNum = " + POut.Long(evaluationCriterion.GradingScaleNum) + ", "
+ "GradeShowing = '" + POut.String(evaluationCriterion.GradeShowing) + "', "
+ "GradeNumber = " + POut.Float(evaluationCriterion.GradeNumber) + ", "
+ "Notes = " + DbHelper.ParamChar + "paramNotes, "
+ "ItemOrder = " + POut.Int(evaluationCriterion.ItemOrder) + ", "
+ "MaxPointsPoss = " + POut.Float(evaluationCriterion.MaxPointsPoss) + " "
+ "WHERE EvaluationCriterionNum = " + POut.Long(evaluationCriterion.EvaluationCriterionNum);
if (evaluationCriterion.Notes == null)
{
evaluationCriterion.Notes = "";
}
OdSqlParameter paramNotes = new OdSqlParameter("paramNotes", OdDbType.Text, POut.StringParam(evaluationCriterion.Notes));
Db.NonQ(command, paramNotes);
}
///<summary>Inserts one EvaluationCriterion into the database. Returns the new priKey.</summary>
public static long Insert(EvaluationCriterion evaluationCriterion){
if(DataConnection.DBtype==DatabaseType.Oracle) {
evaluationCriterion.EvaluationCriterionNum=DbHelper.GetNextOracleKey("evaluationcriterion","EvaluationCriterionNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(evaluationCriterion,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
evaluationCriterion.EvaluationCriterionNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(evaluationCriterion,false);
}
}
///<summary>Updates one EvaluationCriterion 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(EvaluationCriterion evaluationCriterion, EvaluationCriterion oldEvaluationCriterion)
{
string command = "";
if (evaluationCriterion.EvaluationNum != oldEvaluationCriterion.EvaluationNum)
{
if (command != "")
{
command += ",";
}
command += "EvaluationNum = " + POut.Long(evaluationCriterion.EvaluationNum) + "";
}
if (evaluationCriterion.CriterionDescript != oldEvaluationCriterion.CriterionDescript)
{
if (command != "")
{
command += ",";
}
command += "CriterionDescript = '" + POut.String(evaluationCriterion.CriterionDescript) + "'";
}
if (evaluationCriterion.IsCategoryName != oldEvaluationCriterion.IsCategoryName)
{
if (command != "")
{
command += ",";
}
command += "IsCategoryName = " + POut.Bool(evaluationCriterion.IsCategoryName) + "";
}
if (evaluationCriterion.GradingScaleNum != oldEvaluationCriterion.GradingScaleNum)
{
if (command != "")
{
command += ",";
}
command += "GradingScaleNum = " + POut.Long(evaluationCriterion.GradingScaleNum) + "";
}
if (evaluationCriterion.GradeShowing != oldEvaluationCriterion.GradeShowing)
{
if (command != "")
{
command += ",";
}
command += "GradeShowing = '" + POut.String(evaluationCriterion.GradeShowing) + "'";
}
if (evaluationCriterion.GradeNumber != oldEvaluationCriterion.GradeNumber)
{
if (command != "")
{
command += ",";
}
command += "GradeNumber = " + POut.Float(evaluationCriterion.GradeNumber) + "";
}
if (evaluationCriterion.Notes != oldEvaluationCriterion.Notes)
{
if (command != "")
{
command += ",";
}
command += "Notes = " + DbHelper.ParamChar + "paramNotes";
}
if (evaluationCriterion.ItemOrder != oldEvaluationCriterion.ItemOrder)
{
if (command != "")
{
command += ",";
}
command += "ItemOrder = " + POut.Int(evaluationCriterion.ItemOrder) + "";
}
if (evaluationCriterion.MaxPointsPoss != oldEvaluationCriterion.MaxPointsPoss)
{
if (command != "")
{
command += ",";
}
command += "MaxPointsPoss = " + POut.Float(evaluationCriterion.MaxPointsPoss) + "";
}
if (command == "")
{
return(false);
}
if (evaluationCriterion.Notes == null)
{
evaluationCriterion.Notes = "";
}
OdSqlParameter paramNotes = new OdSqlParameter("paramNotes", OdDbType.Text, POut.StringParam(evaluationCriterion.Notes));
command = "UPDATE evaluationcriterion SET " + command
+ " WHERE EvaluationCriterionNum = " + POut.Long(evaluationCriterion.EvaluationCriterionNum);
Db.NonQ(command, paramNotes);
return(true);
}
///<summary>Inserts one EvaluationCriterion into the database. Provides option to use the existing priKey.</summary>
public static long Insert(EvaluationCriterion evaluationCriterion,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
evaluationCriterion.EvaluationCriterionNum=ReplicationServers.GetKey("evaluationcriterion","EvaluationCriterionNum");
}
string command="INSERT INTO evaluationcriterion (";
if(useExistingPK || PrefC.RandomKeys) {
command+="EvaluationCriterionNum,";
}
command+="EvaluationNum,CriterionDescript,IsCategoryName,GradingScaleNum,GradeShowing,GradeNumber,Notes,ItemOrder,MaxPointsPoss) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(evaluationCriterion.EvaluationCriterionNum)+",";
}
command+=
POut.Long (evaluationCriterion.EvaluationNum)+","
+"'"+POut.String(evaluationCriterion.CriterionDescript)+"',"
+ POut.Bool (evaluationCriterion.IsCategoryName)+","
+ POut.Long (evaluationCriterion.GradingScaleNum)+","
+"'"+POut.String(evaluationCriterion.GradeShowing)+"',"
+ POut.Float (evaluationCriterion.GradeNumber)+","
+"'"+POut.String(evaluationCriterion.Notes)+"',"
+ POut.Int (evaluationCriterion.ItemOrder)+","
+ POut.Float (evaluationCriterion.MaxPointsPoss)+")";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
evaluationCriterion.EvaluationCriterionNum=Db.NonQ(command,true);
}
return evaluationCriterion.EvaluationCriterionNum;
}
///<summary>Updates one EvaluationCriterion 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(EvaluationCriterion evaluationCriterion,EvaluationCriterion oldEvaluationCriterion){
string command="";
if(evaluationCriterion.EvaluationNum != oldEvaluationCriterion.EvaluationNum) {
if(command!=""){ command+=",";}
command+="EvaluationNum = "+POut.Long(evaluationCriterion.EvaluationNum)+"";
}
if(evaluationCriterion.CriterionDescript != oldEvaluationCriterion.CriterionDescript) {
if(command!=""){ command+=",";}
command+="CriterionDescript = '"+POut.String(evaluationCriterion.CriterionDescript)+"'";
}
if(evaluationCriterion.IsCategoryName != oldEvaluationCriterion.IsCategoryName) {
if(command!=""){ command+=",";}
command+="IsCategoryName = "+POut.Bool(evaluationCriterion.IsCategoryName)+"";
}
if(evaluationCriterion.GradingScaleNum != oldEvaluationCriterion.GradingScaleNum) {
if(command!=""){ command+=",";}
command+="GradingScaleNum = "+POut.Long(evaluationCriterion.GradingScaleNum)+"";
}
if(evaluationCriterion.GradeShowing != oldEvaluationCriterion.GradeShowing) {
if(command!=""){ command+=",";}
command+="GradeShowing = '"+POut.String(evaluationCriterion.GradeShowing)+"'";
}
if(evaluationCriterion.GradeNumber != oldEvaluationCriterion.GradeNumber) {
if(command!=""){ command+=",";}
command+="GradeNumber = "+POut.Float(evaluationCriterion.GradeNumber)+"";
}
if(evaluationCriterion.Notes != oldEvaluationCriterion.Notes) {
if(command!=""){ command+=",";}
command+="Notes = '"+POut.String(evaluationCriterion.Notes)+"'";
}
if(evaluationCriterion.ItemOrder != oldEvaluationCriterion.ItemOrder) {
if(command!=""){ command+=",";}
command+="ItemOrder = "+POut.Int(evaluationCriterion.ItemOrder)+"";
}
if(evaluationCriterion.MaxPointsPoss != oldEvaluationCriterion.MaxPointsPoss) {
if(command!=""){ command+=",";}
command+="MaxPointsPoss = "+POut.Float(evaluationCriterion.MaxPointsPoss)+"";
}
if(command==""){
return false;
}
command="UPDATE evaluationcriterion SET "+command
+" WHERE EvaluationCriterionNum = "+POut.Long(evaluationCriterion.EvaluationCriterionNum);
Db.NonQ(command);
return true;
}
///<summary>Updates one EvaluationCriterion in the database.</summary>
public static void Update(EvaluationCriterion evaluationCriterion){
string command="UPDATE evaluationcriterion SET "
+"EvaluationNum = "+POut.Long (evaluationCriterion.EvaluationNum)+", "
+"CriterionDescript = '"+POut.String(evaluationCriterion.CriterionDescript)+"', "
+"IsCategoryName = "+POut.Bool (evaluationCriterion.IsCategoryName)+", "
+"GradingScaleNum = "+POut.Long (evaluationCriterion.GradingScaleNum)+", "
+"GradeShowing = '"+POut.String(evaluationCriterion.GradeShowing)+"', "
+"GradeNumber = "+POut.Float (evaluationCriterion.GradeNumber)+", "
+"Notes = '"+POut.String(evaluationCriterion.Notes)+"', "
+"ItemOrder = "+POut.Int (evaluationCriterion.ItemOrder)+", "
+"MaxPointsPoss = "+POut.Float (evaluationCriterion.MaxPointsPoss)+" "
+"WHERE EvaluationCriterionNum = "+POut.Long(evaluationCriterion.EvaluationCriterionNum);
Db.NonQ(command);
}
public FormEvaluationCriterionEdit(EvaluationCriterion evalCritCur)
{
InitializeComponent();
Lan.F(this);
_evalCritCur = evalCritCur;
}
///<summary>Inserts one EvaluationCriterion into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EvaluationCriterion evaluationCriterion)
{
return(InsertNoCache(evaluationCriterion, false));
}
