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