//Update a record public static int UpdateRecord(int PropId, int Channelmgr, int user) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { var obj = db.tblPropertyChannelMgrMaps.SingleOrDefault(u => u.iPropId == PropId); if (obj != null) { db.tblPropertyChannelMgrMaps.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } tblPropertyChannelMgrMap CM = new tblPropertyChannelMgrMap(); CM.dtActionDate = DateTime.Now; CM.iActionBy = user; CM.iChannelMgr = Channelmgr; CM.iPropId = PropId; db.tblPropertyChannelMgrMaps.Attach(CM); db.Entry(CM).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//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); }
public static KeyValuePair <int, string> ToggleStatus(int companyId, bool enable) { using (OneFineRateEntities db = new OneFineRateEntities()) { var comp = db.tblCorporateCompanyMs.Where(x => x.iCompanyId == companyId).FirstOrDefault(); if (comp != null) { if (enable) { comp.cStatus = "A"; } else { comp.cStatus = "I"; } db.tblCorporateCompanyMs.Attach(comp); db.Entry(comp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(new KeyValuePair <int, string>(1, "Record has been updated successfully!")); } return(new KeyValuePair <int, string>(-1, "An error occured while updating the record.")); } }
//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; } } }
//Delete a record public static int DeleteRecord(etblPropertyPromotionMap eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { using (OneFineRateEntities db1 = new OneFineRateEntities()) { var PP = db1.tblPropertyPromotionMaps.Where(a => a.iID == eobj.iID).ToList(); if (eobj.iPromoId != Convert.ToInt32(Promotions.OFRFreebies)) { eobj.bParentActive = (bool)PP[0].bParentActive; } eobj.iPromoId = PP[0].iPromoId; } OneFineRate.tblPropertyPromotionMap obj = (OneFineRate.tblPropertyPromotionMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyPromotionMap()); db.tblPropertyPromotionMaps.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//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); }
//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); }
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; } } }
//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 static KeyValuePair <int, string> ToggleStatus(int RateRangeId, bool enable) { try { using (OneFineRateEntities db = new OneFineRateEntities()) { var comp = db.tblRoomRateRangeMs.Where(x => x.iRangeId == RateRangeId).FirstOrDefault(); if (comp != null) { if (enable) { comp.cStatus = "A"; } else { comp.cStatus = "I"; } db.Entry(comp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(new KeyValuePair <int, string>(1, "Status updated successfully!")); } return(new KeyValuePair <int, string>(-1, "An error occured while updating the record.")); } } catch (Exception) { return(new KeyValuePair <int, string>(-1, "An error occured while updating the record.")); } }
//Update a record public static int UpdateRecord(etblPropertySpaMap eobj, bool Type) { int retval = 0; using (OneFineRateEntities dbnew = new OneFineRateEntities()) { try { OneFineRate.tblPropertySpaMap obj = (OneFineRate.tblPropertySpaMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertySpaMap()); if (Type) { dbnew.tblPropertySpaMaps.Attach(obj); dbnew.Entry(obj).State = System.Data.Entity.EntityState.Modified; dbnew.SaveChanges(); retval = 1; } else { dbnew.tblPropertySpaMaps.Add(obj); dbnew.SaveChanges(); retval = 1; } } catch (Exception) { throw; } } return(retval); }
//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); }
public void Update(TUser user) { using (var db = new OneFineRateEntities()) { var tblUser = (tblWebsiteUserMater)OneFineRateAppUtil.clsUtils.ConvertToObject(user, new tblWebsiteUserMater()); db.tblWebsiteUserMaters.Attach(tblUser); db.Entry(tblUser).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
//Update a record public static int UpdateRecord(etblPropertyRoomTypeRoomAmentiesMap eobj) { bool Type = false; int retval = 0; using (OneFineRateEntities dbnew = new OneFineRateEntities()) { try { var dbobj = dbnew.tblPropertyRoomTypeRoomAmentiesMaps.SingleOrDefault(u => u.iPropId == eobj.iPropId && u.iRoomId == eobj.iRoomId); if (dbobj != null) { Type = true; } } catch (Exception) { throw; } } using (OneFineRateEntities db = new OneFineRateEntities()) { try { if (Type) { OneFineRate.tblPropertyRoomTypeRoomAmentiesMap obj = (OneFineRate.tblPropertyRoomTypeRoomAmentiesMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomTypeRoomAmentiesMap()); db.tblPropertyRoomTypeRoomAmentiesMaps.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); db.uspUpdateAmenitiesInLookup(eobj.iPropId, eobj.iRoomId); retval = 1; } else { OneFineRate.tblPropertyRoomTypeRoomAmentiesMap dbuser = (OneFineRate.tblPropertyRoomTypeRoomAmentiesMap)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPropertyRoomTypeRoomAmentiesMap()); db.tblPropertyRoomTypeRoomAmentiesMaps.Add(dbuser); db.SaveChanges(); db.uspUpdateAmenitiesInLookup(eobj.iPropId, eobj.iRoomId); retval = 1; } } catch (Exception) { throw; } } return(retval); }
//Update a record public static int UpdateRecord(eUsers eobj, string Groups) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblUserM dbuser = (OneFineRate.tblUserM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblUserM()); var dbobj = db.tblUserMs.SingleOrDefault(u => u.sUserName != dbuser.sUserName && u.sEmail == dbuser.sEmail); if (dbobj != null) { return(3); } OneFineRate.tblUserM obj = (OneFineRate.tblUserM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblUserM()); db.tblUserMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); try { var obj1 = db.tblUserGroupMs.Where(u => u.iUserId == dbuser.iUserId); db.tblUserGroupMs.RemoveRange(obj1); } catch (Exception) { } var grps = Groups.Split(',').ToList(); db.tblUserGroupMs.AddRange(grps.Select(x => new tblUserGroupM() { cStatus = "A", dtActionDate = DateTime.Now, dtCreationDate = DateTime.Now, iActionBy = dbuser.iActionBy, iCreatedBy = dbuser.iActionBy, iGroupId = Convert.ToInt32(x), iUserId = dbuser.iUserId })); db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Update a record public static int UpdateRecord(eGroups eobj, string Menus) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { var mns = Menus.Split(',').ToList(); if (mns.Count > 1) { OneFineRate.tblGroupM obj = (OneFineRate.tblGroupM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblGroupM()); db.tblGroupMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); try { var obj1 = db.tblGroupMenuMs.Where(u => u.iGroupId == obj.iGroupId); db.tblGroupMenuMs.RemoveRange(obj1); } catch (Exception) { } db.tblGroupMenuMs.AddRange(mns.Select(menu => new tblGroupMenuM { cStatus = "A", dtActionDate = DateTime.Now, dtCreationDate = DateTime.Now, iActionBy = obj.iActionBy, iCreatedBy = obj.iActionBy, iMenuId = Convert.ToInt32(menu), iGroupId = obj.iGroupId })); db.SaveChanges(); retval = 1; } else { retval = 2; } } catch (Exception) { throw; } } return(retval); }
public static int DeleteRecord(string sModule) { using (OneFineRateEntities db = new OneFineRateEntities()) { try { var obj = db.tblEmailSettingsMs.SingleOrDefault(u => u.sModule == sModule); db.tblEmailSettingsMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Deleted; return(db.SaveChanges()); } catch (Exception) { throw; } } }
public static int UpdateRecord(etblEmailSettingsM eobj) { using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblEmailSettingsM obj = (OneFineRate.tblEmailSettingsM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblEmailSettingsM()); db.tblEmailSettingsMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } catch (Exception) { throw; } } }
public static int DeleteRecord(int purchaseId) { using (OneFineRateEntities db = new OneFineRateEntities()) { try { var obj = db.tblPurchaseHistories.Find(purchaseId); db.tblPurchaseHistories.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Deleted; return(db.SaveChanges()); } catch (Exception) { throw; } } }
public static int UpdatePassword(int iUserId, string OldPassword, string NewPassword) { using (OneFineRateEntities db = new OneFineRateEntities()) { byte[] b = new byte[1]; string pass = SimpleHash.ComputeHash(OldPassword, "SHA1", b); var dbobj = (from s in db.tblUserMs select new { s.iUserId, s.sFirstName, s.sLastName, s.sUserName, s.sPassword, s.cStatus, s.dtActionDate, s.dtCreatedOn, s.iActionBy, s.sContact, s.sEmail }).Where(u => u.iUserId == iUserId && u.sPassword == pass).AsQueryable(); var list = dbobj.ToList(); if (list.Count == 0) { return(0); } else { OneFineRate.tblUserM obj = (OneFineRate.tblUserM)OneFineRateAppUtil.clsUtils.ConvertToObject(list[0], new OneFineRate.tblUserM()); obj.sPassword = SimpleHash.ComputeHash(NewPassword, "SHA1", b); obj.dtActionDate = DateTime.Now; obj.iActionBy = iUserId; db.tblUserMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(1); } }
public static KeyValuePair <int, string> ToggleStatus(int serviceChargeId, bool enable) { try { using (OneFineRateEntities db = new OneFineRateEntities()) { var model = db.tblServiceChargeMs.Where(x => x.iServiceChargeId == serviceChargeId).FirstOrDefault(); var duplicateCount = db.tblServiceChargeMs.Any(x => x.iServiceChargeId != serviceChargeId && ((model.dtFrom >= x.dtFrom && model.dtFrom <= x.dtTo) || (model.dtTo >= x.dtFrom && model.dtTo <= x.dtTo) || (model.dtFrom <= x.dtFrom && model.dtTo >= x.dtTo)) && x.cStatus == "A"); if (duplicateCount) { return(new KeyValuePair <int, string>(-1, "Overlapping date range can not be assigned!")); } if (model != null) { if (enable) { model.cStatus = "A"; } else { model.cStatus = "I"; } db.Entry(model).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(new KeyValuePair <int, string>(1, "Status updated successfully!")); } return(new KeyValuePair <int, string>(-1, "An error occured while updating the record.")); } } catch (Exception) { return(new KeyValuePair <int, string>(-1, "An error occured while updating the record.")); } }
//Update a record public static int UpdateRecord(etblUserFeedbackTripAdvisor eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblUserFeedbackTripAdvisor obj = (OneFineRate.tblUserFeedbackTripAdvisor)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblUserFeedbackTripAdvisor()); db.tblUserFeedbackTripAdvisors.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Update a record public static int UpdateRecord(etblPropertyM eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblBankDetailM obj = (OneFineRate.tblBankDetailM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblBankDetailM()); db.tblBankDetailMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Delete a record public static int DeleteRecord(string sPosition) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { var obj = db.tblPromotionalHotelsMs.SingleOrDefault(u => u.sPosition == sPosition); db.tblPromotionalHotelsMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Delete a record public static int DeleteRecord(int id) { int operationStatus = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { var obj = db.tblWebsiteUserMaters.SingleOrDefault(u => u.Id == id); db.tblWebsiteUserMaters.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); operationStatus = 1; } catch (Exception) { throw; } } return(operationStatus); }
//Delete a record public static int DeleteRecord(int id) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { var obj = db.tblStateMs.SingleOrDefault(u => u.iStateId == id); db.tblStateMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Update a record public static int UpdateRecord(WebsiteUserMaster eobj) { int operationStatus = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblWebsiteUserMater obj = (OneFineRate.tblWebsiteUserMater)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblWebsiteUserMater()); db.tblWebsiteUserMaters.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); operationStatus = 1; } catch (Exception) { throw; } } return(operationStatus); }
//Update a record public static int UpdateLoyalityPoints(eLoyalityPoints eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblLoyalityPointsM obj = (OneFineRate.tblLoyalityPointsM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblLoyalityPointsM()); db.tblLoyalityPointsMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//Delete Rank public static int DeleteRecord(etblRankManagement eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { 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; } catch (Exception) { throw; } } return(retval); }
//Delete a record public static int DeleteRecord(string from, string to) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { var obj = db.tblExchangeRatesMs.SingleOrDefault(u => u.sCurrencyCodeFrom == from && u.sCurrencyCodeTo == to); db.tblExchangeRatesMs.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }