/// <summary> /// 删除客户成交 /// </summary> /// <param name="user">登陆用户基本信息</param> /// <param name="customertransactions">客户成交实体</param> /// <param name="cancellationToken">验证</param> /// <returns></returns> public async Task DeleteAsync(SimpleUser user, CustomerTransactions customertransactions, CancellationToken cancellationToken = default(CancellationToken)) { if (user == null) { throw new ArgumentNullException(nameof(user)); } if (customertransactions == null) { throw new ArgumentNullException(nameof(customertransactions)); } //删除基本信息 customertransactions.DeleteTime = DateTime.Now; customertransactions.DeleteUser = user.Id; customertransactions.IsDeleted = true; Context.Attach(customertransactions); var entry = Context.Entry(customertransactions); entry.Property(x => x.IsDeleted).IsModified = true; entry.Property(x => x.DeleteUser).IsModified = true; entry.Property(x => x.DeleteTime).IsModified = true; try { await Context.SaveChangesAsync(cancellationToken); } catch (DbUpdateConcurrencyException) { throw; } }
void SetExtraWorkTotal() { if (SelectedFlat != null) { ExtraWorkTotal = CustomerTransactions.Where(ct => ct.Flat.Id == SelectedFlat.Id).Select(ct => ct.ExtraWorkTotal).FirstOrDefault(); } }
public async Task <IActionResult> OnGetAsync(string sortString, string filterString) { await FetchCustomerData(); if (!string.IsNullOrEmpty(filterString)) { CustomerTransactions = CustomerTransactions.Where(s => s.Date.ToString().Contains(filterString) || s.Amount.ToString().Contains(filterString) || s.Currency.ToString().Contains(filterString) || (s.Description ?? "").ToString().Contains(filterString) ).ToList(); } DateSort = string.IsNullOrEmpty(sortString) ? "Date_Dsc_Sort" : ""; CurrencySort = sortString == "Currency_Asc_Sort" ? "Currency_Dsc_Sort" : "Currency_Dsc_Sort"; AmountSort = sortString == "Amount_Asc_Sort" ? "Amount_Dsc_Sort" : "Amount_Asc_Sort"; DescriptionSort = sortString == "Description_Asc_Sort" ? "Description_Dsc_Sort" : "Description_Dsc_Sort"; switch (sortString) { case "Date_Dsc_Sort": CustomerTransactions = CustomerTransactions.OrderByDescending(s => s.Date).ToList(); break; case "Currency_Asc_Sort": CustomerTransactions = CustomerTransactions.OrderBy(s => s.Currency).ToList(); break; case "Currency_Dsc_Sort": CustomerTransactions = CustomerTransactions.OrderByDescending(s => s.Currency).ToList(); break; case "Amount_Asc_Sort": CustomerTransactions = CustomerTransactions.OrderBy(s => s.Amount).ToList(); break; case "Amount_Dsc_Sort": CustomerTransactions = CustomerTransactions.OrderByDescending(s => s.Amount).ToList(); break; case "Description_Asc_Sort": CustomerTransactions = CustomerTransactions.OrderBy(s => s.Description).ToList(); break; case "Description_Dsc_Sort": CustomerTransactions = CustomerTransactions.OrderByDescending(s => s.Description).ToList(); break; } return(Page()); }
}//Fin del metodo /// <summary> /// Este metodo consulta las transacciones para el cliente seleccionado /// </summary> private void ConsultTransactions() { CustomerTransactions.Clear(); CustomerTrackings.Clear(); foreach (CustomerTransaction t in CustomerSelected.Transactions) { CustomerTransactions.Add(t); } foreach (CustomerTracking cT in CustomerSelected.CustomerTracking) { CustomerTrackings.Add(cT); } }
/// <summary> /// 修改客户成交信息 /// </summary> /// <param name="customertransactions"></param> /// <param name="cancellationToken"></param> /// <returns></returns> public async Task UpdateAsync(CustomerTransactions customertransactions, CancellationToken cancellationToken = default(CancellationToken)) { if (customertransactions == null) { throw new ArgumentNullException(nameof(customertransactions)); } Context.Attach(customertransactions); Context.Update(customertransactions); try { await Context.SaveChangesAsync(cancellationToken); } catch (DbUpdateConcurrencyException) { } }
/// <summary> /// 新增客户成交信息 /// </summary> /// <param name="customertransactions">实体</param> /// <param name="cancellationToken">验证</param> /// <returns></returns> public async Task <CustomerTransactions> CreateAsync(CustomerTransactions customertransactions, CancellationToken cancellationToken = default(CancellationToken)) { if (customertransactions == null) { throw new ArgumentNullException(nameof(customertransactions)); } Context.Add(customertransactions); if (customertransactions.CustomerTransactionsFollowUps != null) { Context.AddRange(customertransactions.CustomerTransactionsFollowUps); } await Context.SaveChangesAsync(cancellationToken); return(customertransactions); }
public List <CustomerTransactions> GetAccountHistory(int accNo) { IList <Chilindo.DAL.Models.AccountHistory> lstHistory = _customerAccountInfo.AccountHistory(accNo); List <CustomerTransactions> custTran = new List <CustomerTransactions>(); CustomerTransactions objCustomerTran; foreach (Chilindo.DAL.Models.AccountHistory history in lstHistory) { objCustomerTran = new CustomerTransactions(); objCustomerTran.TransactionType = history.TransactionType; objCustomerTran.Currency = history.Currency; objCustomerTran.Amount = history.Amount; objCustomerTran.LastUpdateOn = history.LastUpdateOn; objCustomerTran.AccountId = history.AccountId; objCustomerTran.AccountNumber = history.AccountNumber; custTran.Add(objCustomerTran); } return(custTran); }
public async Task Save() { try { var uv = new CustomerTransactions(); if (CustomerView.CustomerId > 0) { CustomerView = await uv.CustomerUpdate(this.GetCustomerUpdate()); } else { CustomerView = await uv.CustomerAdd(this.GetCustomerAdd()); } } catch (Exception ex) { MessagingCenter.Send(this, "Save error"); } }
/// <summary> /// 再次带看 /// </summary> /// <param name="customertransactions"></param> /// <param name="customertransactionstollowup"></param> /// <param name="customerFollowUp"></param> /// <param name="cancellationToken">验证</param> /// <returns></returns> public async Task CreateAgainBeltLookAsync(CustomerTransactions customertransactions, CustomerTransactionsFollowUp customertransactionstollowup, CustomerFollowUp customerFollowUp, CancellationToken cancellationToken = default(CancellationToken)) { if (customertransactions == null) { throw new ArgumentNullException(nameof(customertransactions)); } if (customertransactions != null) { Context.Add(customertransactions); } if (customertransactionstollowup != null) { Context.Add(customertransactionstollowup); } if (customerFollowUp != null) { Context.Add(customerFollowUp); } await Context.SaveChangesAsync(cancellationToken); }
/// <summary> /// Este metodo actualiza las propiedades relacionadas al area de actualizacion de informacion /// de la vista. /// </summary> /// <param name="customer"></param> private void UpdateCustomerProperty(Customer customer) { CanModify = false; if (customer != null) { CustomerName = customer.CustomerName; CustomerNit = customer.Nit; CustomerAddres = customer.Address; CustomerPhone = customer.Phone; CustomerObservation = customer.Observation; ConsultTransactions(); } else { CustomerName = null; CustomerNit = null; CustomerAddres = null; CustomerPhone = null; CustomerObservation = null; CustomerTransactions.Clear(); } }
/// <summary> /// 新增客户成交信息 /// </summary> /// <param name="customerdeal">实体</param> /// <param name="customerInfo"></param> /// <param name="customerTransactionsFollowUp"></param> /// <param name="customerTransactions"></param> /// <param name="customerFollowUp"></param> /// <param name="cancellationToken">验证</param> /// <returns></returns> public async Task <CustomerDeal> CreateAsync(CustomerDeal customerdeal, CustomerInfo customerInfo, CustomerTransactionsFollowUp customerTransactionsFollowUp, CustomerTransactions customerTransactions, CustomerFollowUp customerFollowUp, CancellationToken cancellationToken = default(CancellationToken)) { if (customerdeal == null) { throw new ArgumentNullException(nameof(customerdeal)); } Context.Attach(customerdeal); Context.Update(customerdeal); if (customerInfo != null) { Context.Attach(customerInfo); Context.Update(customerInfo); } if (customerTransactions != null) { Context.Attach(customerTransactions); Context.Update(customerTransactions); Context.Add(customerTransactionsFollowUp); } if (customerFollowUp != null) { Context.Add(customerFollowUp); } await Context.SaveChangesAsync(cancellationToken); return(customerdeal); }
public async Task GetTransactionsByNuban(string nuban, string currencyCode) { try { var selectedMonthIndex = DateTime.Now.Month; var currentYear = DateTime.Now.Year; var daysInMonth = DateTime.DaysInMonth(currentYear, selectedMonthIndex); var startDate = new DateTime(currentYear, selectedMonthIndex, 1); var endDate = new DateTime(currentYear, selectedMonthIndex, daysInMonth); CheckConnectivity(); if (string.IsNullOrEmpty(nuban)) { return; } IsTransactionLoading = true; TransactionMessage = string.Empty; ShowTransactionErrorMessage = false; CustomerTransactions.Clear(); var apirequest = new ApiRequest(); string url = $"Transaction/GetUserTransactionsByRange?userId={GlobalStaticFields.Customer.Email}&StartDate={startDate.ToString("MM-dd-yyyy")}&EndDate={endDate.ToString("MM-dd-yyyy")}"; var request = await apirequest.GetWithSwitchId(GlobalStaticFields.Customer.Email, "", URLConstants.SwitchApiLiveBaseUrl, url, "BankAccounts"); if (request.IsSuccessStatusCode) { var jsonString = await request.Content.ReadAsStringAsync(); jsonString = jsonString.JsonCleanUp(); transactions.Clear(); var jobj = JsonConvert.DeserializeObject <APIResponse <List <GetStatements> > >(jsonString); if (jobj.Status) { var filt = jobj.Data.Where(c => c.FromAccount == nuban || c.ToAccount == nuban).OrderByDescending(c => c.ID).ToList().Take(3); foreach (var rec in filt) { var amt = Convert.ToDouble(rec.Amount).ToString("##, ###.##"); var refinedTrans = new RefinedTransactions { CategoryName = rec.CategoryName, BeneficiaryName = rec.BeneficiaryName, Amount = rec.IsBeneficiary == true ? $"{Utilities.GetCurrency(currencyCode)} {amt}" : $"{Utilities.GetCurrency(currencyCode)} {amt}", AmountColor = rec.IsBeneficiary == true ? Color.Green : Color.Red, ReferenceID = rec.ReferenceID, TransactionDate = rec.TransactionDate.ToString("d MMM"), PaymentReference = rec.PaymentReference }; transactions.Add(refinedTrans); } CustomerTransactions.ReplaceRange(transactions); if (CustomerTransactions.Count > 0) { TransactionMessage = ""; } } else { ShowTransactionErrorMessage = true; TransactionMessage = "No Transaction Found"; } } else { var content = await request.Content.ReadAsStringAsync(); } } catch (WebException e) { } catch (Exception ex) { } finally { IsTransactionLoading = false; } }
public CustomerTransactions Get(string dtTo, string dtFrom, string LocationID) { EarthSkyTimeEntities1 estEnt = new EarthSkyTimeEntities1(); CustomerTransactions transactions = new CustomerTransactions(); transactions.CustomerTransactionList = new List <CustomerTransaction>(); // get all transactions var oTrans = from t in estEnt.Transactions join c in estEnt.Customers on t.CustomerID equals c.CustomerID join l in estEnt.Locations on t.LocationID equals l.LocationID into joinedT from l in joinedT.DefaultIfEmpty() orderby t.TransactionDate descending select new { t.Amount, t.TransactionDate, c.FirstName, c.LastName, l.LocationName, l.City, l.State, LocationID = l.LocationID == null ? 0 : l.LocationID }; if (dtFrom != "undefined" && dtFrom != "null") { DateTime dFrom = Convert.ToDateTime(dtFrom); oTrans = oTrans.Where(m => m.TransactionDate >= dFrom); } if (dtTo != "undefined" && dtTo != "null") { DateTime dTo = Convert.ToDateTime(dtTo).AddDays(1); oTrans = oTrans.Where(m => m.TransactionDate <= dTo); } if (LocationID != "undefined") { int iLocation = Convert.ToInt32(LocationID); if (iLocation > 0) { oTrans = oTrans.Where(m => m.LocationID == iLocation); } } foreach (var t1 in oTrans) { string sLoc = t1.LocationName + " - " + t1.City + ", " + t1.State; if (t1.LocationName != null) { sLoc = t1.LocationName; if (t1.City != "") { sLoc += " - " + t1.City; } if (t1.State != "") { sLoc += ", " + t1.State; } } else { sLoc = "None"; } transactions.CustomerTransactionList.Add(new CustomerTransaction { Name = t1.LastName + ", " + t1.FirstName, Amount = Convert.ToDecimal(t1.Amount), Location = sLoc, DateUpdated = Convert.ToDateTime(t1.TransactionDate).ToShortDateString() }); } return(transactions); }