private int ProcessRECORD_PET_SIZE(string selected_field)
{
/*
* CREATE TABLE [dbo].[RECORD_PET_SIZE] (
* [ID_PK] INT IDENTITY (1, 1) NOT NULL,
* [DESCRIPTION] NVARCHAR (25) NOT NULL,
* PRIMARY KEY CLUSTERED ([ID_PK] ASC)
* );
*/
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT ID_PK FROM [RECORD_PET_SIZE] WHERE [DESCRIPTION] = @FIELD_TEXT";
command.Parameters.AddWithValue("@FIELD_TEXT", selected_field);
int field_id = DAOHelper.RetreiveID(command);
SqlCommand executeDataCommand = new SqlCommand();
executeDataCommand.Parameters.AddWithValue("@FIELD_TEXT", selected_field);
if (field_id == -1) /* New Record */
{
executeDataCommand.CommandText = "INSERT INTO [RECORD_PET_SIZE] ([DESCRIPTION]) VALUES(@FIELD_TEXT) ;";
DAOHelper.InsertData(executeDataCommand);
field_id = DAOHelper.RetreiveID(command);
}
else
{
executeDataCommand.CommandText = "UPDATE [RECORD_PET_SIZE] SET [DESCRIPTION] = @FIELD_TEXT WHERE [ID_PK] = @ID_PK ;";
executeDataCommand.Parameters.AddWithValue("@ID_PK", field_id);
DAOHelper.InsertData(executeDataCommand);
}
return(field_id);
}
public async Task <IMetering> GetLastMetering(string terminalId)
{
// Get last metering
MeteringDAO lastMetering = await _context.Meterings
.Include(x => x.SensorValueRelations)
.OrderByDescending(x => x.Time)
.FirstOrDefaultAsync(x => x.TerminalId == terminalId);
// Map to Metering model
Metering res = new Metering()
{
TerminalId = lastMetering.TerminalId,
Latitude = lastMetering.Latitude,
Longitude = lastMetering.Longitude,
Time = lastMetering.Time,
};
// Get sensor vals for last metering
var sensorVals = await _context.MeteringSensorRelations
.Include(x => x.Metering)
.Include(x => x.SensorValue)
.Where(x => x.Metering.Id == lastMetering.Id)
.ToListAsync();
foreach (var sv in sensorVals)
{
Property prop = DynamicPropertyManagers.Sensors.GetProperty(sv.PropertyName);
res.SensorValues.SetValue(prop, DAOHelper.ByteArrayToObject(prop.TypeOfValue, sv.SensorValue.Value));
}
return(res);
}
public void SaveMetering(IMetering metering)
{
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
try
{
var m = _context.Meterings.Add(Mapper.Map <MeteringDAO>(metering));
_context.SaveChanges();
foreach (var met in metering.SensorValues)
{
var sv = _context.SensorValues.Add(new SensorValueDAO()
{
Value = DAOHelper.ObjectToByteArray(met.Value)
});
_context.SaveChanges();
_context.MeteringSensorRelations.Add(new MeteringSensorValueRelationDAO()
{
MeteringId = m.Id,
SensorValueId = sv.Id,
PropertyName = met.Key.Name
});
_context.SaveChanges();
}
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
throw;
}
}
}
public IHttpActionResult Put(Livro livro)
{
using (var command = DAOHelper.CreateCommand("Livro_Insert"))
{
command.Parameters.AddWithValue("$Id", livro.Id).Direction = System.Data.ParameterDirection.InputOutput;
command.Parameters.AddWithValue("$ISBN", livro.ISBN);
command.Parameters.AddWithValue("$Autor", livro.Autor);
command.Parameters.AddWithValue("$Nome", livro.Nome);
command.Parameters.AddWithValue("$Preco", livro.Preco);
command.Parameters.AddWithValue("$DataPublicacao", livro.DataPublicacao);
command.Parameters.AddWithValue("$ImagemCapa", livro.ImagemCapa);
command.ExecuteNonQuery();
livro.Id = (int)command.Parameters["$Id"].Value;
}
if (livro.Id > 0)
{
return(Ok(livro));
}
else
{
return(BadRequest("Não foi possível inserir o livro"));
}
}
static void Main(string[] args)
{
LogHelper.setLogFile("../logs/Log_OPCSampleGrpConfig.txt");
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
try
{
OPCSampleGrpConfig.Common.FormCaptionHelper.GetInstance().AddCaptionsToStringHelper();
ConfigureFileHelper.GetInstance().init();
//Connect to central database
DBConnectionStrings.GetInstance().AddConnectionString(ConfigureFileHelper.GetInstance().ConnectionStringConfig);
//set the language and encoding change
LanguageType type = LanguageTypeHelper.GetInstance().GetLanTypeByLanStr(ConfigureFileHelper.GetInstance().LanguageStr);
LanguageTypeHelper.GetInstance().SetLanaguageType(type);
DAOHelper.SetEncodingChange(ConfigureFileHelper.GetInstance().EncodingChange);
ViewManager.GetInstance().RegisterViewFactory(new OPCSampleGrpConfigViewFactory());
IView view = ViewManager.GetInstance().GetView(OPCSampleGrpConfigStart.OPCSAMPLEGRPCONFIGSTARTFRM);
Form frm = (Form)view;
if (args.Length > 0)
{
OPCSampleGrpConfigStartController sampleGrpController = (OPCSampleGrpConfigStartController)view.getController();
sampleGrpController.SetSampleGrpConfigLocation(ref frm, args[0]);
}
Application.Run(frm);
}
catch (Exception localExecption)
{
Console.WriteLine(localExecption.ToString());
}
DBConnectionStrings.GetInstance().TerminateMonitorThread();
}
public void TestConvertLineTypeToDBString01()
{
LineType lineType = LineType.Spline;
string str = DAOHelper.ConvertLineTypeToDBString(lineType);
lineType = LineType.Line;
str = DAOHelper.ConvertLineTypeToDBString(lineType);
}
public void TestChangeStrToBool01()
{
string str = string.Empty;
bool b = DAOHelper.ChangeStrToBool(str);
DAOHelper.ChangeStrToBool("Y");
}
public SqlQueryBuilder Select(IEnumerable <SelectField> fields)
{
fields.AssertNotNull(nameof(fields));
fields = fields.Select(x => new SelectField(DAOHelper.EscapeField(x.Field), x.Alias));
_selectFields = fields;
return(this);
}
private void ProcessMarineSpeciesData(int class_id, int counter, string scientific, string common)
{
int record_id = -1;
SqlCommand command;
/*
* 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])
* );
*/
/*
* For Hard Coral, [Acanthastrea lordhowensis] is repeated twice in the document
*
*/
command = new SqlCommand();
command.CommandText = "SELECT ID_PK FROM [MARINE_SPECIES] WHERE [SCIENTIFIC] = @SCIENTIFIC_TEXT";
command.Parameters.AddWithValue("@SCIENTIFIC_TEXT", scientific);
record_id = DAOHelper.RetreiveID(command);
SqlCommand insertDataCommand = new SqlCommand();
insertDataCommand.Parameters.AddWithValue("@CLASS_ID", class_id);
insertDataCommand.Parameters.AddWithValue("@SPECIES_ID", counter);
insertDataCommand.Parameters.AddWithValue("@SCIENTIFIC_TEXT", scientific);
insertDataCommand.Parameters.AddWithValue("@COMMON_TEXT", common);
if (record_id == -1) /* New Record */
{
insertDataCommand.CommandText = "INSERT INTO [MARINE_SPECIES] " +
"([CLASS_FK], [SPECIES_FK], [SCIENTIFIC], [COMMON]) VALUES (@CLASS_ID, @SPECIES_ID, @SCIENTIFIC_TEXT,@COMMON_TEXT) ;";
DAOHelper.InsertData(insertDataCommand);
//record_id = DAOHelper.RetreiveID(command);
}
else
{
insertDataCommand.CommandText = "UPDATE [MARINE_SPECIES] " +
"SET [CLASS_FK] = @CLASS_ID, [SPECIES_FK] = @SPECIES_ID, [SCIENTIFIC] = @SCIENTIFIC_TEXT, [COMMON] = @COMMON_TEXT " +
" WHERE [ID_PK] = @ID_PK ;";
insertDataCommand.Parameters.AddWithValue("@ID_PK", record_id);
DAOHelper.InsertData(insertDataCommand);
}
//return record_id;
}
public void Testconvert8859P1ToGB231201()
{
string s = string.Empty;
string str = DAOHelper.convert8859P1ToGB2312(s);
DAOHelper.SetEncodingChange(true);
DAOHelper.convert8859P1ToGB2312(s);
DAOHelper.SetEncodingChange(false);
}
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 void TestconvertGB2312To8859P101()
{
string str = string.Empty;
string str1 = DAOHelper.convertGB2312To8859P1(str);
DAOHelper.SetEncodingChange(true);
DAOHelper.convertGB2312To8859P1(str);
DAOHelper.SetEncodingChange(false);
}
public void TestCreateEnqueneParameters()
{
List <string> pas = new List <string>();
pas.Add("a");
try
{
DAOHelper.CreateEnqueneParameters(pas);
}
catch (System.Exception ex)
{
}
}
private DBType GetDatabaseTypeFromString(string databaseConnectionString)
{
string FUNCTION_NAME = "GetDatabaseTypeFromString";
LogHelper.Trace(CLASS_NAME, FUNCTION_NAME, "Function_Entered");
//connection string will have dbtype at the first of the string with ';' as delimiter.
string dbTypeString = databaseConnectionString.Substring(0, databaseConnectionString.IndexOf(DAOHelper.DB_Delimiter));
DBType dbType = DAOHelper.GetDbType(dbTypeString);
LogHelper.Debug(CLASS_NAME, FUNCTION_NAME, string.Format("Database Type = {0}", dbType.ToString()));
return(dbType);
}
public async Task <double> GetSumPropertyValue(string terminalId, SensorProperty prop, DateTime start, DateTime end)
{
// Try cast to double
if (typeof(double).IsAssignableFrom(prop.TypeOfValue))
{
return
((await Filter(terminalId, prop, start, end)).Sum(
selector => (double)DAOHelper.ByteArrayToObject(prop.TypeOfValue, selector.SensorValue.Value)));
}
// Try convert to double
return((await Filter(terminalId, prop, start, end))
.Sum(selector => Convert.ToDouble(DAOHelper.ByteArrayToObject(prop.TypeOfValue, selector.SensorValue.Value))));
}
public IEnumerable <Livro> GetAll()
{
List <Livro> livros = new List <Livro>();
using (var command = DAOHelper.CreateCommand("Livro_SelectAll"))
using (MySqlDataReader reader = command.ExecuteReader())
while (reader.Read())
{
livros.Add(CreateEntity(reader));
}
return(livros);
}
static void Main()
{
ConfigureFileHelper.GetInstance().init();
//LanguageType type = LanguageTypeHelper.GetInstance().GetLanTypeByLanStr(ConfigureFileHelper.GetInstance().LanguageStr);
//LanguageTypeHelper.GetInstance().SetLanaguageType(type);
DAOHelper.SetEncodingChange(ConfigureFileHelper.GetInstance().EncodingChange);
STEE.ISCS.Log.LogHelper.setLogFile("../logs/Log_OPCDataLogger.txt");
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new OPCDataLogger());
}
static void Main(string[] args)
{
MySqlConnection conn = DAOHelper.GetConnection();
IDataReader reader = DAOHelper.QueryReader("SELECT * FROM user", conn);
while (reader.Read())
{
Console.WriteLine(reader["Host"]); // 打印出每个用户的用户名
}
//DataTable table = ds.Tables[0];
//string user = table.Columns["User"].ToString();
//Console.WriteLine("abcd");
Console.ReadLine();
}
private DBType GetDatabaseTypeFromString(string databaseConnectionString)
{
string FUNCTION_NAME = "GetDatabaseTypeFromString";
LogHelperCli.GetInstance().Log_Generic(CLASS_NAME + "." + FUNCTION_NAME, LogHelperCli.GetInstance().GetLineNumber(),
EDebugLevelManaged.DebugInfo, "Function Entered.");
//connection string will have dbtype at the first of the string with ';' as delimiter.
string dbTypeString = databaseConnectionString.Substring(0, databaseConnectionString.IndexOf(DAOHelper.DB_Delimiter));
DBType dbType = DAOHelper.GetDbType(dbTypeString);
LogHelperCli.GetInstance().Log_Generic(CLASS_NAME + "." + FUNCTION_NAME, LogHelperCli.GetInstance().GetLineNumber(),
EDebugLevelManaged.DebugInfo, string.Format("Database Type = {0}", dbType.ToString()));
return(dbType);
}
private int ProcessMarineClassData(string selected_field)
{
SqlCommand command;
//string selected_field = GetSelectedWord(line, field_name);
/*
* CREATE TABLE [dbo].[MARINE_CLASS] (
* [ID_PK] INT IDENTITY (1, 1) NOT NULL,
* [TEXT] NVARCHAR (40) NULL,
* [SCHEDULE4] NVARCHAR (40) NOT NULL,
* PRIMARY KEY CLUSTERED ([ID_PK] ASC)
* );
*/
/* Check whether the field name is in [MARINE_CLASS] */
//sql_statement = "SELECT ID_PK FROM [MARINE_CLASS] WHERE [SCHEDULE4] = @FIELD_TEXT";
command = new SqlCommand();
command.CommandText = "SELECT ID_PK FROM [MARINE_CLASS] WHERE [SCHEDULE4] = @FIELD_TEXT";
command.Parameters.AddWithValue("@FIELD_TEXT", selected_field);
int field_id = DAOHelper.RetreiveID(command);
//command.CommandText = "SELECT ID_PK FROM [MARINE_CLASS] WHERE [SCHEDULE4] = @FIELD_TEXT";
SqlCommand executeDataCommand = new SqlCommand();
executeDataCommand.Parameters.AddWithValue("@FIELD_TEXT", selected_field);
if (field_id == -1) /* New Record */
{
executeDataCommand.CommandText = "INSERT INTO [MARINE_CLASS] ([SCHEDULE4]) VALUES(@FIELD_TEXT) ;";
DAOHelper.InsertData(executeDataCommand);
field_id = DAOHelper.RetreiveID(command);
}
else
{
executeDataCommand.CommandText = "UPDATE [MARINE_CLASS] SET [SCHEDULE4] = @FIELD_TEXT WHERE [ID_PK] = @ID_PK ;";
executeDataCommand.Parameters.AddWithValue("@ID_PK", field_id);
DAOHelper.InsertData(executeDataCommand);
}
//return command;
return(field_id);
}
public async Task <List <Metering> > GetMeterings(string terminalId, DateTime start, DateTime end, SensorProperty prop)
{
return((await FilterQuery(start, end, terminalId, prop)
.OrderBy(x => x.Metering.Time)
.ToListAsync())
.Select(x => new Metering()
{
TerminalId = x.Metering.TerminalId,
Longitude = x.Metering.Longitude,
Latitude = x.Metering.Latitude,
Time = x.Metering.Time,
SensorValues = new PropertiesCollection(new [] { new KeyValuePair <Property, object>(
DynamicPropertyManagers.Sensors.GetProperty(prop.Name),
DAOHelper.ByteArrayToObject(prop.TypeOfValue, x.SensorValue.Value)), })
})
.ToList());
}
public IHttpActionResult Delete(int id)
{
int result = 0;
using (var command = DAOHelper.CreateCommand("Livro_Delete"))
{
command.Parameters.AddWithValue("$Id", id);
result = command.ExecuteNonQuery();
}
if (result > 0)
{
return(Ok());
}
else
{
return(BadRequest("Não foi possível deleter o livro de Id: " + id.ToString()));
}
}
private string getConnectionStringBasedType(string configFile, string dbLabel)
{
string connectionString;
DBType dbType = DAOHelper.GetDbType(GetINIDataString(dbLabel, "DB_TYPE", "", 255, configFile));
if (dbType == DBType.Oracle)
{
connectionString = GetINIDataString(dbLabel, "DB_TYPE", "", 255, configFile) + ";Data Source = " + GetINIDataString(dbLabel, "SERVICE_NAME", "", 255, configFile) + ";" +
"User Id = " + GetINIDataString(dbLabel, "USER_ID", "", 255, configFile) + "; " +
"Password = "******"USER_PASSWORD", "", 255, configFile) + "; ";
}
else
{
connectionString = GetINIDataString(dbLabel, "DB_TYPE", "", 255, configFile) + ";Database = " + GetINIDataString(dbLabel, "SERVICE_NAME", "", 255, configFile) + ";" +
"User Id = " + GetINIDataString(dbLabel, "USER_ID", "", 255, configFile) + "; " +
"Password = "******"USER_PASSWORD", "", 255, configFile) + ";Host = " + GetINIDataString(dbLabel, "HOST_NAME", "", 255, configFile) + ";Port=3306;";
}
return(connectionString);
}
static void Main(string[] args)
{
string Function_Name = "Main";
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
// Add the event handler for handling UI thread exceptions to the event.
Application.ThreadException += new ThreadExceptionEventHandler(Program.UIThreadExceptionHandler);
try
{
ConfigureFileHelper.GetInstance().init();
//LanguageTypeHelper.GetInstance().SetLanaguageType(LanguageType.English);
LanguageType type = LanguageTypeHelper.GetInstance().GetLanTypeByLanStr(ConfigureFileHelper.GetInstance().LanguageStr);
LanguageTypeHelper.GetInstance().SetLanaguageType(type);
DAOHelper.SetEncodingChange(ConfigureFileHelper.GetInstance().EncodingChange);
LanguageHelper.InitAllStrings();
string eventName = CreateWin32EventAndSetLogFile();
ViewManager.GetInstance().RegisterViewFactory(new TrendingViewFactory());
IView view = ViewManager.GetInstance().GetView(TrendViewConst.TrendView); //viewID is ""
Form frm = (Form)view;
if (args.Length > 0)
{
TrendViewController trendController = (TrendViewController)view.getController();
trendController.DrawTrendView(ref frm, args[0]);
}
Application.Run(frm);
//event will be closed automatically.
LogHelper.Info(CLASS_NAME, Function_Name, "Closed Event:" + eventName);
}
catch (Exception localExecption)
{
LogHelper.Error("TrendViewer.Program", Function_Name, localExecption.ToString());
}
}
private void updateSpeciesData(int family_id, string selected_field)
{
/*
* 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])
* );
*/
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT ID_PK FROM [MARINE_SPECIES] WHERE [SCIENTIFIC] = @FIELD_TEXT";
command.Parameters.AddWithValue("@FIELD_TEXT", selected_field);
int field_id = DAOHelper.RetreiveID(command);
if (field_id > 0 && family_id > 0)
{
SqlCommand executeDataCommand = new SqlCommand();
executeDataCommand.CommandText = "UPDATE [MARINE_SPECIES] SET [FAMILY_FK] = @FAMILY_ID WHERE [ID_PK] = @ID_PK ;";
executeDataCommand.Parameters.AddWithValue("@FAMILY_ID", family_id);
executeDataCommand.Parameters.AddWithValue("@ID_PK", field_id);
DAOHelper.InsertData(executeDataCommand);
Console.Write(" ==> Record Found !!!");
}
/*
* Please note that due to an error in the doucment, the following reocord is not updated with family id
*
* Puntius cumingii, it should be Puntius cumungii
*
*/
}
public IHttpActionResult GetById(int id)
{
Livro livro = null;
using (var command = DAOHelper.CreateCommand("Livro_SelectById"))
{
command.Parameters.AddWithValue("$Id", id);
using (MySqlDataReader reader = command.ExecuteReader())
if (reader.Read())
{
livro = CreateEntity(reader);
}
}
if (livro == null)
{
return(NotFound());
}
return(Ok(livro));
}
public IEnumerable <Livro> Search(string isbn = "", string autor = "", string nome = "", double preco = 0, DateTime?dataPublicacao = null, string imagemCapa = "")
{
List <Livro> livros = new List <Livro>();
using (var command = DAOHelper.CreateCommand("Livro_Search"))
{
command.Parameters.AddWithValue("$ISBN", string.IsNullOrEmpty(isbn) ? DBNull.Value : (object)isbn);
command.Parameters.AddWithValue("$Autor", string.IsNullOrEmpty(autor) ? DBNull.Value : (object)autor);
command.Parameters.AddWithValue("$Nome", string.IsNullOrEmpty(nome) ? DBNull.Value : (object)nome);
command.Parameters.AddWithValue("$Preco", preco == 0 ? DBNull.Value : (object)preco);
command.Parameters.AddWithValue("$DataPublicacao", dataPublicacao == null ? DBNull.Value : (object)dataPublicacao);
command.Parameters.AddWithValue("$ImagemCapa", string.IsNullOrEmpty(imagemCapa) ? DBNull.Value : (object)imagemCapa);
using (MySqlDataReader reader = command.ExecuteReader())
while (reader.Read())
{
livros.Add(CreateEntity(reader));
}
}
return(livros);
}
private int ProcessMarineFamilyData(string selected_field)
{
/*
* CREATE TABLE [dbo].[MARINE_FAMILY] (
* [ID_PK] INT IDENTITY (1, 1) NOT NULL,
* [TEXT] NVARCHAR (25) NOT NULL,
* [SCHEDULE3] NVARCHAR (25) NOT NULL,
* PRIMARY KEY CLUSTERED ([ID_PK] ASC)
* );
*/
SqlCommand command = new SqlCommand();
command.CommandText = "SELECT ID_PK FROM [MARINE_FAMILY] WHERE [SCHEDULE3] = @FIELD_TEXT";
command.Parameters.AddWithValue("@FIELD_TEXT", selected_field);
int field_id = DAOHelper.RetreiveID(command);
//return field_id;
SqlCommand executeDataCommand = new SqlCommand();
executeDataCommand.Parameters.AddWithValue("@FIELD_TEXT", selected_field);
if (field_id == -1) /* New Record */
{
executeDataCommand.CommandText = "INSERT INTO [MARINE_FAMILY] ([SCHEDULE3],[TEXT]) VALUES(@FIELD_TEXT, @FIELD_TEXT) ;";
DAOHelper.InsertData(executeDataCommand);
field_id = DAOHelper.RetreiveID(command);
}
else
{
executeDataCommand.CommandText = "UPDATE [MARINE_FAMILY] SET [SCHEDULE3] = @FIELD_TEXT WHERE [ID_PK] = @ID_PK ;";
executeDataCommand.Parameters.AddWithValue("@ID_PK", field_id);
DAOHelper.InsertData(executeDataCommand);
}
return(field_id);
}
public ActionResult AbstractFactory(string factoryType)
{
IDAOFactory factory = null;
if (factoryType == "mssql")
{
factory = new MsSqlFactory();
}
else
{
factory = new MySqlFactory();
}
factoryType = "DesignPatterns.Pattern.GangOfFour.Creational.MsSqlFactory";
ObjectHandle oh = Activator.CreateInstance(Assembly.GetExecutingAssembly().FullName, factoryType);
factory = (IDAOFactory)oh.Unwrap();
DAOHelper o = new DAOHelper(factory);
o.Save();
return(View());
}
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));
}
