public void UpdatePrjTypeAsync(ProjectInfo projectInfo, Guid ProjId) { var projectTypeList = GetArmsProjectTypesByIdAsync(ProjId); var modifiedProjectTypeList = projectInfo.ProjectTypeList; var addProjectTypes = from projectTypes in modifiedProjectTypeList where !projectTypeList.Any(x => x.ProjectTypeId == projectTypes.ProjectTypeId) select projectTypes; var deletedProjectTypes = from projecttypes in projectTypeList where !modifiedProjectTypeList.Any(x => x.ProjectTypeId == projecttypes.ProjectTypeId) select projecttypes; var LambdaaddProjectTypes = modifiedProjectTypeList.Where(x => !projectTypeList.Any(y => x.ProjectTypeId == y.ProjectTypeId)); var LambdadelProjectTypes = projectTypeList.Where(x => !modifiedProjectTypeList.Any(y => x.ProjectTypeId == y.ProjectTypeId)); foreach (var delprojectType in deletedProjectTypes) { ArmsProjectType projType = new ArmsProjectType { ProjectTypeId = delprojectType.ProjectTypeId, ProjectId = ProjId, UserId = "Manoj" }; DeleteProjectType(projType); } foreach (var addprojectType in addProjectTypes) { ArmsProjectType projType = new ArmsProjectType { ProjectTypeId = addprojectType.ProjectTypeId, ProjectId = ProjId, UserId = "Manoj" }; AddArmsProjectTypes(projType); } }
public async Task <ArmsProjectType> AddArmsProjectType(ArmsProjectType armsProjectType) { await _currentContext.ArmsProjectType.AddAsync(armsProjectType); _currentContext.Attach(armsProjectType); _currentContext.Entry(armsProjectType).State = EntityState.Added; return(armsProjectType); }
/** End of Arms Project Types */ public void DeleteProjectType(ArmsProjectType projType) { var result = _currentContext.ArmsProjectType.Where(x => x.ProjectId == projType.ProjectId && x.ProjectTypeId == projType.ProjectTypeId); foreach (var prjtype in result) { _currentContext.ArmsProjectType.Remove(prjtype); } _currentContext.SaveChanges(); }
/* Update ARMS Project Types Calls */ public void AddPrjTypeAsync(ProjectInfo projectInfo, Guid ProjId) { foreach (var projectType in projectInfo.ProjectTypeList) { ArmsProjectType projType = new ArmsProjectType { ProjectTypeId = projectType.ProjectTypeId, ProjectId = ProjId, UserId = "Manoj" }; AddArmsProjectTypes(projType); } }
/* * public async Task<ArmsProject> AddArmsProjectAsync(ArmsProject armsProject) * { * await _currentContext.ArmsProject.AddAsync(armsProject); * * // _currentContext.Attach(armsProject); * // _currentContext.Entry(armsProject).State = EntityState.Added; * _currentContext.SaveChanges(); * return armsProject; * } * */ public ArmsProjectType AddArmsProjectTypes(ArmsProjectType armsProjectType) { _currentContext.ArmsProjectType.Add(armsProjectType); _currentContext.SaveChanges(); return(armsProjectType); }