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