public void BookGuest(string firstName, string lastName, DateTime startDate, DateTime endDate, int roomTypeId)
{
// Insert to 'Guests' table and then retrieve that guest to eventually book them
GuestModel guest = _db.LoadData <GuestModel, dynamic>("dbo.spGuests_Insert",
new { firstName, lastName },
connectionStringName,
true).First();
// To calculate total cost for the booking, need the room type and how many days were stayed
RoomTypeModel roomType = _db.LoadData <RoomTypeModel, dynamic>("select * from dbo.RoomTypes where Id = @Id",
new { Id = roomTypeId },
connectionStringName,
false).First();
TimeSpan timeStaying = endDate.Date.Subtract(startDate.Date);
// Get available rooms that fit the criteria of the dates desired and the room type
List <RoomModel> availableRooms = _db.LoadData <RoomModel, dynamic>("dbo.spRooms_GetAvailableRooms",
new { startDate, endDate, roomTypeId },
connectionStringName,
true);
// Save booking by inserting into 'Bookings' table
_db.SaveData("dbo.spBookings_Insert",
new
{
roomId = availableRooms.First().Id,
guestId = guest.Id,
startDate,
endDate,
totalCost = timeStaying.Days * roomType.Price
},
connectionStringName,
true);
}
public void OnGet()
{
if (RoomTypeId > 0)
{
RoomType = _db.GetRoomTypeById(RoomTypeId);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
RoomTypeModel model = new RoomTypeModel();
RoomType rt = createRoomType();
lblResult.Text = model.InsertRoomType(rt);
}
public string UpdateRoom(RoomTypeModel roomType)
{
string result = string.Empty;
using (HotelDBContext _hotelEntities = new HotelDBContext())
{
try
{
RoomType roomTbl = new RoomType();
roomTbl.Id = roomType.Id;
roomTbl.RoomName = roomType.RoomName;
roomTbl.Amenities = roomType.Amenities;
roomTbl.ImagePath = roomType.ImagePath;
roomTbl.ModifiedOn = System.DateTime.Now.ToShortDateString();
_hotelEntities.RoomTypes.Add(roomTbl);
_hotelEntities.Entry(roomTbl).State = System.Data.Entity.EntityState.Modified;
_hotelEntities.SaveChanges();
result = "Record Updated";
}
catch (Exception)
{
result = "Failed To Upadate";
}
return(result);
}
}
public void BookGuest(string firstName,
string lastName,
DateTime startDate,
DateTime endDate,
int roomTypeId)
{
GuestModel guest = _db.LoadData <GuestModel, dynamic>("dbo.spGuests_Insert",
new { firstName, lastName },
connectionStringName,
true).First();
RoomTypeModel roomType = _db.LoadData <RoomTypeModel, dynamic>("select * from dbo.RoomTypes where Id = @Id",
new { Id = roomTypeId },
connectionStringName,
false).First();
TimeSpan timeStaying = endDate.Date.Subtract(startDate.Date);
List <RoomModel> availableRooms = _db.LoadData <RoomModel, dynamic>("dbo.spRooms_GetAvailableRooms",
new { startDate, endDate, roomTypeId },
connectionStringName,
true);
_db.SaveData("dbo.spBookings_insert",
new
{
roomId = availableRooms.First().Id,
guestId = guest.Id,
startDate = startDate,
endDate = endDate,
totalCost = timeStaying.Days * roomType.Price
},
connectionStringName,
true);
}
public static RoomTypeModel GetRoomTypeModel(int id)
{
RoomTypeModel rt = null;
SqlConnection conn = Connection.GetConnection();
if (conn != null)
{
string sql = "select * from RoomType where RoomTypeID = @id";
SqlCommand cm = new SqlCommand(sql, conn);
cm.Parameters.AddWithValue("@id", id);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
if (rs.Read())
{
rt = new RoomTypeModel();
rt.RoomTypeID = rs.GetInt32(0);
rt.RoomStyle = RoomStyleDAO.GetRoomStyle(rs.GetInt32(1));
rt.RoomSize = RoomSizeDAO.GetRoomSize(rs.GetInt32(2));
rt.Price = rs.GetInt32(3);
rt.Description = rs.GetString(4);
}
}
conn.Close();
}
;
return(rt);
}
public async Task RoomService_AddRoomTypeAsync_Test()
{
try
{
using (var db = new DatabaseContext(dbContextOpt.Options))
{
var userId = Guid.Parse("AC087774-4D7C-47CA-A926-373D9A6C580A");
var propertyId = Guid.Parse("D95FF806-C50A-4A54-A476-02D350B2C6FA");
var roomTypeModel = new RoomTypeModel
{
Type = "Double Occupancy",
Price = 6000,
PropertyId = propertyId
};
var roomType = new RoomTypes
{
Id = Guid.NewGuid(),
Type = roomTypeModel.Type,
Price = roomTypeModel.Price,
PropertyId = roomTypeModel.PropertyId
};
db.RoomTypes.Add(roomType);
await db.SaveChangesAsync();
}
}
catch (Exception ex)
{
logService.Log("Add Room Type", ex.InnerException.Message, ex.Message, ex.StackTrace);
Assert.Fail();
}
}
public static List <RoomTypeModel> GetAllRoomTypeModel()
{
List <RoomTypeModel> list = new List <RoomTypeModel>();
SqlConnection conn = Connection.GetConnection();
if (conn != null)
{
string sql = "select * from RoomType";
SqlCommand cm = new SqlCommand(sql, conn);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
RoomTypeModel rt = new RoomTypeModel();
rt.RoomTypeID = rs.GetInt32(0);
rt.RoomStyle = RoomStyleDAO.GetRoomStyle(rs.GetInt32(1));
rt.RoomSize = RoomSizeDAO.GetRoomSize(rs.GetInt32(2));
rt.Price = rs.GetInt32(3);
rt.Description = rs.GetString(4);
list.Add(rt);
}
}
conn.Close();
}
;
return(list);
}
public IEnumerable <BookingViewModel> GetAllBookings()
{
using (HotelDBContext _hotelEntities = new HotelDBContext())
{
var data = _hotelEntities.Bookings.ToList();
List <BookingViewModel> bookingList = new List <BookingViewModel>();
for (var i = 0; i < data.Count; i++)
{
BookingViewModel bookingView = new BookingViewModel();
bookingView.Id = data[i].Id;
bookingView.InvoiceNumber = data[i].InvoiceNumber;
bookingView.HotelId = Convert.ToInt32(data[i].HotelId);
bookingView.RoomId = Convert.ToInt32(data[i].RoomId);
RoomTypeModel roomModel = GetAllRoomType().SingleOrDefault(x => x.Id == bookingView.RoomId);
bookingView.FromDate = roomModel.RoomName;
bookingView.ToDate = roomModel.RoomName;
bookingView.BookingDate = roomModel.RoomName;
bookingView.Adult = data[i].Adult;
bookingView.Children = data[i].Children;
bookingView.BuyingPrice = data[i].BuyingPrice;
bookingList.Add(bookingView);
}
return(bookingList);
}
}
/// <summary>
/// Insert a new value in the list
/// </summary>
/// <param name=<em>"value"</em>>New value to be inserted</param>
// POST: api/RoomType
public IHttpActionResult Post(RoomTypeModel country)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new HTMEntities3())
{
ctx.RoomTypes.Add(new RoomType()
{
id = country.id,
RoomName = country.RoomName,
Description = country.Description,
BedId = country.BedId,
RoomStatusId = country.RoomStatusId,
Code = country.Code,
Max_Child_No = country.Max_Child_No,
Max_Adult_No = country.Max_Adult_No,
InsertedOn = country.InsertedOn,
InsertedBy = country.InsertedBy,
IsActive = country.IsActive,
IsDelete = country.IsDelete
});
ctx.SaveChanges();
}
return(Ok());
}
public static bool flag(RoomTypeModel room)
{
if (room.RTID1 == -1)
{
return(false);
}
return(true);
}
public ActionResult SaveRoomType(RoomTypeModel model)
{
if (model != null)
{
_IRoomTypeMasterService.Save(model);
}
return(View());
}
//添加房间
private void btnAddRoom_Click(object sender, EventArgs e)
{
RoomTypeModel room = new RoomTypeModel();
room.RTID1 = -1;
EditingRoomForm editing = new EditingRoomForm(room);
editing.Show();
}
public void BookGuest(string firstName, string lastName, DateTime startDate, DateTime endDate, int roomTypeId)
{
string sql = @"select 1 from Guests where FirstName = @firstName and LastName = @lastName";
int results = _db.LoadData <dynamic, dynamic>(sql, new { firstName, lastName }, connectionStringName).Count();
if (results == 0)
{
sql = @"insert into Guests (FirstName, LastName)
values (@firstName, @lastName);" ;
_db.SaveData(sql, new { firstName, lastName }, connectionStringName);
}
sql = @"select [Id], [FirstName], [LastName]
from Guests
where FirstName = @firstName and LastName = @lastName LIMIT 1;" ;
GuestModel guest = _db.LoadData <GuestModel, dynamic>(sql,
new { firstName, lastName },
connectionStringName).First();
RoomTypeModel roomType = _db.LoadData <RoomTypeModel, dynamic>("select * from RoomTypes where Id = @Id",
new { Id = roomTypeId },
connectionStringName).First();
TimeSpan timeStaying = endDate.Date.Subtract(startDate.Date);
sql = @"select r.*
from Rooms r
inner join RoomTypes t on t.Id = r.RoomTypeId
where r.RoomTypeId = @roomTypeId
and r.Id not in (
select b.RoomId
from Bookings b
where (@startDate < b.StartDate and @endDate > b.EndDate)
or (b.StartDate <= @endDate and @endDate < b.EndDate)
or (b.StartDate <= @startDate and @startDate < b.EndDate)
);" ;
List <RoomModel> availableRooms = _db.LoadData <RoomModel, dynamic>(sql,
new { startDate, endDate, roomTypeId },
connectionStringName);
sql = @"insert into Bookings(RoomId, GuestId, StartDate, EndDate, TotalCost)
values (@roomId, @guestId, @startDate, @endDate, @totalCost);" ;
_db.SaveData(sql,
new
{
roomId = availableRooms.First().Id,
guestId = guest.Id,
startDate = startDate,
endDate = endDate,
totalCost = timeStaying.Days * roomType.Price
},
connectionStringName);
}
public void Clear()
{
CheckIn = new CheckInModel();
Guests.Clear();
Services.Clear();
RoomType = new RoomTypeModel();
GuestDocuments.Clear();
roominess = roomNumber = -1;
id = 0;
}
public void CreateRoomType(RoomTypeModel obj, ref string roomtype, ref int retcode, ref string retmesg)
{
try
{
data.CreateRoomType(obj, ref roomtype, ref retcode, ref retmesg);
}
catch (Exception)
{
}
}
//修改房间
private void btnUpdateRomm_Click(object sender, EventArgs e)
{
int index = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value);
string name = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[1].Value.ToString();
int minMoney = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value);
int flag = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[3].Value);
int count = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[4].Value);
RoomTypeModel room = new RoomTypeModel(index, name, minMoney, flag, count);
EditingRoomForm editing = new EditingRoomForm(room);
editing.Show();
}
public void Save(RoomTypeModel model)
{
RoomTypeMaster _objData = new RoomTypeMaster();
_objData.RoomTypeName = model.RoomTypeName;
_objData.RoomTypeCode = model.RoomTypeCode;
_objData.ActiveStatus = model.ActiveStatus;
_objData.UniqueID = Guid.NewGuid().ToString();
_Repository.Add(_objData);
_Repository.Save();
}
private void OnSelectedRoomTypeItem(object sender, ItemTappedEventArgs e)
{
RoomTypeModel md = (RoomTypeModel)lv_room_type.SelectedItem;
int cnt = Vm.RoomTypeList.IndexOf(md);
if (cnt >= 0)
{
Vm.RoomTypeSelection(cnt);
}
((ListView)sender).SelectedItem = null;
}
public JsonResult CreateRoomType(RoomTypeModel objRoomType)
{
objRoomType.Code = new Locdau().LocDauChuoi(objRoomType.Name).ToUpper();
objRoomType.DouldBed = objRoomType.DouldBed < 0 ? 0: objRoomType.DouldBed;
objRoomType.SingBed = objRoomType.SingBed < 0 ? 0 : objRoomType.SingBed;
objRoomType.UserLimit = objRoomType.UserLimit < 0 ? 0 : objRoomType.UserLimit;
string mess = "";
string roomtype = "";
int retcode = 0;
new CRoomType().CreateRoomType(objRoomType, ref roomtype, ref retcode, ref mess);
return(Json(new { notifi = mess }, JsonRequestBehavior.AllowGet));
}
public async Task <int> AddRoomType([FromBody] RoomTypeModel roomTypeModel)
{
var roomType = new RoomType()
{
Name = roomTypeModel.Name,
Price = roomTypeModel.Price,
};
await _hotelContext.RoomTypes.AddAsync(roomType);
await _hotelContext.SaveChangesAsync();
return(roomType.RoomTypeId);
}
//删除房间
private void btnDeleteRoom_Click(object sender, EventArgs e)
{
int index = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value);
RoomTypeModel room = new RoomTypeModel();
room.RTID1 = index;
int result = RommBLL.getDelete(room);
if (result > 0)
{
MessageBox.Show("OK");
}
else
{
MessageBox.Show("NO");
}
}
public IEnumerable <RoomTypeModel> GetAllRoomType()
{
using (HotelDBContext _hotelEntities = new HotelDBContext())
{
var data = _hotelEntities.RoomTypes.ToList();
List <RoomTypeModel> roomList = new List <RoomTypeModel>();
for (var i = 0; i < data.Count; i++)
{
RoomTypeModel room = new RoomTypeModel();
room.Id = data[i].Id;
room.RoomName = data[i].RoomName;
roomList.Add(room);
}
return(roomList);
}
}
public async Task RoomApi_AddRoomTypeAsync_IntegrationTest()
{
var propertyId = Guid.Parse("BCEDAB95-5E70-4A0B-83DC-0053D28A7D8F");
var token = await GenerateTokenAsync();
client.DefaultRequestHeaders.Add("Authorization", $"Bearer {token.AccessToken}");
var roomTypeModel = new RoomTypeModel
{
Type = "4 person dorm aircon room",
Price = 3800,
PropertyId = propertyId
};
var payload = new StringContent(
JsonConvert.SerializeObject(roomTypeModel),
Encoding.UTF8,
"application/json"
);
try
{
var request = await client.PostAsync("api/v1/Room/type/add", payload);
var response = await request.Content.ReadAsStringAsync();
if (request.IsSuccessStatusCode)
{
var content = JsonConvert.DeserializeObject <ResponseModel>(response);
Assert.IsTrue(content.Status);
}
else
{
var resp = JsonConvert.DeserializeObject <ResponseModel>(response);
Assert.Fail(resp.Message);
}
}
catch (Exception ex)
{
logService.Log("API Endpoint: Add Room Type", ex.InnerException.Message, ex.Message, ex.StackTrace);
Assert.Fail(ex.Message);
}
}
public RoomTypeModel GetRoomById(int roomID)
{
using (HotelDBContext _hotelEntities = new HotelDBContext())
{
var data = _hotelEntities.RoomTypes.ToList();
List <RoomTypeModel> roomList = new List <RoomTypeModel>();
for (var i = 0; i < data.Count; i++)
{
RoomTypeModel model = new RoomTypeModel();
model.Id = data[i].Id;
model.RoomName = data[i].RoomName;
model.Amenities = data[i].Amenities;
roomList.Add(model);
}
RoomTypeModel getRoomData = roomList.SingleOrDefault(x => x.Id == roomID);
return(getRoomData);
}
}
public List <RoomTypeModel> OdaTurlerComboBoxDoldur()
{
List <RoomTypeModel> roomTypeModels = new List <RoomTypeModel>();
using (PGDatabase dbd = new PGDatabase())
{
string command = "select * from odatype ";
NpgsqlDataReader reader = dbd.Reader(command);
while (reader.Read())
{
RoomTypeModel roomType = new RoomTypeModel();
roomType.id = Convert.ToInt32(reader["id"]);
roomType.odaTurAdi = (reader["odaturadi"]).ToString();
roomTypeModels.Add(roomType);
}
reader.Close();
dbd.connClose();
}
return(roomTypeModels);
}
public async Task <IActionResult> PostRoomTypeAsync([FromBody] RoomTypeModel obj)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var response = await _roomService.AddRoomTypesAsync(obj);
_responseModel.Status = response.Status;
_responseModel.Message = response.Message;
if (_responseModel.Status)
{
return(Ok(_responseModel));
}
else
{
return(BadRequest(_responseModel));
}
}
public IActionResult RoomTypeSettings(RoomTypeModel model)
{
var list = new List <RoomTypeSettings>();
for (var i = 0; i < model.RoomTypeName.Count; i++)
{
var rateLevelsList = new List <RateLevel>();
for (var j = 0; j < model.RoomRateLevelsCount[i]; j++)
{
rateLevelsList.Add(new RateLevel());
}
list.Add(new RoomTypeSettings
{
RoomTypeName = model.RoomTypeName[i],
RateLevels = rateLevelsList
});
}
return(View(new RoomTypeSettingsModel {
CorrectList = list
}));
}
public void LoadData(int checkInId)
{
CheckIn = dbCrud.GetCheckIn(checkInId);
Guests = dbInfo.FindGuests(checkInId);
GuestDocuments = new List <GuestDocuments>();
foreach (GuestModel guest in Guests)
{
GuestDocuments.Add(new GuestDocuments(guest.Document.TrimEnd(' ')));
}
RoomModel room = dbCrud.GetRoom(CheckIn.RoomId);
Roominess = room.NumberOfPlaces;
RoomNumber = room.RoomNumber;
Services = new List <ServiceData>();
List <CheckInServiceModel> checkInServices = dbInfo.FindServices(checkInId);
foreach (CheckInServiceModel checkInServiceModel in checkInServices)
{
Services.Add(new ServiceData(dbCrud.GetService(checkInServiceModel.ServiceId), checkInServiceModel.Number));
}
RoomType = dbCrud.GetRoomType(room.TypeId);
}
private void btnOK_Click(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
int minMoney = Convert.ToInt32(txtMin.Text.Trim());
int flag = cb.Checked ? 1 : 0;
int count = Convert.ToInt32(txtCount.Text.Trim());
if (room.RTID1 == -1)
{
//添加
RoomTypeModel room2 = new RoomTypeModel(name, minMoney, flag, count);
int result = RommBLL.getAdd(room2);
if (result > 0)
{
MessageBox.Show("OK");
}
else
{
MessageBox.Show("NO");
}
}
else
{
//修改
RoomTypeModel room2 = new RoomTypeModel(room.RTID1, name, minMoney, flag, count);
int result = RommBLL.getUpdate(room2);
if (result > 0)
{
MessageBox.Show("OK");
}
else
{
MessageBox.Show("NO");
}
}
}
