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); }
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); }