//Get Single Record public static etblUserFeedbackTripAdvisor GetSingleRecordById(int bookingId) { etblUserFeedbackTripAdvisor eobj = new etblUserFeedbackTripAdvisor(); using (OneFineRateEntities db = new OneFineRateEntities()) { var dbobj = db.tblUserFeedbackTripAdvisors.SingleOrDefault(u => u.iBookingId == bookingId); if (dbobj != null) { eobj = (etblUserFeedbackTripAdvisor)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj); } } return(eobj); }
//Add new record public static int AddRecord(etblUserFeedbackTripAdvisor eobj) { int retval = 0; using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblUserFeedbackTripAdvisor dbuser = (OneFineRate.tblUserFeedbackTripAdvisor)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblUserFeedbackTripAdvisor()); db.tblUserFeedbackTripAdvisors.Add(dbuser); db.SaveChanges(); retval = 1; } catch (Exception) { throw; } } return(retval); }
//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); }