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

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

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

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

                var res = db.jobCategoryLookups.FirstOrDefault(e => e.jobCategoryLookupId == jobCategoryLookupId);

                if (res == null) return null;

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

                db.SaveChanges();
                return res;

            }
        }