public override void Insert(System.Data.IDbConnection connection, object instance) { var request = (DataProviderTransaction) instance; var sql = GenerateInsertStatement(); var values = new { Id = request.Transaction.Id, StreamId = request.Transaction.StreamId, Date = request.Transaction.Date, RequestId = request.Transaction.ParentRequest.Id, DataProvider = request.Transaction.DataProvider.Id, DataProviderName = request.Transaction.DataProvider.Name, ConnectionType = request.Transaction.ConnectionType.Type, Connection = request.Transaction.ConnectionType.Connection, Action = request.Transaction.Action.Name, State = request.Transaction.State.Name, StateId = request.Transaction.State.Id, CostPrice = request.Transaction.DataProvider.CostPrice, RecommendedPrice = request.Transaction.DataProvider.RecommendedPrice, BillableForNoRecordState = request.Transaction.BillNoRecords.Name, BillableForNoRecordStateId = request.Transaction.BillNoRecords.Id }; connection.Execute(sql, values); }
public override void Insert(System.Data.IDbConnection connection, object instance) { var request = instance as MonitoringApiRequest; var sql = GenerateInsertStatement(); var values = new { RequestId = request.Request.RequestId, RequestDate = request.Request.RequestDate, UserHostAddress = request.Request.UserHostAddress, Authorization = request.Request.Header.Authorization, UserName = request.Request.UserName, Method = request.Request.Method, BasePath = request.Request.Url.BasePath, HostName = request.Request.Url.HostName, IsSecure = request.Request.Url.IsSecure, Port = request.Request.Url.Port, Query = request.Request.Url.Query, SiteBase = request.Request.Url.SiteBase, Scheme = request.Request.Url.Scheme, Host = request.Request.Header.Host, UserAgent = request.Request.Header.UserAgent, ContentType = request.Request.Header.ContentType, JsonRequest = request.Request.JsonRequest }; connection.Execute(sql, values); }
public static void ExecuteRuleSet(System.Workflow.Activities.Rules.RuleSet ruleSet, object thisObject) { System.Workflow.Activities.Rules.RuleValidation validation = new System.Workflow.Activities.Rules.RuleValidation(thisObject.GetType(), null); ruleSet.Validate(validation); System.Workflow.ComponentModel.Compiler.ValidationErrorCollection errors = validation.Errors; if (errors.Count > 0) { System.Windows.MessageBox.Show("There were Errors in the validation"); } System.Workflow.Activities.Rules.RuleExecution execution = new System.Workflow.Activities.Rules.RuleExecution(validation, thisObject); ruleSet.Execute(execution); }
public override void Insert(System.Data.IDbConnection connection, object instance) { var command = instance as DataProviderEvent; var sql = GenerateInsertStatement(); var values = new { Id = command.Command.Id, CommitSequence = command.Command.Payload.CommitSequence, Payload = command.Command.Payload.Payload, DataProvider = command.Command.Payload.DataProvider, DataProviderId = command.Command.Payload.DataProviderId, CommandType = command.Command.Payload.CommandType, CommandTypeId = command.Command.Payload.CommandTypeId, Type = command.Command.Payload.TypeStringValue }; connection.Execute(sql, values); }
public PinnedRepoElement(CodeFramework.Core.Data.PinnedRepository pinnedRepo, System.Windows.Input.ICommand command) : base(pinnedRepo.Name, () => command.Execute(new RepositoryIdentifier { Owner = pinnedRepo.Owner, Name = pinnedRepo.Name }), Images.Repo) { PinnedRepo = pinnedRepo; // BUG FIX: App keeps getting relocated so the URLs become off if (PinnedRepo.ImageUri.EndsWith("repository.png", System.StringComparison.Ordinal)) { Image = UIImage.FromFile("Images/repository.png"); } else if (PinnedRepo.ImageUri.EndsWith("repository_fork.png", System.StringComparison.Ordinal)) { Image = UIImage.FromFile("Images/repository_fork.png"); } else { ImageUri = new System.Uri(PinnedRepo.ImageUri); } }
public PinnedRepoElement(CodeFramework.Core.Data.PinnedRepository pinnedRepo, System.Windows.Input.ICommand command) : base(pinnedRepo.Name, () => command.Execute(new CodeHub.Core.Utils.RepositoryIdentifier { Owner = pinnedRepo.Owner, Name = pinnedRepo.Name }), Images.Repo) { PinnedRepo = pinnedRepo; ImageUri = new System.Uri(PinnedRepo.ImageUri); }
private void SafelyExecute(System.Windows.Input.ICommand command) { if (command.CanExecute(null)) command.Execute(null); }
public void Then_throw_argument_null_exception() { new Action(() => System.Execute(null)) .ShouldThrow <ArgumentNullException>(); }
protected override void Act() { Result = System.Execute(Options); }
static void Insert(System.Data.OleDb.OleDbConnection cn, System.Data.IDbTransaction tr = null) { var sql = @"INSERT INTO Item(ItemName) VALUES(@ItemName)"; var count = cn.Execute(sql, new { ItemName = DateTime.Now.Millisecond.ToString() }, transaction: tr); Console.WriteLine(count.ToString()); }
static void GetIdentityWithDapper(System.Data.OleDb.OleDbConnection cn) { // 2回回しても問題なく動作する for (int i = 0; i < 2; i++) { var sql = "INSERT INTO Item(ItemName) VALUES (@ItemName)"; cn.Execute(sql, new { ItemName = "秋映" }); var id = (int)cn.Query("SELECT @@IDENTITY as ID").First().ID; Console.WriteLine("@@IDENTITY -> " + id.ToString()); var results = cn.Query<Item>("SELECT * FROM Item WHERE ID = @Id", new { @Id = id }); Console.WriteLine(results.First().ID + ":" + results.First().ItemName); } }
static void Update(System.Data.OleDb.OleDbConnection cn, System.Data.IDbTransaction tr = null) { var sql = @"UPDATE Item SET ItemName = 'シナノゴールド' WHERE ID = @Id"; var count = cn.Execute(sql, new { Id = 1 }, transaction: tr); Console.WriteLine(count.ToString()); }