public Infrastructure.Data.Entities.QualificationsVm Post(Infrastructure.Data.Entities.QualificationsVm vm, string Userid) { using (var db = new LMISEntities()) { try { var id = vm.Id; var checkExist = db.Qualifications.Count(c => ((c.QualificationAr == vm.QualificationAr && !string.IsNullOrEmpty(vm.QualificationAr)) || (c.QualificationEn == vm.QualificationEn && !string.IsNullOrEmpty(vm.QualificationEn)) || (c.QualificationFr == vm.QualificationFr) && !string.IsNullOrEmpty(vm.QualificationFr)) && c.Id != vm.Id && c.IsDeleted == null); if (checkExist > 0) { return(null); } if (id > 0) //Update { var tr = db.Qualifications .Where(r => r.IsDeleted == null && r.Id == id) .ToList().Single(); tr.GroupID = vm.GroupID; tr.QualificationAr = vm.QualificationAr; tr.QualificationEn = vm.QualificationEn; tr.QualificationFr = vm.QualificationFr; tr.UpdateUserID = Userid; tr.UpdateDate = DateTime.UtcNow; } else //Insert { var tr = new Qualification() { QualificationAr = vm.QualificationAr, QualificationEn = vm.QualificationEn, QualificationFr = vm.QualificationFr, GroupID = vm.GroupID, PostUserID = Userid, PostDate = DateTime.UtcNow }; db.Qualifications.Add(tr); db.SaveChanges(); vm.Id = tr.Id; } db.SaveChanges(); } catch (Exception ex) { ExceptionDispatchInfo.Capture(ex).Throw(); } return(vm); } }
public Infrastructure.Data.DTOs.ModelResponse Post(Infrastructure.Data.DTOs.UserInfo user, Infrastructure.Data.Entities.QualificationsVm vm) { try { //Authorization if (user == null) { return(new ModelResponse(101)); } var ds = Repo.Post(vm, user.UserId); // if(ds==null) // { return new ModelResponse(102, ds); } return(new ModelResponse(0, ds)); } catch (Exception ex) { return(new ModelResponse(ex)); } }