public void updateGrid() { string iscredit = ""; DataSet transactionsDataSet = new DataSet(); DataTable transactionsDataTable = new DataTable("Transactions"); transactionsDataTable.Columns.Add("AccountTitle"); transactionsDataTable.Columns.Add("TransactionType"); transactionsDataTable.Columns.Add("Description"); transactionsDataTable.Columns.Add("Date"); transactionsDataTable.Columns.Add("Time"); transactionsDataTable.Columns.Add("Amount"); transactionsDataTable.Columns.Add("Balance"); foreach (var item in currentTransactions) { if (item.iscredit == 1) { iscredit = "Credit"; } else { iscredit = "Debit"; } //transactionsDataTable.Rows.Add(item.AccountName, iscredit, item.transactionDescription, item.transactionDate.Date.ToShortDateString(), item.transactionTime.ToShortTimeString(), item.transactionAmount, item.balance); //working code when deleting the rows. transactionsDataTable.Rows.Add(item.AccountName, iscredit, item.transactionDescription, item.transactionDate.Date.ToShortDateString(), item.transactionTime.TimeOfDay.ToString(), item.transactionAmount, item.balance); } transactionsDataSet.Tables.Add(transactionsDataTable); LedgerGridView.DataSource = transactionsDataSet; LedgerGridView.DataMember = "Transactions"; LedgerGridView.Refresh(); reColorGrid(); }
private void SaveTransactionsButton_Click(object sender, EventArgs e) { if (isBalanced() == false) { return; } Model.transaction trans; try { using (var db = new POSApplication.Model.posdbEntities()) { foreach (var item in currentTransactions) { trans = new Model.transaction(); trans.accountid = GetAccountID(item.AccountName); if (item.iscredit == 0) { trans.Debit = Decimal.Parse(item.transactionAmount.ToString()); } else { trans.Credit = Decimal.Parse(item.transactionAmount.ToString()); } trans.entrydate = item.transactionDate; trans.entrytime = item.transactionTime.TimeOfDay; trans.description = item.transactionDescription; db.transactions.Add(trans); db.SaveChanges(); } MessageBox.Show("Transactions saved successfully."); } LedgerGridView.DataSource = null; LedgerGridView.DataMember = null; LedgerGridView.Refresh(); CreditAccountID.Text = ""; CreditAmountField.Text = ""; CreditTransactionDescription.Text = ""; DebitAccountID.Text = ""; DebitAmountField.Text = ""; DebitTransactionDescription.Text = ""; } catch (Exception e1) { MessageBox.Show("Transactions could not be saved."); } }
private void ShowLedgerButton_Click(object sender, EventArgs e) { if (selectedAccount.Length == 0) { if (AccountNameCombo.Text.Length > 0) { selectedAccount = AccountNameCombo.GetItemText(AccountNameCombo.Text); } } //if (selectedAccount.Length > 0) searchRecords(selectedAccount, dateTimePicker1.Value.ToString(), dateTimePicker2.Value.ToString()); selectedAccount = ""; string iscredit = ""; DataSet transactionsDataSet = new DataSet(); DataTable transactionsDataTable = new DataTable("Transactions"); transactionsDataTable.Columns.Add("AccountTitle"); transactionsDataTable.Columns.Add("TransactionType"); transactionsDataTable.Columns.Add("Description"); transactionsDataTable.Columns.Add("Date"); transactionsDataTable.Columns.Add("Time"); transactionsDataTable.Columns.Add("Amount"); transactionsDataTable.Columns.Add("Balance"); foreach (var item in currentTransactions) { if (item.iscredit == 1) { iscredit = "Credit"; } else { iscredit = "Debit"; } //working code when deleting the rows. transactionsDataTable.Rows.Add(item.AccountName, iscredit, item.transactionDescription, item.transactionDate.Date.ToShortDateString(), item.transactionTimeString, item.transactionAmount, item.balance); } transactionsDataSet.Tables.Add(transactionsDataTable); LedgerGridView.DataSource = transactionsDataSet; LedgerGridView.DataMember = "Transactions"; LedgerGridView.Refresh(); reColorGrid(); }
private void BtnLoad_Click(object sender, EventArgs e) { try { dt.Clear(); DataSet ds = new DataSet(); if (_SelectRange.chBSHead.Checked) { DataRow currentrow = _SelectRange.HelpGridView.GetDataRow(_SelectRange.HelpGridView.FocusedRowHandle); DataSet dsBSHeads = ProjectFunctions.GetDataSet("Select AccCode,AccName from ActMst Where AccBSHcode ='" + currentrow["BSCode"].ToString() + "'"); if (dsBSHeads.Tables[0].Rows.Count > 0) { dsBSHeads.Tables[0].Columns.Add("Select", typeof(bool)); foreach (DataRow dr in dsBSHeads.Tables[0].Rows) { dr["Select"] = true; } PrepareActMstHelpGrid(); _SelectRange.HelpGrid.DataSource = dsBSHeads.Tables[0]; _SelectRange.HelpGridView.BestFitColumns(); } else { _SelectRange.HelpGrid.DataSource = null; _SelectRange.HelpGridView.BestFitColumns(); } } if (_SelectRange.chLedger.Checked) { DataRow currentrow = _SelectRange.HelpGridView.GetDataRow(_SelectRange.HelpGridView.FocusedRowHandle); DataSet dsLedgerHeads = ProjectFunctions.GetDataSet("Select AccCode,AccName from ActMst Where AccLedger ='" + currentrow["LgrCode"].ToString() + "'"); if (dsLedgerHeads.Tables[0].Rows.Count > 0) { dsLedgerHeads.Tables[0].Columns.Add("Select", typeof(bool)); foreach (DataRow dr in dsLedgerHeads.Tables[0].Rows) { dr["Select"] = true; } PrepareActMstHelpGrid(); _SelectRange.HelpGrid.DataSource = dsLedgerHeads.Tables[0]; _SelectRange.HelpGridView.BestFitColumns(); } else { _SelectRange.HelpGrid.DataSource = null; _SelectRange.HelpGridView.BestFitColumns(); } } foreach (DataRow dr in (_SelectRange.HelpGrid.DataSource as DataTable).Rows) { if (dr["Select"].ToString().ToUpper() == "TRUE") { String SubEntries = String.Empty; if (_SelectRange.chSubEntries.Checked) { SubEntries = "Y"; } ds = ProjectFunctions.GetDataSet("[sp_ZoomPartyActGrid] '" + Convert.ToDateTime(_SelectRange.DtFrom.EditValue).ToString("yyyy-MM-dd") + "','" + Convert.ToDateTime(_SelectRange.DtEnd.EditValue).ToString("yyyy-MM-dd") + "','" + dr["AccCode"].ToString() + "','" + SubEntries + "'"); if (ds.Tables[0].Rows.Count > 0) { int Count = 0; Decimal Balance = 0; for (Count = 0; Count < ds.Tables[0].Rows.Count; Count++) { if (Count == 0) { ds.Tables[0].Rows[0]["Balance"] = Convert.ToDecimal(ds.Tables[0].Rows[0]["Debit"]) - Convert.ToDecimal(ds.Tables[0].Rows[0]["Credit"]); Balance = Convert.ToDecimal(ds.Tables[0].Rows[0]["Balance"]); } else { if (ds.Tables[0].Rows[Count]["VutID"].ToString() != "-1") { ds.Tables[0].Rows[Count]["Balance"] = Balance + Convert.ToDecimal(ds.Tables[0].Rows[Count]["Debit"]) - Convert.ToDecimal(ds.Tables[0].Rows[Count]["Credit"]); Balance = Convert.ToDecimal(ds.Tables[0].Rows[Count]["Balance"]); } else { ds.Tables[0].Rows[Count]["Debit"] = Convert.ToDecimal("0"); ds.Tables[0].Rows[Count]["Credit"] = Convert.ToDecimal("0"); ds.Tables[0].Rows[Count]["VutNo"] = null; ds.Tables[0].Rows[Count]["VutDesc"] = null; ds.Tables[0].Rows[Count]["VutDate"] = Convert.ToDateTime("1900-01-01"); ds.Tables[0].Rows[Count]["VutType"] = null; } } } if (ds.Tables[0].Rows.Count > 0) { if (dt.Rows.Count > 0) { dt.Merge(ds.Tables[0]); } else { dt = ds.Tables[0]; } } } } } if (dt.Rows.Count > 0) { dt.Columns.Add("CRDR", typeof(String)); foreach (DataRow dr in dt.Rows) { if (Convert.ToDecimal(dr["Balance"]) > 0) { dr["CRDR"] = "Dr."; } if (Convert.ToDecimal(dr["Balance"]) < 0) { dr["CRDR"] = "Cr."; dr["Balance"] = -(Convert.ToDecimal(dr["Balance"])); } } dt.WriteXmlSchema("C://Temp//abc.xml"); LedgerGrid.DataSource = dt; LedgerGridView.BestFitColumns(); LedgerGridView.Columns["LedgerPartyName"].GroupIndex = 0; LedgerGridView.ExpandAllGroups(); } else { LedgerGrid.DataSource = null; } _SelectRange.Visible = false; } catch (Exception ex) { ProjectFunctions.SpeakError(ex.Message); } }