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); }