protected void BtnPostToLedger_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GvJrShow.Rows)
{
LDTO.JournalId = Convert.ToInt32(row.Cells[1].Text);
if (row.Cells[5].Text.ToString() != " ")
{
LDTO.DRAmount = Convert.ToDouble(row.Cells[5].Text);
LDTO.CRAmount = null;
}
if (row.Cells[6].Text.ToString() != " ")
{
LDTO.DRAmount = null;
LDTO.CRAmount = Convert.ToDouble(row.Cells[6].Text);
}
LDTO.CreateBy = HttpContext.Current.User.Identity.Name;
LDTO.CreateDate = System.DateTime.Now;
//start clbal, opbal
List <COAInfoDTO> coa = new List <COAInfoDTO>();
coa = CBLL.LoadCoAInfo(Convert.ToInt32(row.Cells[10].Text), "", "", 0, "", "", "", "", "", "");
double?balance;
if (coa.First().Balance != null)
{
balance = coa.First().Balance;
}
else
{
balance = 0;
}
List <LedgerDTO> ld = new List <LedgerDTO>();
ld = LBLL.LoadLedgerData(0, 0, Convert.ToInt32(row.Cells[10].Text));
double?opbal;
double?clbal;
double?dramoun = 0;
double?cramount = 0;
if (ld.Count != 0)
{
if (ld.First().OPBAL != null)
{
opbal = ld.First().OPBAL;
}
else
{
opbal = 0;
}
if (ld.First().CLBAL != null)
{
clbal = ld.First().CLBAL;
}
else
{
clbal = 0;
}
if (ld.First().DRAmount != null)
{
dramoun = ld.First().DRAmount;
}
else
{
dramoun = 0;
}
if (ld.First().CRAmount != null)
{
cramount = ld.First().CRAmount;
}
else
{
cramount = 0;
}
LDTO.OPBAL = clbal;
if (row.Cells[5].Text.ToString() != " ")
{
LDTO.CLBAL = clbal + Convert.ToDouble(row.Cells[5].Text);
}
if (row.Cells[6].Text.ToString() != " ")
{
LDTO.CLBAL = clbal + Convert.ToDouble(row.Cells[6].Text);
}
}
else
{
LDTO.OPBAL = balance;
if (row.Cells[5].Text.ToString() != " ")
{
LDTO.CLBAL = balance + Convert.ToDouble(row.Cells[5].Text);
}
if (row.Cells[6].Text.ToString() != " ")
{
LDTO.CLBAL = balance + Convert.ToDouble(row.Cells[6].Text);
}
}
// end of clbal,opbal
CDTO.COAId = Convert.ToInt32(row.Cells[10].Text);
CDTO.Balance = LDTO.CLBAL;
CBLL.Edit_COAUpdate(CDTO);
JDTO.JournalId = Convert.ToInt32(row.Cells[1].Text);
JDTO.PostLeadgerStatus = "Y";
JBLL.Edit_JournalUpdate(JDTO);
LBLL.Add(LDTO);
}
PanelGVShow.Visible = false;
PanelEntity.Visible = false;
int TransectionNo;
TransectionNo = Convert.ToInt32(HFTransectionNo.Value);
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('/AccSysManagment/AccountingReport/JournalUpdateRptUI.aspx?TransectionNo=" + TransectionNo.ToString() + "');", true);
PanleAdd.Visible = false;
pagingLoal();
}
protected void BtnSave_Click(object sender, EventArgs e)
{
DataTable dt = (DataTable)ViewState["CurrentData"];
int count = dt.Rows.Count;
int rowCount = 0;
double drAmount = 0;
double crAmount = 0;
rowCount = GvJrEntry.Rows.Count;
for (int i = 0; i < rowCount; i++)
{
if (Convert.ToString(dt.Rows[i][1]) == "DR")
{
drAmount = drAmount + Convert.ToDouble(dt.Rows[i][6]);
}
else
{
crAmount = crAmount + Convert.ToDouble(dt.Rows[i][6]);
}
}
if (Convert.ToInt32(drAmount) != Convert.ToInt32(crAmount))
{
lblCheckDRC_R.Visible = true;
lblCheckDRC_R.Text = "Please Check DR. & CR. Amount";
}
else
{
// Start for LOG File Journal Update In Ladger page
for (int i = 0; i < count; i++)
{
string logField = "";
var Journalinfo = JBLL.LoadJournalUpdate_ladger(Convert.ToInt32(dt.Rows[i][0]), 0);
if (Convert.ToString(dt.Rows[i][4]) != Journalinfo.First().SubCode2Id.ToString())
{
logField += "SubCode2Id" + "-" + Journalinfo.First().SubCode2Id.ToString() + "#" + dt.Rows[i][4] + ";";
}
if (Convert.ToString(dt.Rows[i][2]) != Journalinfo.First().COAId.ToString())
{
logField += "COAId" + "-" + Journalinfo.First().COAId.ToString() + "#" + dt.Rows[i][2] + ";";
}
if (Convert.ToString(dt.Rows[i][9]) != Journalinfo.First().SubVoucherId.ToString())
{
logField += "SubVoucherId" + "-" + Journalinfo.First().SubVoucherId.ToString() + "#" + dt.Rows[i][9] + ";";
}
if (Convert.ToString(dt.Rows[i][1]) != Journalinfo.First().JournalType.ToString())
{
logField += "JournalType" + "-" + Journalinfo.First().JournalType.ToString() + "#" + dt.Rows[i][1] + ";";
}
if (Convert.ToString(dt.Rows[i][1]) == "DR")
{
if (Convert.ToString(dt.Rows[i][6]) != Journalinfo.First().DRAmount.ToString()) // problem
{
logField += "DRAmount" + "-" + Journalinfo.First().DRAmount.ToString() + "#" + dt.Rows[i][6] + ";";
}
}
else
{
if (Convert.ToString(dt.Rows[i][6]) != Journalinfo.First().CRAmount.ToString()) // problem
{
logField += "CRAmount" + "-" + Journalinfo.First().CRAmount.ToString() + "#" + dt.Rows[i][6] + ";";
}
}
if (txtTransectionDate.Text != Journalinfo.First().TransectionDate.ToString())
{
logField += "TransectionDate" + "-" + Journalinfo.First().TransectionDate.ToString() + "#" + txtTransectionDate.Text + ";";
}
if (Convert.ToString(dt.Rows[i][7]) != Journalinfo.First().VONO.ToString()) // problem
{
logField += "VONO" + "-" + Journalinfo.First().VONO.ToString() + "#" + dt.Rows[i][7] + ";";
}
if (Convert.ToString(dt.Rows[i][8]) != Journalinfo.First().MRNO.ToString()) // problem
{
logField += "MRNO" + "-" + Journalinfo.First().MRNO.ToString() + "#" + dt.Rows[i][8] + ";";
}
if (Convert.ToString(dt.Rows[i][11]) != Journalinfo.First().Remarks.ToString()) // problem
{
logField += "Remarks" + "-" + Journalinfo.First().Remarks.ToString() + "#" + dt.Rows[i][11] + ";";
}
if (logField.Length > 0)
{
logField = " JournalId" + "-" + Convert.ToInt32(dt.Rows[i][0]) + ";" + logField;
JLDTO.LogField = logField;
JLDTO.LogDate = System.DateTime.Now;
JLDTO.LogBy = "ABHI";
JLBLL.AddLogAccJournal(JLDTO);
}
}
// End for LOG File Journal Update In Ladger page
for (int i = 0; i < count; i++)
{
JDTO.JournalId = Convert.ToInt32(dt.Rows[i][0]);
JDTO.SubCode2Id = Convert.ToInt32(dt.Rows[i][4]);
JDTO.COAId = Convert.ToInt32(dt.Rows[i][2]);
JDTO.SubVoucherId = Convert.ToInt32(dt.Rows[i][9]);
JDTO.JournalType = Convert.ToString(dt.Rows[i][1]);
if (Convert.ToString(dt.Rows[i][1]) == "DR")
{
JDTO.DRAmount = Convert.ToInt32(dt.Rows[i][6]);
JDTO.CRAmount = null;
}
else
{
JDTO.DRAmount = null;
JDTO.CRAmount = Convert.ToInt32(dt.Rows[i][6]);
}
JDTO.VONO = Convert.ToString(dt.Rows[i][7]);
JDTO.MRNO = Convert.ToString(dt.Rows[i][8]);
JDTO.Remarks = Convert.ToString(dt.Rows[i][11]);
JDTO.TransectionNo = Convert.ToInt32(dt.Rows[i][12]);
if (txtTransectionDate.Text == "Today")
{
JDTO.TransectionDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
}
else
{
JDTO.TransectionDate = Convert.ToDateTime(txtTransectionDate.Text.ToString());
}
JDTO.PostLeadgerStatus = "Y";
JDTO.UpdateBy = HttpContext.Current.User.Identity.Name;
JDTO.UpdateDate = System.DateTime.Now;
JBLL.Edit(JDTO);
}
// insert in to ledger
for (int i = 0; i < count; i++)
{
LDTO.JournalId = Convert.ToInt32(dt.Rows[i][0]);
// LDTO.OPBAL = 0;
if (Convert.ToString(dt.Rows[i][1]) == "DR")
{
LDTO.DRAmount = Convert.ToDouble(dt.Rows[i][6]);
LDTO.CRAmount = null;
}
else
{
LDTO.DRAmount = null;
LDTO.CRAmount = Convert.ToDouble(dt.Rows[i][6]);
}
// LDTO.CLBAL = 0;
LDTO.CreateBy = HttpContext.Current.User.Identity.Name;
LDTO.CreateDate = System.DateTime.Now;
//start clbal, opbal
List <COAInfoDTO> coa = new List <COAInfoDTO>();
coa = CBLL.LoadCoAInfo(Convert.ToInt32(dt.Rows[i][2]), "", "", 0, "", "", "", "", "", "");
double?balance;
if (coa.First().Balance != null)
{
balance = coa.First().Balance;
}
else
{
balance = 0;
}
List <LedgerDTO> ld = new List <LedgerDTO>();
ld = LBLL.LoadLedgerData(0, 0, Convert.ToInt32(dt.Rows[i][2]));
double?opbal;
double?clbal;
double?dramoun = 0;
double?cramount = 0;
if (ld.Count != 0)
{
if (ld.First().OPBAL != null)
{
opbal = ld.First().OPBAL;
}
else
{
opbal = 0;
}
if (ld.First().CLBAL != null)
{
clbal = ld.First().CLBAL;
}
else
{
clbal = 0;
}
if (ld.First().DRAmount != null)
{
dramoun = ld.First().DRAmount;
}
else
{
dramoun = 0;
}
if (ld.First().CRAmount != null)
{
cramount = ld.First().CRAmount;
}
else
{
cramount = 0;
}
LDTO.OPBAL = clbal;
LDTO.CLBAL = clbal + Convert.ToDouble(dt.Rows[i][6]);
}
else
{
LDTO.OPBAL = balance;
if (Convert.ToString(dt.Rows[i][1]) == "DR")
{
LDTO.CLBAL = balance + Convert.ToDouble(dt.Rows[i][6]);
}
else
{
LDTO.CLBAL = balance + Convert.ToDouble(dt.Rows[i][6]);
}
}
// end of clbal,opbal
CDTO.COAId = Convert.ToInt32(dt.Rows[i][2]);
CDTO.Balance = LDTO.CLBAL;
CBLL.Edit_COAUpdate(CDTO);
LBLL.Add(LDTO);
}
CLearContorl();
int TransectionNo;
TransectionNo = Convert.ToInt32(HFTransectionNo.Value);
ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('AccSysManagment/AccountingReport/JournalUpdateRptUI.aspx?TransectionNo=" + TransectionNo.ToString() + "');", true);
pagingLoal();
}
}