public SigmaResultType AddSigmaUserSigmaRole(TypeSigmaUserSigmaRole objSigmaUserSigmaRole) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); objSigmaUserSigmaRole.CreatedBy = userinfo.SigmaUserId; //objSigmaUserSigmaRole.ProjectId = userinfo.CurrentProjectId; TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); // Get connection string string connStr = ConnStrHelper.getDbConnString(); List<SqlParameter> paramList = new List<SqlParameter>(); paramList.Add(new SqlParameter("@SigmaRoleId", objSigmaUserSigmaRole.SigmaRoleId)); paramList.Add(new SqlParameter("@SigmaUserId", objSigmaUserSigmaRole.SigmaUserId)); paramList.Add(new SqlParameter("@ReportTo", objSigmaUserSigmaRole.ReportTo)); paramList.Add(new SqlParameter("@ReportToRole", objSigmaUserSigmaRole.ReportToRole)); paramList.Add(new SqlParameter("@IsDefault", objSigmaUserSigmaRole.IsDefault)); paramList.Add(new SqlParameter("@ProjectId", objSigmaUserSigmaRole.ProjectId)); paramList.Add(new SqlParameter("@CreatedBy", objSigmaUserSigmaRole.CreatedBy)); using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, "usp_AddSigmaUserSigmaRole", paramList.ToArray()); result.IsSuccessful = true; scope.Complete(); } return result; }
public SigmaResultType UpdateSigmaUserSigmaRoleForHierarchy(TypeSigmaUserSigmaRole objSigmaUserSigmaRole) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); // Get connection string string connStr = ConnStrHelper.getDbConnString(); // Compose parameters SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SigmaTrgRoleId", objSigmaUserSigmaRole.SigmaTrgRoleId), new SqlParameter("@SigmaRoleId", objSigmaUserSigmaRole.SigmaRoleId), new SqlParameter("@SigmaUserId", objSigmaUserSigmaRole.SigmaUserId), new SqlParameter("@ProjectId", userinfo.CurrentProjectId), new SqlParameter("@UpdatedBy", userinfo.SigmaUserId), }; using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_UpdateSigmaUserSigmaRoleForHierarchy", parameters); result.IsSuccessful = true; scope.Complete(); } return result; }
public SigmaResultType MultiUsers(TypeSigmaUser objSigmaUser) { TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); // Get connection string string connStr = ConnStrHelper.getDbConnString(); if(objSigmaUser.SigmaOperation == "D"){ result = RemoveSigmaUser(objSigmaUser); }else { switch (objSigmaUser.SigmaOperation) { case "C": if (IsAddUser()) result = AddSigmaUser(objSigmaUser); else { result.IsSuccessful = false; result.ErrorMessage = "You have exceeded the number of user licenses."; } break; case "U": result = UpdateSigmaUser(objSigmaUser); break; } if (result.IsSuccessful) { TypeSigmaUserSigmaRole objSigmaUserSigmaRole = new TypeSigmaUserSigmaRole(); objSigmaUserSigmaRole.SigmaUserId = objSigmaUser.SigmaUserId; result = MultiSigmaUserSigmaRole(objSigmaUserSigmaRole, objSigmaUser.SigmaUserSigmaRoles); } } return result; }
public SigmaResultType RemoveSigmaUserSigmaRole(TypeSigmaUserSigmaRole objSigmaUserSigmaRole) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); SigmaResultType result = new SigmaResultType(); TransactionScope scope = null; // Get connection string string connStr = ConnStrHelper.getDbConnString(); // Compose parameters SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SigmaUserId", objSigmaUserSigmaRole.SigmaUserId) }; using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_RemoveSigmaUserSigmaRole", parameters); result.IsSuccessful = true; scope.Complete(); } return result; }
public SigmaResultType MultiSigmaUserSigmaRole(TypeSigmaUserSigmaRole objSigmaUserSigmaRole, List<TypeSigmaUserSigmaRole> listObj) { TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); // Get connection string string connStr = ConnStrHelper.getDbConnString(); using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) { if(objSigmaUserSigmaRole != null) RemoveSigmaUserSigmaRole(objSigmaUserSigmaRole); foreach (TypeSigmaUserSigmaRole anObj in listObj) { AddSigmaUserSigmaRole(anObj); } result.IsSuccessful = true; scope.Complete(); } return result; }
//public SigmaResultType MultiProject(List<TypeProject> listObj) //{ // TransactionScope scope = null; // SigmaResultType result = new SigmaResultType(); // // Get connection string // string connStr = ConnStrHelper.getDbConnString(); // using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) // { // foreach (TypeProject anObj in listObj) // { // switch (anObj.SigmaOperation) // { // case "C": // AddProject(anObj); // break; // case "U": // UpdateProject(anObj); // break; // case "D": // RemoveProject(anObj); // break; // } // } // scope.Complete(); // } // return result; //} public SigmaResultType AddProjectInfo(TypeProject objProject) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); SigmaResultType resultProject = new SigmaResultType(); bool isDiscipline = true; bool isAuthentication = true; // Project Closed if (objProject.IsActive.ToUpper().Equals("N")) { if (userinfo.SigmaUserId.ToUpper().Equals("ADMIN")) { isAuthentication = true; } else { isAuthentication = false; } } if (objProject.ProjectDiscipline.Count == 0) { isDiscipline = false; } if (!(string.IsNullOrEmpty(objProject.ProjectName)) && !(string.IsNullOrEmpty(objProject.ProjectNumber)) && !(string.IsNullOrEmpty(objProject.ProjectManagerId)) //&& !(string.IsNullOrEmpty(objProject.ClientCompanyId)) && !(string.IsNullOrEmpty(objProject.ClientProjectId)) && !(string.IsNullOrEmpty(objProject.ClientProjectName)) && isDiscipline && isAuthentication ) { using (scope = new TransactionScope(TransactionScopeOption.RequiresNew)) { if (objProject.SigmaOperation == SigmaOperation.INSERT) { resultProject = AddProject(objProject); objProject.ProjectId = resultProject.ScalarValue; objProject.ProjectDiscipline.ForEach(item => item.ProjectId = objProject.ProjectId); objProject.ProjectSubcontractor.ForEach(item => item.ProjectId = objProject.ProjectId); } else if (objProject.SigmaOperation == SigmaOperation.UPDATE) { resultProject = UpdateProject(objProject); objProject.ProjectDiscipline.ForEach(item => item.ProjectId = objProject.ProjectId); objProject.ProjectSubcontractor.ForEach(item => item.ProjectId = objProject.ProjectId); // Delete ProjectDiscipline && ProjectSubcontractor if (resultProject.IsSuccessful) { RemoveProjectDiscipline(objProject); RemoveProjectSubcontractor(objProject); } } if (resultProject.IsSuccessful) { // ProjectDiscipline if (objProject.ProjectDiscipline.Count > 0) { foreach (var item in objProject.ProjectDiscipline) { switch (item.SigmaOperation) { case SigmaOperation.INSERT: AddProjectDiscipline(item); break; } } } // ProjectSubcontractor if (objProject.ProjectSubcontractor.Count > 0) { foreach (var item in objProject.ProjectSubcontractor) { switch (item.SigmaOperation) { case SigmaOperation.INSERT: AddProjectSubcontractor(item); break; } } } // Project Manager #region Project Manager if (!(string.IsNullOrEmpty(objProject.ProjectManagerId.ToString()))) { SigmaUserMgr sigmaUserMgr = new SigmaUserMgr(); SigmaRoleMgr sigmaRoleMgr = new SigmaRoleMgr(); ProjectUserDisciplineMgr projectUserDisciplineMgr = new ProjectUserDisciplineMgr(); TypeSigmaUserSigmaRole userRole = new TypeSigmaUserSigmaRole(); TypeProjectUserDiscipline userDiscipline = new TypeProjectUserDiscipline(); DataSet sigmaRoleDataSet = null; DataSet sigmaUserSigmaRoleDataSet = null; // Get SigmaRoleId sigmaRoleDataSet = sigmaRoleMgr.GetSigmaRoleByName("Project Manager"); var sigmaRole = sigmaRoleDataSet.Tables[0].Rows[0]["SigmaRoleId"]; // Get SigmaUserSigmaRole //sigmaUserSigmaRole = projectUserDisciplineMgr. // Set SigmaUserSigmaRole userRole.SigmaRoleId = int.Parse(sigmaRole.ToString()); userRole.SigmaUserId = objProject.ProjectManagerId; userRole.ProjectId = objProject.ProjectId; userRole.CreatedBy = userinfo.SigmaUserId; if (objProject.SigmaOperation == SigmaOperation.INSERT) { sigmaUserMgr.AddSigmaUserSigmaRoleForProject(userRole); // ProjectUserDiscipline if (objProject.ProjectDiscipline.Count > 0) { foreach (var item in objProject.ProjectDiscipline) { TypeProjectUserDiscipline projectUserDiscipline = new TypeProjectUserDiscipline(); projectUserDiscipline.ProjectId = objProject.ProjectId; projectUserDiscipline.SigmaUserId = objProject.ProjectManagerId; projectUserDiscipline.DisciplineCode = item.DisciplineCode; switch (item.SigmaOperation) { case SigmaOperation.INSERT: projectUserDisciplineMgr.AddProjectUserDiscipline(projectUserDiscipline); break; } } } } if (objProject.SigmaOperation == SigmaOperation.UPDATE) { //sigmaUserSigmaRoleDataSet = sigmaUserMgr.GetSigmaUserSigmaRoleBySigmaRoleId(objProject.ProjectId, int.Parse(sigmaRole.ToString())); //var sigmaUserSigmaRole = sigmaUserSigmaRoleDataSet.Tables[0].Rows[0]["SigmaUserId"]; // 1. SigmaUserSigmaRole Delete sigmaUserMgr.RemoveSigmaUserSigmaRoleByProjectId(userRole); // 2. SigmaUserSigmaRole Insert sigmaUserMgr.AddSigmaUserSigmaRole(userRole); // 3. ProjectUserDiscipline Delete userDiscipline.ProjectId = objProject.ProjectId; userDiscipline.SigmaUserId = userRole.SigmaUserId; userDiscipline.DisciplineCode = "ALL"; projectUserDisciplineMgr.RemoveProjectUserDiscipline(userDiscipline); // 4. ProjectUserDiscipline Insert foreach (var item in objProject.ProjectDiscipline) { TypeProjectUserDiscipline projectUserDiscipline = new TypeProjectUserDiscipline(); projectUserDiscipline.ProjectId = objProject.ProjectId; projectUserDiscipline.SigmaUserId = objProject.ProjectManagerId; projectUserDiscipline.DisciplineCode = item.DisciplineCode; switch (item.SigmaOperation) { case SigmaOperation.INSERT: projectUserDisciplineMgr.AddProjectUserDiscipline(projectUserDiscipline); break; } } // 5. ProjectUserDiscipline Delete(except ProjectManager) projectUserDisciplineMgr.RemoveProjectUserDisciplineByProjectInfo(objProject.ProjectId); } } #endregion Project Manager } result.AffectedRow = resultProject.AffectedRow; result.ScalarValue = resultProject.ScalarValue; result.IsSuccessful = true; scope.Complete(); } } else { result.AffectedRow = -1; result.ErrorCode = "ProjectSetting0001"; result.ErrorMessage = "Validation"; result.IsSuccessful = false; } return result; }
public SigmaResultType AddSigmaUserSigmaRole(TypeSigmaUserSigmaRole objSigmaUserSigmaRole) { SigmaResultType result = new SigmaResultType(); try { MemberMgr memberMgr = new MemberMgr(); result = memberMgr.AddSigmaUserSigmaRole(objSigmaUserSigmaRole); return result; } catch (Exception ex) { // Log Exception ExceptionHelper.logException(ex); result.IsSuccessful = false; result.ErrorMessage = ex.Message; return result; } }
public SigmaResultType UpdateSigmaUserSigmaRoleForHierarchy(TypeSigmaUserSigmaRole objSigmaUser) { SigmaResultType result = new SigmaResultType(); try { SigmaUserMgr sigmaUserMgr = new SigmaUserMgr(); result = sigmaUserMgr.UpdateSigmaUserSigmaRoleForHierarchy(objSigmaUser); result.IsSuccessful = true; return result; } catch (Exception ex) { // Log Exception ExceptionHelper.logException(ex); result.IsSuccessful = false; result.ErrorMessage = ex.Message; return result; } }
public SigmaResultType UpdateSigmaUserSigmaRole(TypeSigmaUserSigmaRole objSigmaUserSigmaRole) { SigmaResultType result = new SigmaResultType(); try { result.IsSuccessful = true; return result; } catch (Exception ex) { // Log Exception ExceptionHelper.logException(ex); result.IsSuccessful = false; result.ErrorMessage = ex.Message; return result; } }