public int Execute(IImageData imageData, bool isValidNumber)
{
var electricityMeterData = TransformImageDataToElectricityMeterData(imageData, isValidNumber);
using (var cn = new System.Data.SqlClient.SqlConnection(_connectionString))
{
cn.Open();
var id = cn.Insert(electricityMeterData);
cn.Close();
return(id);
}
}
public int BlackListFile(string originalFileName, string filepath)
{
var fileBlackListData = TransformDataToBlackListData(originalFileName, filepath);
using (var cn = new System.Data.SqlClient.SqlConnection(_connectionString))
{
cn.Open();
var id = cn.Insert(fileBlackListData);
cn.Close();
return(id);
}
}
public Boolean InsertInto(Character character)
{
try
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(ConnectionStrings.GetConnectionString("MonsterManualDb")))
{
connection.Open();
connection.Insert(character);
connection.Close();
return(true);
}
} catch (Exception e)
{
return(false);
}
}
public void TestSqlConnectionForQueryForSystemSqlServerTypeMapAttribute()
{
// Setup
var table = CreateSdsAttributeTables(1).First();
using (var connection = new System.Data.SqlClient.SqlConnection(Database.ConnectionString))
{
// Act
var id = connection.Insert <SdsAttributeTable>(table);
// Query
var queryResult = connection.Query <SdsAttributeTable>(id).First();
// Assert
Helper.AssertPropertiesEquality(table, queryResult);
}
}
public long Insert <T>(T entityToInsert) where T : class
{
long lResult = 0;
try
{
//using (var cn = new System.Data.SqlClient.SqlConnection(ConnStr))
//{
// lResult = cn.Insert<T>(entityToInsert);
//}
if (_ProviderName == "System.Data.SqlClient")
{
using (System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(ConnStr))
{
lResult = cn.Insert <T>(entityToInsert);
}
}
else if (_ProviderName == "MySql.Data.MySqlClient")
{
using (MySql.Data.MySqlClient.MySqlConnection cn = new MySql.Data.MySqlClient.MySqlConnection(ConnStr))
{
lResult = cn.Insert <T>(entityToInsert);
}
}
else
{
using (System.Data.SqlClient.SqlConnection cn = SqlClient)
{
lResult = cn.Insert <T>(entityToInsert);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lResult);
}
