//Update a record
public static int UpdateRecord(etblPropertyRoomMap eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var CheckRoomCodeExists = db.tblPropertyRoomMaps.Any(
p => p.iPropId == eobj.iPropId &&
p.iRoomId != eobj.iRoomId &&
p.sRoomCode == eobj.sRoomCode);
if (CheckRoomCodeExists == false)
{
OneFineRate.tblPropertyRoomMap obj = (OneFineRate.tblPropertyRoomMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomMap());
db.tblPropertyRoomMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
else
{
retval = 2;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public string UpdateStatus(int Id, bool Mode)
{
object result = null;
string strReturn = string.Empty;
try
{
obj = BL_tblPropertyRoomMap.GetSingleRecordById(Id);
obj.bActive = Mode ? true : false;
int i = BL_tblPropertyRoomMap.UpdateRecord(obj);
if (i == 1)
{
if (Mode)
{
result = new { st = 1, msg = "Room enabled Successfully ." };
}
else
{
result = new { st = 1, msg = "Room disabled Successfully ." };
}
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
catch (Exception)
{
result = new { st = 0, msg = "Kindly try after some time." };
}
strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strReturn);
}
public ActionResult Edit(int Id)
{
ViewBag.HeaderText = "Modify Room";
obj = BL_tblPropertyRoomMap.GetSingleRecordById(Id);
obj.Mode = "Edit";
obj.SizeType = obj.sSizeType;
decimal ft = (decimal)obj.dSizeSqft;
decimal mt = (decimal)obj.dSizeMtr;
if (obj.SizeType == "Sq.Mtr")
{
obj.dSizeSqft = mt;
obj.dSizeMtr = ft;
}
else
{
obj.dSizeSqft = ft;
obj.dSizeMtr = mt;
}
obj.AccessibilityItems = BL_tblRoomAccessibilityM.GetRoomAccessibility(obj.sRoomAccessibilityIds);
obj.BuildingcharacteristicsItems = BL_tblBuildingCharacteristicsM.GetBuildingCharacteristics(obj.sBuildingCharacteristicsIds);
obj.OutdoorViewItems = BL_tblRoomOutdoorViewM.GetRoomOutdoorViews(obj.sRoomOutdoorViewIds);
return(PartialView("_PropertyRoom", obj));
}
//Get Single Record
public static etblPropertyRoomMap GetSingleRecordById(int id)
{
etblPropertyRoomMap eobj = new etblPropertyRoomMap();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var dbobj = db.tblPropertyRoomMaps.SingleOrDefault(u => u.iRoomId == id);
if (dbobj != null)
{
eobj = (etblPropertyRoomMap)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj);
}
}
return(eobj);
}
//Add new record
public static int AddRecord(etblPropertyRoomMap eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
long RoomId = 0;
var CheckRoomCodeExists = db.tblPropertyRoomMaps.Any(
p => p.iPropId == eobj.iPropId &&
p.sRoomCode == eobj.sRoomCode);
if (CheckRoomCodeExists == false)
{
OneFineRate.tblPropertyRoomMap dbuser = (OneFineRate.tblPropertyRoomMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomMap());
db.tblPropertyRoomMaps.Add(dbuser);
db.SaveChanges();
RoomId = dbuser.iRoomId;
var CheckAllRoomExists = db.tblPropertyTaxMaps.Any(
p => p.iPropId == eobj.iPropId &&
p.iRoomId == null);
List <PropertyRoomTaxList> objPropTaxIdList = new List <PropertyRoomTaxList>();
if (CheckAllRoomExists == true)
{
objPropTaxIdList = (from t1 in db.tblPropertyTaxMaps
where t1.iPropId == eobj.iPropId && t1.iRoomId == null
select new PropertyRoomTaxList()
{
dtStayFrom = (DateTime)t1.dtStayFrom,
dtStayTo = (DateTime)t1.dtStayTo,
iPropId = t1.iPropId,
iRoomId = t1.iRoomId,
iPropTaxId = t1.iPropTaxId,
cStatus = t1.cStatus
}).ToList();
#region Propperty Room Tax List
if (objPropTaxIdList != null)
{
List <PropertyRoomTaxList> LPRPC = new List <PropertyRoomTaxList>();
for (int i = 0; i < objPropTaxIdList.Count; i++)
{
DateTime CurrentDate = (DateTime)objPropTaxIdList[i].dtStayFrom;
while (CurrentDate <= objPropTaxIdList[i].dtStayTo)
{
PropertyRoomTaxList PRPC = new PropertyRoomTaxList();
PRPC.dtStay = CurrentDate;
PRPC.iPropTaxId = objPropTaxIdList[i].iPropTaxId;
PRPC.iPropId = objPropTaxIdList[i].iPropId;
PRPC.iRoomId = RoomId;
PRPC.iActionBy = (int)eobj.iActionBy;
PRPC.dtActionDate = DateTime.Now;
PRPC.cStatus = objPropTaxIdList[i].cStatus;
LPRPC.Add(PRPC);
CurrentDate = CurrentDate.AddDays(1);
}
}
if (LPRPC != null)
{
db.tblPropertyRoomTaxMaps.AddRange(LPRPC.Select(m => new tblPropertyRoomTaxMap()
{
dtStay = m.dtStay,
iPropTaxId = m.iPropTaxId,
iPropId = m.iPropId,
iRoomId = (long)m.iRoomId,
dtActionDate = m.dtActionDate,
iActionBy = m.iActionBy,
cStatus = m.cStatus
}));
db.SaveChanges();
}
}
#endregion
}
retval = 1;
}
else
{
retval = 2;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public ActionResult Add(etblPropertyRoomMap eObj)
{
object result = null;
try
{
if (ModelState.IsValid)
{
decimal?sqft = 0, sqmtr = 0;
sqft = eObj.dSizeSqft;
sqmtr = eObj.dSizeMtr;
if (eObj.SizeType == "Sq.Mtr")
{
eObj.dSizeSqft = sqmtr;
eObj.dSizeMtr = sqft;
}
//get all room accessbility comma seperated
if (eObj.SelectedAccessibility != null)
{
eObj.sRoomAccessibilityIds = eObj.SelectedAccessibility.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + ", " + s2);
}
//get all room building characteristics comma seperated
if (eObj.SelectedBuildingcharacteristics != null)
{
eObj.sBuildingCharacteristicsIds = eObj.SelectedBuildingcharacteristics.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + ", " + s2);
}
//get all room building characteristics comma seperated
if (eObj.SelectedOutdoorView != null)
{
eObj.sRoomOutdoorViewIds = eObj.SelectedOutdoorView.Select(i => i.ToString(CultureInfo.InvariantCulture)).Aggregate((s1, s2) => s1 + ", " + s2);
}
eObj.dtActionDate = DateTime.Now;
eObj.bActive = true;
eObj.sSizeType = eObj.SizeType;
if (eObj.Mode == "Add")
{
eObj.iPropId = Convert.ToInt32(Session["PropId"]);
eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
int j = BL_tblPropertyRoomMap.AddRecord(eObj);
if (j == 1)
{
result = new { st = 1, msg = "Added Successfully ." };
}
else if (j == 2)
{
result = new { st = 0, msg = "Room Code already exists" };
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
else
{
eObj.iActionBy = ((OneFineRateBLL.BL_Login.UserDetails)Session["UserDetails"]).iUserId;
int i = BL_tblPropertyRoomMap.UpdateRecord(eObj);
if (i == 1)
{
result = new { st = 1, msg = "Updated Successfully ." };
}
else if (i == 2)
{
result = new { st = 0, msg = "Room Code already exists" };
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
}
else
{
string errormsg = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
errormsg += error.ErrorMessage;
errormsg += "</br>";
}
}
result = new { st = 0, msg = errormsg };
}
}
catch (Exception)
{
result = new { st = 0, msg = "Kindly try after some time." };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
