//Update a record
public static int UpdateRecord(etblPropertyDiningMap eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblPropertyDiningMap obj = (OneFineRate.tblPropertyDiningMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyDiningMap());
db.tblPropertyDiningMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
//var checkExistsRestaurantName = db.tblPropertyDiningMaps.Any(
// p => p.iPropId == eobj.iPropId
// && p.iRestaurantID != eobj.iRestaurantID
// && p.sRestaurantName == eobj.sRestaurantName);
//if (checkExistsRestaurantName == false)
//{
//}
//else
//{
// retval = 2;
//}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//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);
}
//Update a record
public static int AddUpdateRecord(int propid, int ActionBy, DataTable PropertyRoomInventory, DataTable PropertyRoomRatePlanInventoryMap, Boolean Type)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
SqlParameter[] MyParam = new SqlParameter[5];
MyParam[0] = new SqlParameter("@PropertyRoomInventory", PropertyRoomInventory);
MyParam[0].TypeName = "[dbo].[PropertyRoomInventory]";
MyParam[1] = new SqlParameter("@PropertyRoomRatePlanInventoryMap", PropertyRoomRatePlanInventoryMap);
MyParam[1].TypeName = "[dbo].[PropertyRoomRatePlanInventoryMap]";
MyParam[2] = new SqlParameter("@iActionBy", ActionBy);
MyParam[3] = new SqlParameter("@iPropId", propid);
MyParam[4] = new SqlParameter("@CloseOut", Type);
db.Database.ExecuteSqlCommand("uspUpdateRateInventory @PropertyRoomInventory, @PropertyRoomRatePlanInventoryMap, @iActionBy, @iPropId,@CloseOut ", MyParam);
retval = 1;
}
catch (Exception)
{
retval = 0;
throw;
}
}
return(retval);
}
public static List <CheckBoxList> GetOnsiteRecreationFacilities(string data)
{
List <CheckBoxList> selectItems = null;
using (OneFineRateEntities db = new OneFineRateEntities())
{
string[] objSelectItems;
if (data != null)
{
objSelectItems = data.Split(',');
selectItems = (from am in db.tblOnsiteRecreationFacilitiesMs.ToList()
join si in objSelectItems.ToList() on am.iRecreationFacilityId equals Convert.ToInt32(si) into result
from r in result.DefaultIfEmpty()
select new CheckBoxList()
{
Text = am.sRecreationFacility,
Value = am.iRecreationFacilityId,
Selected = r == null ? false : true
}).ToList();
}
else
{
selectItems = db.tblOnsiteRecreationFacilitiesMs.Select(x => new CheckBoxList()
{
Text = x.sRecreationFacility,
Value = x.iRecreationFacilityId
}).ToList();
}
return(selectItems);
}
}
public static List <SelectListItem> StateList(int?stateID = null, int?countryID = null)
{
List <SelectListItem> states = new List <SelectListItem>();
if (!countryID.HasValue || countryID.Value == 0)
{
states.Insert(0, new SelectListItem()
{
Text = "Select", Value = "0"
});
return(states);
}
using (OneFineRateEntities dbContext = new OneFineRateEntities())
{
states = dbContext.tblStateMs.Where(state => state.iCountryId == countryID)
.Select(state => new SelectListItem()
{
Text = state.sState,
Value = state.iStateId.ToString(),
Selected = stateID == null ? false : true
}).OrderBy(state => state.Text).ToList();
states.Insert(0, new SelectListItem()
{
Text = "Select", Value = "0"
});
}
return(states);
}
//Update a record
public static int UpdateRecord(etblPropertyRoomRatePlanInventoryMap eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
//remove old mapings
db.tblPropertyRoomRatePlanInventoryMaps.RemoveRange(db.tblPropertyRoomRatePlanInventoryMaps.Where(x => x.iRoomId == eobj.iRoomId && x.dtInventoryDate == eobj.dtInventoryDate && x.iRPId == eobj.iRPId));
OneFineRate.tblPropertyRoomRatePlanInventoryMap obj = (OneFineRate.tblPropertyRoomRatePlanInventoryMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomRatePlanInventoryMap());
db.tblPropertyRoomRatePlanInventoryMaps.Add(obj);
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public static List <etblPropetyPhotoMap> GetMappedProperty(int propertyId)
{
var mappedPropetyPhotoList = new List <etblPropetyPhotoMap>();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var dbobjPropertyPhotoMapList = db.tblPropertyPhotoMaps.Where(x => x.iPropId == propertyId && x.bIsMapped == true).ToList();
if (dbobjPropertyPhotoMapList != null)
{
foreach (var item in dbobjPropertyPhotoMapList)
{
var eobj = (etblPropetyPhotoMap)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new etblPropetyPhotoMap());
eobj.ddliPhotoSubCatId = BL_tblPhotoCategoryM.GetSubcategoriesFromCategoryId(eobj.iPhotoCatId.HasValue ? eobj.iPhotoCatId.Value : 0, propertyId);
mappedPropetyPhotoList.Add(eobj);
}
}
//SqlParameter[] parameterValue = new SqlParameter[1];
//parameterValue[0] = new SqlParameter("@iPropId", propertyId);
//var data = db.Database.SqlQuery<DbDataRecord>("uspGetAllPropertyImagesWithHotelCount @iPropId", parameterValue);
}
return(mappedPropetyPhotoList);
}
//Add a record to guest details table
public static int AddRecord(eBiddingSearch eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
GuestUserDetails objDetail = new GuestUserDetails();
objDetail.Title = eobj.sUserTitle;
objDetail.FirstName = eobj.sUserFirstName;
objDetail.LastName = eobj.sUserLastName;
objDetail.Email = eobj.sUserEmail;
objDetail.PhoneNumber = eobj.sUserMobileNo;
OneFineRate.tblWebsiteGuestUserMaster dbuser = (OneFineRate.tblWebsiteGuestUserMaster)OneFineRateAppUtil.clsUtils.ConvertToObject(objDetail, new OneFineRate.tblWebsiteGuestUserMaster());
db.tblWebsiteGuestUserMasters.Add(dbuser);
db.SaveChanges();
retval = Convert.ToInt32(dbuser.Id);
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public static string getMappedMenus(int a)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
var groups = (from s in db.tblGroupMenuMs
select new
{
s.iGroupId,
s.iMenuId,
}).Where(u => u.iGroupId == a).AsQueryable();
var lstGroup = groups.ToList();
string groupArr = "";
foreach (var item in lstGroup)
{
groupArr += "{ \"id\" : " + item.iMenuId + "},";
}
try
{
groupArr = "[" + groupArr.Substring(0, groupArr.Length - 1) + "]";
}
catch (Exception)
{
groupArr = "[]";
}
return(groupArr);
}
}
//Update a record
public static int UpdateRecord(eCustomerPointsMap eobj)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblCustomerPointsMap obj = (OneFineRate.tblCustomerPointsMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblCustomerPointsMap());
db.tblCustomerPointsMaps.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw e;
}
catch (Exception ex)
{
throw ex;
}
}
}
public static eBidBookingResult UpdateBidBooking(int bookingId, int PropId)
{
try
{
eBidBookingResult model = new eBidBookingResult();
using (OneFineRateEntities db = new OneFineRateEntities())
{
SqlConnection objConn = default(SqlConnection);
DataSet ds = new DataSet();
objConn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());
objConn.Open();
SqlParameter[] MyParam = new SqlParameter[2];
MyParam[0] = new SqlParameter("@iBookingId", bookingId);
MyParam[1] = new SqlParameter("@iSelectedPropId", PropId);
ds = SqlHelper.ExecuteDataset(objConn, CommandType.StoredProcedure, "uspSaveBidHotel", MyParam);
if (ds.Tables.Count > 0)
{
if (ds.Tables[1].Rows.Count > 0)
{
model.ID = Convert.ToInt32(ds.Tables[1].Rows[0]["ID"]);
model.Message = Convert.ToString(ds.Tables[1].Rows[0]["Message"]);
model.Status = Convert.ToString(ds.Tables[1].Rows[0]["Status"]);
}
}
objConn.Close();
}
return(model);
}
catch (Exception)
{
throw;
}
}
//Update Rank
public static int UpdateRecord(etblRankManagement eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
bool checkExists = false;
checkExists = db.tblRankManagements.Any(
p => p.iPropId == eobj.iPropId &&
p.iID != eobj.iID &&
(((p.dtStartdate <= eobj.dtStartdate && p.dtEndDate >= eobj.dtStartdate) || (p.dtStartdate <= eobj.dtEndDate && p.dtEndDate >= eobj.dtEndDate)) ||
((eobj.dtStartdate <= p.dtStartdate && eobj.dtEndDate >= p.dtStartdate) || (eobj.dtStartdate <= p.dtEndDate && eobj.dtEndDate >= p.dtEndDate)))
);
if (checkExists != true)
{
OneFineRate.tblRankManagement obj = (OneFineRate.tblRankManagement)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblRankManagement());
db.tblRankManagements.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 AddUpdateRecord(etblAdditionalCommission eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@iAdditionalCommisionId", eobj.iAdditionalCommisionId),
new SqlParameter("@dtCommisionStartDate", eobj.dtCommisionStartDate),
new SqlParameter("@dtCommisionEndDate", eobj.dtCommisionEndDate),
new SqlParameter("@bActive", eobj.bActive),
new SqlParameter("@dCommission", eobj.dCommission),
new SqlParameter("@iPropId", eobj.iPropId),
new SqlParameter("@iActionBy", eobj.iActionBy)
};
retval = db.Database.SqlQuery <int>("uspSetAdditionalCommision @iAdditionalCommisionId, @dtCommisionStartDate,@dtCommisionEndDate, @bActive, @dCommission, @iPropId, @iActionBy", parameters).SingleOrDefault();
//OneFineRate.tblAdditionalCommision dbstate = (OneFineRate.tblAdditionalCommision)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblAdditionalCommision());
//db.tblAdditionalCommisions.Add(dbstate);
//db.SaveChanges();
//retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public static decimal GetPropertyCommission(int propertyId)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
return(db.tblBankDetailMs.Where(x => x.iPropId == propertyId).Select(x => x.dCommission).SingleOrDefault().GetValueOrDefault());
}
}
public IQueryable <TUser> GetAll()
{
List <TUser> users = new List <TUser>();
using (var db = new OneFineRateEntities())
{
var userList = db.tblWebsiteUserMaters.ToList();
foreach (var item in userList)
{
var user = (TUser)Activator.CreateInstance(typeof(TUser));
user.Id = item.Id;
user.FirstName = item.FirstName;
user.LastName = item.LastName;
user.DisplayName = item.DisplayName;
user.LockoutEnabled = item.LockoutEnabled;
user.LockoutEndDate = item.LockoutEndDateUtc;
user.ModifiedOn = item.ModifiedOn;
user.PasswordHash = item.PasswordHash;
user.PhoneNumber = item.PhoneNumber;
user.PhoneNumberConfirmed = item.PhoneNumberConfirmed;
user.SecurityStamp = item.SecurityStamp;
user.TwoFactorEnabled = item.TwoFactorEnabled;
user.UserName = item.UserName;
user.Email = item.Email;
user.AccessFailedCount = item.AccessFailedCount;
users.Add(user);
}
}
return(users.AsQueryable <TUser>());
}
//Delete a record
public static int DeleteRecord(int id)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
try
{
var obj1 = db.tblGroupMenuMs.Where(u => u.iGroupId == id);
db.tblGroupMenuMs.RemoveRange(obj1);
}
catch (Exception) { }
try
{
var obj1 = db.tblUserGroupMs.Where(u => u.iUserId == id);
db.tblUserGroupMs.RemoveRange(obj1);
}
catch (Exception) { }
var obj = db.tblGroupMs.SingleOrDefault(u => u.iGroupId == id);
db.tblGroupMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
public TUser GetById(long userId)
{
var user = (TUser)Activator.CreateInstance(typeof(TUser));
using (var db = new OneFineRateEntities())
{
try
{
db.Configuration.AutoDetectChangesEnabled = false;
var tblUser = db.tblWebsiteUserMaters.Find(userId);
if (tblUser != null)
{
user = (TUser)OneFineRateAppUtil.clsUtils.ConvertToObject(tblUser, new WebsiteUser());
}
}
catch (Exception)
{
throw;
}
finally
{
}
}
return(user);
}
public static List <eTblPurchaseHistory> GetRecordForSearch(OneFineRateAppUtil.jQueryDataTableParamModel param, out int TotalCount)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
List <eTblPurchaseHistory> purchaseHistoryList = new List <eTblPurchaseHistory>();
param.sSearch = param.sSearch == null ? "" : param.sSearch;
var purchaseHistoryList_AsQueryable = db.tblPurchaseHistories.Where(u => u.FIRSTNAME.Contains(param.sSearch)).AsQueryable();
TotalCount = purchaseHistoryList_AsQueryable.Count();
switch (param.iSortingCols)
{
case 0:
purchaseHistoryList_AsQueryable = param.sortDirection == "asc" ? purchaseHistoryList_AsQueryable.OrderBy(u => u.FIRSTNAME) : purchaseHistoryList_AsQueryable.OrderByDescending(u => u.FIRSTNAME);
break;
}
List <tblPurchaseHistory> lstUser = purchaseHistoryList_AsQueryable.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();
foreach (var item in lstUser)
{
purchaseHistoryList.Add((eTblPurchaseHistory)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new eTblPurchaseHistory()));
}
return(purchaseHistoryList);
}
}
public static etblBannerM GetBannerDetailsByID(int BannerId)
{
etblBannerM promorec = new etblBannerM();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var rec = (from m in db.tblBannerMs
join c in db.tblUserMs on m.iActionBy equals c.iUserId
select new
{
m.iBannerId,
m.sBannerName,
m.sBannerType,
m.sDescription,
m.sTextPosition,
m.sLinkId,
m.cstatus,
m.sImgUrl,
m.iResolutionH,
m.iResolutionW,
m.UniqueAzureFileName,
UserName = c.sFirstName + " " + c.sLastName
}
).Where(u => u.iBannerId == BannerId).AsQueryable();
var data = rec.ToList();
promorec = (etblBannerM)OneFineRateAppUtil.clsUtils.ConvertToObject(data[0], promorec);
return(promorec);
}
}
public static long AddRecordAndGetId(eTblPurchaseHistory eobj)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblPurchaseHistory purchangeHistory = (OneFineRate.tblPurchaseHistory)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPurchaseHistory());
db.tblPurchaseHistories.Add(purchangeHistory);
var status = db.SaveChanges();
return(purchangeHistory.iPurchaseId);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
throw;
}
catch (Exception)
{
throw;
}
}
}
public static int AddMultipleRecord(etblPropetyPhotoMap[] eobjs)
{
int statusCode = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
foreach (var item in eobjs)
{
item.iPhotoCatId = null;
item.iPhotoSubCatId = null;
OneFineRate.tblPropertyPhotoMap dbPropertyImg = (OneFineRate.tblPropertyPhotoMap)OneFineRateAppUtil.clsUtils.ConvertToObject(item, new OneFineRate.tblPropertyPhotoMap());
db.tblPropertyPhotoMaps.Add(dbPropertyImg);
}
statusCode = db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
return(statusCode);
}
public static int UpdateRecord(eTblPurchaseHistory eobj)
{
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblPurchaseHistory obj = (OneFineRate.tblPurchaseHistory)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPurchaseHistory());
db.tblPurchaseHistories.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
throw;
}
catch (Exception)
{
throw;
}
}
}
//Bind Country Dropdown
public static List <CountryList> CountryList()
{
List <CountryList> objCountryList = new List <CountryList>();
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var objCountry = db.tblCountryMs.AsQueryable();
foreach (var item in objCountry)
{
CountryList objC = new CountryList();
objC.iCountryId = item.iCountryId;
objC.CountryName = item.sCountry;
objCountryList.Add(objC);
}
}
catch (Exception)
{
throw;
}
}
return(objCountryList);
}
public static List <CheckBoxList> GetHotelParkingsCheckBox(string data)
{
List <CheckBoxList> selectItems = null;
using (OneFineRateEntities db = new OneFineRateEntities())
{
string[] objSelectItems;
if (data != null)
{
objSelectItems = data.Split(',');
selectItems = (from am in db.tblHotelParkingMs.Where(u => u.cRadioCheckBox == "C").ToList()
join si in objSelectItems.ToList() on am.iHotelParkingId equals Convert.ToInt32(si) into result
from r in result.DefaultIfEmpty()
select new CheckBoxList()
{
Text = am.sParking,
Value = am.iHotelParkingId,
Selected = r == null ? false : true
}).ToList();
}
else
{
selectItems = db.tblHotelParkingMs.Where(u => u.cRadioCheckBox == "C").Select(x => new CheckBoxList()
{
Text = x.sParking,
Value = x.iHotelParkingId
}).ToList();
}
return(selectItems);
}
}
public static string GenrateMenuForMappingShow(int UserId)
{
using (OneFineRateEntities _context = new OneFineRateEntities())
{
var result = _context.uspGetPropertiesAndChainByUserForShow(UserId);
var lstResult = result.ToList();
string ReturnString = "";
foreach (var item in lstResult)
{
ReturnString += "{ \"id\" : " + item.iPropId + ", \"name\": \"" + item.PropName.Trim() + "\", \"parent\": \"" + item.chainName.Trim() + "\", \"checked\": \"" + item.Mapped + "\"},";
}
try
{
ReturnString = "[" + ReturnString.Substring(0, ReturnString.Length - 1) + "]";
}
catch (Exception)
{
ReturnString = "[]";
}
return(ReturnString);
}
}
//Add new record
public static int AddRecord(eRatePlan eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
int dbobj = (from s in db.tblRatePlanMs.Where(u => u.sRatePlan == eobj.sRatePlan.Trim())
select new
{
s.iRatePlanId,
}).Count();
if (dbobj > 0)
{
return(retval = 2);
}
OneFineRate.tblRatePlanM dbuser = (OneFineRate.tblRatePlanM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblRatePlanM());
db.tblRatePlanMs.Add(dbuser);
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(eTblPromotionalHotel eobj)
{
int retval = -1;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var existingModel = db.tblPromotionalHotelsMs.FirstOrDefault(x => x.sPosition == eobj.sPosition);
if (existingModel != null)
{
existingModel.iPropId = eobj.iPropId;
existingModel.sDescription = eobj.sDescription;
existingModel.sImageUrl = eobj.sImageUrl;
existingModel.iActionBy = eobj.iActionBy;
existingModel.dtActionDate = eobj.dtActionDate;
existingModel.sPosition = eobj.sPosition;
}
//db.Entry(existingModel).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(eRatePlan eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
int dbobj = (from s in db.tblRatePlanMs.Where(u => u.sRatePlan == eobj.sRatePlan.Trim() && u.iRatePlanId != eobj.iRatePlanId)
select new
{
s.iRatePlanId,
}).Count();
if (dbobj > 0)
{
return(retval = 2);
}
OneFineRate.tblRatePlanM obj = (OneFineRate.tblRatePlanM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblRatePlanM());
db.tblRatePlanMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Get Single Record
public static etblPropertyRoomInventory GetSingleRecordById(int roomid, DateTime inventorydate)
{
etblPropertyRoomInventory eobj = new etblPropertyRoomInventory();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var dbobj = (from t1 in db.tblPropertyRoomInventories
join t2 in db.tblPropertyRoomMaps on new { t1.iRoomId, t1.iPropId } equals new { t2.iRoomId, t2.iPropId }
select new
{
t1.dtInventoryDate,
t1.iPropId,
t1.iRoomId,
t1.iInventory,
t1.bStopSell,
t1.iCutOff,
t1.dtActionDate,
t1.iActionBy,
t1.iAvailableInventory,
t2.sRoomName
}).Where(u => u.dtInventoryDate == inventorydate && u.iRoomId == roomid).AsQueryable().SingleOrDefault();
if (dbobj != null)
{
eobj = (etblPropertyRoomInventory)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj);
}
}
return(eobj);
}
//Add new record
public static int AddRecord(etblPropertyDiningMap eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var checkExistsRestaurantName = db.tblPropertyDiningMaps.Any(
p => p.iPropId == eobj.iPropId &&
p.sRestaurantName == eobj.sRestaurantName);
if (checkExistsRestaurantName == false)
{
OneFineRate.tblPropertyDiningMap dbstate = (OneFineRate.tblPropertyDiningMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyDiningMap());
db.tblPropertyDiningMaps.Add(dbstate);
db.SaveChanges();
retval = 1;
}
else
{
retval = 2;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
