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