123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154 |
- <?xml version="1.0" encoding="utf-8"?>
- <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
- <EntityContainerMapping StorageEntityContainer="Хранилище gr606_sosanModelContainer" CdmEntityContainer="Entities">
- <EntitySetMapping Name="Address">
- <EntityTypeMapping TypeName="gr606_sosanModel.Address">
- <MappingFragment StoreEntitySet="Address">
- <ScalarProperty Name="IdAddress" ColumnName="IdAddress" />
- <ScalarProperty Name="Street" ColumnName="Street" />
- <ScalarProperty Name="Number" ColumnName="Number" />
- <ScalarProperty Name="HouseNumber" ColumnName="HouseNumber" />
- <ScalarProperty Name="Flat" ColumnName="Flat" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="CardAmount">
- <EntityTypeMapping TypeName="gr606_sosanModel.CardAmount">
- <MappingFragment StoreEntitySet="CardAmount">
- <ScalarProperty Name="IdCard" ColumnName="IdCard" />
- <ScalarProperty Name="Sum" ColumnName="Sum" />
- <ScalarProperty Name="PaymentName" ColumnName="PaymentName" />
- <ScalarProperty Name="IdPay" ColumnName="IdPay" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Cash">
- <EntityTypeMapping TypeName="gr606_sosanModel.Cash">
- <MappingFragment StoreEntitySet="Cash">
- <ScalarProperty Name="IdCash" ColumnName="IdCash" />
- <ScalarProperty Name="Sum" ColumnName="Sum" />
- <ScalarProperty Name="PaymentName" ColumnName="PaymentName" />
- <ScalarProperty Name="IdPay" ColumnName="IdPay" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="CashRegister">
- <EntityTypeMapping TypeName="gr606_sosanModel.CashRegister">
- <MappingFragment StoreEntitySet="CashRegister">
- <ScalarProperty Name="IdCashRegistre" ColumnName="IdCashRegistre" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
- <ScalarProperty Name="IdSurrender" ColumnName="IdSurrender" />
- <ScalarProperty Name="IdDate" ColumnName="IdDate" />
- <ScalarProperty Name="IdPay" ColumnName="IdPay" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Dates">
- <EntityTypeMapping TypeName="gr606_sosanModel.Dates">
- <MappingFragment StoreEntitySet="Dates">
- <ScalarProperty Name="IdDate" ColumnName="IdDate" />
- <ScalarProperty Name="Date" ColumnName="Date" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Employees">
- <EntityTypeMapping TypeName="gr606_sosanModel.Employees">
- <MappingFragment StoreEntitySet="Employees">
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- <ScalarProperty Name="Surname" ColumnName="Surname" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
- <ScalarProperty Name="TelephoneNumber" ColumnName="TelephoneNumber" />
- <ScalarProperty Name="Email" ColumnName="Email" />
- <ScalarProperty Name="Login" ColumnName="Login" />
- <ScalarProperty Name="Password" ColumnName="Password" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="PasportDetails">
- <EntityTypeMapping TypeName="gr606_sosanModel.PasportDetails">
- <MappingFragment StoreEntitySet="PasportDetails">
- <ScalarProperty Name="IdDetail" ColumnName="IdDetail" />
- <ScalarProperty Name="Number" ColumnName="Number" />
- <ScalarProperty Name="Series" ColumnName="Series" />
- <ScalarProperty Name="IssuedBy" ColumnName="IssuedBy" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Payment">
- <EntityTypeMapping TypeName="gr606_sosanModel.Payment">
- <MappingFragment StoreEntitySet="Payment">
- <ScalarProperty Name="IdPay" ColumnName="IdPay" />
- <ScalarProperty Name="HistoryAboutPayment" ColumnName="HistoryAboutPayment" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Product">
- <EntityTypeMapping TypeName="gr606_sosanModel.Product">
- <MappingFragment StoreEntitySet="Product">
- <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="Manufacture" ColumnName="Manufacture" />
- <ScalarProperty Name="ProductGroup" ColumnName="ProductGroup" />
- <ScalarProperty Name="Cost" ColumnName="Cost" />
- <ScalarProperty Name="TypeOfProduct" ColumnName="TypeOfProduct" />
- <ScalarProperty Name="Bardcode" ColumnName="Bardcode" />
- <ScalarProperty Name="Margin" ColumnName="Margin" />
- <ScalarProperty Name="Quantity" ColumnName="Quantity" />
- <ScalarProperty Name="Discount" ColumnName="Discount" />
- <ScalarProperty Name="Unit" ColumnName="Unit" />
- <ScalarProperty Name="VAT" ColumnName="VAT" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Revenue">
- <EntityTypeMapping TypeName="gr606_sosanModel.Revenue">
- <MappingFragment StoreEntitySet="Revenue">
- <ScalarProperty Name="IdRevenue" ColumnName="IdRevenue" />
- <ScalarProperty Name="SumRevenue" ColumnName="SumRevenue" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SuppliersProduct">
- <EntityTypeMapping TypeName="gr606_sosanModel.SuppliersProduct">
- <MappingFragment StoreEntitySet="SuppliersProduct">
- <ScalarProperty Name="IdSupplier" ColumnName="IdSupplier" />
- <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
- <ScalarProperty Name="IdSupply" ColumnName="IdSupply" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SupplyProduct">
- <EntityTypeMapping TypeName="gr606_sosanModel.SupplyProduct">
- <MappingFragment StoreEntitySet="SupplyProduct">
- <ScalarProperty Name="IdSupply" ColumnName="IdSupply" />
- <ScalarProperty Name="QuantityDeliveredProduct" ColumnName="QuantityDeliveredProduct" />
- <ScalarProperty Name="CostDeliveredProduct" ColumnName="CostDeliveredProduct" />
- <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SurrenderOfMoney">
- <EntityTypeMapping TypeName="gr606_sosanModel.SurrenderOfMoney">
- <MappingFragment StoreEntitySet="SurrenderOfMoney">
- <ScalarProperty Name="IdSurrender" ColumnName="IdSurrender" />
- <ScalarProperty Name="Sum" ColumnName="Sum" />
- <ScalarProperty Name="NumberOfChecks" ColumnName="NumberOfChecks" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="WorkingShift">
- <EntityTypeMapping TypeName="gr606_sosanModel.WorkingShift">
- <MappingFragment StoreEntitySet="WorkingShift">
- <ScalarProperty Name="IdShift" ColumnName="IdShift" />
- <ScalarProperty Name="NameShift" ColumnName="NameShift" />
- <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- </EntityContainerMapping>
- </Mapping>
|