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;
}
