public MemberRoleLookupVo insert(MemberRoleLookupVo input)
        {
            using (var db = new MainDb())
            {

                db.memberRoleLookups.Add(input);
                db.SaveChanges();

                return input;
            }
        }
        public MemberRoleLookupVo update(MemberRoleLookupVo input, Guid? memberRoleLookupId= null)
        {
            using (var db = new MainDb())
            {

                if (memberRoleLookupId == null)
                    memberRoleLookupId = input.memberRoleLookupId;

                var res = db.memberRoleLookups.FirstOrDefault(e => e.memberRoleLookupId == memberRoleLookupId);

                if (res == null) return null;

                input.created = res.created;
               // input.createdBy = res.createdBy;
                db.Entry(res).CurrentValues.SetValues(input);

                db.SaveChanges();
                return res;

            }
        }