public bool Check(DataContext context) { var value = context.GetValue(this.LeftExpression); if (value == null) { return(false); } var valuetype = value.GetType(); if (valuetype == typeof(Int32) || valuetype == typeof(Int16) || valuetype == typeof(Int64) || valuetype == typeof(byte)) { var intvalue = (int)value; int comparevalue; if (int.TryParse(this.RightValue, out comparevalue)) { return(intvalue > comparevalue); } else { return(false); } } return(false); }
public bool Check(DataContext context) { var value = context.GetValue(this.LeftExpression); if (value == null) { return(false); } string stringvalue = value.ToString().ToLower(); if (stringvalue == this.RightValue) { return(false); } if (value.GetType() == typeof(bool)) { bool boolrightvalue = false; if (string.IsNullOrWhiteSpace(this.RightValue) || this.RightValue.ToLower() == "true" || this.RightValue == "1" || this.RightValue.ToLower() == "yes" || this.RightValue.ToLower() == "ok") { boolrightvalue = true; } var boolvalue = (bool)value; if (boolvalue == boolrightvalue) { return(false); } } return(true); }
protected override void OnBindingComplete(EventArgs e) { base.OnBindingComplete(e); if (DataContext.GetValue("RodzajKorespondencji") == null) { rodzajComboBox.SelectedIndex = 0; DataContext.SetValue("RodzajKorespondencji", (Enova.Business.Old.DB.Web.RodzajKorespondencji)rodzajComboBox.SelectedItem); } }
public void DataContext_Should_Get_A_Typed_Value_From_Database() { commandMock.Setup(c => c.ExecuteScalar()).Returns(1); using (var context = new DataContext()) { var value = context.GetValue <int>("SELECT COUNT(Id) FROM Airplane"); } commandMock.Verify(c => c.ExecuteScalar(), Times.Once()); }
public bool Check(DataContext context) { var value = context.GetValue(LeftExpression); if (value == null) { return(false); } var stringvalue = value.ToString(); return(stringvalue.StartsWith(this.RightValue)); }
public void DataContext_Should_Get_A_Value_From_Database() { using (var context = new DataContext()) { var value = context.GetValue("SELECT COUNT(Id) FROM Airplane"); } connectionMock.Verify(c => c.Open(), Times.Once()); connectionMock.Verify(c => c.Close(), Times.Once()); connectionMock.Verify(c => c.BeginTransaction(), Times.Never()); commandMock.Verify(c => c.ExecuteScalar(), Times.Once()); commandMock.VerifySet(c => c.CommandText = "SELECT COUNT(Id) FROM Airplane"); providerMock.Object.DbTransaction.Should().BeNull(); }
public void C_DataContext_Non_Transitional_Should_Execute_A_Insert_SQL_Command_With_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data() { using (var context = new DataContext(Transaction.No)) { var insertParameters = new Manufacturer { Name = "General Motors", BuildYear = 1908 }; context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @BuildYear)", insertParameters); var manufacturer = context.First <Manufacturer>("SELECT * FROM Le_Manufacturer WHERE BuildYear = 1908"); var manufacturerCount = context.GetValue <int>("SELECT COUNT(TheId) FROM Le_Manufacturer"); manufacturer.TheId.Should().BeGreaterThan(0); manufacturer.Name.Should().Be("General Motors"); manufacturer.BuildYear.Should().Be(1908); manufacturerCount.Should().Be(3); } }
private static object GetValue(string Key, string ObjectTypeName, DataContext dataContext) { object value = dataContext.GetValue(Key); if (value == null) { value = GetValueByObjectType(Key, ObjectTypeName, dataContext); } if (value == null) { string subkey = GetSubKey(Key); if (!string.IsNullOrEmpty(subkey)) { value = GetValue(subkey, ObjectTypeName, dataContext); } } return(value); }
public void B_DataContext_Transitional_Should_Execute_A_Insert_SQL_Command_With_Array_Parameters_And_Read_Created_Data_In_Same_And_Count_Data_In_Another_Context() { using (var context = new DataContext()) { context.Execute("INSERT INTO Le_Manufacturer VALUES (@0, @1)", "McLaren", 1963); var manufacturer = context.First<Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer WHERE Name = @0", "McLaren"); context.Commit(); manufacturer.TheId.Should().BeGreaterThan(0); manufacturer.Name.Should().Be("McLaren"); manufacturer.BuildYear.Should().Be(1963); } using (var context = new DataContext()) { var manufacturerCount = context.GetValue<int>("SELECT COUNT(TheId) FROM Le_Manufacturer"); manufacturerCount.Should().Be(2); } }
public void B_DataContext_Transitional_Should_Execute_A_Insert_SQL_Command_With_Array_Parameters_And_Read_Created_Data_In_Same_And_Count_Data_In_Another_Context() { using (var context = new DataContext()) { context.Execute("INSERT INTO Le_Manufacturer VALUES (@0, @1)", "McLaren", 1963); var manufacturer = context.First <Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer WHERE Name = @0", "McLaren"); context.Commit(); manufacturer.TheId.Should().BeGreaterThan(0); manufacturer.Name.Should().Be("McLaren"); manufacturer.BuildYear.Should().Be(1963); } using (var context = new DataContext()) { var manufacturerCount = context.GetValue <int>("SELECT COUNT(TheId) FROM Le_Manufacturer"); manufacturerCount.Should().Be(2); } }
public void A_DataContext_Transitional_Should_Execute_A_Insert_SQL_Command_With_Anonymous_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data_In_Another_Context() { using (var context = new DataContext()) { var insertParameters = new { Name = "Lotus", Year = 1952 }; context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @Year)", insertParameters); var manufacturer = context.First<Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer"); context.Commit(); manufacturer.TheId.Should().BeGreaterThan(0); manufacturer.Name.Should().Be("Lotus"); manufacturer.BuildYear.Should().Be(1952); } using (var context = new DataContext()) { var manufacturerCount = context.GetValue<int>("SELECT COUNT(TheId) FROM Le_Manufacturer"); manufacturerCount.Should().Be(1); } }
public void A_DataContext_Transitional_Should_Execute_A_Insert_SQL_Command_With_Anonymous_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data_In_Another_Context() { using (var context = new DataContext()) { var insertParameters = new { Name = "Lotus", Year = 1952 }; context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @Year)", insertParameters); var manufacturer = context.First <Manufacturer>("SELECT TOP 1 * FROM Le_Manufacturer"); context.Commit(); manufacturer.TheId.Should().BeGreaterThan(0); manufacturer.Name.Should().Be("Lotus"); manufacturer.BuildYear.Should().Be(1952); } using (var context = new DataContext()) { var manufacturerCount = context.GetValue <int>("SELECT COUNT(TheId) FROM Le_Manufacturer"); manufacturerCount.Should().Be(1); } }
public void C_DataContext_Non_Transitional_Should_Execute_A_Insert_SQL_Command_With_Object_Parameters_And_Read_Created_Data_In_Same_And_Count_Data() { using (var context = new DataContext(Transaction.No)) { var insertParameters = new Manufacturer { Name = "General Motors", BuildYear = 1908 }; context.Execute("INSERT INTO Le_Manufacturer VALUES (@Name, @BuildYear)", insertParameters); var manufacturer = context.First<Manufacturer>("SELECT * FROM Le_Manufacturer WHERE BuildYear = 1908"); var manufacturerCount = context.GetValue<int>("SELECT COUNT(TheId) FROM Le_Manufacturer"); manufacturer.TheId.Should().BeGreaterThan(0); manufacturer.Name.Should().Be("General Motors"); manufacturer.BuildYear.Should().Be(1908); manufacturerCount.Should().Be(3); } }
public void DataContext_Should_Get_A_Typed_Value_From_Database() { commandMock.Setup(c => c.ExecuteScalar()).Returns(1); using (var context = new DataContext()) { var value = context.GetValue<int>("SELECT COUNT(Id) FROM Airplane"); } commandMock.Verify(c => c.ExecuteScalar(), Times.Once()); }