//for delete
public void BankDelete(int BankId)
{
Banks result = ent.Banks.Where(x => x.BankId == BankId).FirstOrDefault();
ent.DeleteObject(result);
ent.SaveChanges();
}
public BankManagementsModel Create(BankManagementsModel model, out ActionResponse _ores)
{
if (IsExists(model.BankId, model.BankName) == false)
{
Banks obj = new Banks
{
BankName = model.BankName,
BankAddress = model.BankAddress,
PhoneNo = model.PhoneNo,
ContactPerson = model.ContactPerson,
ContactPersonPhoneNo = model.ContactPersonPhoneNo,
ContactPersonMobileNo = model.ContactPersonMobileNo,
ContactPersonEmail = model.ContactPersonEmail,
CountryId = model.CountryId
};
_ent.AddToBanks(obj);
_ent.SaveChanges();
model.BankId = obj.BankId;
_res.ActionMessage = String.Format(Resources.Message.SuccessfullySaved, "Bank detail");
_res.ErrNumber = 0;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
else
{
_res.ActionMessage = String.Format(Resources.Message.AlreadyExist, "Bank detail");
_res.ErrNumber = 1001;
_res.ErrSource = "DataBase";
_res.ErrType = "App";
_res.ResponseStatus = true;
}
_ores = _res;
return(model);
}
private void EmulateSharepointConnection()
{
var author =
new SharepointLookupFieldEmulator()
{
LookupId = ClientContext.EnsureUser("ftc\\testuser").Id
};
var created = new DateTime(2018, 10, 1, 10, 0, 0);
Banks.AddItem(
new Bank()
{
Title = "test", Bik = "123", Created = created, Author = author
});
Banks.AddItem(
new Bank()
{
Title = "test2", Bik = "345", Created = created, Author = author
});
Banks.AddItem(
new Bank()
{
Title = "test3", Bik = "12121", Created = created, Author = author
});
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,TypeId")] Banks banks)
{
if (id != banks.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(banks);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BanksExists(banks.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(banks));
}
protected void Page_Load(object sender, EventArgs e)
{
// Vencimiento de sesion
if (Session[Constants.NameSessionUser] == null)
{
Utilities.logout(Page.Session, Page.Response);
}
else
{
_user = (Users)Session[Constants.NameSessionUser];
}
if (!IsPostBack)
{
dwBanks.DataSource = Banks.getAllBanks();
dwBanks.DataBind();
dwDepositType.DataSource = Concepts.getConceptsByType();
dwDepositType.DataBind();
// calendar.StartDate = DateTime.Now.AddDays(-4);
// calendar.EndDate = DateTime.Now;
calendar.SelectedDate = DateTime.Now;
if ((_user._usu_tip_id == "01" || _user._usu_tip_id == "03"))
{
this.formForCustomer();
}
else
{
this.formForEmployee();
}
}
}
public IPaymentProvider Create(Banks bank)
{
switch (bank)
{
case Banks.AkBank:
case Banks.IsBankasi:
case Banks.HalkBank:
case Banks.TurkEkonomiBankasi:
case Banks.DenizBank:
case Banks.IngBank:
case Banks.ZiraatBankasi:
case Banks.KuveytTurk:
return(ActivatorUtilities.GetServiceOrCreateInstance <AssecoPaymentProvider>(_serviceProvider));
case Banks.FinansBank:
return(ActivatorUtilities.GetServiceOrCreateInstance <FinansbankPaymentProvider>(_serviceProvider));
//Posnet
case Banks.Yapikredi:
return(ActivatorUtilities.GetServiceOrCreateInstance <YapikrediPaymentProvider>(_serviceProvider));
//GVP
case Banks.Garanti:
return(ActivatorUtilities.GetServiceOrCreateInstance <GarantiPaymentProvider>(_serviceProvider));
//GET 7/24
case Banks.VakifBank:
return(ActivatorUtilities.GetServiceOrCreateInstance <VakifbankPaymentProvider>(_serviceProvider));
default:
throw new NotSupportedException("Bank not supported");
}
}
public void DeleteBank(int BankId)
{
Banks model = ent.Banks.First(x => x.BankId == BankId);
ent.DeleteObject(model);
ent.SaveChanges();
}
public List <ExpBankVoucher> GetTransactionInfoForSearch()
{
using (_context)
{
var Data = (from t in _context.EXP_BankVoucher.AsEnumerable()
join b in _context.Sys_Bank on t.BankID equals b.BankID into Banks
from b in Banks.DefaultIfEmpty()
join br in _context.Sys_Branch on t.BranchID equals br.BranchID into Branches
from br in Branches.DefaultIfEmpty()
join ci in _context.EXP_CI on(t.CIID == null?null:t.CIID) equals ci.CIID into CIs
from ci in CIs.DefaultIfEmpty()
orderby t.BVID descending
select new ExpBankVoucher
{
BVID = t.BVID,
RefBVNo = t.RefBVNo,
BVDate = (Convert.ToDateTime(t.BVDate)).ToString("dd'/'MM'/'yyyy"),
BVType = (t.BVType == "DR"? "Debit": "Credit"),
BankID = t.BankID,
BankName = b == null?null:b.BankName,
BranchID = t.BranchID,
BranchName = br == null ? null : br.BranchName,
ACNo = t.ACNo,
ACName = t.ACName,
Remarks = t.Remarks,
RecordStatus = DalCommon.ReturnRecordStatus(t.RecordStatus)
}).ToList();
return(Data);
}
}
public Banks SaveAsync(Banks cls)
{
try
{
var headers = Request.Headers?.ToList();
if (headers == null || headers.Count <= 0)
{
return(null);
}
var guid = Request.Headers.GetValues("cusGuid").FirstOrDefault();
if (string.IsNullOrEmpty(guid))
{
return(null);
}
var cusGuid = Guid.Parse(guid);
if (!Assistence.CheckCustomer(cusGuid))
{
return(null);
}
db.Bank.AddOrUpdate(cls);
db.SaveChanges();
Assistence.SaveLog(cusGuid, cls.Guid, EnTemp.Bank);
return(cls);
}
catch (Exception ex)
{
WebErrorLog.ErrorInstence.StartErrorLog(ex);
return(null);
}
}
private void LoadList()
{
Banks clsBank = new Banks();
string SortField = "BankID";
if (Request.QueryString["sortfield"] != null)
{
SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID);
}
SortOption sortoption = SortOption.Ascending;
if (Request.QueryString["sortoption"] != null)
{
sortoption = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true);
}
string SearchKey = "";
if (Request.QueryString["Search"] != null)
{
SearchKey = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
}
PageData.DataSource = clsBank.ListAsDataTable(SearchKey, SortField, sortoption).DefaultView;
clsBank.CommitAndDispose();
int iPageSize = Convert.ToInt16(Session["PageSize"]);
PageData.AllowPaging = true;
PageData.PageSize = iPageSize;
try
{
PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
catch
{
PageData.CurrentPageIndex = 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
cboCurrentPage.Items.Clear();
for (int i = 0; i < PageData.PageCount; i++)
{
int iValue = i + 1;
cboCurrentPage.Items.Add(new ListItem(iValue.ToString(), iValue.ToString()));
if (PageData.CurrentPageIndex == i)
{
cboCurrentPage.Items[i].Selected = true;
}
else
{
cboCurrentPage.Items[i].Selected = false;
}
}
lblDataCount.Text = " of " + " " + PageData.PageCount;
}
private bool Delete()
{
bool boRetValue = false;
string stIDs = "";
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
if (chkList != null)
{
if (chkList.Checked == true)
{
stIDs += chkList.Value + ",";
boRetValue = true;
}
}
}
if (boRetValue)
{
Banks clsBank = new Banks();
clsBank.Delete(stIDs.Substring(0, stIDs.Length - 1));
clsBank.CommitAndDispose();
}
return(boRetValue);
}
/// <summary>
///
/// </summary>
/// <param name="atLeastOnePatchIsPasted"></param>
/// <param name="noBanksSelected">noBanksAreSelectedForPastingSelectTheBankSWhereTheCopiedPatchesCanBePastedIn</param>
/// <returns></returns>
private bool PastePatchesBank(IList <bool> atLeastOnePatchIsPasted,
out string noBanksSelected)
{
// Set list(s) selected.
if (!CheckSelectedBanksForPasting())
{
{
noBanksSelected =
"No banks are selected for pasting. Select the bank(s) where the copied patches can be pasted in.";
return(true);
}
}
// Copy clip board patches to selected patches.
foreach (var bank in Banks.Where(bank => bank.IsSelected))
{
// ReSharper disable ConditionIsAlwaysTrueOrFalse, needed for preventing modified closure warning
var pasted = atLeastOnePatchIsPasted[0];
// ReSharper restore ConditionIsAlwaysTrueOrFalse
var cont = bank.Patches.All(patch => PasteToSelectedPatch(patch, ref pasted));
atLeastOnePatchIsPasted[0] = pasted;
if (!cont)
{
break;
}
}
noBanksSelected = "";
return(false);
}
public static async Task <Banks> GetBanksAsync()
{
string uri = "http://api.bocapi.net/v1/api/banks?subscription-key=";
string subscription_id = "9827d6c7a50d4bbdb449d53ac5d02b7a";
uri = uri + subscription_id;
Banks banksresults = new Banks();
HttpClient client = new HttpClient();
client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = client.GetAsync(uri).Result;
if (response.IsSuccessStatusCode)
{
var content = await response.Content.ReadAsStringAsync();
content = content.Substring(19);
content = content.Remove(content.Length - 5);
banksresults = JsonConvert.DeserializeObject <Banks>(content);
}
return(banksresults);
}
public async Task Crawl()
{
Console.WriteLine("--- Years");
years = await GetYears();
Console.WriteLine("--- Banks");
banks = await GetBanks();
foreach (var year in years)
{
Console.WriteLine($"--- Set year {year.YearStart.Year}");
await SetYear(year);
Console.WriteLine("--- Dashboard");
await GetDashBoard();
Console.WriteLine("--- Expenses");
await GetExpenses();
Console.WriteLine("--- Dividends");
await GetDividends();
foreach (var bank in banks)
{
Console.WriteLine($"--- Transactions {year.YearStart.Year} {bank.BankId} - {bank.BankName}");
var tx = await GetTransactions(bank.BankId);
}
}
}
public MemberInfo SelectMemberbyRegNumber(string index)
{
AddParameter("@p_regNumber", index);
using (MySqlDataReader reader = ExecuteReader("Member_SelRegNumber"))
{
if (reader.Read())
{
regNumber = reader.GetString(0);
Name = reader.GetString(1);
Address = reader.GetString(2);
Mobile = reader.GetString(3);
HomeTP = reader.GetString(4);
Email = reader.GetString(5);
Amount = reader.GetInt32(6);
paymentType = (PaymentType)reader.GetInt32(7);
bank = (Banks)reader.GetInt32(8);
subscriptionType = (SubscriptionType)reader.GetInt32(9);
nameInMag = reader.GetString(10);
ID = reader.GetInt32(11);
numOfMagazine = reader.GetInt32(12);
Note = reader.GetString(13);
}
}
return(this);
}
public async Task <IActionResult> PutBanks(byte id, Banks banks)
{
if (id != banks.BankId)
{
return(BadRequest());
}
_context.Entry(banks).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BanksExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
//Update Supplier status
public Boolean DeleteSelectedBank(Banks bank)
{
Boolean update;
try
{
update = false;
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_UpdateBankStatusById", conn))
{
cmd.CommandTimeout = 200;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BankID", SqlDbType.NVarChar).Value = bank.BankID;
cmd.ExecuteNonQuery();
update = true;
}
}
}
catch (SqlException ex)
{
throw new Exception("SQL Error : " + ex.Message);
}
return(update);
}
public async Task <DateTime?> CalculateTransfer(string sourceIban = null, string targetIban = null)
{
DateTime?result = null;
if (!string.IsNullOrEmpty(sourceIban))
{
var sourceId = elixirLogic.GetBankIdFromIBAN(sourceIban);
Source = Banks.Where(b => b.Identifier == sourceId).FirstOrDefault();
}
if (!string.IsNullOrEmpty(targetIban))
{
var targetId = elixirLogic.GetBankIdFromIBAN(targetIban);
Target = Banks.Where(b => b.Identifier == targetId).FirstOrDefault();
}
try
{
result = await elixirLogic.GetTransferTime(SendTime, Source, Target);
}
catch (ArgumentException ex)
{
OnPropertyChanged("BankInvalid");
}
return(result);
}
/// <summary>
/// Retrieves the thumbnail URL for a particular <see cref="Banks"/> object.
/// </summary>
/// <param name="bank">The value to retrieve.</param>
/// <returns>The banks thumbnail URL.</returns>
public string GetBankThumbnailUrl(Banks bank)
{
var banksSection = Configuration.GetSection("images").GetSection("banks");
return(bank switch
{
Banks.Nacion => banksSection["nacion"],
Banks.BBVA => banksSection["bbva"],
Banks.Piano => banksSection["piano"],
Banks.Hipotecario => banksSection["hipotecario"],
Banks.Galicia => banksSection["galicia"],
Banks.Santander => banksSection["santander"],
Banks.Ciudad => banksSection["ciudad"],
Banks.Supervielle => banksSection["supervielle"],
Banks.Patagonia => banksSection["patagonia"],
Banks.Comafi => banksSection["comafi"],
Banks.Bancor => banksSection["bancor"],
Banks.Chaco => banksSection["chaco"],
Banks.Pampa => banksSection["pampa"],
Banks.ICBC => banksSection["icbc"],
Banks.Provincia => banksSection["provincia"],
Banks.Reba => banksSection["reba"],
Banks.Roela => banksSection["roela"],
_ => string.Empty,
});
public Supplier()
{
Type = "CRD"; //Dimension type of customers is DEB.
Beginperiod = 1;
Beginyear = 1965;
Endperiod = 1;
Endyear = 2019;
Financials = new Financials
{
Matchtype = MatchType.Customersupplier, //Fixed value customersupplier.
Accounttype = "inherit", //Fixed value inherit.
Subanalyse = Subanalyse.False, //Fixed value false
Duedays = 100,
Substitutionlevel = 1, //Level of the balancesheet account. Fixed value 1.
Payavailable = false, //Determines if direct debit is possible.
Ebilling = false, //Determines if the sales invoices will be sent electronically to the customer.
Vatobligatory = false,
Level = 2,
Collectionschema = CollectionSchema.Core, //Collection schema information. Apply this information only when the customer invoices are collected by SEPA direct debit.
Collectmandate = new Collectmandate()
};
Banks = new Banks();
Postingrules = new Postingrules();
Addresses = new Addresses();
Paymentconditions = new Paymentconditions();
}
private void SaveRecord(string Sender)
{
ComputePayment(Sender);
PaymentsDetails clsDetails = new PaymentsDetails();
clsDetails.PaymentID = Convert.ToInt64(lblPaymentID.Text);
clsDetails.BankID = Convert.ToInt32(cboBank.SelectedItem.Value);
clsDetails.BankCode = cboBank.SelectedItem.Text;
clsDetails.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
clsDetails.ChequeNo = txtChequeNo.Text;
clsDetails.PayeeID = Convert.ToInt64(cboPayee.SelectedItem.Value);
clsDetails.PayeeCode = cboPayee.SelectedItem.Text;
clsDetails.PayeeName = txtPayeeName.Text;
clsDetails.Particulars = txtRemarks.Text;
clsDetails.TotalDebitAmount = Convert.ToDecimal(lblTotalDebitAmount.Text);
clsDetails.TotalCreditAmount = Convert.ToDecimal(lblTotalCreditAmount.Text);
Payments clsPayments = new Payments();
clsPayments.Update(clsDetails);
Banks clsBank = new Banks(clsPayments.Connection, clsPayments.Transaction);
clsBank.UpdateChequeCounter(clsDetails.BankID, clsDetails.ChequeNo);
clsPayments.CommitAndDispose();
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
Banks clsBank = new Banks();
cboBank.DataTextField = "BankCode";
cboBank.DataValueField = "BankID";
cboBank.DataSource = clsBank.ListAsDataTable().DefaultView;
cboBank.DataBind();
clsBank.CommitAndDispose();
cboBank.SelectedIndex = 0;
cboBank_SelectedIndexChanged(null, null);
Contacts clsContact = new Contacts();
cboPayee.DataTextField = "ContactCode";
cboPayee.DataValueField = "ContactID";
cboPayee.DataSource = clsDataClass.DataReaderToDataTable(clsContact.Suppliers(null, 0, "ContactName", SortOption.Ascending)).DefaultView;
cboPayee.DataBind();
clsContact.CommitAndDispose();
cboPayee.SelectedIndex = 0;
txtChequeDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
lblPaymentID.Text = "0";
lblTotalDebitAmount.Text = "0.00";
lblTotalCreditAmount.Text = "0.00";
lblTotalAmount.Text = "0.00";
txtPostingDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
LoadAccount();
}
public IHttpActionResult PutBanks(int id, Banks banks)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != banks.ID)
{
return(BadRequest());
}
db.Entry(banks).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BanksExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// GET: Configuration
public ActionResult Setup()
{
// If session is empty redirect to login
if (string.IsNullOrEmpty((string)GlobalData.getUerNameFromApplication))
{
return(RedirectToAction("Index", "Default"));
}
var banks = (from x in db.Banks
select new
{
BankName = x.BankName,
SortCode = x.SortCode
}).ToList();
List <Banks> bnk = new List <Banks>();
if (banks != null)
{
foreach (var financialInstitution in banks)
{
var bank = new Banks();
bank.BankName = financialInstitution.BankName.Trim();
bank.BankCode = financialInstitution.SortCode.Trim();
bnk.Add(bank);
}
}
return(View(bnk));
}
//Add New Supplier to Database
public Boolean AddNewBank(Banks bank)
{
Boolean insert;
try
{
insert = false;
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("sp_InsertNewBank", conn))
{
cmd.CommandTimeout = 200;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@BankName", SqlDbType.NVarChar).Value = bank.BankName;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = bank.Phone;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar).Value = bank.Address;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = bank.Email;
cmd.ExecuteNonQuery();
insert = true;
}
}
}
catch (SqlException ex)
{
throw new Exception("SQL Error : " + ex.Message);
}
return(insert);
}
public BanksTests()
{
// Get flutterwave secret key from environmental variables
var flutterwaveSecretKey = Environment.GetEnvironmentVariable("FlutterwaveSecretKey");
_banks = new Banks(new FlutterwaveApi(flutterwaveSecretKey));
}
private bool LoadFileData(string fileName, Banks bank)
{
try
{
Excel.Application excelApp = new Excel.Application();
Excel.Workbook workBook = excelApp.Workbooks.Open(fileName);
foreach (Excel.Worksheet workSheet in workBook.Worksheets)
{
switch (bank)
{
case Banks.Capital:
break;
case Banks.Chase:
PopulateChaseData(workSheet);
break;
case Banks.Cyprus:
PopulateCyprusData(workSheet);
break;
}
}
excelApp.Quit();
return(true);
}
catch (Exception exc)
{
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="cutPasteAction"></param>
private void CopyPasteCopySetLists(bool cutPasteAction)
{
if (SelectedScopeSet == PcgViewModel.ScopeSet.Banks)
{
foreach (var setListSlot in (from ISetList setList in Banks.Where(bank => bank.IsSelected)
from ISetListSlot setListSlot in setList.Patches
where setList.IsLoaded
select setListSlot).Where(setListSlot => cutPasteAction ||
Settings.Default.CopyPaste_CopyIncompleteSetListSlots ||
setListSlot.IsCompleteInPcg))
{
PcgClipBoard.CopySetListSlotToClipBoard(setListSlot, cutPasteAction);
}
}
else
{
foreach (var setListSlot in Patches.Where(patch => patch.IsSelected).Cast <ISetListSlot>().Where(
(setListSlot => cutPasteAction ||
Settings.Default.CopyPaste_CopyIncompleteSetListSlots ||
setListSlot.IsCompleteInPcg)))
{
PcgClipBoard.CopySetListSlotToClipBoard(setListSlot, cutPasteAction);
}
}
}
public MemberInfo SelectMember(int id)
{
AddParameter("@p_ID", id);
using (MySqlDataReader reader = ExecuteReader("Member_Sel"))
{
ID = id;
if (reader.Read())
{
regNumber = reader.GetString(0);
Name = reader.GetString(1);
Address = reader.GetString(2);
Mobile = reader.GetString(3);
HomeTP = reader.GetString(4);
Email = reader.GetString(5);
Amount = reader.GetInt32(6);
paymentType = (PaymentType)reader.GetInt32(7);
bank = (Banks)reader.GetInt32(8);
subscriptionType = (SubscriptionType)reader.GetInt32(9);
nameInMag = reader.GetString(10);
numOfMagazine = reader.GetInt32(11);
Note = reader[12] == DBNull.Value?"": reader[12].ToString();
}
}
return(this);
}
public void deleteInfo()
{
FIO = "";
bank = (Banks)1;
FEE = 0;
countMoney = 0;
dateLastChange = DateTime.Today;
}
private void Populate()
{
//this.stackName.Children.Add(new TextBlock() { Text=Constants.bcac, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
//this.stackName.Children.Add(new TextBlock() { Text = Constants.bcbcr, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
//this.stackName.Children.Add(new TextBlock() { Text = Constants.bccr, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
//this.stackName.Children.Add(new TextBlock() { Text = Constants.bcr, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
//this.stackName.Children.Add(new TextBlock() { Text = Constants.bncr, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
//this.stackName.Children.Add(new TextBlock() { Text = Constants.bpdc, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
//this.stackName.Children.Add(new TextBlock() { Text = Constants.bsj, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
//this.stackName.Children.Add(new TextBlock() { Text = Constants.hsbc, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
//this.stackName.Children.Add(new TextBlock() { Text = Constants.sctb, Foreground = new SolidColorBrush(Colors.Blue), HorizontalAlignment = System.Windows.HorizontalAlignment.Left, VerticalAlignment = System.Windows.VerticalAlignment.Center });
banks = new Banks();
banks.Add(Constants.bcac, Constants.bcacc, Constants.bcacv);
banks.Add(Constants.bcbcr, Constants.bcbcrc, Constants.bcbcrv);
banks.Add(Constants.bccr, Constants.bccrc, Constants.bccrv);
banks.Add(Constants.bcr, Constants.bcrc, Constants.bcrv);
banks.Add(Constants.bncr, Constants.bncrc, Constants.bncrv);
banks.Add(Constants.bpdc, Constants.bpdcc, Constants.bpdcv);
banks.Add(Constants.bsj, Constants.bsjc, Constants.bsjv);
banks.Add(Constants.hsbc, Constants.hsbcc, Constants.hsbcv);
banks.Add(Constants.sctb, Constants.sctbc, Constants.sctbv);
this.telGrid.ItemsSource = banks;
isUpdating = true;
//dispatcherTimer = new DispatcherTimer() { Interval = new TimeSpan(0, 0, 20, 0, 0) };
dispatcherTimer = new DispatcherTimer() { Interval = new TimeSpan(0, 0, 0, 5, 0) };
UIAccessExtensions.ExecuteOutsideUI(() =>
{
banks.Refresh();
isUpdating = false;
});
this.dispatcherTimer.Tick += (s, e) =>
{
if (!isUpdating)
{
isUpdating = true;
UIAccessExtensions.ExecuteOutsideUI(() =>
{
banks.Refresh();
isUpdating = false;
});
}
};
dispatcherTimer.Start();
}
public static Banks CreateBanks(int bankID_pk, string name)
{
Banks banks = new Banks();
banks.bankID_pk = bankID_pk;
banks.name = name;
return banks;
}
public void AddToBanks(Banks banks)
{
base.AddObject("Banks", banks);
}
