/// <summary>
/// Manages the trainer delete dal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int32.</returns>
public int ManageTrainer_DeleteDAL(TrainerOpenMapping _mapping)
{
return(ExecuteScalarInt32Sp("TrainerOpenMapping_Delete",
ParamBuilder.Par("ID", _mapping.ID),
ParamBuilder.Par("UpdatedDate", _mapping.UpdatedDate),
ParamBuilder.Par("UpdatedBy", _mapping.UpdatedBy)
));
}
/// <summary>
/// Manages the trainer create dal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int64.</returns>
public long ManageTrainer_CreateDAL(TrainerOpenMapping _mapping)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TrainerOpenMapping_Create", parameters,
ParamBuilder.Par("PersonID", _mapping.PersonID),
ParamBuilder.Par("OpenId", _mapping.OpenId),
ParamBuilder.Par("OpenType", _mapping.OpenType),
ParamBuilder.Par("CreatedBy", _mapping.CreatedBy),
ParamBuilder.Par("CreatedDate", _mapping.CreatedDate)
));
}
/// <summary>
/// Manages the trainer get by id dal.
/// </summary>
/// <param name="ID">The identifier.</param>
/// <returns>TrainerOpenMapping.</returns>
public TrainerOpenMapping ManageTrainer_GetByIDDAL(long ID)
{
TrainerOpenMapping Venue = new TrainerOpenMapping();
using (var conn = new SqlConnection(DBHelper.ConnectionString))
{
conn.Open();
DynamicParameters dbParams = new DynamicParameters();
dbParams.AddDynamicParams(new { ID = ID });
Venue = conn.Query <TrainerOpenMapping>("TrainerOpenMapping_GetbyId", dbParams, commandType: System.Data.CommandType.StoredProcedure).FirstOrDefault <TrainerOpenMapping>();
conn.Close();
}
return(Venue);
}
/// <summary> /// Manages the trainer duplication check bal. /// </summary> /// <param name="_mapping">The mapping.</param> /// <returns>System.Int32.</returns> public int ManageTrainer_AvalabilityCheckBAL(TrainerOpenMapping _mapping) => _ConfigurationDAL.ManageTrainer_AvailabilityCheckDAL(_mapping);
/// <summary> /// Manages the trainer duplication check bal. /// </summary> /// <param name="_mapping">The mapping.</param> /// <returns>System.Int32.</returns> public int ManageTrainer_DuplicationCheckBAL(TrainerOpenMapping _mapping) => _ConfigurationDAL.ManageTrainer_DuplicationCheckDAL(_mapping);
/// <summary> /// Manages the trainer delete bal. /// </summary> /// <param name="_mapping">The mapping.</param> /// <returns>System.Int32.</returns> public int ManageTrainer_DeleteBAL(TrainerOpenMapping _mapping) => _ConfigurationDAL.ManageTrainer_DeleteDAL(_mapping);
/// <summary> /// Manages the trainer create bal. /// </summary> /// <param name="_mapping">The mapping.</param> /// <returns>System.Int64.</returns> public long ManageTrainer_CreateBAL(TrainerOpenMapping _mapping) => _ConfigurationDAL.ManageTrainer_CreateDAL(_mapping);
/// <summary>
/// Manages the trainer duplication check dal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int32.</returns>
public int ManageTrainer_AvailabilityCheckDAL(TrainerOpenMapping _mapping)
{
return(ExecuteScalarSPInt32("TrainerOpenMapping_AvalabilityCheck",
ParamBuilder.Par("PersonID", _mapping.PersonID),
ParamBuilder.Par("OpenId", _mapping.OpenId)));
}
/// <summary>
/// Manages the trainer duplication check dal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int32.</returns>
public int ManageTrainer_DuplicationCheckDAL(TrainerOpenMapping _mapping)
{
return(ExecuteScalarSPInt32("TrainerOpenMapping_DuplicationCheck",
ParamBuilder.Par("PersonID", _mapping.PersonID),
ParamBuilder.Par("OpenId", _mapping.OpenId), ParamBuilder.Par("OpenType", _mapping.OpenType)));
}
