async protected void btnModificar_Click(object sender, EventArgs e) { if (ValidarModificar()) { Models.Hotel hotelModificado = new Models.Hotel(); Models.Hotel hotel = new Models.Hotel() { HOT_CODIGO = Convert.ToInt32(txtCodigo.Text), HOT_NOMBRE = txtNombre.Text, HOT_EMAIL = txtEmail.Text, HOT_DIRECCION = txtDireccion.Text, HOT_CATEGORIA = drpCategoria.SelectedValue.ToString(), HOT_TELEFONO = txtTelefono.Text }; hotelModificado = await hotelManager.Actualizar(hotel, VG.usuarioActual.CadenaToken); if (hotelModificado != null) { lblStatus.Text = "Hotel modificado correctamente"; lblStatus.Visible = true; InicializarControles(); } else { lblStatus.Text = "Hubo un error al modificar el hotel"; lblStatus.ForeColor = Color.Maroon; lblStatus.Visible = true; } } }
// POST: api/hotels public IHttpActionResult Add([FromBody] Models.Hotel hotel) { if (!ModelState.IsValid) { return(BadRequest("Data is not valid.")); } return(Ok(_hotelManager.CreateHotel(hotel))); }
public void OnGet() { RoleId = HttpContext.Session.GetInt32(Constants.UserRoleId).Value; int hotelId = HttpContext.Session.GetInt32(Constants.CurrentHotel).Value; using (var connection = new MySqlConnection(_configuration.GetConnectionString("Default"))) { Hotel = connection.QuerySingleOrDefault <Models.Hotel>("SELECT * FROM Hotel where HotelID = @HotelId;", new { HotelId = hotelId }); Rooms = connection.Query <Models.Room>("SELECT DISTINCT BedSize, BedCount, Description FROM Room where Hotel_HotelID = @HotelId;", new { HotelId = hotelId }); } }
public async Task <Models.Hotel> GetHotelByIdAsync(int id) { UriBuilder builder = new UriBuilder(AppSettings.HotelsEndpoint); builder.AppendToPath($"Hotels/{id}"); string uri = builder.ToString(); Models.Hotel hotel = await _requestService.GetAsync <Models.Hotel>(uri); return(hotel); }
private async void OnSelectHotelAsync(Models.Hotel item) { if (item != null) { var navigationParameter = new Dictionary <string, object> { { "hotel", item }, { "from", From }, { "until", Until }, }; await NavigationService.NavigateToAsync <BookingHotelViewModel>(navigationParameter); } }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } Hotel = await _context.Hotel.FirstOrDefaultAsync(m => m.Id == id); if (Hotel == null) { return(NotFound()); } return(Page()); }
public void OnGet() { RoleId = HttpContext.Session.GetInt32(Constants.UserRoleId).Value; int hotelId = HttpContext.Session.GetInt32(Constants.CurrentHotel).Value; int userId = HttpContext.Session.GetInt32(Constants.UserId).Value; using (var connection = new MySqlConnection(_configuration.GetConnectionString("Default"))) { Hotel = connection.QuerySingleOrDefault <Models.Hotel>("SELECT * FROM Hotel where HotelID = @HotelId;", new { HotelId = hotelId }); MyReservations = connection.Query(@" SELECT * FROM Reservation res, Room r WHERE r.Hotel_HotelID = @HotelId AND res.Room_RoomID = r.RoomID AND res.User_UserID = @UserID ORDER BY res.StartDate ASC", new { HotelId = hotelId, UserId = userId }); } }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } Hotel = await _context.Hotel.FindAsync(id); if (Hotel != null) { _context.Hotel.Remove(Hotel); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
//GET all hotels public List <Models.Hotel> GetHotels() { List <Models.Hotel> hotels = new List <Models.Hotel>(); var result = context.Hotels.ToList(); if (result != null) { foreach (var hotel in result) { Models.Hotel model = new Models.Hotel(); model.Address = hotel.Address; model.City = hotel.City; model.ContactNo = hotel.ContactNo; model.ContactPerson = hotel.ContactPerson; model.CreatedBy = hotel.CreatedBy; model.CreatedDate = hotel.CreatedDate; model.facebook = hotel.facebook; model.IsActive = hotel.IsActive; model.Name = hotel.Name; model.PinCode = hotel.PinCode; model.Twitter = hotel.Twitter; model.UpdatedBy = hotel.UpdatedBy; model.UpdatedDate = hotel.UpdatedDate; model.Website = hotel.Website; model.Id = hotel.Id; model.Rooms = new List <Models.Room>(); foreach (var item in hotel.Rooms) { Models.Room rooms = new Models.Room(); rooms.HotelId = item.HotelId; rooms.Name = item.Name; rooms.Category = item.Category; rooms.Price = item.Price; rooms.IsActive = item.IsActive; rooms.CreatedBy = item.CreatedBy; rooms.CreatedDate = DateTime.Today; rooms.UpdatedBy = item.UpdatedBy; rooms.UpdatedDate = DateTime.Today; model.Rooms.Add(rooms); } hotels.Add(model); } } return(hotels.OrderBy(x => x.Name).ToList()); }
private Models.Hotel ParseHotel(System.Data.DataRow row) { var hot = new Models.Hotel(); hot.Category = row["hot_categoria"].ToString(); hot.Code = int.Parse(row["hot_codigo"].ToString()); hot.Description = row["hot_descripcion"].ToString(); hot.Latitude = row["hot_latitud"].ToString(); hot.Longitude = row["hot_longitud"].ToString(); hot.Image = row["hot_imagen"].ToString(); hot.Name = row["hot_nombre"].ToString(); hot.Price = new Models.Price(); hot.Price.Board = row["hpm_regimen"].ToString(); hot.Price.CheckIn = DateTime.Parse(row["hpm_fechaEntrada"].ToString()); hot.Price.Nigths = int.Parse(row["HPM_noches"].ToString()); hot.Price.Pvp = decimal.Parse(row["HPM_pvp"].ToString()); return hot; }
protected async void grdHoteles_RowUpdating(object sender, GridViewUpdateEventArgs e) { Label lblCode = (Label)grdHoteles.Rows[e.RowIndex].Cells[0].FindControl("lblCodigoHotel"); string hotNombre = (grdHoteles.Rows[e.RowIndex].FindControl("txtHotNombre") as TextBox).Text.Trim(); string hotEmail = (grdHoteles.Rows[e.RowIndex].FindControl("txtHotEmail") as TextBox).Text.Trim(); string hotDireccion = (grdHoteles.Rows[e.RowIndex].FindControl("txtHotDireccion") as TextBox).Text.Trim(); string hotCategoria = (grdHoteles.Rows[e.RowIndex].FindControl("drpCategoriaEdit") as DropDownList).Text; string hotTelefono = (grdHoteles.Rows[e.RowIndex].FindControl("txtHotTelefono") as TextBox).Text.Trim(); if (ValidarModificar(hotNombre, hotEmail, hotDireccion, hotCategoria, hotTelefono)) { Models.Hotel hotelModificado = new Models.Hotel(); Models.Hotel hotel = new Models.Hotel() { HOT_CODIGO = Convert.ToInt32(lblCode.Text), HOT_NOMBRE = hotNombre, HOT_EMAIL = hotEmail, HOT_DIRECCION = hotDireccion, HOT_CATEGORIA = hotCategoria, HOT_TELEFONO = hotTelefono }; hotelModificado = await hotelManager.Actualizar(hotel, VG.usuarioActual.CadenaToken); if (hotelModificado != null) { //ScriptManager.RegisterStartupScript(this, this.GetType(), "ModalView", "<script>$(function() { $('#successModal').modal('show'); });</script>", false); lblStatus.Text = "Hotel modificado correctamente"; lblStatus.Visible = true; InicializarControles(); } else { lblStatus.Text = "Hubo un error al modificar el hotel"; lblStatus.ForeColor = Color.Maroon; lblStatus.Visible = true; } grdHoteles.EditIndex = -1; InicializarControles(); } }
private void Save_Click(object sender, RoutedEventArgs e) { HotelsData hotelsData = new HotelsData(); int.TryParse(textBoxTankCount.Text, out int count); int.TryParse(textBoxTankSize.Text, out int size); Hotels.Models.Hotel hotel = new Models.Hotel() { Name = textBoxName.Text, TanksCount = count, TankSize = size, Mobile = textBoxMobile.Text, Address = textBoxAdress.Text }; hotelsData.AddHotel(hotel); MessageBox.Show("تم الحفظ"); }
// POST hotels public Models.Hotel AddHotel(Models.Hotel hotel) { Database.Hotel model = new Database.Hotel(); model.Address = hotel.Address; model.City = hotel.City; model.ContactNo = hotel.ContactNo; model.ContactPerson = hotel.ContactPerson; model.CreatedBy = hotel.CreatedBy; model.CreatedDate = hotel.CreatedDate; model.facebook = hotel.facebook; model.IsActive = hotel.IsActive; model.Name = hotel.Name; model.PinCode = hotel.PinCode; model.Twitter = hotel.Twitter; model.UpdatedBy = hotel.UpdatedBy; model.UpdatedDate = hotel.UpdatedDate; model.Website = hotel.Website; model.Rooms = new List <Database.Room>(); foreach (var item in hotel.Rooms) { Database.Room rooms = new Database.Room(); // rooms.HotelId = item.HotelId; rooms.Name = item.Name; rooms.Category = item.Category; rooms.Price = item.Price; rooms.IsActive = item.IsActive; rooms.CreatedBy = item.CreatedBy; rooms.CreatedDate = DateTime.Today; rooms.UpdatedBy = item.UpdatedBy; rooms.UpdatedDate = DateTime.Today; model.Rooms.Add(rooms); } var result = context.Hotels.Add(model); context.SaveChanges(); return(hotel); }
public void Add(Models.Hotel h) { hrep.Add(h); Save(); }
public Collection <tcm.Hotel> GetHotels() { var fetchXml = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'> <entity name='tc_hotel'> <attribute name='tc_masterhotelid' /> <attribute name='tc_hotelid' /> <order attribute='tc_masterhotelid' descending='false' /> <link-entity name='tc_location' from='tc_locationid' to='tc_locationid' visible='false' link-type='outer' alias='a'> <attribute name='tc_regionid' /> </link-entity> </entity> </fetch>"; var hotels = new Collection <tcm.Hotel>(); int pageNumber = 1; string pagingCookie = null; int fetchCount = 10000; while (true) { string xml = CreateXml(fetchXml, pagingCookie, pageNumber, fetchCount); FetchExpression exp = new FetchExpression(xml); var records = orgService.RetrieveMultiple(exp); if (records == null || records.Entities.Count == 0) { return(null); } foreach (var item in records.Entities) { var h = new Models.Hotel { Code = item["tc_masterhotelid"].ToString(), Id = item.Id.ToString() }; if (item.Contains("a.tc_regionid")) { var alias = item["a.tc_regionid"]; if (alias != null) { var aliasValue = ((AliasedValue)alias).Value; if (aliasValue != null) { h.DestinationId = ((EntityReference)aliasValue).Id.ToString(); } } } hotels.Add(h); } ; if (records.MoreRecords) { pageNumber++; pagingCookie = records.PagingCookie; } else { break; } } return(hotels); }
public void Add(Models.Hotel h) { entities.Hotels.Add(h); }
public void Delete(Models.Hotel h) { entities.Hotels.Remove(h); }
public void Delete(Models.Hotel h) { hrep.Delete(h); Save(); }
public ActionResult Index(string id) { string key = HotelCloud.Common.HCRequest.GetString("key"); string hotelWeixinid = string.Empty; string userWeixinid = string.Empty; if (!string.IsNullOrEmpty(key) && key.Contains("@")) { List <string> list = key.Split('@').ToList(); hotelWeixinid = list[0]; userWeixinid = list[1]; hotel3g.Models.Cookies.SetCookies("userWeixinNO", userWeixinid, 30, hotelWeixinid); ViewData["hotelWeixinid"] = hotelWeixinid; ViewData["userWeixinid"] = userWeixinid; ViewData["generatesign"] = WeiXin.Common.ValidateSignProduct.GenerateSign(hotelWeixinid, userWeixinid); } int hid = Convert.ToInt32(id); ViewData["hid"] = hid; string firstimgurl = null; string MemberCardRuleJson = ActionController.getMemberCardIntegralRule(userWeixinid, hotelWeixinid); ViewData["MemberCardRuleJson"] = MemberCardRuleJson; Hashtable MemberCardRuleJsonobj = Newtonsoft.Json.JsonConvert.DeserializeObject <Hashtable>(MemberCardRuleJson); Hashtable ruletable = Newtonsoft.Json.JsonConvert.DeserializeObject <Hashtable>(MemberCardRuleJsonobj["rule"].ToString()); double graderate = WeiXinPublic.ConvertHelper.ToDouble(ruletable["GradeRate"]); ViewData["graderate"] = graderate; double reduce = WeiXinPublic.ConvertHelper.ToDouble(ruletable["Reduce"]); ViewData["reduce"] = reduce; int couponType = WeiXinPublic.ConvertHelper.ToInt(ruletable["CouponType"]); ViewData["couponType"] = couponType; string gradeName = WeiXinPublic.ConvertHelper.ToString(ruletable["GradeName"]); ViewData["gradeName"] = gradeName; DateTime indate = DateTime.Now.Date; DateTime outdate = DateTime.Now.AddDays(1).Date; if (!string.IsNullOrEmpty(HCRequest.GetString("indate")) && !string.IsNullOrEmpty(HCRequest.GetString("outdate"))) { if (HCRequest.getDate("outdate").Date <= DateTime.Now.Date.AddMonths(2)) { indate = HCRequest.getDate("indate"); outdate = HCRequest.getDate("outdate"); } } ViewData["indate"] = indate; ViewData["outdate"] = outdate; ViewData["ratejson"] = ActionController.getratejson(hid, indate, outdate, hotelWeixinid, graderate, out firstimgurl, reduce, couponType); Models.Hotel hotel = ActionController.gethotelinfo(hid, hotelWeixinid); ViewData["hotel"] = hotel; ViewData["firstimgurl"] = firstimgurl; //string commentopen = string.Empty; //string membershow = string.Empty; //string dingfangmember = string.Empty; //string sql = "select comment,showmemberprice,dingfang_MemberOnly from WeiXinNO with (nolock) where weixinId=@weixinId "; //DataTable db_open = SQLHelper.Get_DataTable(sql, SQLHelper.GetCon(), new Dictionary<string, DBParam>() // {{"weixinId",new DBParam(){ParamValue=hotelWeixinid}}, // }); //if (db_open.Rows.Count > 0) //{ // commentopen = db_open.Rows[0]["comment"].ToString(); // membershow = db_open.Rows[0]["showmemberprice"].ToString(); // dingfangmember = db_open.Rows[0]["dingfang_MemberOnly"].ToString(); //} //ViewData["commentopen"] = commentopen; //ViewData["membershow"] = membershow; //ViewData["dingfangmember"] = dingfangmember; ModuleAuthorityResponse ModuleAuthority = hotel3g.Models.DAL.AuthorityHelper.ModuleAuthority(hotelWeixinid); ViewData["commentopen"] = ModuleAuthority.comment; ViewData["membershow"] = ModuleAuthority.membership_price; ViewData["dingfangmember"] = ModuleAuthority.membership_room; //控制弹窗 ViewData["memberbasics"] = ModuleAuthority.module_memberbasics; BaseHotelCommentInfo baseHotelCommentInfo = new BaseHotelCommentInfo(); if (ModuleAuthority.comment == 1) { Comment comment = new Comment(); baseHotelCommentInfo = comment.GetBaseInfo(hid); } ViewData["baseHotelCommentInfo"] = baseHotelCommentInfo; var memberCardCustomList = new List <Models.Home.MemberCardCustom>(); var memberinfo = new Repository.MemberInfo(); if (ModuleAuthority.membership_price == 1) { memberinfo = hotel3g.Repository.MemberHelper.GetMemberInfo(hotelWeixinid); if (memberinfo == null) { memberinfo = new Repository.MemberInfo(); } } int ismember = Convert.ToBoolean(MemberCardRuleJsonobj["becomeMember"].ToString()) ? 0 : 1; if (ismember == 0 || ModuleAuthority.membership_price == 1) { int customcount = 0; DataTable db_CardCustom = MemberCardCustom.GetMemberCardCustomList(hotelWeixinid, out customcount, 1, 50, "", ""); memberCardCustomList = DataTableToEntity.GetEntities <Models.Home.MemberCardCustom>(db_CardCustom).ToList(); } ViewData["customlist"] = memberCardCustomList; ViewData["memberinfo"] = memberinfo; return(View()); }