public SqlDataMapper(SqlDbType type, string connectionString, IModelBuilderSql <T> builder)
{
this.builder = builder ?? throw new Exception("instance du paramètre builder null");
if (string.IsNullOrEmpty(connectionString))
{
throw new Exception("Connection String is empty");
}
dbHandler = new SqlDbHandlerFactory().CreateHandler(type, connectionString);
}
public StaffLocation CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var staffLocation = new StaffLocation {
Id = dbHandler.GetValue <long>(0 + startingIndex),
UserId = dbHandler.GetValue <long>(1 + startingIndex),
PlaceId = dbHandler.GetValue <long>(2 + startingIndex)
};
nextStartingIndex = 3 + startingIndex;
return(staffLocation);
}
public TicketAttribution CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex,
out int nextStartingIndex)
{
var ticketAtt = new TicketAttribution();
ticketAtt.Id = dbHandler.GetValue <long>(0);
ticketAtt.StaffId = dbHandler.GetValue <long>(1);
ticketAtt.TicketId = dbHandler.GetValue <long>(2);
nextStartingIndex = 3 + startingIndex;
return(ticketAtt);
}
public Login CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex) {
var login = new Login {
Id = dbHandler.GetValue<long>(0 + startingIndex),
PasswordHash = dbHandler.GetValue<byte[]>(1 + startingIndex),
PasswordSalt = dbHandler.GetValue<byte[]>(2 + startingIndex),
UserId = dbHandler.GetValue<long>(3 + startingIndex),
Email = dbHandler.GetValue<string>(4 + startingIndex)
};
nextStartingIndex = 5 + startingIndex;
return login;
}
public TicketWare CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex,
out int nextStartingIndex)
{
var wareBuilder = new WareBuilder();
var ticketWare = new TicketWare();
ticketWare.Id = dbHandler.GetValue <long>(0 + startingIndex);
ticketWare.TicketId = dbHandler.GetValue <long>(1 + startingIndex);
ticketWare.WareId = dbHandler.GetValue <long>(2 + startingIndex);
ticketWare.Ware = wareBuilder.CreateDomainModel(dbHandler, 3 + startingIndex, out nextStartingIndex);
return(ticketWare);
}
public Meal CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var meal = new Meal {
Id = dbHandler.GetValue <long>(0 + startingIndex),
Date = dbHandler.GetValue <DateTime>(1 + startingIndex),
Description = dbHandler.GetValue <string>(2 + startingIndex),
PlaceId = dbHandler.GetValue <long>(3 + startingIndex)
};
nextStartingIndex = 4 + startingIndex;
return(meal);
}
public TicketComment CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var userBuilder = new UserBuilder();
var ticketComment = new TicketComment();
ticketComment.Id = dbHandler.GetValue <long>(0 + startingIndex);
ticketComment.Content = dbHandler.GetValue <string>(1 + startingIndex);
ticketComment.TicketId = dbHandler.GetValue <long>(2 + startingIndex);
ticketComment.AuthorId = dbHandler.GetValue <long>(3 + startingIndex);
ticketComment.Created = dbHandler.GetValue <DateTime>(4 + startingIndex);
ticketComment.Author = userBuilder.CreateDomainModel(dbHandler, 5 + startingIndex, out nextStartingIndex);
return(ticketComment);
}
public WareBooking CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var wareBooking = new WareBooking();
var userBuilder = new UserBuilder();
var wareBuilder = new WareBuilder();
wareBooking.Id = dbHandler.GetValue <long>(0);
wareBooking.WareId = dbHandler.GetValue <long>(1);
wareBooking.UserId = dbHandler.GetValue <long>(2);
wareBooking.Start = dbHandler.GetValue <DateTime>(3);
wareBooking.End = dbHandler.GetValue <DateTime>(4);
wareBooking.User = userBuilder.CreateDomainModel(dbHandler, 5 + startingIndex, out nextStartingIndex);
wareBooking.Ware = wareBuilder.CreateDomainModel(dbHandler, nextStartingIndex, out nextStartingIndex);
return(wareBooking);
}
public Place CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var result = new Place();
result.Id = dbHandler.GetValue <long>(0 + startingIndex);
result.Name = dbHandler.GetValue <string>(1 + startingIndex);
result.HighBandwidthWifi = dbHandler.GetValue <bool>(2 + startingIndex);
result.MembersOnlyArea = dbHandler.GetValue <bool>(3 + startingIndex);
result.UnlimitedBeverages = dbHandler.GetValue <bool>(4 + startingIndex);
result.CosyRoomAmount = dbHandler.GetValue <int>(5 + startingIndex);
result.LaptopAmount = dbHandler.GetValue <int>(6 + startingIndex);
result.PrinterAmount = dbHandler.GetValue <int>(7 + startingIndex);
nextStartingIndex = 8 + startingIndex;
return(result);
}
public MealBooking CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var userBuilder = new UserBuilder();
var mealBuilder = new MealBuilder();
var mealRes = new MealBooking();
mealRes.Id = dbHandler.GetValue <long>(0 + startingIndex);
mealRes.MealId = dbHandler.GetValue <long>(1 + startingIndex);
mealRes.UserId = dbHandler.GetValue <long>(2 + startingIndex);
mealRes.Note = dbHandler.GetValue <string>(3 + startingIndex);
mealRes.Meal = mealBuilder.CreateDomainModel(dbHandler, 4 + startingIndex, out nextStartingIndex);
mealRes.User = userBuilder.CreateDomainModel(dbHandler, nextStartingIndex, out nextStartingIndex);
return(mealRes);
}
public Ware CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var placeBuilder = new PlaceBuilder();
var ware = new Ware {
Id = dbHandler.GetValue <long>(0 + startingIndex),
Name = dbHandler.GetValue <string>(1 + startingIndex),
Description = dbHandler.GetValue <string>(2 + startingIndex),
SerialNumber = dbHandler.GetValue <string>(3 + startingIndex),
PlaceId = dbHandler.GetValue <long>(4 + startingIndex),
InStorage = dbHandler.GetValue <bool>(5 + startingIndex)
};
ware.Place = placeBuilder.CreateDomainModel(dbHandler, 6 + startingIndex, out nextStartingIndex);
return(ware);
}
public RoomBooking CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var userBuilder = new UserBuilder();
var roomBuilder = new RoomBuilder();
var booking = new RoomBooking {
Id = dbHandler.GetValue <long>(0 + startingIndex),
RoomId = dbHandler.GetValue <long>(1 + startingIndex),
ClientId = dbHandler.GetValue <long>(2 + startingIndex),
Start = dbHandler.GetValue <DateTime>(3 + startingIndex),
End = dbHandler.GetValue <DateTime>(4 + startingIndex)
};
booking.Client = userBuilder.CreateDomainModel(dbHandler, 5 + startingIndex, out nextStartingIndex);
booking.Room = roomBuilder.CreateDomainModel(dbHandler, nextStartingIndex, out nextStartingIndex);
return(booking);
}
public Subscription CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var subTypeBuilder = new SubscriptionTypeBuilder();
var clientBuilder = new UserBuilder();
var placeBuilder = new PlaceBuilder();
var sub = new Subscription();
sub.Id = dbHandler.GetValue<long>(0 + startingIndex);
sub.TypeId = dbHandler.GetValue<long>(1 + startingIndex);
sub.LatestRenewal = dbHandler.GetValue<DateTime>(2 + startingIndex);
sub.ClientId = dbHandler.GetValue<long>(3 + startingIndex);
sub.PlaceId = dbHandler.GetValue<long>(4 + startingIndex);
sub.FixedContract = dbHandler.GetValue<bool>(5 + startingIndex);
sub.Type = subTypeBuilder.CreateDomainModel(dbHandler, 6 + startingIndex, out nextStartingIndex);
sub.Place = placeBuilder.CreateDomainModel(dbHandler, nextStartingIndex, out nextStartingIndex);
sub.Client = clientBuilder.CreateDomainModel(dbHandler, nextStartingIndex, out nextStartingIndex);
return sub;
}
CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var subType = new SubscriptionType {
Id = dbHandler.GetValue <long>(0 + startingIndex),
Name = dbHandler.GetValue <string>(1 + startingIndex),
FixedContractDurationMonth = dbHandler.GetValue <int>(2 + startingIndex),
PriceFirstHour = dbHandler.GetValue <double>(3 + startingIndex),
PriceNextHalfHour = dbHandler.GetValue <double>(4 + startingIndex),
PriceDay = dbHandler.GetValue <double>(5 + startingIndex),
PriceDayStudent = dbHandler.GetValue <double>(6 + startingIndex),
MonthlyFeeFixedContract = dbHandler.GetValue <double>(7 + startingIndex),
MonthlyFeeContractFree = dbHandler.GetValue <double>(8 + startingIndex),
Description = dbHandler.GetValue <string>(9 + startingIndex)
};
nextStartingIndex = 10 + startingIndex;
return(subType);
}
public User CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var successParsing =
Enum.TryParse <UserType>(dbHandler.GetValue <short>(4 + startingIndex).ToString(), out var type);
if (!successParsing)
{
throw new Exception("Error parsing RoomType");
}
var user = new User();
user.Id = dbHandler.GetValue <long>(0 + startingIndex);
user.FirstName = dbHandler.GetValue <string>(1 + startingIndex);
user.LastName = dbHandler.GetValue <string>(2 + startingIndex);
user.IsAStudent = dbHandler.GetValue <bool>(3 + startingIndex);
user.Type = type;
nextStartingIndex = 5 + startingIndex;
return(user);
}
public Room CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var placeBuilder = new PlaceBuilder();
var successParsing =
Enum.TryParse <RoomType>(dbHandler.GetValue <long>(3 + startingIndex).ToString(), out var type);
if (!successParsing)
{
throw new Exception("Error parsing RoomType");
}
var room = new Room {
Id = dbHandler.GetValue <long>(0 + startingIndex),
Name = dbHandler.GetValue <string>(1 + startingIndex),
PlaceId = dbHandler.GetValue <long>(2 + startingIndex),
Type = type
};
room.Place = placeBuilder.CreateDomainModel(dbHandler, 4 + startingIndex, out nextStartingIndex);
return(room);
}
public TimeSlot CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var placeBuilder = new PlaceBuilder();
var successParsing =
Enum.TryParse <DayOfWeek>(dbHandler.GetValue <long>(1 + startingIndex).ToString(), out var day);
if (!successParsing)
{
throw new Exception("Error parsing RoomType");
}
var timeslot = new TimeSlot {
Id = dbHandler.GetValue <long>(0 + startingIndex),
StartHour = dbHandler.GetValue <short>(2 + startingIndex),
StartMinutes = dbHandler.GetValue <short>(3 + startingIndex),
EndHour = dbHandler.GetValue <short>(4 + startingIndex),
EndMinutes = dbHandler.GetValue <short>(5 + startingIndex),
PlaceId = dbHandler.GetValue <long>(6 + startingIndex),
Day = day
};
timeslot.Place = placeBuilder.CreateDomainModel(dbHandler, 7 + startingIndex, out nextStartingIndex);
return(timeslot);
}
public Ticket CreateDomainModel(ISqlDbHandler dbHandler, int startingIndex, out int nextStartingIndex)
{
var placeBuilder = new PlaceBuilder();
var userBuilder = new UserBuilder();
var successParsing =
Enum.TryParse <TicketState>(dbHandler.GetValue <long>(2 + startingIndex).ToString(), out var state);
if (!successParsing)
{
throw new Exception("Error parsing TicketState");
}
var ticket = new Ticket();
ticket.Id = dbHandler.GetValue <long>(0 + startingIndex);
ticket.OpenedById = dbHandler.GetValue <long>(1 + startingIndex);
ticket.State = state;
ticket.Description = dbHandler.GetValue <string>(3 + startingIndex);
ticket.PlaceId = dbHandler.GetValue <long>(4 + startingIndex);
ticket.Title = dbHandler.GetValue <string>(5 + startingIndex);
ticket.Created = dbHandler.GetValue <DateTime>(6 + startingIndex);
ticket.OpenedBy = userBuilder.CreateDomainModel(dbHandler, 7 + startingIndex, out nextStartingIndex);
ticket.Place = placeBuilder.CreateDomainModel(dbHandler, nextStartingIndex, out nextStartingIndex);
return(ticket);
}
