/// <summary>
/// Manages the venues delete dal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int32.</returns>
public int ManageVenues_DeleteDAL(VenueOpenMapping _mapping)
{
return(ExecuteScalarInt32Sp("VenueOpenMapping_Delete",
ParamBuilder.Par("ID", _mapping.ID),
ParamBuilder.Par("UpdatedDate", _mapping.UpdatedDate),
ParamBuilder.Par("UpdatedBy", _mapping.UpdatedBy)
));
}
/// <summary>
/// Manages the venues create dal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int64.</returns>
public long ManageVenues_CreateDAL(VenueOpenMapping _mapping)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("VenueOpenMapping_Create", parameters,
ParamBuilder.Par("VenueID", _mapping.VenueID),
ParamBuilder.Par("OpenId", _mapping.OpenId),
ParamBuilder.Par("OpenType", _mapping.OpenType),
ParamBuilder.Par("CreatedBy", _mapping.CreatedBy),
ParamBuilder.Par("CreatedDate", _mapping.CreatedDate)
));
}
/// <summary>
/// Manages the venues get by iddal.
/// </summary>
/// <param name="ID">The identifier.</param>
/// <returns>VenueOpenMapping.</returns>
public VenueOpenMapping ManageVenues_GetByIDDAL(long ID)
{
VenueOpenMapping Venue = new VenueOpenMapping();
using (var conn = new SqlConnection(DBHelper.ConnectionString))
{
conn.Open();
DynamicParameters dbParams = new DynamicParameters();
dbParams.AddDynamicParams(new { ID = ID });
Venue = conn.Query <VenueOpenMapping>("VenueOpenMapping_GetbyId", dbParams, commandType: System.Data.CommandType.StoredProcedure).FirstOrDefault <VenueOpenMapping>();
conn.Close();
}
return(Venue);
}
/// <summary>
/// Manags the venues duplication check bal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int32.</returns>
public int ManageVenues_DuplicationCheckBAL(VenueOpenMapping _mapping)
{
return(_ConfigurationDAL.ManageVenues_DuplicationCheckDAL(_mapping));
}
/// <summary>
/// Manages the venues delete bal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int32.</returns>
public int ManageVenues_DeleteBAL(VenueOpenMapping _mapping)
{
return(_ConfigurationDAL.ManageVenues_DeleteDAL(_mapping));
}
/// <summary>
/// Manages the venues create bal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int64.</returns>
public long ManageVenues_CreateBAL(VenueOpenMapping _mapping)
{
return(_ConfigurationDAL.ManageVenues_CreateDAL(_mapping));
}
/// <summary>
/// Manages the venues duplication check dal.
/// </summary>
/// <param name="_mapping">The mapping.</param>
/// <returns>System.Int32.</returns>
public int ManageVenues_DuplicationCheckDAL(VenueOpenMapping _mapping)
{
return(ExecuteScalarSPInt32("VenueOpenMapping_DuplicationCheck",
ParamBuilder.Par("VenueID", _mapping.VenueID),
ParamBuilder.Par("OpenId", _mapping.OpenId), ParamBuilder.Par("OpenType", _mapping.OpenType)));
}
