public void UpdateJobStatus(Model.JobInfo jobInfo, Model.JobProcessStatus status) { if (!Active) return; Logger.Log.Instance.Info(string.Format("DefaultJobHistoryUpdater. Update Job status. JobId: {0}, Status: {1}", jobInfo.JobId, status.ToString())); using (var connection = new SqlConnection(RoleSettings.DbConnectionString)) { connection.Open(); var commandText = "INSERT INTO JobHistory (JobId,Status,UpdateDate,ProcessingRole) VALUES (@JobId,@Status, GETDATE(),@RoleId)"; using (var command = new SqlCommand(commandText, connection)) { command.Parameters.Add("@JobId", SqlDbType.NVarChar); command.Parameters["@JobId"].Value = jobInfo.JobId; command.Parameters.Add("@Status", SqlDbType.NVarChar); command.Parameters["@Status"].Value = status.ToString(); command.Parameters.Add("@RoleId", SqlDbType.NVarChar); command.Parameters["@RoleId"].Value = RoleSettings.RoleId; command.ExecuteNonQuery(); } connection.Close(); } }
public Model.PagedList<Model.Employee> GetEmployees(int pageNumber = 1, int pageSize = 20, string orderBy = "Id", Model.SortingOrder sortingOrder = Model.SortingOrder.DESC) { using (var connection = new SqlConnection(Configurations.EmployeeDbConnectionString)) { var addRemarkCommand = new SqlCommand("spGetEmployees", connection); addRemarkCommand.CommandType = System.Data.CommandType.StoredProcedure; addRemarkCommand.Parameters.Add(new SqlParameter("@PageNumber", pageNumber)); addRemarkCommand.Parameters.Add(new SqlParameter("@PageSize", pageSize)); addRemarkCommand.Parameters.Add(new SqlParameter("@OrderBy", orderBy)); addRemarkCommand.Parameters.Add(new SqlParameter("@SortingOrder", sortingOrder.ToString())); var resultReader = addRemarkCommand.ExecuteReader(); int totalRecords = 0; var pagedList = new Model.PagedList<Model.Employee>(); if (resultReader.HasRows) { while (resultReader.Read()) { pagedList.Add(ParseEmployee(resultReader)); totalRecords = (int)resultReader["TotalResults"]; } } pagedList.PageSize = pageSize; pagedList.PageNumber = pageNumber; pagedList.TotalRecords = totalRecords; return pagedList; } }
public Model.PagedList<Model.Remark> GetRemarks(string employeeId, int pageNumber = 1, int pageSize = 20, string orderBy = "Id", Model.SortingOrder sortingOrder = Model.SortingOrder.DESC) { using (var connection = new SqlConnection(Configurations.EmployeeDbConnectionString)) { var addRemarkCommand = new SqlCommand("spGetRemarksForEmployee", connection); addRemarkCommand.CommandType = System.Data.CommandType.StoredProcedure; addRemarkCommand.Parameters.Add(new SqlParameter("@EmployeeId", long.Parse(employeeId))); addRemarkCommand.Parameters.Add(new SqlParameter("@PageNumber", pageNumber)); addRemarkCommand.Parameters.Add(new SqlParameter("@PageSize", pageSize)); addRemarkCommand.Parameters.Add(new SqlParameter("@OrderBy", orderBy)); addRemarkCommand.Parameters.Add(new SqlParameter("@SortingOrder", sortingOrder.ToString())); var resultReader = addRemarkCommand.ExecuteReader(); int totalRecords = 0; var pagedList = new Model.PagedList<Model.Remark>(); if (resultReader.HasRows) { while (resultReader.Read()) { pagedList.Add(new Model.Remark() { Text = (string)resultReader["RemarkText"], CreateTimeStamp = (DateTime)resultReader["CreateTimestamp"] }); totalRecords = (int)resultReader["TotalResults"]; } } pagedList.PageSize = pageSize; pagedList.PageNumber = pageNumber; pagedList.TotalRecords = totalRecords; return pagedList; } }
public static string Render(Model.CSSDocument css) { StringBuilder txt = new StringBuilder(); //foreach (Import imp in css.Imports) { // txt.AppendFormat("{0}\r\n", imp.ToString()); //} //foreach (Media mtg in css.Medias) { // txt.AppendFormat("@media{0} {{\r\n", mtg.Media != Media.None ? " " + mtg.Media.ToString() : ""); // foreach (Selector sel in mtg.Selectors) { // txt.Append(Render(sel, 1)); // txt.Append("\r\n"); // } // txt.Append("}\r\n"); //} //foreach (Selector sel in css.Selectors) { // txt.Append(Render(sel)); // txt.Append("\r\n"); //} txt.Append(css.ToString()); return txt.ToString(); }
/// <summary> /// Sends the async. /// </summary> /// <param name="bytes">The bytes.</param> /// <param name="type">The type.</param> /// <param name="endOfMessage">if set to <c>true</c> [end of message].</param> /// <param name="cancellationToken">The cancellation token.</param> /// <returns>Task.</returns> public async Task SendAsync(byte[] bytes, Model.Net.WebSocketMessageType type, bool endOfMessage, CancellationToken cancellationToken = default(CancellationToken)) { await _sendResource.WaitAsync(cancellationToken).ConfigureAwait(false); try { WebSocketMessageType nativeType; if (!Enum.TryParse(type.ToString(), true, out nativeType)) { _logger.Warn("Unrecognized WebSocketMessageType: {0}", type.ToString()); } var linkedTokenSource = CancellationTokenSource.CreateLinkedTokenSource(cancellationToken, _cancellationTokenSource.Token); await _client.SendAsync(new ArraySegment<byte>(bytes), nativeType, true, linkedTokenSource.Token).ConfigureAwait(false); } finally { _sendResource.Release(); } }
public void AdFailed(Model.AdType AdType) { _settings.AdFailed(AdType); OnLog(string.Format("Ads failed request for: {0}", AdType.ToString())); GetAd(null); }
/// <summary> /// 更新状态栏 /// </summary> private void UpdateStatus(Model.DoState doState) { this.toolStripStatusLabel2.Text = doState.ToString(); this.toolStripProgressBar1.Value = (int)doState.DoPercent; if (doState.CurrentCount == doState.SumCount) { this.btnSave.Enabled = true; this.txtLog.AppendText("文件已全部处理完毕!" + Environment.NewLine); this.dgFiles.DataSource = fileBLL.GetAllList(); } }
/// <summary> /// Update picture in database /// </summary> /// <param name="item">Picture to update</param> /// <returns>Picture info</returns> public PictureExecutionResult UpdatePicture(Model.Picture item) { UpdateSessionCulture(); using (var logSession = Helpers.Log.Session($"{GetType()}.{System.Reflection.MethodBase.GetCurrentMethod().Name}()", VerboseLog, RaiseLog)) try { using (var rep = GetNewRepository(logSession)) { var itm = rep .Get<Repository.Model.File>(p => p.FileId == item.FileId, asNoTracking: true) .LeftOuterJoin(rep.Get<Repository.Model.Picture>(asNoTracking: true), f=>f.FileId, p=>p.FileId, (File,Picture) => new { File, Picture }) .FirstOrDefault(); if (itm == null || itm.File == null) throw new Exception(string.Format(Properties.Resources.FILESERVICE_FileNotFound, item.FileId)); var dbPicture = AutoMapper.Mapper.Map<Repository.Model.Picture>(item); rep.AddOrUpdate(dbPicture, state: (itm.Picture != null ? System.Data.Entity.EntityState.Modified : System.Data.Entity.EntityState.Added) ); } return GetPicture(item.FileId); } catch (Exception ex) { ex.Data.Add(nameof(item), item.ToString()); logSession.Enabled = true; logSession.Add(ex); return new PictureExecutionResult(ex); } }
public void SmartDelete(List<ThreadUsr.StatusEnum> threadStatusesToChange, Model.Entities.ObjectType? statusChangeObjectType, int? statusChangeObjectK) { string memcachedKey = new Caching.CacheKey(Caching.CacheKeyPrefix.UpdateThreadUsrJobStatus, "UsrK", this.K.ToString(), "StatusChangeObjectType", statusChangeObjectType.ToString(), "StatusChangeObjectK", statusChangeObjectK.ToString()).ToString(); SmartDeleteThreadUsrJob sdtuj = new SmartDeleteThreadUsrJob(this.K, threadStatusesToChange, statusChangeObjectType, statusChangeObjectK, memcachedKey); sdtuj.ExecuteAsynchronously(); }
/// <summary> /// Gets the cache file path based on a set of parameters /// </summary> private string GetCacheFilePath(string originalPath, ImageSize outputSize, int quality, DateTime dateModified, Model.Drawing.ImageFormat format, bool addPlayedIndicator, double percentPlayed, int? unwatchedCount, string backgroundColor) { var filename = originalPath; filename += "width=" + outputSize.Width; filename += "height=" + outputSize.Height; filename += "quality=" + quality; filename += "datemodified=" + dateModified.Ticks; filename += "f=" + format; var hasIndicator = false; if (addPlayedIndicator) { filename += "pl=true"; hasIndicator = true; } if (percentPlayed > 0) { filename += "p=" + percentPlayed; hasIndicator = true; } if (unwatchedCount.HasValue) { filename += "p=" + unwatchedCount.Value; hasIndicator = true; } if (hasIndicator) { filename += "iv=" + IndicatorVersion; } if (!string.IsNullOrEmpty(backgroundColor)) { filename += "b=" + backgroundColor; } return GetCachePath(ResizedImageCachePath, filename, "." + format.ToString().ToLower()); }
/// <summary> /// 查询默认命名空间 /// </summary> /// <param name="namespace1"></param> /// <returns></returns> public Model.ConfigServers GetDefault(Model.DatabaseType dbType = Model.DatabaseType.Empty) { var list = GetAll(); if (list.Count == 0) { return null; } else { if (dbType == Model.DatabaseType.Empty) { return list.Last(); } else { var li = list.Where(p => p.Type == dbType.ToString()); var rli = li.Count() > 0 ? li.Last() : null; return rli; } } }
/*! \brief Check whether the logical context is satisfiable, and compare the result with the expected result. If the context is satisfiable, then display the model. */ public void check(Status expected_result, out Model model) { Status result = solver.Check(); model = null; Console.WriteLine("{0}", result); switch (result) { case Status.UNSATISFIABLE: break; case Status.UNKNOWN: break; case Status.SATISFIABLE: model = solver.Model; Console.WriteLine("{0}", model.ToString()); break; } if (result != expected_result) { Console.WriteLine("BUG: unexpected result"); } }
/// <summary> /// 90 degree rotation of the cube with rotation axis-z in vertical direction /// </summary> /// <param name="direction">The direction (left/right) of the cube</param> public void rotateVertical90(Model.Direction direction, bool isRecorded = true) { string directionText = direction.ToString(); rotateSurface(Model.CubeSurface.Right, direction, false); rotateSurface(Model.CubeSurface.MiddleVertical, direction, false); rotateSurface(Model.CubeSurface.Left, direction == Model.Direction.Right ? Model.Direction.Left : Model.Direction.Right, false); string imgLocation = direction == Model.Direction.Right ? ImageLocation.VerticalRight90 : ImageLocation.VerticalLeft90; if (isRecorded) { // Step +1 this.numberSteps++; this.History.Add(new Model.HistoryItem(this.Clone(), NumberSteps, String.Format("90 degree vertical {0}", directionText), imgLocation)); } }
/// <summary> /// Create the order specified /// </summary> /// <param name="businessId">business for order</param> /// <param name="order">order to create</param> public void CreateOrder(long businessId, Model.Order.Order order) { // do the sql const string SQL_INSERT = @"DECLARE @CustomerCultureCode nvarchar(11), @CustomerTimezoneId int, @OrderRef nvarchar(11), @BusinessReference nvarchar(10) SELECT @CustomerCultureCode = B.DefaultCultureCode, @CustomerTimezoneId = B.TimezoneId, @BusinessReference = B.ReferenceCode FROM Business.Business as B INNER JOIN Business.BusinessStatus as S ON B.BusinessStatusCode = S.Code WHERE Id = @BusinessId exec booking.GetOrderReference @Reference = @OrderRef out INSERT INTO Booking.Orders (OrderSourceCode, ChannelId, ChannelReference, IntegrationTypeCode, AgentId, OfflineSourceCode, CustomerCultureCode, CustomerCurrencyCode, CustomerTimezoneId, LeadGuestId, UpdatedByUserId, GroupReference, OrderReference, Notes, IsIssue, ReasonForIssue, BusinessReference) VALUES (@OrderSourceCode, @ChannelId, @ChannelReference, @IntegrationTypeCode, @AgentId, @OfflineSourceCode, @CustomerCultureCode, @CustomerCurrencyCode, @CustomerTimezoneId, @LeadGuestId, @UpdatedByUserId, @GroupReference, @OrderRef, @Notes, @IsIssue, @ReasonForIssue, @BusinessReference) SELECT @Id = SCOPE_IDENTITY()"; SqlParameter orderIdParam = DbHelper.CreateParameterOut<int>(OrderMapper.Parameters.Id, System.Data.SqlDbType.Int); var parameters = new List<SqlParameter> { DbHelper.CreateParameter(OrderMapper.Parameters.OrderSourceCode, order.OrderSourceCode), DbHelper.CreateParameter(OrderMapper.Parameters.ChannelId, order.ChannelId), DbHelper.CreateParameter(OrderMapper.Parameters.ChannelReference, order.ChannelReference), DbHelper.CreateParameter(OrderMapper.Parameters.IntegrationTypeCode, order.IntegrationType != null && order.IntegrationType != IntegrationTypeEnum.Unknown ? order.IntegrationType.GetCode() : null), DbHelper.CreateParameter(OrderMapper.Parameters.AgentId, order.AgentId), DbHelper.CreateParameter(OrderMapper.Parameters.OfflineSourceCode, order.OfflineSourceEnum.HasValue ? order.OfflineSourceEnum.GetCode() : null), DbHelper.CreateParameter(OrderMapper.Parameters.CustomerCurrencyCode, order.CustomerCurrencyCode), DbHelper.CreateParameter(BookingMapper.Parameters.BusinessId, businessId), DbHelper.CreateParameter(OrderMapper.Parameters.LeadGuestId, order.LeadGuestId), DbHelper.CreateParameter(OrderMapper.Parameters.GroupReference, order.GroupReference), DbHelper.CreateParameter(OrderMapper.Parameters.Notes, order.Notes), DbHelper.CreateParameter(OrderMapper.Parameters.IsIssue, order.IsIssue), DbHelper.CreateParameter(OrderMapper.Parameters.ReasonForIssue, order.ReasonForIssue), orderIdParam }; AuditFieldsHelper.PopulateAuditFields(parameters); // execute DbHelper.ExecuteNonQueryCommand(SQL_INSERT, System.Data.CommandType.Text, parameters); // Make sure the record was created if (orderIdParam.Value == DBNull.Value) { throw new PrimaryKeyNotSetException(ErrorFactory.CreateAndLogError(Errors.SRVEX30112, "OrderDao.Create", additionalDescriptionParameters: (new object[] { "order", order.ToString() }), descriptionParameters: (new object[] { "order" }))); } // set the id order.Id = DbHelper.ParameterValue<int>(orderIdParam); }
public string GenerateFullFile(Model.FullFile file) { return file.ToString(); }
public static Intermediate.Operand Operand(Model.Register r) { return Operand(r.ToString()); }
public void UpdateThreadUsrs(ThreadUsr.StatusEnum changeStatus, List<ThreadUsr.StatusEnum> threadStatusesToChange, Model.Entities.ObjectType? statusChangeObjectType, int? statusChangeObjectK) { string memcachedKey = new Caching.CacheKey(Caching.CacheKeyPrefix.UpdateThreadUsrJobStatus, "UsrK", this.K.ToString(), "StatusChangeObjectType", statusChangeObjectType.ToString(), "StatusChangeObjectK", statusChangeObjectK.ToString()).ToString(); UpdateThreadUsrJob utuj = new UpdateThreadUsrJob(this.K, changeStatus, threadStatusesToChange, statusChangeObjectType, statusChangeObjectK, memcachedKey); utuj.ExecuteAsynchronously(); //Update uThreadUsr = new Update(); //uThreadUsr.Table = TablesEnum.ThreadUsr; //uThreadUsr.Changes.Add(new Assign(ThreadUsr.Columns.Status, changeStatus)); //uThreadUsr.Changes.Add(new Assign(ThreadUsr.Columns.StatusChangeDateTime, Time.Now)); //uThreadUsr.Where = new Q(ThreadUsr.Columns.UsrK, this.K); //if (threadStatusesToChange != null && threadStatusesToChange.Count > 0) //{ // Or statusOr = new Or(); // foreach (ThreadUsr.StatusEnum statusEnum in threadStatusesToChange) // { // statusOr = new Or(statusOr, // new Q(ThreadUsr.Columns.Status, statusEnum)); // } // uThreadUsr.Where = new And(uThreadUsr.Where, // statusOr); //} //else // throw new Exception("Usr.UpdateThreadUsrs(): Invalid list of ThreadUsr.StatusEnum to change."); //if (statusChangeObjectType != null) //{ // if (statusChangeObjectType.Value == Model.Entities.ObjectType.Usr) // { // // do nothing here // } // else // { // uThreadUsr.Where = new And(uThreadUsr.Where, // new Q(ThreadUsr.Columns.StatusChangeObjectType, statusChangeObjectType.Value)); // } // if (statusChangeObjectK != null) // { // if (statusChangeObjectType.Value == Model.Entities.ObjectType.Usr) // { // uThreadUsr.Where = new And(uThreadUsr.Where, // new Q(ThreadUsr.Columns.InvitingUsrK, statusChangeObjectK.Value)); // } // else // { // uThreadUsr.Where = new And(uThreadUsr.Where, // new Q(ThreadUsr.Columns.StatusChangeObjectK, statusChangeObjectK.Value)); // } // } //} //uThreadUsr.CommandTimeout = 90; //uThreadUsr.Run(); }
/// <summary> /// Sends the async. /// </summary> /// <param name="bytes">The bytes.</param> /// <param name="type">The type.</param> /// <param name="endOfMessage">if set to <c>true</c> [end of message].</param> /// <param name="cancellationToken">The cancellation token.</param> /// <returns>Task.</returns> public Task SendAsync(byte[] bytes, Model.Net.WebSocketMessageType type, bool endOfMessage, CancellationToken cancellationToken) { WebSocketMessageType nativeType; if (!Enum.TryParse(type.ToString(), true, out nativeType)) { _logger.Warn("Unrecognized WebSocketMessageType: {0}", type.ToString()); } return _client.SendAsync(new ArraySegment<byte>(bytes), nativeType, true, cancellationToken); }
public PostBulkDocuments(IDatabase db, Model.BulkDocuments documents) : base(UriBuilder.Build(db, documents), new Http.Methods.Post()) { _stream = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(documents.ToString())); }
/// <summary> /// Creates a statement verb from the 0.90 set of verbs. /// </summary> /// <param name="verb"></param> /// <remarks>You really shouldn't be using this method. It's simply used as an easy way to promote the /// verb enum to the verb class.</remarks> public StatementVerb(Model.TinCan090.StatementVerb verb) : this((PredefinedVerbs)Enum.Parse(typeof(PredefinedVerbs), verb.ToString(), true)) { }
private void assignSpecific(int id, Model model) { GameObject target; GameObject targetLabel; switch (id) { case 0: target = d_original; targetLabel = d_originalLabel; break; case 1: target = d_copy; targetLabel = d_copyLabel; break; case 2: target = t_original; targetLabel = t_originalLabel; break; case 3: target = t_copyA; targetLabel = t_copyALabel; break; case 4: target = t_copyB; targetLabel = t_copyBLabel; break; default: MonoBehaviour.print("Illegal specific model assign("+id+")"); return; //break; } setupModel(target, model); if (!sceneParameters.hide_labels) { if (model != null) { targetLabel.GetComponent<TextMesh>().text = model.ToString(); } else { targetLabel.GetComponent<TextMesh>().text = "NULL"; } } }
/// <summary> /// Update file in database /// </summary> /// <param name="file">File to update</param> /// <returns>File info</returns> public FileExecutionResult Update(Model.File item) { UpdateSessionCulture(); using (var logSession = Helpers.Log.Session($"{GetType()}.{System.Reflection.MethodBase.GetCurrentMethod().Name}()", VerboseLog, RaiseLog)) try { using (var rep = GetNewRepository(logSession)) { SRVCCheckCredentials(logSession, rep, Repository.Model.RightType.Login, Repository.Model.RightType.UploadFile); logSession.Add($"Try to get file with id = '{item.Id}' from database..."); var dbFile = rep.GetFile(item.Id); if (dbFile == null) throw new Exception(string.Format(Properties.Resources.FILESERVICE_FileNotFound, item.Id)); if (item.EncodingName != null) dbFile.Encoding = item.Encoding; dbFile.MimeType = (string.IsNullOrEmpty(item.Mime)) ? FileStorage.MimeStorage.GetMimeTypeByExtension(dbFile.UniqueFileName) : item.Mime; if (!string.IsNullOrEmpty(item.Name)) { dbFile.FileName = System.IO.Path.GetFileName(item.Name); logSession.Add($"Try to rename file in file storage..."); var fi = MainFileStorage.FileRename(item.Id, dbFile.FileName); dbFile.UniqueFileName = fi.Name; } logSession.Add($"Try to update file in database..."); rep.SaveChanges(); return new FileExecutionResult(AutoMapper.Mapper.Map<Model.File>(dbFile)); } } catch (Exception ex) { ex.Data.Add(nameof(item), item.ToString()); logSession.Enabled = true; logSession.Add(ex); return new FileExecutionResult(ex); } }