public static string GetScientificName(int record_id)
{
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT SCIENTIFIC FROM [MARINE_SPECIES] WHERE [ID_PK] LIKE @RECORD_ID";
command.Parameters.AddWithValue("@RECORD_ID", record_id);
return(DAOHelper.RetreiveString(command));
}
public static (string, string) CheckScientificName(string scientific_name)
{
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT ID_PK, [SCIENTIFIC] FROM [MARINE_SPECIES] WHERE [SCIENTIFIC] LIKE @SCIENTIFIC_TEXT";
command.Parameters.AddWithValue("@SCIENTIFIC_TEXT", "%" + scientific_name + "%");
//return DAOHelper.RetreiveID(command);
List <string> result = DAOHelper.RetreiveAllString(command, 2);
switch (result.Count)
{
case 2: return(result[0], result[1]);
case 1: return(result[0], "");
default: return("-1", "");
}
}
public static int GetIDByScientificName(string scientific_name)
{
/*
* CREATE TABLE [dbo].[MARINE_SPECIES] (
* [ID_PK] INT IDENTITY (1, 1) NOT NULL,
* [CLASS_FK] INT NOT NULL,
* [SPECIES_FK] INT NOT NULL,
* [SCIENTIFIC] NVARCHAR (40) NOT NULL,
* [COMMON] NVARCHAR (80) NULL,
* [TEXT] NVARCHAR (50) NULL,
* [FAMILY_FK] INT NULL,
* CONSTRAINT [PK_MARINE_SPECIES] PRIMARY KEY CLUSTERED ([ID_PK] ASC),
* CONSTRAINT [FK_MARINE_SPECIES_MARINE_CLASS] FOREIGN KEY ([CLASS_FK]) REFERENCES [dbo].[MARINE_CLASS] ([ID_PK]),
* CONSTRAINT [FK_MARINE_SPECIES_MARINE_FAMILY] FOREIGN KEY ([FAMILY_FK]) REFERENCES [dbo].[MARINE_FAMILY] ([ID_PK])
* );
*/
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT ID_PK FROM [MARINE_SPECIES] WHERE [SCIENTIFIC] LIKE @SCIENTIFIC_TEXT";
command.Parameters.AddWithValue("@SCIENTIFIC_TEXT", "%" + scientific_name + "%");
return(DAOHelper.RetreiveID(command));
}