public ActionResult ModifyCommonAmenities(etblPropertyRoomAmentiesMap obj) { object result = null; try { if (ModelState.IsValid) { try { obj.dtActionDate = DateTime.Now; //get all basic rooms amenities comma seperated if (obj.SelectedBasicRoomAmenities != null) { obj.sBasicRoomAmenities = obj.SelectedBasicRoomAmenities.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all Additional amenities comma seperated if (obj.SelectedAdditionalAmenities != null) { obj.sAdditionalRoomAmenities = obj.SelectedAdditionalAmenities.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all bathroom amenities comma seperated if (obj.SelectedBathroomAmenities != null) { obj.sBathRoomAmenities = obj.SelectedBathroomAmenities.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } //get all Bedding and Linens comma seperated if (obj.SelectedBeddingandLinens != null) { obj.sBeddingRoomAmenities = obj.SelectedBeddingandLinens.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + "," + s2); } int j = BL_tblPropertyRoomAmentiesMap.UpdateRecord(obj); if (j == 1) { result = new { st = 1, msg = "Common Room Amenities Modified Successfully." }; } else { result = new { st = 0, msg = "Kindly try after some time." }; } } catch (Exception) { throw; } } } catch (Exception) { result = new { st = 0, msg = "Kindly try after some time." }; } return(Json(result, JsonRequestBehavior.AllowGet)); }
//Update a record public static int UpdateRecord(etblPropertyRoomAmentiesMap eobj) { bool Type = false; int retval = 0; using (OneFineRateEntities dbnew = new OneFineRateEntities()) { try { var dbobj = dbnew.tblPropertyRoomAmentiesMaps.SingleOrDefault(u => u.iPropId == eobj.iPropId); if (dbobj != null) { Type = true; } } catch (Exception) { throw; } } using (OneFineRateEntities db = new OneFineRateEntities()) { try { if (Type) { OneFineRate.tblPropertyRoomAmentiesMap obj = (OneFineRate.tblPropertyRoomAmentiesMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomAmentiesMap()); db.tblPropertyRoomAmentiesMaps.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); db.uspUpdateAmenitiesInLookup(eobj.iPropId, 0); retval = 1; } else { OneFineRate.tblPropertyRoomAmentiesMap dbuser = (OneFineRate.tblPropertyRoomAmentiesMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomAmentiesMap()); db.tblPropertyRoomAmentiesMaps.Add(dbuser); db.SaveChanges(); db.uspUpdateAmenitiesInLookup(eobj.iPropId, 0); retval = 1; } } catch (Exception) { throw; } } return(retval); }
//get Single record public static etblPropertyRoomAmentiesMap GetSingleRecordById(int id) { etblPropertyRoomAmentiesMap eobj = new etblPropertyRoomAmentiesMap(); using (OneFineRateEntities db = new OneFineRateEntities()) { var dbobj = db.tblPropertyRoomAmentiesMaps.SingleOrDefault(u => u.iPropId == id); if (dbobj != null) { eobj = (etblPropertyRoomAmentiesMap)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj); } } return(eobj); }
public ActionResult CommonAmenties() { try { objnew = BL_tblPropertyRoomAmentiesMap.GetSingleRecordById(Convert.ToInt32(Session["PropId"])); objnew.RoomAnenitiesRadio = BL_tblHotelRoomAmenityM.GetHotelRoomAmenityRadio(); objnew.iPropId = Convert.ToInt32(Session["PropId"]); objnew.BasicRoomAmenitiesItems = BL_tblHotelRoomAmenityM.GetHotelRoomAmenityCheckBox(objnew.sBasicRoomAmenities); objnew.AdditionalAmenitiesItems = BL_tblHotelRoomAmenityAdditionalM.GetHotelRoomAmenityAdditional(objnew.sAdditionalRoomAmenities); objnew.BathroomAmenitiesItems = BL_tblHotelRoomAmenityBathRoomM.GetHotelRoomAmenityBathRoom(objnew.sBathRoomAmenities); objnew.BeddingandLinensItems = BL_tblHotelRoomAmenityBeddingM.GetHotelRoomAmenityBedding(objnew.sBeddingRoomAmenities); } catch (Exception) { } return(View("CommonAmenities", objnew)); }
public ActionResult RoomAmenties(string id, string name) { try { objRoomType = BL_tblPropertyRoomTypeRoomAmentiesMap.GetSingleRecordById(Convert.ToInt32(id)); //get master commaon Amenities Data objnew = BL_tblPropertyRoomAmentiesMap.GetSingleRecordById(Convert.ToInt32(Session["PropId"])); //--Get Ids that would be disabled--------------------- if (objnew.sBasicRoomAmenities != null) { objRoomType.DisabledBasicRoomAmenities = objnew.sBasicRoomAmenities.Trim().Split(','); } if (objnew.sAdditionalRoomAmenities != null) { objRoomType.DisabledAdditionalAmenities = objnew.sAdditionalRoomAmenities.Trim().Split(','); } if (objnew.sBathRoomAmenities != null) { objRoomType.DisabledBathroomAmenities = objnew.sBathRoomAmenities.Trim().Split(','); } if (objnew.sBeddingRoomAmenities != null) { objRoomType.DisabledBeddingandLinens = objnew.sBeddingRoomAmenities.Trim().Split(','); } //----------------------------------------------- objRoomType.RoomAnenitiesRadio = BL_tblHotelRoomAmenityM.GetHotelRoomAmenityRadio(); objRoomType.iPropId = Convert.ToInt32(Session["PropId"]); objRoomType.iRoomId = Convert.ToInt32(id); objRoomType.BasicRoomAmenitiesItems = BL_tblHotelRoomAmenityM.GetHotelRoomAmenityCheckBox(objRoomType.sBasicRoomAmenities, objnew.sBasicRoomAmenities); objRoomType.AdditionalAmenitiesItems = BL_tblHotelRoomAmenityAdditionalM.GetHotelRoomAmenityAdditional(objRoomType.sAdditionalRoomAmenities, objnew.sAdditionalRoomAmenities); objRoomType.BathroomAmenitiesItems = BL_tblHotelRoomAmenityBathRoomM.GetHotelRoomAmenityBathRoom(objRoomType.sBathRoomAmenities, objnew.sBathRoomAmenities); objRoomType.BeddingandLinensItems = BL_tblHotelRoomAmenityBeddingM.GetHotelRoomAmenityBedding(objRoomType.sBeddingRoomAmenities, objnew.sBeddingRoomAmenities); objRoomType.iCommonBasicAmenitieRadio = objnew.iBasicAmentiesRadio; objRoomType.sRoomName = name; } catch (Exception) { } return(View("Amenities", objRoomType)); }