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