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