public void Remove(AccountSetup account)
{
if (Context.Entry(account).State == EntityState.Detached)
{
context.AccountSetup.Attach(account);
}
context.AccountSetup.Remove(account);
}
internal void DeleteAccountSetupInformation(AccountSetup accountSetupObj)
{
try
{
connection.Open();
string selectQuery = @"DELETE FROM [tbl_acc_setup] WHERE [accs_id] ='" + accountSetupObj.Id + "' ";
SqlCommand command = new SqlCommand(selectQuery, connection);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
internal void UpdateAccountSetupInformation(AccountSetup accountSetupObj)
{
try
{
connection.Open();
string selectQuery = @"UPDATE [tbl_acc_setup]
SET[accs_transport_area] ='" + accountSetupObj.TransportArea + "',[accs_amount]='" + accountSetupObj.Amount + "',[accs_class_id]='" + accountSetupObj.Class + "',[accs_head_nature]='" + accountSetupObj.Nature + "',[accs_head_id]='" + accountSetupObj.AccountHead + "' WHERE [accs_id] ='" + accountSetupObj.Id + "' ";
SqlCommand command = new SqlCommand(selectQuery, connection);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
internal void GetSaveAccountSetupInformation(AccountSetup accountSetupObj)
{
try
{
connection.Open();
string selectQuery = @"INSERT INTO [tbl_acc_setup]
([accs_id],[accs_head_id],[accs_head_nature],[accs_class_id],[accs_amount],[accs_transport_area])
VALUES
('" + accountSetupObj.Id + "','" + accountSetupObj.AccountHead + "','" + accountSetupObj.Nature + "','" + accountSetupObj.Class + "','" + accountSetupObj.Amount + "','" + accountSetupObj.TransportArea + "')";
SqlCommand command = new SqlCommand(selectQuery, connection);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
public void DeleteAccountSetupInformation(AccountSetup accountSetupObj)
{
accountSetupGatewayObj.DeleteAccountSetupInformation(accountSetupObj);
}
public void UpdateAccountSetupInformation(AccountSetup accountSetupObj)
{
accountSetupGatewayObj.UpdateAccountSetupInformation(accountSetupObj);
}
public void GetSaveAccountSetupInformation(AccountSetup accountSetupObj)
{
accountSetupGatewayObj.GetSaveAccountSetupInformation(accountSetupObj);
}
public DbEntityEntry <AccountSetup> Entry(AccountSetup account)
{
return(Context.Entry(account));
}
public void Attach(AccountSetup account)
{
context.AccountSetup.Attach(account);
}
public void Add(AccountSetup account)
{
context.AccountSetup.Add(account);
}
public static void Run()
{
var _account = new AccountSetup();
Console.WriteAscii("Setup", Color.DodgerBlue);
Cinstance.Out("The information provided here can be changed once setup is finished", Color.CornflowerBlue, 1);
bool AccountNumberEntry = false;
string AccountNumber = "";
while (!AccountNumberEntry)
{
Cinstance.Out("Account Number: ", Color.HotPink, _nextBufferOnSameLine: true);
AccountNumber = Console.ReadLine();
if (File.Exists(AccountNumber.ToString() + ".fx"))
{
Cinstance.Out("Account file already exists, to prevent this, change the account number or delete the current file", Color.OrangeRed);
}
else if (!Regex.IsMatch(AccountNumber, "^[0-9]+$"))
{
Cinstance.Out("Value was not numerical (regex used - ^\\d$)", Color.OrangeRed);
}
else
{
AccountNumberEntry = true;
}
}
_account.AccountNumber = Convert.ToInt32(AccountNumber);
Cinstance.Out($"Account number bound to value ", Color.HotPink, _nextBufferOnSameLine: true);
Cinstance.Out(_account.AccountNumber.ToString(), Color.DeepPink, 1);
bool AccountNameEntry = false;
string AccountName = "";
while (!AccountNameEntry)
{
Cinstance.Out("Account Name: ", Color.HotPink, _nextBufferOnSameLine: true);
AccountName = Console.ReadLine();
if (AccountName.Length > 16 || !Regex.IsMatch(AccountName, "[a-zA-Z]+"))
{
Cinstance.Out("Value violated input rules", Color.OrangeRed);
Cinstance.Out(" -16 chars max", Color.CadetBlue);
Cinstance.Out(" -Letters only", Color.CadetBlue);
}
else
{
AccountNameEntry = true;
}
}
_account.AccountName = AccountName;
Cinstance.Out($"Account name bound to value ", Color.HotPink, _nextBufferOnSameLine: true);
Cinstance.Out(_account.AccountName, Color.DeepPink, 1);
bool AccountCurrencyEntry = false;
char AccountCurrency = ' ';
while (!AccountCurrencyEntry)
{
Cinstance.Out("Account Currency -select index-: ", Color.HotPink);
Cinstance.Out(" a) £ (GBP)", Color.LightPink);
Cinstance.Out(" b) $ (USD)", Color.LightPink);
Cinstance.Out(" c) € (EUR)", Color.LightPink);
Cinstance.Out(" d) R (ZAR)", Color.LightPink);
AccountCurrency = Console.ReadLine()[0];
if (!Index2Currency.ContainsKey(AccountCurrency.ToString().ToLower()[0]))
{
Cinstance.Out("Dictionary did not contain this index", Color.OrangeRed);
}
else
{
AccountCurrencyEntry = true;
}
}
_account.Currency = Index2Currency[Convert.ToChar(AccountCurrency)];
Cinstance.Out($"Account currency bound to ", Color.HotPink, _nextBufferOnSameLine: true);
Cinstance.Out(Index2Description[AccountCurrency.ToString()], Color.DeepPink, 2);
bool AccountEquityEntry = false;
string AccountEquity = "";
while (!AccountEquityEntry)
{
Cinstance.Out("Account Equity: ", Color.HotPink, _nextBufferOnSameLine: true);
AccountEquity = Console.ReadLine();
if (Regex.IsMatch(AccountEquity, "[a-zA-Z]+"))
{
Cinstance.Out("Value was not numerical (regex used - ^\\d$)", Color.OrangeRed);
}
else
{
AccountEquityEntry = true;
}
}
_account.AccountEquity = Convert.ToDouble(AccountEquity);
Cinstance.Out($"Account equity set to ", Color.HotPink, _nextBufferOnSameLine: true);
Cinstance.Out(_account.AccountEquity.ToString(), Color.DeepPink, 2);
Cinstance.Out($"Your account is being written to a new file - {_account.AccountNumber}.fx", Color.ForestGreen, 1);
Utils.Pause();
bool _scribeComplete = false;
bool _initDisplayComplete = false;
new Thread(() =>
{
Thread.CurrentThread.IsBackground = true;
Cinstance.InitDisplay(ref _scribeComplete, ref _initDisplayComplete, loadText: "Writing");
}).Start();
var scribe = new FX_Scribe(_account);
scribe.WriteToFile(ref _scribeComplete);
Utils.Pause();
Cinstance.Out("Account Successfully Written", Color.CadetBlue, _prefixWithNewLines: 1);
}
