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