public void UpdateRecord(ITable vmRecord, string keyColumnName, object keyColValue)
{
IEnumerable <KeyValuePair <string, object> > values = DataBaseServices.GetKeyValuePairs(vmRecord);
string tableName = DataBaseServices.GetTableName(vmRecord);
RegisterOperation(new SqlOperation(tableName, values, SqlOperationTypeEnum.Update, keyColumnName, keyColValue));
}
private static EmailUtilities GetData(string procedureName, List <SqlParameter> parameterList)
{
var emailStatusUtility = new EmailUtilities();
var dbs = new DataBaseServices();
var wslog = new Log();
try
{
var cmd = new SqlCommand(procedureName)
{
CommandType = CommandType.StoredProcedure
};
if (parameterList != null)
{
cmd.Parameters.AddRange(parameterList.ToArray());
}
emailStatusUtility = dbs.RetrieveDataTable_by_SQLCommand(cmd);
if (emailStatusUtility.OperationStatus != "Success")
{
wslog.WriteLog("ERR", emailStatusUtility.Description);
throw new ArgumentException(emailStatusUtility.Description, "Error");
}
}
catch (Exception exp)
{
wslog.WriteLog("ERR", exp.Message.ToString());
}
return(emailStatusUtility);
}
public override int Delete(IEnumerable <T> models)
{
try
{
int affected = 0;
string tableName = DataBaseServices.GetTableName(default(T));
using (SqlConnection connection = new SqlConnection(ConnectionIdentifier))
using (QueryFactory db = new QueryFactory(connection, new SqlServerCompiler()))
{
foreach (T model in models)
{
int id = model.Id;
affected += db.Query(tableName)
.Where("Id", id)
.Delete();
}
return(affected);
}
}
catch (Exception ex)
{
Log.Error(ex, "SQL Data Manager Delete error");
return(0);
}
}
public void InsertRecord(ITable vmRecord)
{
IEnumerable <KeyValuePair <string, object> > values = DataBaseServices.GetKeyValuePairs(vmRecord);
string tableName = DataBaseServices.GetTableName(vmRecord);
RegisterOperation(new SqlOperation(tableName, values, SqlOperationTypeEnum.Insert));
}
public void ExecuteScheduledJob(string ProcedureName, int refreshType = 0)
{
var emailStatusUtility = new EmailUtilities();
var dbs = new DataBaseServices();
var wslog = new Log();
var sqlParametersList = new List <SqlParameter>
{
new SqlParameter("@refreshtype", refreshType)
{
SqlDbType = SqlDbType.NVarChar
}
};
try
{
if (refreshType == 0)
{
emailStatusUtility = dbs.ExecuteNonQuery(ProcedureName);
}
else
{
emailStatusUtility = dbs.ExecuteNonQuery(ProcedureName, sqlParametersList.ToArray());
}
if (emailStatusUtility.OperationStatus != "Success")
{
wslog.WriteLog("ERR", emailStatusUtility.Description);
throw new ArgumentException(emailStatusUtility.Description, "Error");
}
}
catch (Exception exp)
{
wslog.WriteLog("ERR", exp.Message.ToString());
}
}
/// <summary>
/// After data has been loaded from API into UI this method saves data to database if data comes from API
/// </summary>
/// <param name="Countries"></param>
/// <returns>Task</returns>
public async Task SaveData(List <Country> Countries, List <Rate> Rates)
{
if (SetConnectionStatus())
{
dataBaseServices = new DataBaseServices();
await Task.Run(() => dataBaseServices.SaveCountriesData(Countries));
await Task.Run(() => dataBaseServices.SaveRatesData(Rates));
}
}
public RequestResponseLogController(IMapper mapper
, UsersSrevices usersSrevices
, SystemServices sysservices
, DataBaseServices dataBaseServices
, AppSystemServices appSystemServices
)
{
_mapper = mapper;
_sysservices = sysservices;
_dataBaseServices = dataBaseServices;
_appSystemServices = appSystemServices;
}
public TestModuleController(IMapper mapper
, UsersSrevices usersSrevices
, SystemServices sysservices
, DataBaseServices dataBaseServices
, AppSystemServices appSystemServices
)
{
_mapper = mapper;
_sysservices = sysservices;
_dataBaseServices = dataBaseServices;
_appSystemServices = appSystemServices;
}
public DataBaseConnectionController(IMapper mapper
, UsersSrevices usersSrevices
, SystemServices sysservices
, DataBaseServices dataBaseServices
, AppSystemServices appSystemServices
, IHostingEnvironment hostingEnvironment)
{
_mapper = mapper;
_sysservices = sysservices;
_dataBaseServices = dataBaseServices;
_appSystemServices = appSystemServices;
_hostingEnvironment = hostingEnvironment;
}
/// <summary>
/// Is connection status true, get rates data from GetApiData Class
/// </summary>
/// <returns>List of Rate</returns>
public async Task <List <Rate> > GetRatesAPIDataAsync()
{
dataBaseServices = new DataBaseServices();
if (SetConnectionStatus())
{
Rates = await GetApiData.LoadRatesFromAPIAsync();
}
else
{
Rates = dataBaseServices.GetRatesData();
}
return(Rates);
}
public override T FindById(int id)
{
try
{
string tableName = DataBaseServices.GetTableName(default(T));
using (SqlConnection connection = new SqlConnection(ConnectionIdentifier))
using (QueryFactory db = new QueryFactory(connection, new SqlServerCompiler()))
{
return(db.Query(tableName).Where("Id", id).First <T>());
}
}
catch (Exception ex)
{
Log.Error(ex, "SQL Data Manager FindById error", id);
return(default);
public override List <T> FindAll()
{
try
{
string tableName = DataBaseServices.GetTableName(default(T));
using (SqlConnection connection = new SqlConnection(ConnectionIdentifier))
using (QueryFactory db = new QueryFactory(connection, new SqlServerCompiler()))
{
return(db.Query(tableName)
.Get <T>()
.ToList());
}
}
catch (Exception ex)
{
Log.Error(ex, "SQL Data Manager Find All error");
return(null);
}
}
public Generators()
{
InitializeComponent();
this.skinEngines.SkinFile = $"{System.Environment.CurrentDirectory}\\Plugins\\Skins\\OneOrange.ssk";
//this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
InitSystemConfig();
DataBaseServices services = new DataBaseServices();
// 初始化数据
InitDatabase initDatabase = new InitDatabase(true);
var list = FreeSqlFactory._Freesql.Select <SQLConfig>().ToList();
TreeNode root = new TreeNode()
{
Text = "服务器"
};
treeViewDatabase.Nodes.Add(root);
}
public override int Delete(T model)
{
try
{
string tableName = DataBaseServices.GetTableName(model);
int id = model.Id;
using (SqlConnection connection = new SqlConnection(ConnectionIdentifier))
using (QueryFactory db = new QueryFactory(connection, new SqlServerCompiler()))
{
return(db.Query(tableName)
.Where("Id", id)
.Delete());
}
}
catch (Exception ex)
{
Log.Error(ex, "SQL Data Manager Delete error", model);
return(0);
}
}
public EmailUtilities SaveData(string procedureName, List <SqlParameter> sqlparameterList)
{
var emailStatusUtility = new EmailUtilities();
var dbs = new DataBaseServices();
var wslog = new Log();
try
{
emailStatusUtility = dbs.ExecuteNonQuery(procedureName, sqlparameterList.ToArray());
if (emailStatusUtility.OperationStatus != "Success")
{
wslog.WriteLog("ERR", emailStatusUtility.Description);
throw new ArgumentException(emailStatusUtility.Description, "Error");
}
}
catch (Exception exp)
{
wslog.WriteLog("ERR", exp.Message.ToString());
}
return(emailStatusUtility);
}
/// <summary>
/// This method searches for an internet connection. If connection is valid gets data from API, if not gets data from Databse
/// </summary>
/// <returns>List of Country</returns>
public async Task <List <Country> > ReturnCountriesData()
{
dataBaseServices = new DataBaseServices();
SetConnectionStatus();
if (SetConnectionStatus())
{
Countries = await GetApiData.LoadCountriesFromAPIAsync();
}
else
{
MessageService.ShowMessage("Error", "Set up your Internet connection");
Countries = dataBaseServices.GetCountriesData();
}
if (!SetConnectionStatus())
{
if (Countries.Count == 0)
{
MessageService.ShowMessage("Error", "First use of this application requires a valid internet connection");
}
}
return(Countries);
}
public DataGridViewModel()
{
_personDataService = PersonDataService.Instance;
}
public SqlUnitOfWork()
{
sqlOperations = new List <SqlOperation>();
connectionString = DataBaseServices.GetConnectionIdentifier();
}
public OptionData()
{
UnderlyingShares = new ObservableCollection <ShareAndWeight>();
AviableShares = new ObservableCollection <Share>(DataBaseServices.getShares());
}
protected DataManagerBase()
{
ConnectionIdentifier = DataBaseServices.GetConnectionIdentifier();
}
