public SigmaResultType AddImportedSchedule(TypeImportedSchedule paramObj) { SigmaResultType result = new SigmaResultType(); try { ScheduleMgr scheduleMgr = new ScheduleMgr(); result = scheduleMgr.AddImportedSchedule(paramObj); return result; } catch (Exception ex) { // Log Exception ExceptionHelper.logException(ex); result.IsSuccessful = false; result.ErrorMessage = ex.Message; return result; } }
public SigmaResultType AddImportedSchedule(TypeImportedSchedule objImportedSchedule) { TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); // Get connection string string connStr = ConnStrHelper.getDbConnString(); List<SqlParameter> paramList = new List<SqlParameter>(); paramList.Add(new SqlParameter("@Wbs", objImportedSchedule.Wbs)); paramList.Add(new SqlParameter("@ScheduleLineItem", objImportedSchedule.ScheduleLineItem)); paramList.Add(new SqlParameter("@P6StartDate", objImportedSchedule.P6StartDate)); paramList.Add(new SqlParameter("@P6FinishDate", objImportedSchedule.P6FinishDate)); paramList.Add(new SqlParameter("@P6Duration", objImportedSchedule.P6Duration)); paramList.Add(new SqlParameter("@SigmaStartDate", objImportedSchedule.SigmaStartDate)); paramList.Add(new SqlParameter("@SigmaFinishDate", objImportedSchedule.SigmaFinishDate)); paramList.Add(new SqlParameter("@SigmaDuration", objImportedSchedule.SigmaDuration)); paramList.Add(new SqlParameter("@EstimatedManhours", objImportedSchedule.EstimatedManhours)); paramList.Add(new SqlParameter("@AssignedCrew", objImportedSchedule.AssignedCrew)); paramList.Add(new SqlParameter("@DisciplineCode", objImportedSchedule.DisciplineCode)); paramList.Add(new SqlParameter("@CwpId", objImportedSchedule.CwpId)); paramList.Add(new SqlParameter("@AssignedTo", objImportedSchedule.AssignedTo)); paramList.Add(new SqlParameter("@CreatedBy", objImportedSchedule.CreatedBy)); 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_AddImportedSchedule", paramList.ToArray()); result.IsSuccessful = true; result.ScalarValue = (int)outParam.Value; scope.Complete(); } return result; }
/// <summary> /// Update P6 Data /// Project Control > Data > Schedule > Update /// </summary> /// <param name="objImportedSchedule"></param> /// <returns></returns> public SigmaResultType UpdateImportedSchedule(TypeImportedSchedule objImportedSchedule) { TransactionScope scope = null; SigmaResultType result = new SigmaResultType(); string connStr = ConnStrHelper.getDbConnString(); List<SqlParameter> paramList = new List<SqlParameter>(); paramList.Add(new SqlParameter("@ScheduledWorkItemId", objImportedSchedule.ScheduledWorkItemId)); paramList.Add(new SqlParameter("@DisciplineCode", objImportedSchedule.DisciplineCode)); paramList.Add(new SqlParameter("@CwpId", objImportedSchedule.CwpId)); paramList.Add(new SqlParameter("@AssignedTo", objImportedSchedule.AssignedTo)); paramList.Add(new SqlParameter("@UpdatedBy", objImportedSchedule.UpdatedBy)); using (scope = new TransactionScope(TransactionScopeOption.Required)) { result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_UpdateImportedSchedule", paramList.ToArray()); result.IsSuccessful = true; scope.Complete(); } return result; }