/// <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))); }