Ejemplo n.º 1
0
        /// <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);
            }
        }