public static int DeleteUserRole(int _Id)
{
UserRoleModel data = new UserRoleModel {
UserRoleId = _Id
};
string sql = "spDeleteUserRole";
return(SqlDataAccess.DeleteRecord(sql, new { UserRoleId = _Id }));
}
public static int DeleteRolePermission(int _PermissionId, int _RoleId)
{
string sql = @"spDeleteRolePermission";
var data = new DynamicParameters();
data.Add("@permissionid", _PermissionId);
data.Add("@roleid", _RoleId);
return(SqlDataAccess.DeleteRecord(sql, data));
}
public static int DeleteUnitOffering(int unitOfferingId)
{
try
{
string sql = "spDeleteUnitOffering";
return(SqlDataAccess.DeleteRecord(sql, new { unitofferingid = unitOfferingId }));
}
catch (Exception E)
{
SqlDataAccess.TryConvertExceptionMessage(E);
}
return(0);
}
public static int DeleteEnrollment(int _Id)
{
string sql = "spDeleteEnrollment";
return(SqlDataAccess.DeleteRecord(sql, new { EnrollmentId = _Id }));
}
public static int DeleteUnit(int unitId)
{
string sql = "spDeleteUnit";
return(SqlDataAccess.DeleteRecord(sql, new { UnitId = unitId }));
}
public static int DeleteYear(int yearId)
{
string sql = "spDeleteYear";
return(SqlDataAccess.DeleteRecord(sql, new { YearId = yearId }));
}
public static int DeleteTeam(int _TeamId)
{
string sql = "spDeleteTeam";
return(SqlDataAccess.DeleteRecord(sql, new { TeamId = _TeamId }));
}
