// insert SelectedAction
public bool insertAndDeleteSelectedAction(clsConcern businessObject)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[sp_InsertAndDeleteSelectedAction]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
MainConnection.Open();
//sqlCommand.Parameters.Add(new SqlParameter("@REF_ID", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.REF_ID));
sqlCommand.Parameters.Add(new SqlParameter("@REF_ID", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.REF_ID));
sqlCommand.Parameters.Add(new SqlParameter("@ACTREF", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ACTREF));
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception("clsConcern::Update::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
// insert CONCERN
public bool insert(clsConcern businessObject, string email)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[sp_InsertConcernCauseCounterMeasure]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
MainConnection.Open();
sqlCommand.Parameters.Add(new SqlParameter("@EMAILADDRESS", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, email));
//sqlCommand.Parameters.Add(new SqlParameter("@REF_ID", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.REF_ID));
sqlCommand.Parameters.Add(new SqlParameter("@CONCERN", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CONCERN));
sqlCommand.Parameters.Add(new SqlParameter("@CAUSE", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CAUSE));
sqlCommand.Parameters.Add(new SqlParameter("@COUNTERMEASURE", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.COUNTERMEASURE));
sqlCommand.Parameters.Add(new SqlParameter("@DUE_DATE", SqlDbType.DateTime, 15, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DUE_DATE));
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception("clsConcern::Update::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/// <summary>
/// insert into Concern.
/// </summary>
/// <param name="keys">primary key</param>
public bool Insert(clsConcern businessObject, string email)
{
if (!businessObject.IsValid)
{
throw new InvalidBusinessObjectException(businessObject.BrokenRulesList.ToString());
}
return(_dataObject.insert(businessObject, email));
}
/// <summary>
/// UPDATE SELECTED CONCERN
/// </summary>
/// <param name="keys">primary key</param>
public bool UpdateSelectedConcern(clsConcern businessObject)
{
if (!businessObject.IsValid)
{
throw new InvalidBusinessObjectException(businessObject.BrokenRulesList.ToString());
}
return(_dataObject.UpdateSelectedConcern(businessObject));
}
internal List <clsConcern> PopulateObjectsFromReaderActionReferences(IDataReader dataReader)
{
List <clsConcern> list = new List <clsConcern>();
while (dataReader.Read())
{
clsConcern businessObject = new clsConcern();
PopulateBusinessObjectFromReaderActionReferences(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
internal void PopulateBusinessObjectFromReader(clsConcern businessObject, IDataReader dataReader)
{
businessObject.REF_ID = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.REF_ID.ToString()));
businessObject.CONCERN = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.CONCERN.ToString()));
businessObject.CAUSE = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.CAUSE.ToString()));
businessObject.COUNTERMEASURE = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.COUNTERMEASURE.ToString()));
businessObject.EMP_ID = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.EMP_ID.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsConcern.clsConcernFields.ACT_REFERENCE.ToString())))
{
businessObject.ACT_REFERENCE = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.ACT_REFERENCE.ToString()));
}
else
{
businessObject.ACT_REFERENCE = string.Empty;
}
businessObject.DUE_DATE = dataReader.GetDateTime(dataReader.GetOrdinal(clsConcern.clsConcernFields.DUE_DATE.ToString()));
businessObject.DESCR = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.DESCR.ToString()));
}
//GET GENERATED REFNO
public clsConcern GetGeneratedRefNo()
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "[dbo].[sp_GetGeneratedRefNo]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
MainConnection.Open();
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
clsConcern businessObjects = new clsConcern();
//
PopulateBusinessObjectFromReaderGeneratedRefNo(businessObjects, dataReader);
//
return(businessObjects);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("clsConcernGetGeneratedRefNo::getProfile::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
internal void PopulateBusinessObjectFromReaderActionReferences(clsConcern businessObject, IDataReader dataReader)
{
businessObject.ACTION_REFERENCES = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.ACTION_REFERENCES.ToString()));
businessObject.ACTREF = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.ACTREF.ToString()));
}
internal void PopulateBusinessObjectFromReaderAction(clsConcern businessObject, IDataReader dataReader)
{
businessObject.ACTREF = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.ACTREF.ToString()));
businessObject.ACT_MESSAGE = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.ACT_MESSAGE.ToString()));
businessObject.DUE_DATE = dataReader.GetDateTime(dataReader.GetOrdinal(clsConcern.clsConcernFields.DUE_DATE.ToString()));
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
///
internal void PopulateBusinessObjectFromReaderGeneratedRefNo(clsConcern businessObject, IDataReader dataReader)
{
businessObject.GENERATEDREF_ID = dataReader.GetString(dataReader.GetOrdinal(clsConcern.clsConcernFields.GENERATEDREF_ID.ToString()));
}
