示例#1
0
        //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);
        }
示例#2
0
        //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);
        }
示例#3
0
        //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);
        }