//void ShowSelected(object param) //{ // this.ShowAllTrue = false; // Search(null); // Mouse.OverrideCursor = null; //} public void OnSelectionChange(object param) { this.JsonData = transactionRepository.GetLastSelectionData(Convert.ToInt32(ScreenId.AccountTransaction)); if (ID != 0 && JsonData == null) { AccountsTransactionDetailList = transactionRepository.GetAccountsTransactionDetails(ID, this.JsonData); AccountDetailListStore = this.AccountsTransactionDetailList; this.ShowAllCount = this.AccountDetailListStore.Count(); TotalAmount = Convert.ToString(AccountsTransactionDetailList.Sum(x => Convert.ToDecimal(x.AmountStr))); //List<AccountsTransactionsEntity> Templist = new List<AccountsTransactionsEntity>(); //Templist.AddRange(AccountsTransactionDetailList); //Templist.Add(new AccountsTransactionsEntity { TransactionType = "Total", Name = "", TransactionNo = "", TransactiondateStr = "", AmountStr = String.Format("{0:#,##0.##}", Amount) }); ////AccountsTransactionDetailList.Add(Templist.ToList()); //AccountsTransactionDetailList = Templist; this.ShowSelectedCount = this.AccountsTransactionDetailList.Count(); } else if (ID != 0 && !String.IsNullOrEmpty(JsonData)) { AccountsTransactionDetailList = transactionRepository.GetAccountsTransactionDetails(ID, this.JsonData); AccountDetailListStore = this.AccountsTransactionDetailList; this.ShowAllCount = this.AccountDetailListStore.Count(); TotalAmount = Convert.ToString(AccountsTransactionDetailList.Sum(x => Convert.ToDecimal(x.AmountStr))); //List<AccountsTransactionsEntity> Templist = new List<AccountsTransactionsEntity>(); //Templist.AddRange(AccountsTransactionDetailList); //Templist.Add(new AccountsTransactionsEntity { TransactionType = "Total", Name = "", TransactionNo = "", TransactiondateStr = "", AmountStr = String.Format("{0:#,##0.##}", Amount) }); ////AccountsTransactionDetailList.Add(Templist.ToList()); //AccountsTransactionDetailList = Templist; this.ShowSelectedCount = this.AccountsTransactionDetailList.Count(); } }
void Search(object param) { //UIServices.SetBusyState(); //DoProcessing(); if (Count != 0) { SearchValues = new List <SearchEntity>(); if (this.SelectedSearchYear != null && this.SelectedSearchYear != string.Empty) { SearchEntity value = new SearchEntity(); value.FieldName = "Year"; value.FieldValue = this.SelectedSearchYear; SearchValues.Add(value); var year = Convert.ToInt32(this.SelectedSearchYear); } else { SearchEntity value = new SearchEntity(); value.FieldName = "Year"; value.FieldValue = "0"; SearchValues.Add(value); } if (this.SelectedSearchQuarter != null && this.SelectedSearchQuarter != string.Empty) { SearchEntity value = new SearchEntity(); value.FieldName = "Quarter"; value.FieldValue = this.SelectedSearchQuarter; int month1; int month2; int month3; if (Convert.ToInt32(this.SelectedSearchQuarter) == 1) { month1 = 1; month2 = 2; month3 = 3; } else if (Convert.ToInt32(this.SelectedSearchQuarter) == 2) { month1 = 4; month2 = 5; month3 = 6; } else if (Convert.ToInt32(this.SelectedSearchQuarter) == 3) { month1 = 7; month2 = 8; month3 = 9; } else { month1 = 10; month2 = 11; month3 = 12; } SearchValues.Add(value); } else { SearchEntity value = new SearchEntity(); value.FieldName = "Quarter"; value.FieldValue = "0"; SearchValues.Add(value); } if (this.SelectedSearchMonth != null && this.SelectedSearchMonth != string.Empty) { SearchEntity value = new SearchEntity(); value.FieldName = "Month"; value.FieldValue = this.SelectedSearchMonth; SearchValues.Add(value); var month = Convert.ToInt32(this.SelectedSearchMonth); } else { SearchEntity value = new SearchEntity(); value.FieldName = "Month"; value.FieldValue = "0"; SearchValues.Add(value); } if (this.SelectedSearchStartDate != null && this.SelectedSearchEndDate != null) { SearchEntity value = new SearchEntity(); value.FieldName = "StartDate"; //value.FieldValue = this.SelectedSearchStartDate.ToString(); value.FieldValue = string.Format("{0:MMM/dd/yyyy}", this.SelectedSearchStartDate); SearchValues.Add(value); //string[] value = new string[2]; SearchEntity value1 = new SearchEntity(); value1.FieldName = "EndDate"; //value1.FieldValue = this.SelectedSearchEndDate.ToString(); value1.FieldValue = string.Format("{0:MMM/dd/yyyy}", this.SelectedSearchEndDate); //DefaultList = FullPQList.Where(x => x.CreatedDate > this.SelectedSearchStartDate && x.CreatedDate < this.SelectedSearchEndDate).ToList(); //if (this.IncludingGSTTrue == true) // this.SalesQuotationListInternal = DefaultList.Where(x => x.ExcIncGST == true).ToList(); //else // this.SalesQuotationListInternal = DefaultList.Where(x => x.ExcIncGST == false).ToList(); //this.SalesQuotationListcmb = DefaultList; SearchValues.Add(value1); } else { SearchEntity value = new SearchEntity(); value.FieldName = "StartDate"; value.FieldValue = ""; SearchValues.Add(value); SearchEntity value1 = new SearchEntity(); value1.FieldName = "EndDate"; value1.FieldValue = ""; SearchValues.Add(value1); } //if (this.ID != 0) //{ // SearchEntity value = new SearchEntity(); // value.FieldName = "PandS"; // value.FieldValue = this.PandS.ToString(); // SearchValues.Add(value); //} //else //{ // SearchEntity value = new SearchEntity(); // value.FieldName = "PandS"; // value.FieldValue = "0"; // SearchValues.Add(value); //} if (this.ShowAllTrue == true) { SearchEntity value = new SearchEntity(); value.FieldName = "ShowAll"; value.FieldValue = this.ShowAllTrue.ToString(); SearchValues.Add(value); } else { SearchEntity value = new SearchEntity(); value.FieldName = "ShowAll"; value.FieldValue = "false"; SearchValues.Add(value); } jsonSearch = JsonConvert.SerializeObject(SearchValues); this.JsonData = jsonSearch; var results = transactionsRepository.SaveSearchJson(jsonSearch, Convert.ToInt32(ScreenId.AccountTransaction), "Account_transaction"); if (Count != 0) { if (ID != 0 && JsonData != null) { AccountsTransactionDetailList = transactionRepository.GetAccountsTransactionDetails(ID, this.JsonData); AccountDetailListStore = this.AccountsTransactionDetailList; this.ShowAllCount = this.AccountDetailListStore.Count(); this.ShowSelectedCount = this.AccountsTransactionDetailList.Where(x => x.TransactionType != "Total").Count(); TotalAmount = Convert.ToString(AccountsTransactionDetailList.Sum(x => Convert.ToDecimal(x.AmountStr))); //var Templist = new List<AccountsTransactionsEntity>(); //Templist.AddRange(AccountsTransactionDetailList); //Templist.Add(new AccountsTransactionsEntity { TransactionType = "Total", Name = "", TransactionNo = "", TransactiondateStr = "", AmountStr = String.Format("{0:#,##0.##}", Amount) }); ////AccountsTransactionDetailList.Add(Templist.ToList()); //AccountsTransactionDetailList = Templist; //this.ShowAllCount = this.AccountDetailListStore.Count(); } } } }