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));
}
