/// <summary> /// Populating the datagrid and /// retrieving the next journal /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void JournalAdd_Load(object sender, EventArgs e) { DataTable dt = SubGroup.ViewSubGroup(); /////////////////////////////////// //// Account name DataGridViewComboBoxColumn cw = new DataGridViewComboBoxColumn(); cw.DataSource = dt; cw.DisplayMember = "S_DESC"; cw.HeaderText = "ACCOUNT NAME"; this.JournalGridView.Columns.Add(cw); /////////////////////////////////////// ////// debit or Credit ////// DataTable myDataTable = new DataTable(); DataColumn myDataColumn; myDataColumn = new DataColumn(); myDataColumn.DataType = System.Type.GetType("System.String"); myDataColumn.ColumnName = "Account"; myDataColumn.ReadOnly = false; myDataColumn.Unique = true; myDataTable.Columns.Add(myDataColumn); DataRow dr = myDataTable.NewRow(); dr["Account"] = "DR"; myDataTable.Rows.Add(dr); myDataTable.AcceptChanges(); dr = myDataTable.NewRow(); dr["Account"] = "CR"; myDataTable.Rows.Add(dr); myDataTable.AcceptChanges(); cw = new DataGridViewComboBoxColumn(); cw.DataSource = myDataTable; cw.DisplayMember = "Account"; this.JournalGridView.Columns.Add(cw); ////////////////////////////////////// //// Amount Column //// DataGridViewTextBoxColumn ct = new DataGridViewTextBoxColumn(); this.JournalGridView.Columns.Add(ct); /////////////////////////////////////// ///// Retrieve next journal id ///// int rst = JournalPoster.NextJournal(); this.journalidtxt.Text = rst.ToString(); }
private void PostBtn_Click(object sender, EventArgs e) { string jid = journalidtxt.Text; if (!(JournalPoster.DeleteJournal(jid))) { MessageBox.Show("Fail to delete Journal"); return; } }
private void PostBtn_Click(object sender, EventArgs e) { int jnum = Convert.ToInt32(journalidtxt.Text); string jd = dateTimePicker1.Text; string narr = NarrTxt.Text; Journal rst = new Journal(); rst.jid = jnum.ToString(); rst.jdate = jd; rst.narration = narr; List <JournalEntry> st = new List <JournalEntry>(); int rs = this.JournalGridView.Rows.Count; for (int i = 0; i < rs - 1; ++i) { DataGridViewRow dr = this.JournalGridView.Rows[i]; JournalEntry jr = new JournalEntry(); for (int j = 0; j < 3; ++j) { DataGridViewCell c = dr.Cells[j]; if (c.Value != null) { if (j == 0) { jr.jname = c.Value.ToString(); } else if (j == 1) { jr.drcr = c.Value.ToString(); } else if (j == 2) { jr.amount = c.Value.ToString(); } } } st.Add(jr); } rst.rs = st; if (!JournalPoster.PostForAdd(rst)) { MessageBox.Show("Anomaly in Posting"); return; } }
private void ShowJournalbtn_Click(object sender, EventArgs e) { string jid = Journaltxt.Text; Journal j = AccountLayer.JournalPoster.GetJournalFromId(jid); if (j == null || j.rs.Count == 0) { MessageBox.Show("Journal doesnot exist"); return; } DataTable dt = JournalPoster.JournalEntryToDataTable(j.rs); this.dataGridView1.DataSource = dt; dataGridView1.Refresh(); dataGridView1.ReadOnly = true; }
private void journalidtxt_Leave(object sender, EventArgs e) { string jid = journalidtxt.Text; if (!(JournalPoster.IsValidJournal(jid))) { MessageBox.Show("Invalid Journal"); return; } Journal j = JournalPoster.GetJournalFromId(jid); dateTimePicker1.Text = j.jdate; NarrTxt.Text = j.narration; DataTable dt = JournalPoster.JournalEntryToDataTable(j.rs); this.JournalGridView.DataSource = dt; this.JournalGridView.Refresh(); this.JournalGridView.ReadOnly = true; PostBtn.Enabled = true; }
private void button2_Click(object sender, EventArgs e) { int x = JournalPoster.NextJournal(); MessageBox.Show(x.ToString()); }