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