/// <summary> /// save the new change record /// </summary> internal void PostToDB(Changes change) { string itemQry = ""; try { List <string> qryList = new List <string>(); //insert to master data string qry = dBservices.BuildInsertChanges(change); qryList.Add(qry); for (int i = 0; i < change.ObjectsList.Count; i++) { qry = dBservices.BuildInsertObjectsAffected(change.ObjectsList[i], change.Id); qryList.Add(qry); } for (int i = 0; i < change.TestsList.Count; i++) { qry = dBservices.BuildInsertObjectsAffected(change.TestsList[i], change.Id); qryList.Add(qry); } foreach (var item in qryList) { dBservices.insert(item); itemQry = item; } } catch (Exception ex) { LogWaveClass.LogWave("שגיאת הכנסה לדטהבייס " + itemQry + " " + ex.Message); } }