public static bool CheckSerialNumberSubmissionCount(Guid serialNumber)
{
string sqlQuery = @"SELECT COUNT(*)
FROM dbo.Submission
WHERE SerialNumber = @SerialNumber;";
int serialExists = DBDataAccess.CountData(sqlQuery, new { SerialNumber = serialNumber });
return(serialExists != 2);
}
public static bool CheckSerialNumberExists(Guid serialNumber)
{
string sqlQuery = @"SELECT COUNT(*)
FROM dbo.Product
WHERE SerialNumber = @SerialNumber;";
int serialExists = DBDataAccess.CountData(sqlQuery, new { SerialNumber = serialNumber });
return(serialExists == 1);
}