private static void ShowLoginForm()
{
var mainWindow = DiFactory.Resolve <MainWindow>();
mainWindow.Visible = false;
mainWindow.Hide();
LoginForm form = DiFactory.Resolve <LoginForm>();
bool logined = false;
form.Logined += (sndr, arg) =>
{
logined = true;
form.Close();
};
form.ShowDialog();
if (logined)
{
mainWindow.Init();
Application.Run(mainWindow);
}
else
{
Application.Exit();
}
}
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
BundleConfig.RegisterBundles(BundleTable.Bundles);
Application["DiContainer"] = new DiFactory();
}
public void QueryMultiple_無參數()
{
var testDbContext = DiFactory.GetService <TestDbContext>();
var sql = @"
SELECT *
FROM [dbo].[A]
WHERE [Name] = N'C'
SELECT [d].*
FROM [dbo].[ADetail] [d]
JOIN [dbo].[A] [a]
ON [d].[AGuid] = [a].[Guid]
WHERE [a].[Name] = N'C'
";
var boxDto = testDbContext.QueryMultiple(sql)
.Result(reader =>
{
var tempResult = reader.TranslateFirstOrDefault <A>();
tempResult.Details = reader.Translate <ADetail>().ToArray();
return(tempResult);
});
Assert.True(boxDto != null);
Assert.True(boxDto.Details.Count == 3);
}
public void QueryMultiple_有參數_DynamicParameters_匿名()
{
var sql = @"
SELECT *
FROM [dbo].[A]
WHERE [Guid] = @Guid
SELECT *
FROM [dbo].[ADetail]
WHERE [AGuid] = @Guid
";
var dbConnection = DiFactory.GetService <IDbConnection>();
var param = new DynamicParameters();
param.AddDynamicParams(new { Guid = _dGuid });
var boxDto = new A();
dbConnection.QueryMultipleResult(sql, param)
.Result(reader =>
{
boxDto = reader.ReadFirstOrDefault <A>();
boxDto.Details = reader.Read <ADetail>().ToArray();
});
Assert.True(boxDto != null);
Assert.True(boxDto.Details.Count == 2);
}
public void 指定型別()
{
Dapper.SqlMapper.AddTypeHandler(new VarcharToNullDecimalHandler());
var sql = @"
DECLARE @TmpTable TABLE
(
[Column1] VARCHAR(50)
)
INSERT INTO @TmpTable(Column1)
VALUES (@Column1)
SELECT *
FROM @TmpTable
";
var dbConnection = DiFactory.GetService <IDbConnection>();
var dto = new TestDto
{
Column1 = 1.234m,
};
var param = new DynamicParameters();
param.Add("Column1", dto.Column1, DbType.AnsiString);
var result = dbConnection.QueryFirstOrDefault <TestDto>(sql, param);
Assert.AreEqual(result.Column1, 1.234m);
}
public void QueryMultiple_無參數()
{
var sql = @"
SELECT *
FROM [dbo].[A]
WHERE [Name] = N'C'
SELECT *
FROM [dbo].[ADetail] [d]
JOIN [dbo].[A] [a]
ON [d].[AGuid] = [a].[Guid]
WHERE [a].[Name] = N'C'
";
var dbConnection = DiFactory.GetService <IDbConnection>();
var boxDto = new A();
dbConnection.QueryMultipleResult(sql)
.Result(reader =>
{
boxDto = reader.ReadFirstOrDefault <A>();
boxDto.Details = reader.Read <ADetail>().ToArray();
});
Assert.True(boxDto != null);
Assert.True(boxDto.Details.Count == 3);
}
public void QueryMultiple_具名參數()
{
var testDbContext = DiFactory.GetService <TestDbContext>();
var sql = @"
SELECT *
FROM [dbo].[A]
WHERE [Guid] = @Guid
SELECT *
FROM [dbo].[ADetail]
WHERE [AGuid] = @Guid
";
var sqlParameters = new[]
{
new SqlParameter("Guid", _dGuid),
};
var boxDto = testDbContext.QueryMultiple(sql, sqlParameters)
.Result(reader =>
{
var tempResult = reader.TranslateFirstOrDefault <A>();
tempResult.Details = reader.Translate <ADetail>().ToArray();
return(tempResult);
});
Assert.True(boxDto != null);
Assert.True(boxDto.Details.Count == 2);
}
/// <summary>
/// ФУнкция установки начальных параметров
/// </summary>
private void ShowStatisticPanel()
{
var statistic = DiFactory.Resolve <StatisticUserControl>();
statistic.Back += (sndr, args) => { ShowStartPanel(); };
ShowContent(statistic);
}
private void ShowTest()
{
var test = DiFactory.Resolve <TestUserControl>();
test.CompleteTest += (sndr, args) => { ShowStartPanel(); };
ShowContent(test);
}
public void QueryMultiple_有參數_匿名()
{
var sql = @"
SELECT *
FROM [dbo].[A]
WHERE [Guid] = @Guid
SELECT *
FROM [dbo].[ADetail]
WHERE [AGuid] = @Guid
";
var dbConnection = DiFactory.GetService <IDbConnection>();
var param = new { Guid = _dGuid };
var boxDto = dbConnection.QueryMultipleResult(sql, param)
.Result(reader =>
{
var readerResult = reader.ReadFirstOrDefault <A>();
readerResult.Details = reader.Read <ADetail>().ToArray();
return(readerResult);
});
Assert.True(boxDto != null);
Assert.True(boxDto.Details.Count == 2);
}
/// <summary>
/// ФУнкция отображения начальной формы
/// </summary>
private void ShowStartPanel()
{
var startContent = DiFactory.Resolve <StartUserControl>();
startContent.StartTest += OnStartTest;
startContent.ShowStatistic += OnShowStatistic;
ShowContent(startContent);
}
public void QueryMultiple_無參數()
{
var sql = @"
SELECT *
FROM [dbo].[A]
WHERE [Name] = @name
";
var parameters = new DynamicParameters();
parameters.Add("@name", "C", SqlDbType.NVarChar, size: 50);
var dbConnection = DiFactory.GetService <IDbConnection>();
var aDto = dbConnection.QueryFirstOrDefault <A>(sql, parameters);
Assert.AreEqual("C", aDto.Name);
}
public void OneTimeSetUp()
{
var testDbContext = DiFactory.GetService <TestDbContext>();
testDbContext.Database.EnsureCreated();
var aGuid = Guid.NewGuid();
testDbContext.A.Add(new A
{
Guid = aGuid,
Name = "C",
Details = new[]
{
new ADetail {
Guid = Guid.NewGuid(), AGuid = aGuid, Name = "C1",
},
new ADetail {
Guid = Guid.NewGuid(), AGuid = aGuid, Name = "C2",
},
new ADetail {
Guid = Guid.NewGuid(), AGuid = aGuid, Name = "C3",
},
}
});
_dGuid = Guid.NewGuid();
testDbContext.A.Add(new A
{
Guid = _dGuid,
Name = "D",
Details = new[]
{
new ADetail {
Guid = Guid.NewGuid(), AGuid = _dGuid, Name = "D1",
},
new ADetail {
Guid = Guid.NewGuid(), AGuid = _dGuid, Name = "D2",
},
}
});
testDbContext.SaveChanges();
}
public static void Main(string[] args)
{
using (var container = DiFactory.GetContainer())
{
var logging = container.Get <ILogging>();
logging.Log("Created container");
var application = container.Get <IApplication>();
application.DoSomeWork(10);
logging.Log("Created appl4ication");
logging.Log("Finished!");
logging.Log("All done!");
}
}
public void QueryMultiple_無參數_Translate_查不到資料()
{
var testDbContext = DiFactory.GetService <TestDbContext>();
var sql = @"
SELECT *
FROM [dbo].[A]
WHERE [Name] = N'Z'
";
var boxDto = testDbContext.QueryMultiple(sql)
.Result(reader =>
{
var tempResult = reader.Translate <A>().ToArray();
return(tempResult);
});
Assert.True(boxDto.Length == 0);
}
public void QueryMultiple_無參數_TranslateFirstOrDefault_查不到資料()
{
var testDbContext = DiFactory.GetService <TestDbContext>();
var sql = @"
SELECT *
FROM [dbo].[A]
WHERE [Name] = N'Z'
";
var boxDto = new A();
testDbContext.QueryMultiple(sql)
.Result(reader =>
{
boxDto = reader.TranslateFirstOrDefault <A>();
});
Assert.True(boxDto == null);
}
public static void ConfigureMobileApp(IAppBuilder app)
{
var config = new HttpConfiguration();
config.Routes.MapHttpRoute(
name: "API Default",
routeTemplate: "api/{controller}/{action}/{id}",
defaults: new { id = RouteParameter.Optional });
config.Routes.MapHttpRoute("custom", ".auth/login/custom", new { controller = "Auth" });
new MobileAppConfiguration()
.AddMobileAppHomeController()
.MapApiControllers()
.AddTablesWithEntityFramework()
.ApplyTo(config);
// Use Entity Framework Code First to create database tables based on your DbContext
var settings = config.GetMobileAppSettingsProvider().GetMobileAppSettings();
if (string.IsNullOrEmpty(settings.HostName))
{
app.UseAppServiceAuthentication(new AppServiceAuthenticationOptions
{
SigningKey = "XCAP05H6LoKvbRRa/QkqLNMI7cOHguaRyHzyg7n5qEkGjQmtBhz4SzYh4Fqwjyi3KJHlSXKPwVu2+bXr6CtpgQ==",
ValidAudiences = new[] { "https://festims.azurewebsites.net/", "http://localhost:60423/", "http://localhost:63511/", "https://festiapi.azurewebsites.net/" },
ValidIssuers = new[] { "https://festims.azurewebsites.net/", "http://localhost:60423/", "http://localhost:63511/", "https://festiapi.azurewebsites.net/" },
TokenHandler = config.GetAppServiceTokenHandler()
});
}
config.DependencyResolver = DiFactory.Create(config);
config.EnableCors(new EnableCorsAttribute("*", "*", "*"));
app.UseWebApi(config);
}
public void Run()
{
Measure("Dapper", () => DiFactory.GetService <DapperService>().Run());
Measure("EfCore", () => DiFactory.GetService <EfCoreService>().FromSqlRaw_SqlParameter());
Measure("EfCore", () => DiFactory.GetService <EfCoreService>().QueryMultiple());
}
public void OneTimeTearDown()
{
var testDbContext = DiFactory.GetService <TestDbContext>();
testDbContext.Database.EnsureDeleted();
}
public void OneTimeSetUp()
{
var testDbContext = DiFactory.GetService <TestDbContext>();
testDbContext.Database.EnsureCreated();
}
