public static BrokerageFeeStructure GetBrokerageFeeStructuresById(int BrokerageFeeStructureID)
{
DataRow BrokerageFeeStructureRow = BrokerageFeeStructureDataAccess.GetInstance.GetBrokerageFeeStructuresById(BrokerageFeeStructureID);
BrokerageFeeStructure TheBrokerageFeeStructure = DataRowToObject(BrokerageFeeStructureRow);
return(TheBrokerageFeeStructure);
}
public static List <BrokerageFeeStructure> GetBrokerageFeeStructureList(bool allOffices = false, bool showDeleted = false)
{
List <BrokerageFeeStructure> BrokerageFeeStructureList = new List <BrokerageFeeStructure>();
DataTable BrokerageFeeStructureTable = BrokerageFeeStructureDataAccess.GetInstance.GetBrokerageFeeStructureList(allOffices, showDeleted);
foreach (DataRow dr in BrokerageFeeStructureTable.Rows)
{
BrokerageFeeStructure TheBrokerageFeeStructure = DataRowToObject(dr);
BrokerageFeeStructureList.Add(TheBrokerageFeeStructure);
}
return(BrokerageFeeStructureList);
}
public static BrokerageFeeStructure DataRowToObject(DataRow dr)
{
BrokerageFeeStructure TheBrokerageFeeStructure = new BrokerageFeeStructure();
TheBrokerageFeeStructure.BrokerageFeeStructureID = int.Parse(dr["BrokerageFeeStructureID"].ToString());
TheBrokerageFeeStructure.PolicyTypeID = int.Parse(dr["PolicyTypeID"].ToString());
TheBrokerageFeeStructure.PolicyTypeDescription = dr["PolicyTypeDescription"].ToString();
TheBrokerageFeeStructure.BrokerageType = dr["BrokerageType"].ToString();
TheBrokerageFeeStructure.DatabaseTableName = dr["DatabaseTableName"].ToString();
TheBrokerageFeeStructure.StoredProcedureName = dr["StoredProcedureName"].ToString();
TheBrokerageFeeStructure.EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat);
return(TheBrokerageFeeStructure);
}
public int DeletBrokerageFeeStructure(BrokerageFeeStructure theBrokerageFeeStructure)
{
int ReturnValue = 0;
using (SqlCommand DeleteCommand = new SqlCommand())
{
DeleteCommand.CommandType = CommandType.StoredProcedure;
DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
DeleteCommand.Parameters.Add(GetParameter("@BrokerageFeeStructureID", SqlDbType.Int, theBrokerageFeeStructure.BrokerageFeeStructureID));
DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
DeleteCommand.CommandText = "pCRM_BrokerageFeeStructures_Delete";
ExecuteStoredProcedure(DeleteCommand);
ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int InsertBrokerageFeeStructure(BrokerageFeeStructure theBrokerageFeeStructure)
{
int Returnvalue = 0;
using (SqlCommand InsertCommand = new SqlCommand())
{
InsertCommand.CommandType = CommandType.StoredProcedure;
InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, Returnvalue)).Direction = ParameterDirection.Output;
InsertCommand.Parameters.Add(GetParameter("@PolicyTypeID", SqlDbType.Int, theBrokerageFeeStructure.PolicyTypeID));
InsertCommand.Parameters.Add(GetParameter("@BrokerageType", SqlDbType.VarChar, theBrokerageFeeStructure.BrokerageType));
InsertCommand.Parameters.Add(GetParameter("@DatabaseTableName", SqlDbType.VarChar, theBrokerageFeeStructure.DatabaseTableName));
InsertCommand.Parameters.Add(GetParameter("@StoredProcedureName", SqlDbType.VarChar, theBrokerageFeeStructure.StoredProcedureName));
InsertCommand.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.VarChar, theBrokerageFeeStructure.EffectiveDateFrom));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_BrokerageFeeStructures_Insert";
ExecuteStoredProcedure(InsertCommand);
Returnvalue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(Returnvalue);
}
}
public static int DeleteBrokerageFeeStructure(BrokerageFeeStructure theBrokerageFeeStructure)
{
return(BrokerageFeeStructureDataAccess.GetInstance.DeletBrokerageFeeStructure(theBrokerageFeeStructure));
}
public static int UpdateBrokerageFeeStructure(BrokerageFeeStructure theBrokerageFeeStructureList)
{
return(BrokerageFeeStructureDataAccess.GetInstance.UpdateBrokerageFeeStructure(theBrokerageFeeStructureList));
}
public int DeleteBrokerageFeeStructure(BrokerageFeeStructure theBrokerageFeeStructure)
{
return(BrokerageFeeStructureIntegration.DeleteBrokerageFeeStructure(theBrokerageFeeStructure));
}
public int UpdateBrokerageFeeStructure(BrokerageFeeStructure theBrokerageFeeStructureList)
{
return(BrokerageFeeStructureIntegration.UpdateBrokerageFeeStructure(theBrokerageFeeStructureList));
}
public int InsertBrokerageFeeStructure(BrokerageFeeStructure theBrokerageFeeStructureList)
{
return(BrokerageFeeStructureIntegration.InsertBrokerageFeeStructure(theBrokerageFeeStructureList));
}
