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]); }