/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of clsTASKS</returns>
internal List <clsTasks> PopulateObjectsFromReader(IDataReader dataReader)
{
List <clsTasks> list = new List <clsTasks>();
while (dataReader.Read())
{
clsTasks businessObject = new clsTasks();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
public clsTasks getTaskDetailByTaskId(clsTasksKeys keys)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[sp_getTaskDetailByTaskId]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@TASK_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.TASK_ID));
MainConnection.Open();
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
clsTasks businessObject = new clsTasks();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("clsTASKS::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(clsTasks businessObject, IDataReader dataReader)
{
businessObject.TASK_ID = dataReader.GetInt32(dataReader.GetOrdinal(clsTasks.clsTASKSFields.TASK_ID.ToString()));
businessObject.PROJ_ID = dataReader.GetInt32(dataReader.GetOrdinal(clsTasks.clsTASKSFields.PROJ_ID.ToString()));
businessObject.PROJECT_CODE = dataReader.GetInt32(dataReader.GetOrdinal(clsTasks.clsTASKSFields.PROJECT_CODE.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.REWORK.ToString())))
{
businessObject.REWORK = dataReader.GetInt16(dataReader.GetOrdinal(clsTasks.clsTASKSFields.REWORK.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.REF_ID.ToString())))
{
businessObject.REF_ID = dataReader.GetString(dataReader.GetOrdinal(clsTasks.clsTASKSFields.REF_ID.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.SEVERITY.ToString())))
{
businessObject.SEVERITY = dataReader.GetInt16(dataReader.GetOrdinal(clsTasks.clsTASKSFields.SEVERITY.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.INC_DESCR.ToString())))
{
businessObject.INC_DESCR = dataReader.GetString(dataReader.GetOrdinal(clsTasks.clsTASKSFields.INC_DESCR.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.INC_TYPE.ToString())))
{
businessObject.INC_TYPE = dataReader.GetInt16(dataReader.GetOrdinal(clsTasks.clsTASKSFields.INC_TYPE.ToString()));
}
businessObject.EMP_ID = dataReader.GetInt32(dataReader.GetOrdinal(clsTasks.clsTASKSFields.EMP_ID.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.PHASE.ToString())))
{
businessObject.PHASE = dataReader.GetInt16(dataReader.GetOrdinal(clsTasks.clsTASKSFields.PHASE.ToString()));
}
businessObject.STATUS = dataReader.GetInt16(dataReader.GetOrdinal(clsTasks.clsTASKSFields.STATUS.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.DATE_STARTED.ToString())))
{
businessObject.DATE_STARTED = dataReader.GetDateTime(dataReader.GetOrdinal(clsTasks.clsTASKSFields.DATE_STARTED.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.TARGET_DATE.ToString())))
{
businessObject.TARGET_DATE = dataReader.GetDateTime(dataReader.GetOrdinal(clsTasks.clsTASKSFields.TARGET_DATE.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.COMPLTD_DATE.ToString())))
{
businessObject.COMPLTD_DATE = dataReader.GetDateTime(dataReader.GetOrdinal(clsTasks.clsTASKSFields.COMPLTD_DATE.ToString()));
}
businessObject.DATE_CREATED = dataReader.GetDateTime(dataReader.GetOrdinal(clsTasks.clsTASKSFields.DATE_CREATED.ToString()));
businessObject.EFFORT_EST = dataReader.GetDouble(dataReader.GetOrdinal(clsTasks.clsTASKSFields.EFFORT_EST.ToString()));
businessObject.ACT_EFFORT = dataReader.GetDouble(dataReader.GetOrdinal(clsTasks.clsTASKSFields.ACT_EFFORT.ToString()));
businessObject.ACT_EFFORT_WK = dataReader.GetDouble(dataReader.GetOrdinal(clsTasks.clsTASKSFields.ACT_EFFORT_WK.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.COMMENTS.ToString())))
{
businessObject.COMMENTS = dataReader.GetString(dataReader.GetOrdinal(clsTasks.clsTASKSFields.COMMENTS.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.OTHERS_1.ToString())))
{
businessObject.OTHERS_1 = dataReader.GetString(dataReader.GetOrdinal(clsTasks.clsTASKSFields.OTHERS_1.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.OTHERS_2.ToString())))
{
businessObject.OTHERS_2 = dataReader.GetString(dataReader.GetOrdinal(clsTasks.clsTASKSFields.OTHERS_2.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsTasks.clsTASKSFields.OTHERS_3.ToString())))
{
businessObject.OTHERS_3 = dataReader.GetString(dataReader.GetOrdinal(clsTasks.clsTASKSFields.OTHERS_3.ToString()));
}
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(clsTasks businessObject)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[sp_InsertTasks]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@TASK_ID", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TASK_ID));
sqlCommand.Parameters.Add(new SqlParameter("@PROJ_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.PROJ_ID));
sqlCommand.Parameters.Add(new SqlParameter("@PROJECT_CODE", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.PROJECT_CODE));
sqlCommand.Parameters.Add(new SqlParameter("@REWORK", SqlDbType.TinyInt, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.REWORK));
if (businessObject.REF_ID == null)
{
sqlCommand.Parameters.Add(new SqlParameter("@REF_ID", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@REF_ID", SqlDbType.VarChar, 15, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.REF_ID));
}
if (businessObject.INC_DESCR == null)
{
sqlCommand.Parameters.Add(new SqlParameter("@INC_DESCR", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@INC_DESCR", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.INC_DESCR));
}
sqlCommand.Parameters.Add(new SqlParameter("@SEVERITY", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.SEVERITY));
sqlCommand.Parameters.Add(new SqlParameter("@INC_TYPE", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.INC_TYPE));
sqlCommand.Parameters.Add(new SqlParameter("@EMP_ID", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EMP_ID));
sqlCommand.Parameters.Add(new SqlParameter("@PHASE", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.PHASE));
sqlCommand.Parameters.Add(new SqlParameter("@STATUS", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.STATUS));
sqlCommand.Parameters.Add(new SqlParameter("@DATE_CREATED", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DATE_CREATED));
if (businessObject.DATE_STARTED == default(DateTime).Date)
{
sqlCommand.Parameters.Add(new SqlParameter("@DATE_STARTED", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@DATE_STARTED", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DATE_STARTED));
}
if (businessObject.TARGET_DATE == default(DateTime).Date)
{
sqlCommand.Parameters.Add(new SqlParameter("@TARGET_DATE", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@TARGET_DATE", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TARGET_DATE));
}
if (businessObject.COMPLTD_DATE == default(DateTime).Date)
{
sqlCommand.Parameters.Add(new SqlParameter("@COMPLTD_DATE", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@COMPLTD_DATE", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.COMPLTD_DATE));
}
sqlCommand.Parameters.Add(new SqlParameter("@EFFORT_EST", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EFFORT_EST));
sqlCommand.Parameters.Add(new SqlParameter("@ACT_EFFORT_WK", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ACT_EFFORT_WK));
sqlCommand.Parameters.Add(new SqlParameter("@ACT_EFFORT", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ACT_EFFORT));
if (businessObject.COMMENTS == null)
{
sqlCommand.Parameters.Add(new SqlParameter("@COMMENTS", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@COMMENTS", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.COMMENTS));
}
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception("clsTASKS::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/// <summary>
/// update row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true for successfully updated</returns>
public bool Update(clsTasks businessObject)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[sp_updateTasksStatus]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@EMP_ID", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EMP_ID));
sqlCommand.Parameters.Add(new SqlParameter("@TASKS_ID", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TASK_ID));
sqlCommand.Parameters.Add(new SqlParameter("@TARGET_DATE", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TARGET_DATE));
sqlCommand.Parameters.Add(new SqlParameter("@STATUS", SqlDbType.SmallInt, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.STATUS));
if (businessObject.COMPLTD_DATE == default(DateTime).Date)
{
sqlCommand.Parameters.Add(new SqlParameter("@COMPLTD_DATE", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@COMPLTD_DATE", SqlDbType.Date, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.COMPLTD_DATE));
}
sqlCommand.Parameters.Add(new SqlParameter("@EFFORT_EST", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EFFORT_EST));
sqlCommand.Parameters.Add(new SqlParameter("@ACT_EFFORT_EST", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ACT_EFFORT_EST));
sqlCommand.Parameters.Add(new SqlParameter("@ACT_EFFORT_EST_WK", SqlDbType.Float, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ACT_EFFORT_EST_WK));
if (businessObject.INC_DESCR == null)
{
sqlCommand.Parameters.Add(new SqlParameter("@INC_DESCR", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@INC_DESCR", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.INC_DESCR));
}
if (businessObject.REMARKS == null)
{
sqlCommand.Parameters.Add(new SqlParameter("@REMARKS", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DBNull.Value));
}
else
{
sqlCommand.Parameters.Add(new SqlParameter("@REMARKS", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.REMARKS));
}
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception("clsTASKS::Update::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
