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