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