/// <summary>
/// TMSs the categories duplication check dal.
/// </summary>
/// <param name="_categories">The categories.</param>
/// <returns>System.Int32.</returns>
public int TMSCategories_DuplicationCheckDAL(TMSCategories _categories)
{
return(ExecuteScalarSPInt32("TMS_Categories_DuplicationCheck",
ParamBuilder.Par("ID", _categories.ID),
ParamBuilder.Par("OrganizationID", _categories.OrganizationID),
ParamBuilder.Par("Code", _categories.Code)));
}
/// <summary>
/// TMSs the categories delete dal.
/// </summary>
/// <param name="_categories">The categories.</param>
/// <returns>System.Int32.</returns>
public int TMSCategories_DeleteDAL(TMSCategories _categories)
{
return(ExecuteScalarInt32Sp("TMS_Categories_Delete",
ParamBuilder.Par("ID", _categories.ID),
ParamBuilder.Par("UpdatedBy", _categories.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _categories.UpdatedDate)));
}
/// <summary>
/// TMSs the categories update dal.
/// </summary>
/// <param name="_categories">The categories.</param>
/// <returns>System.Int32.</returns>
public int TMSCategories_UpdateDAL(TMSCategories _categories)
{
return(ExecuteScalarInt32Sp("TMS_Categories_Update",
ParamBuilder.Par("ID", _categories.ID),
ParamBuilder.Par("PrimaryCategoryName", _categories.PrimaryCategoryName),
ParamBuilder.Par("SecondaryCategoryName", _categories.SecondaryCategoryName),
ParamBuilder.Par("PrimaryDescription", _categories.PrimaryDescription),
ParamBuilder.Par("SecondaryDescription", _categories.SecondaryDescription),
ParamBuilder.Par("Code", _categories.Code),
ParamBuilder.Par("UpdatedBy", _categories.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _categories.UpdatedDate),
ParamBuilder.Par("IsActive", _categories.IsActive),
ParamBuilder.Par("CategoryType", _categories.CategoryType)));
}
/// <summary>
/// TMSs the categories get by id dal.
/// </summary>
/// <param name="ID">The identifier.</param>
/// <returns>TMSCategories.</returns>
public TMSCategories TMSCategories_GetByIDDAL(long ID)
{
TMSCategories Venue = new TMSCategories();
using (var conn = new SqlConnection(DBHelper.ConnectionString))
{
conn.Open();
DynamicParameters dbParams = new DynamicParameters();
dbParams.AddDynamicParams(new { ID = ID });
Venue = conn.Query <TMSCategories>("TMS_Categories_GetbyId", dbParams, commandType: System.Data.CommandType.StoredProcedure).FirstOrDefault <TMSCategories>();
conn.Close();
}
return(Venue);
}
/// <summary>
/// TMSs the categories create dal.
/// </summary>
/// <param name="_categories">The categories.</param>
/// <returns>System.Int64.</returns>
public long TMSCategories_CreateDAL(TMSCategories _categories)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_Categories_Create", parameters,
ParamBuilder.Par("PrimaryCategoryName", _categories.PrimaryCategoryName),
ParamBuilder.Par("SecondaryCategoryName", _categories.SecondaryCategoryName),
ParamBuilder.Par("PrimaryDescription", _categories.PrimaryDescription),
ParamBuilder.Par("SecondaryDescription", _categories.SecondaryDescription),
ParamBuilder.Par("Code", _categories.Code),
ParamBuilder.Par("OrganizationID", _categories.OrganizationID),
ParamBuilder.Par("CreatedBy", _categories.CreatedBy),
ParamBuilder.Par("CreatedDate", _categories.CreatedDate),
ParamBuilder.Par("IsActive", _categories.IsActive),
ParamBuilder.Par("CategoryType", _categories.CategoryType)));
}
/// <summary> /// TMSs the categories duplication check bal. /// </summary> /// <param name="_categories">The categories.</param> /// <returns>System.Int32.</returns> public int TMSCategories_DuplicationCheckBAL(TMSCategories _categories) => _ConfigurationDAL.TMSCategories_DuplicationCheckDAL(_categories);
/// <summary> /// TMSs the categories delete bal. /// </summary> /// <param name="_categories">The categories.</param> /// <returns>System.Int32.</returns> public int TMSCategories_DeleteBAL(TMSCategories _categories) => _ConfigurationDAL.TMSCategories_DeleteDAL(_categories);
/// <summary> /// TMSs the categories create bal. /// </summary> /// <param name="_categories">The categories.</param> /// <returns>System.Int64.</returns> public long TMSCategories_CreateBAL(TMSCategories _categories) => _ConfigurationDAL.TMSCategories_CreateDAL(_categories);
