void ShowBill(int id)
{
lsvBill.Items.Clear();
Room room = lsvBill.Tag as Room;
txbNameRoom.Text = room.Roomname;
TypeRoom roomtype = TypeRoomDAO.Instance.GetTypeRoomById(room.TypeRoom);
txbPriceRoom.Text = roomtype.PriceRoom.ToString();
txbDeposit.Text = (roomtype.Deposits * roomtype.PriceRoom / 100).ToString();
float totalprice = roomtype.PriceRoom - roomtype.PriceRoom * roomtype.Deposits / 100;
int idcus = BookRoomDAO.Instance.GetIdcusByIrRoom(room.IdRoom);
Customer cus = CustomerDAO.Instance.GetCustomerById(idcus);
txbNameCus.Text = cus.CustomerName;
List <DTO.Menu> listBillInfo = MenuDAO.Instance.GetListMenuByTable(id);
foreach (DTO.Menu item in listBillInfo)
{
ListViewItem lsvItem = new ListViewItem(item.ServiceName.ToString());
lsvItem.SubItems.Add(item.Count.ToString());
lsvItem.SubItems.Add(item.PriceService.ToString());
lsvItem.SubItems.Add(item.Totalprice.ToString());
totalprice += item.Totalprice;
lsvBill.Items.Add(lsvItem);
}
CultureInfo culture = new CultureInfo("vi-VN");
Thread.CurrentThread.CurrentCulture = culture;
txbTotalPrice.Text = totalprice.ToString("c");
}
private void TypeRoomsGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
TypeRoom obj = TypeRoomsGrid.SelectedItem as TypeRoom;
string name = obj.NameTypeRoom;
Console.WriteLine("==================>>>>>>>>>>> room selected: " + $"{obj.Id} " + $"{name}");
}
public TypeRoom GetTypeRoomByIdRoom(int id)
{
SqlConnection connection = new SqlConnection(this.connString);
String sqlSelect = "GetTypeRoomByIdRoom";
SqlDataAdapter sqlDataAdapterClient = new SqlDataAdapter();
sqlDataAdapterClient.SelectCommand = new SqlCommand();
sqlDataAdapterClient.SelectCommand.CommandText = sqlSelect;
sqlDataAdapterClient.SelectCommand.Connection = connection;
sqlDataAdapterClient.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlDataAdapterClient.SelectCommand.Parameters.Add(new SqlParameter("@id", id));
DataSet dataSetTypeRooms = new DataSet();
sqlDataAdapterClient.Fill(dataSetTypeRooms, "TypeRoom");
sqlDataAdapterClient.SelectCommand.Connection.Close();
DataRowCollection dataRowCollection = dataSetTypeRooms.Tables["TypeRoom"].Rows;
TypeRoom typeRoom = new TypeRoom();
foreach (DataRow currentRow in dataRowCollection)
{
typeRoom.id = Int32.Parse((currentRow["id"]).ToString());
typeRoom.quantityperson = Int32.Parse(currentRow["quantityperson"].ToString());
typeRoom.quantitybed = Int32.Parse(currentRow["quantitybed"].ToString());
typeRoom.description = currentRow["description"].ToString();
typeRoom.amount = Convert.ToInt32(currentRow["amount"]);
typeRoom.urlimage = currentRow["urlimage"].ToString();
typeRoom.descriptiontyperoom = currentRow["descriptiontyperoom"].ToString();
}//Fin del foreach.
return(typeRoom);
}//
public async Task <IActionResult> Edit(int id, [Bind("ID,Name,Price,IsDelete")] TypeRoom typeRoom)
{
if (id != typeRoom.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(typeRoom);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TypeRoomExists(typeRoom.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(typeRoom));
}
public async Task <IActionResult> Create([FromForm] TypeRoom model)
{
ViewBag.services = await _context.Services.ToListAsync();
if (model.Price.ToString() == "0")
{
ModelState.AddModelError(string.Empty, "Vui lòng chọn mức giá");
return(View("/Views/Admin/Room/TypeRoomCreate.cshtml"));
}
if (ModelState.IsValid)
{
model.CreatedAt = DateTime.Now;
model.Rate = 5;
await _context.TypeRooms.AddAsync(model);
await _context.SaveChangesAsync();
ViewBag.message = "Thêm loại phòng thành công";
ModelState.Clear();
return(View("/Views/Admin/Room/TypeRoomCreate.cshtml"));
}
return(View("/Views/Admin/Room/TypeRoomCreate.cshtml"));
}
public TypeRoom[] getAll()
{
using (SqlConnection connection = new SqlConnection())
{
connection.ConnectionString = this._connectionString;
connection.Open();
using (SqlCommand command = new SqlCommand(_querySelectAllRoom, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
List<TypeRoom> myListRooms = new List<TypeRoom>();
while (reader.Read())
{
TypeRoom Room = new TypeRoom();
Room.Id = (int)reader["Id"];
Room.Name = (string)reader["Name"];
Room.Description = (string)reader["Description"];
Room.Price = (decimal)reader["Price"];
myListRooms.Add(Room);
}
return myListRooms.ToArray();
}
}
}
}
private void txbRoomID_TextChanged(object sender, EventArgs e)
{
try
{
if (dgvRoom.SelectedCells.Count > 0)
{
int id = (int)dgvRoom.SelectedCells[0].OwningRow.Cells["TypeRoom"].Value;
TypeRoom typeroom = TypeRoomDAO.Instance.GetTypeRoomById(id);
cbTypeRoom.SelectedItem = typeroom;
int index = -1;
int i = 0;
foreach (TypeRoom item in cbTypeRoom.Items)
{
if (item.Id == typeroom.Id)
{
index = i;
break;
}
i++;
}
cbTypeRoom.SelectedIndex = index;
}
}
catch
{
}
}
public Room(TypeRoom type, int id)
{
this.TypeOfRoom = type;
this.Id = id;
switch (type)
{
case TypeRoom.Econom:
Price = 300;
SleepingPlaces = 1;
break;
case TypeRoom.Standart:
Price = 500;
SleepingPlaces = 2;
break;
case TypeRoom.Lux:
Price = 800;
SleepingPlaces = 3;
break;
case TypeRoom.President:
Price = 1000;
SleepingPlaces = 4;
break;
}
}
public void Add(TypeRoom typeRoom)
{
var Cmd = _context.CreateCommand();
typeRoom.CreateDate = DateTime.UtcNow;
Cmd.CommandText = "INSERT INTO [TypeRoom]([Id],[Name],[IsShow],[Note],[CreateDate])"
+ " VALUES(@Id,@Name,@IsShow,@Note,@CreateDate)";
Cmd.Parameters.Add("Id", SqlDbType.UniqueIdentifier).Value = typeRoom.Id;
Cmd.AddParameters("Name", typeRoom.Name);
Cmd.AddParameters("IsShow", typeRoom.IsShow);
Cmd.AddParameters("Note", typeRoom.Note);
Cmd.AddParameters("CreateDate", typeRoom.CreateDate);
bool rt = Cmd.command.ExecuteNonQuery() > 0;
Cmd.cacheStartsWithToClear(CacheKeys.TypeRoom.StartsWith);
Cmd.Close();
if (!rt)
{
throw new Exception("Add TypeRoom false");
}
}
public ActionResult DeleteConfirmed(int id)
{
TypeRoom typeRoom = db.TypesRooms.Find(id);
db.TypesRooms.Remove(typeRoom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
TypeRoom typeRoom = db.TypeRooms.Find(id);
typeRoom.Deleted = true;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Data(int id)
{
TypeRoomModel typeRoomModel = new TypeRoomModel(connectionString);
TypeRoom typeroom = typeRoomModel.GetTypeRoomByIdRoom(id);
ViewBag.TypeRoom = typeroom;
return(View());
}
public void Add(TypeRoom model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
entities.TypeRooms.Add(model);
entities.SaveChanges();
}
}
public ReservationCreateRoomViewModel(string id, string num, TypeRoom roomType, decimal pricePerAdult, decimal pricePerChild, bool isFree)
{
this.Id = id;
this.number = num;
this.RoomType = roomType;
this.PriceForAdult = pricePerAdult;
this.PriceForKid = pricePerChild;
this.IsFree = isFree;
}
public void Delete(TypeRoom model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.TypeRooms.FirstOrDefault(e => e.Id == model.Id);
entities.TypeRooms.Remove(item);
entities.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "TypeRoomID,TitleTypeRoom,ComfortableTemperature,AirChange")] TypeRoom typeRoom)
{
if (ModelState.IsValid)
{
db.Entry(typeRoom).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(typeRoom));
}
public JsonResult GetManageRooms(string description)
{
RepositoryTypeRoom repositoryTyperoom = new RepositoryTypeRoom(connectionString);
List <TypeRoom> typeRoom = repositoryTyperoom.GetAllTypeRoom();
TypeRoom typeRoomNew = new TypeRoom();
typeRoomNew = typeRoom.Find(r => r.description == description);
counter = description;
return(Json(typeRoomNew));
}
public static async Task Initializer(this DatabaseContext context, IServiceProvider provider)
{
//Иницилизация ролей
{
foreach (RolesOptions role in Enum.GetValues(typeof(RolesOptions)))
{
var roleForAdd = await context.Roles.SingleOrDefaultAsync(x => x.Id == role);
if (roleForAdd == null)
{
roleForAdd = new Role(role, Enum.GetName(typeof(RolesOptions), role));
await context.Roles.AddAsync(roleForAdd);
}
}
}
//Иницилизация типов комнат
{
foreach (RoomOptions typeRoom in Enum.GetValues(typeof(RoomOptions)))
{
var typeRoomForAdd = await context.TypeRooms.SingleOrDefaultAsync(x => x.Id == typeRoom);
if (typeRoomForAdd == null)
{
typeRoomForAdd = new TypeRoom(typeRoom, Enum.GetName(typeof(RoomOptions), typeRoom));
await context.TypeRooms.AddAsync(typeRoomForAdd);
}
}
}
//Иницилизация админа
{
var admin = await context.Users.SingleOrDefaultAsync(x =>
x.Fio == "admin" && x.RoleId == RolesOptions.Admin);
if (admin == null)
{
var hashProvider = provider.GetService <IPasswordHasher <User> >();
var passwordSalt = "uigu93gtuh";
var password = "******";
var resultHash = hashProvider.HashPassword(null, password + passwordSalt);
admin = new User
{
Id = Guid.NewGuid(),
Email = "admin",
Fio = "admin",
PasswordSalt = passwordSalt,
PasswordHash = resultHash,
PhoneNumber = "adminNumber",
RoleId = RolesOptions.Admin,
};
await context.Users.AddAsync(admin);
}
}
await context.SaveChangesAsync();
}
public async Task <IActionResult> Create([Bind("ID,Name,Price,IsDelete")] TypeRoom typeRoom)
{
if (ModelState.IsValid)
{
_context.Add(typeRoom);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(typeRoom));
}
public ActionResult Create([Bind(Include = "TypeRoomID,TitleTypeRoom,ComfortableTemperature,AirChange")] TypeRoom typeRoom)
{
if (ModelState.IsValid)
{
db.TypesRooms.Add(typeRoom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(typeRoom));
}
public List <TypeRoom> GetListTypeRoom()
{
List <TypeRoom> TypeRoomList = new List <TypeRoom>();
string query = "select * from TypeRoom";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
TypeRoom typeroom = new TypeRoom(item);
TypeRoomList.Add(typeroom);
}
return(TypeRoomList);
}
public TypeRoom GetTypeRoomById(int id)
{
TypeRoom typeRoom = null;
string query = "select * from TypeRoom where id= " + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
typeRoom = new TypeRoom(item);
return(typeRoom);
}
return(typeRoom);
}
// GET: TypeRooms/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TypeRoom typeRoom = db.TypesRooms.Find(id);
if (typeRoom == null)
{
return(HttpNotFound());
}
return(View(typeRoom));
}
public ActionResult Edit([Bind(Include = "TypeRoomID,NameRoom,Capacity,Price,Description,Deleted")] TypeRoom typeRoom, HttpPostedFileBase image1)
{
if (ModelState.IsValid)
{
if (image1 != null)
{
typeRoom.Image = new byte[image1.ContentLength];
image1.InputStream.Read(typeRoom.Image, 0, image1.ContentLength);
}
db.Entry(typeRoom).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(typeRoom));
}
public void UpdateIsDeleted(TypeRoom model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.TypeRooms.FirstOrDefault(e => e.Id == model.Id);
if (item != null)
{
item.isDeleted = true;
entities.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "TypeRoomID,NameRoom,Capacity,Price,Description")] TypeRoom typeRoom, HttpPostedFileBase image2)
{
if (ModelState.IsValid)
{
if (image2 != null)
{
typeRoom.Image = new byte[image2.ContentLength];
image2.InputStream.Read(typeRoom.Image, 0, image2.ContentLength);
}
db.TypeRooms.Add(typeRoom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(typeRoom));
}
private void Btn_Click1(object sender, EventArgs e)
{
txbIdRoom.Text = ((sender as Button).Tag as Room).IdRoom.ToString();
txbRoomName.Text = ((sender as Button).Tag as Room).Roomname;
TypeRoom typeroom = TypeRoomDAO.Instance.GetTypeRoomById(((sender as Button).Tag as Room).TypeRoom);
txbPriceRoom.Text = typeroom.PriceRoom.ToString();
txbNumBed.Text = typeroom.NumBed.ToString();
txbNumLight.Text = typeroom.NumLight.ToString();
txbTelevision.Text = typeroom.Television.ToString();
txbAir.Text = typeroom.AirCondition.ToString();
txbNameType.Text = typeroom.NameTypeRoom;
txbDeposits.Text = typeroom.Deposits.ToString();
RoomDAO.RoomChoose = Convert.ToInt32(txbIdRoom.Text);
RoomDAO.DateCheckIn = dtpCheckin.Value;
RoomDAO.DateCheckOut = dtpCheckout.Value;
}
public void Update(TypeRoom model)
{
using (var entities = new QuanLyKhachSanDbContext())
{
var item = entities.TypeRooms.FirstOrDefault(e => e.Id == model.Id);
if (item != null)
{
item.Id = model.Id;
item.NameTypeRoom = model.NameTypeRoom;
item.Price = model.Price;
item.NumberOfCustomer = model.NumberOfCustomer;
entities.Entry(item).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
}
}
public RoomTypeRoomVM Room(int id)
{
Room room = UnitOfWork.Instance.RoomRepository.Get(id).ToClient();
TypeRoom typeroom = UnitOfWork.Instance.TypeRoomRepository.Get(room.Id_type_room).ToClient();
return(new RoomTypeRoomVM
{
RoomId = room.Id,
Price = typeroom.Price,
Add_info = room.Add_info,
Capacity = typeroom.Capacity,
Kichen = typeroom.Kichen,
Tub = typeroom.Tub,
Num = room.Num,
Type_name = typeroom.Type_name,
TypeRoomId = typeroom.Id,
});
}
public IHttpActionResult Update(Guid id, [FromBody] TypeRoom room)
{
HttpResponseDTO <int> response = new HttpResponseDTO <int>();
try
{
response.code = 0;
response.message = Constanst.SUCCESS;
response.data = typeRoomBL.Update(id, room);
}
catch (Exception e)
{
response.code = 500;
response.message = Constanst.FAIL;
response.data = 0;
}
return(Ok(response));
}
public async Task <IActionResult> Update([FromForm] TypeRoom model, int id)
{
ViewBag.services = await _context.Services.ToListAsync();
if (model.Price.ToString() == "0")
{
ModelState.AddModelError(string.Empty, "Vui lòng chọn mức giá");
return(View("/Views/Admin/Room/TypeRoomCreate.cshtml"));
}
if (ModelState.IsValid)
{
var found = await _context.TypeRooms.FindAsync(id);
if (found != null)
{
found.Name = model.Name;
found.Description = model.Description;
found.Price = model.Price;
found.Thumbnail = model.Thumbnail;
var roomServices = _context.RoomServices.Where(item => item.TypeRoomId == found.Id);
foreach (var item in roomServices)
{
_context.RoomServices.Remove(item);
}
await _context.SaveChangesAsync();
found.TypeRoomServices = model.TypeRoomServices;
await _context.SaveChangesAsync();
ViewBag.message = "Cập nhật loại phòng thành công";
return(Redirect("/admin/room/type/detail/" + id));
}
return(BadRequest("Không tồn tại loại phòng"));
}
return(View("/Views/Admin/Room/TypeRoomDetail.cshtml"));
}
