public int AddDateBooking(int dateAvaliableId, int userId, DateTime startDateBooking, DateTime endDateBooking, decimal paid, decimal totalCostByRoom)
{
ChannelManagerDataSet.DateAvaliableRow dateAvaliableRow = _dataSet.DateAvaliable.FindByid(dateAvaliableId);
ChannelManagerDataSet.UsersRow usersRow = _dataSet.Users.FindByid(userId);
ChannelManagerDataSet.DateBookingRow newDateBookingRow = _dataSet.DateBooking.AddDateBookingRow(dateAvaliableRow, usersRow, startDateBooking, endDateBooking, paid, totalCostByRoom);
return(_dateBookingTableAdapter.Update(newDateBookingRow));
}
public int AddUser(String firstName, String surName, String patronymic, int passportSeries, int passportNum) //возвращает id добавленного пользователя
{
ChannelManagerDataSet.UsersRow newUserRow = _dataSet.Users.AddUsersRow(firstName, surName, patronymic, passportSeries, passportNum);
if (_usersTableAdapter.Update(newUserRow) >= 0)
{
return(newUserRow.id);
}
else
{
return(-1);
}
}
public int AddBooking(int dateAvaliableId, String firstName, String surName, String patronymic, int passportSeries, int passportNum, DateTime startDateRate, DateTime endDateRate, decimal paid, decimal totalCostByRoom)
{
ChannelManagerDataSet.DateAvaliableRow dateAvaliableRow = _dataSet.DateAvaliable.FindByid(dateAvaliableId);
int newUserId = AddUser(firstName, surName, patronymic, passportSeries, passportNum);
if (newUserId >= 0)
{
ChannelManagerDataSet.UsersRow userRow = _dataSet.Users.FindByid(newUserId);
ChannelManagerDataSet.DateBookingRow newDateBookingRow = _dataSet.DateBooking.AddDateBookingRow(dateAvaliableRow, userRow, startDateRate, endDateRate, paid, totalCostByRoom);
_usersTableAdapter.Update(newDateBookingRow);
return(newDateBookingRow.id);
}
else
{
return(-1); //Ошибка добавления пользователя в БД.
}
}
