public SigmaResultType AddProgressStep(TypeProgressStep objProgressStep) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); // Get connection string string connStr = ConnStrHelper.getDbConnString(); List<SqlParameter> paramList = new List<SqlParameter>(); paramList.Add(new SqlParameter("@ProgressTypeId", Utilities.ToInt32(objProgressStep.ProgressTypeId.ToString().Trim()))); paramList.Add(new SqlParameter("@Name", objProgressStep.Name.Trim())); paramList.Add(new SqlParameter("@IsMultipliable", objProgressStep.IsMultipliable.Trim())); paramList.Add(new SqlParameter("@Weight", Utilities.ToInt32(objProgressStep.Weight.ToString().Trim()))); paramList.Add(new SqlParameter("@CreatedBy", userinfo.SigmaUserId.Trim())); SqlParameter outParam = new SqlParameter("@NewId", SqlDbType.Int); outParam.Direction = ParameterDirection.Output; paramList.Add(outParam); using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, "usp_AddProgressStep", paramList.ToArray()); result.IsSuccessful = true; result.ScalarValue = (int)outParam.Value; scope.Complete(); } return result; }
public SigmaResultType UpdateProgressStep(TypeProgressStep objProgressStep) { 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("@ProgressStepId", Utilities.ToInt32(objProgressStep.ProgressStepId.ToString().Trim())), new SqlParameter("@ProgressTypeId", Utilities.ToInt32(objProgressStep.ProgressTypeId.ToString().Trim())), new SqlParameter("@Name", objProgressStep.Name.Trim()), new SqlParameter("@IsMultipliable", objProgressStep.IsMultipliable.Trim()), new SqlParameter("@Weight", Utilities.ToInt32(objProgressStep.Weight.ToString().Trim())), new SqlParameter("@UpdatedBy", userinfo.SigmaUserId.Trim()) }; using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_UpdateProgressStep", parameters); result.IsSuccessful = true; scope.Complete(); } return result; }
public SigmaResultType RemoveProgressStep(TypeProgressStep objProgressStep) { SigmaResultType result = new SigmaResultType(); TransactionScope scope = null; // Get connection string string connStr = ConnStrHelper.getDbConnString(); // Compose parameters SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ProgressStepId", Utilities.ToInt32(objProgressStep.ProgressStepId.ToString().Trim())) }; using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_RemoveProgressStep", parameters); result.IsSuccessful = true; scope.Complete(); } return result; }