public tblRoomMaster GetRoomByName(string RoomNo)
{
try
{
tblRoomMaster objOther = (from tbl in objData.tblRoomMasters
where tbl.RoomNo.Equals(RoomNo) &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
return(objOther);
}
catch (Exception ex)
{
throw ex;
}
}
public tblRoomMaster GetRoomByNameAndId(string RoomNo, int LedgerId)
{
try
{
tblRoomMaster objOther = (from tbl in objData.tblRoomMasters
where tbl.RoomId == LedgerId &&
tbl.RoomNo.Equals(RoomNo)
select tbl).FirstOrDefault();
return(objOther);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update(tblRoomMaster objT)
{
try
{
tblRoomMaster obj = (from tbl in objData.tblRoomMasters
where tbl.RoomId.Equals(objT.RoomId) &&
tbl.IsDelete == false
select tbl).FirstOrDefault();
obj.RoomNo = objT.RoomNo;
obj.FloorNo = objT.FloorNo;
obj.CategoryId = objT.CategoryId;
objData.SubmitChanges();
}
catch (Exception ex)
{
throw ex;
}
}
