Esempio n. 1
0
        internal void UpdateActiveFailed(SiebelActiveUpdatedUser user, string failedLog, string wsparas)
        {
            //this.Status = SiebelActiveStatus.Failed.ToString();
            //this.LastUpdatedBy = user.ToString();
            //this.LastUpdatedDate = DateTime.Now;
            //this.FailedLog = failedLog;
            //this.Update();
            string sql = string.Format("update SiebelActive set Status='{0}',LastUpdatedBy='{1}',LastUpdatedDate=getdate(),FailedLog='{2}',WSParameters='{3}' where id={4}", SiebelActiveStatus.Failed.ToString(), user.ToString(), failedLog.Replace("'", "''"), wsparas.Replace("'", "''"), this.ID);

            CurrentContext.Database.ExecuteSqlCommand(sql);
        }
Esempio n. 2
0
        internal void UpdateActiveProcessing(SiebelActiveUpdatedUser user)
        {
            string sql = string.Format("update SiebelActive set Status='{0}',LastUpdatedBy='{1}',LastUpdatedDate=getdate() where id={2}", SiebelActiveStatus.Processing.ToString(), user.ToString(), this.ID);

            CurrentContext.Database.ExecuteSqlCommand(sql);
        }