private async Task <List <Clients> > GetClients()
{
await using var connection = new SqlConnection(App.GetConString());
var command = BuilderFactory.NewBuilder <CommandBuilder>()
.SetCommandText("SELECT * FROM Clients")
.SetConnection(connection)
.Build().To <SqlCommand>();
var adapter = new SqlDataAdapter(command);
await connection.OpenAsync();
var dataSet = new DataSet();
adapter.Fill(dataSet);
var result = dataSet.Tables[0].AsEnumerable().Select(datarow => new Clients()
{
Id = datarow.Field <int>("Id"),
Name = datarow.Field <string>("Name"),
Surname = datarow.Field <string>("Surname"),
Patronymic = datarow.Field <string>("Patronymic"),
DateOfBirth = datarow.Field <DateTime>("DateOfBirth"),
Gender = datarow.Field <string>("Gender"),
Address = datarow.Field <string>("Address"),
Phone = datarow.Field <string>("Phone"),
PassportCode = datarow.Field <string>("PassportCode")
}).ToList();;
return(result);
}
private async Task <List <AdditionalServices> > GetAdditionalServices()
{
var k = BuilderFactory.NewBuilder <PdfBuilder>()
.SetTitle("fdgdgsdfg")
.Build() as PdfDocument;
MessageBox.Show(k.Info.Creator);
await using var connection = new SqlConnection(App.GetConString());
var command = BuilderFactory.NewBuilder <CommandBuilder>()
.SetCommandText("SELECT * FROM AdditionalServices")
.SetConnection(connection)
.Build() as SqlCommand;
var adapter = new SqlDataAdapter(command);
await connection.OpenAsync();
var dataset = new DataSet();
adapter.Fill(dataset);
var result = dataset.Tables[0].AsEnumerable().Select(datarow => new AdditionalServices
{
Id = datarow.Field <int>("Id"),
Name = datarow.Field <string>("Name"),
Description = datarow.Field <string>("Description"),
Price = datarow.Field <int>("Price")
}).ToList();
return(result);
}
private async Task <List <RestTypes> > GetRestTypes()
{
await using var connection = new SqlConnection(App.GetConString());
var command = BuilderFactory.NewBuilder <CommandBuilder>()
.SetCommandText("SELECT * FROM RestTypes")
.SetConnection(connection)
.Build() as SqlCommand;
var adapter = new SqlDataAdapter(command);
await connection.OpenAsync();
var dataset = new DataSet();
adapter.Fill(dataset);
var result = dataset.Tables[0].AsEnumerable().Select(datarow => new RestTypes()
{
Id = datarow.Field <int>("Id"),
Name = datarow.Field <string>("Name"),
Description = datarow.Field <string>("Description"),
Restrictions = datarow.Field <string>("Restrictions")
}).ToList();
return(result);
}
private async Task <List <Vouchers> > GetVouchers()
{
await using var connection = new SqlConnection(App.GetConString());
var command = BuilderFactory.NewBuilder <CommandBuilder>()
.SetCommandText <Vouchers>(CommandBuilder.CommandType.Get)
.SetConnection(connection)
.Build()
.To <SqlCommand>();
await connection.OpenAsync();
var adapter = new SqlDataAdapter(command);
var dataSet = new DataSet();
adapter.Fill(dataSet);
AllVouchers = dataSet.Tables[0].AsEnumerable().Select(datarow => new Vouchers
{
Id = datarow.Field <int>(0),
StartDate = datarow.Field <DateTime>(1),
EndDate = datarow.Field <DateTime>(2),
Duration = datarow.Field <int>(3),
ClientId = datarow.Field <int>(4),
HotelId = datarow.Field <int>(5),
StuffId = datarow.Field <int>(6),
AdditService1Id = datarow.Field <int>(7),
AdditService2Id = datarow.Field <int>(8),
AdditService3Id = datarow.Field <int>(9),
RestTypeId = datarow.Field <int>(10),
PaymentStatus = datarow.Field <string>(11),
BookingStatus = datarow.Field <string>(12),
ClientName = datarow.Field <string>(13),
ClientSurname = datarow.Field <string>(14),
ClientPatronymic = datarow.Field <string>(15),
HotelName = datarow.Field <string>(16),
StuffName = datarow.Field <string>(17),
StuffSurname = datarow.Field <string>(18),
StuffPatronymic = datarow.Field <string>(19),
AdditServiceName1 = datarow.Field <string>(20),
AdditServiceName2 = datarow.Field <string>(21),
AdditServiceName3 = datarow.Field <string>(22),
RestTypeName = datarow.Field <string>(23)
}).ToList();
return(AllVouchers);
}
private async Task <DataTable> GetPrimitiveList <T>()
{
var listType = typeof(T);
await using var connection = new SqlConnection(App.GetConString());
var command = BuilderFactory.NewBuilder <CommandBuilder>()
.SetCommandText($"SELECT * FROM {listType.Name}")
.SetConnection(connection)
.Build()
.To <SqlCommand>();
var adapter = new SqlDataAdapter(command);
await connection.OpenAsync();
var dataset = new DataSet();
adapter.Fill(dataset);
return(dataset.Tables[0]);
}
