protected void btnUpdate_Click(object sender, EventArgs e)
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail = ACC_JournalDetailManager.GetACC_JournalDetailByID(Int32.Parse(Request.QueryString["aCC_JournalDetailID"]));
ACC_JournalDetail tempACC_JournalDetail = new ACC_JournalDetail();
tempACC_JournalDetail.ACC_JournalDetailID = aCC_JournalDetail.ACC_JournalDetailID;
tempACC_JournalDetail.JournalMasterID = Int32.Parse(ddlJournalMaster.SelectedValue);
tempACC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlACC_ChartOfAccountLabel4.SelectedValue);
tempACC_JournalDetail.ACC_ChartOfAccountLabel3ID = Int32.Parse(ddlACC_ChartOfAccountLabel3.SelectedValue);
tempACC_JournalDetail.WorkStation = Int32.Parse(txtWorkStation.Text);
tempACC_JournalDetail.Debit = Decimal.Parse(txtDebit.Text);
tempACC_JournalDetail.Credit = Decimal.Parse(txtCredit.Text);
tempACC_JournalDetail.ExtraField3 = txtExtraField3.Text;
tempACC_JournalDetail.ExtraField2 = txtExtraField2.Text;
tempACC_JournalDetail.ExtraField1 = txtExtraField1.Text;
tempACC_JournalDetail.AddedBy = Int32.Parse(txtAddedBy.Text);
tempACC_JournalDetail.AddedDate = DateTime.Now;
tempACC_JournalDetail.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
tempACC_JournalDetail.UpdatedDate = DateTime.Now;
tempACC_JournalDetail.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = ACC_JournalDetailManager.UpdateACC_JournalDetail(tempACC_JournalDetail);
Response.Redirect("AdminACC_JournalDetailDisplay.aspx");
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = ACC_JournalDetailManager.DeleteACC_JournalDetail(Convert.ToInt32(linkButton.CommandArgument));
List <ACC_JournalDetail> aCC_JournalDetails = new List <ACC_JournalDetail>();
aCC_JournalDetails = loadFromGrid();
ACC_JournalDetail aCC_JournalDetailToDelete = new ACC_JournalDetail();
foreach (ACC_JournalDetail item in aCC_JournalDetails)
{
if (item.ACC_JournalDetailID == Convert.ToInt32(linkButton.CommandArgument))
{
aCC_JournalDetailToDelete = item;
}
}
aCC_JournalDetails.Remove(aCC_JournalDetailToDelete);
int i = 0;
foreach (ACC_JournalDetail item in aCC_JournalDetails)
{
item.ACC_JournalDetailID = i++;
}
BindJournalGrid(aCC_JournalDetails);
}
protected void btnJournalSubmit_Click(object sender, EventArgs e)
{
try
{
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = Request.QueryString["Type"] != null ? Request.QueryString["Type"] : "0";//Voucher Type
aCC_JournalMaster.ExtraField1 = txtReceivedOrPayto.Text;
aCC_JournalMaster.ExtraField2 = txtAddress.Text;
aCC_JournalMaster.ExtraField3 = "";
aCC_JournalMaster.Note = txtNote.Text;
aCC_JournalMaster.JournalDate = DateTime.Parse(txtJournalMasterDate.Text);
aCC_JournalMaster.AddedBy = getLogin().LoginID;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = getLogin().LoginID;
aCC_JournalMaster.UpdatedDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
int JournalMasterID = 0;
if (Request.QueryString["Tmp"] != null)
{
JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMasterTmp(aCC_JournalMaster);
}
else
{
JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
}
List <ACC_JournalDetail> aCC_Journaldetails = loadFromGrid();
foreach (ACC_JournalDetail item in aCC_Journaldetails)
{
item.JournalMasterID = JournalMasterID;
if (Request.QueryString["Tmp"] != null)
{
ACC_JournalDetailManager.InsertACC_JournalDetailTmp(item);
hlnkPrintVoucher.Visible = false;
}
else
{
ACC_JournalDetailManager.InsertACC_JournalDetail(item);
hlnkPrintVoucher.Visible = true;
}
}
aCC_Journaldetails = new List <ACC_JournalDetail>();
BindJournalGrid(aCC_Journaldetails);
hlnkPrintVoucher.NavigateUrl = "Voucherprint.aspx?JournalMasterID=" + JournalMasterID;
showAlartMessage("Successfully Done.");
cleanDataJournalMaster();
}
catch (Exception ex)
{
showAlartMessage("Error occured");
}
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = ACC_JournalDetailManager.DeleteACC_JournalDetail(Convert.ToInt32(linkButton.CommandArgument));
showACC_JournalDetailGrid();
}
private void showACC_JournalDetailData()
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail = ACC_JournalDetailManager.GetACC_JournalDetailByID(Int32.Parse(Request.QueryString["aCC_JournalDetailID"]));
ddlJournalMaster.SelectedValue = aCC_JournalDetail.JournalMasterID.ToString();
ddlACC_ChartOfAccountLabel4.SelectedValue = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID.ToString();
ddlACC_ChartOfAccountLabel3.SelectedValue = aCC_JournalDetail.ACC_ChartOfAccountLabel3ID.ToString();
txtWorkStation.Text = aCC_JournalDetail.WorkStation.ToString();
txtDebit.Text = aCC_JournalDetail.Debit.ToString();
txtCredit.Text = aCC_JournalDetail.Credit.ToString();
txtExtraField3.Text = aCC_JournalDetail.ExtraField3;
txtExtraField2.Text = aCC_JournalDetail.ExtraField2;
txtExtraField1.Text = aCC_JournalDetail.ExtraField1;
txtAddedBy.Text = aCC_JournalDetail.AddedBy.ToString();
txtUpdatedBy.Text = aCC_JournalDetail.UpdatedBy.ToString();
txtUpdatedDate.Text = aCC_JournalDetail.UpdatedDate;
ddlRowStatus.SelectedValue = aCC_JournalDetail.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail.JournalMasterID = Int32.Parse(ddlJournalMaster.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlACC_ChartOfAccountLabel4.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = Int32.Parse(ddlACC_ChartOfAccountLabel3.SelectedValue);
aCC_JournalDetail.WorkStation = Int32.Parse(txtWorkStation.Text);
aCC_JournalDetail.Debit = Decimal.Parse(txtDebit.Text);
aCC_JournalDetail.Credit = Decimal.Parse(txtCredit.Text);
aCC_JournalDetail.ExtraField3 = txtExtraField3.Text;
aCC_JournalDetail.ExtraField2 = txtExtraField2.Text;
aCC_JournalDetail.ExtraField1 = txtExtraField1.Text;
aCC_JournalDetail.AddedBy = Int32.Parse(txtAddedBy.Text);
aCC_JournalDetail.AddedDate = DateTime.Now;
aCC_JournalDetail.UpdatedBy = Int32.Parse(txtUpdatedBy.Text);
aCC_JournalDetail.UpdatedDate = DateTime.Now;
aCC_JournalDetail.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
Response.Redirect("AdminACC_JournalDetailDisplay.aspx");
}
private void loadData()
{
try
{
string fromDateCurrentYear = "";
if (Request.QueryString["FromDate"] != null)
{
lblDate.Text = "FOR THE PERIOD FROM " + DateTime.Parse(Request.QueryString["FromDate"]).ToString("dd/MM/yyyy") + " TO " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy") + "";
lblStatement.Text = "TRANSACTION SUMMARY";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["FromDate"]).ToString("yyyy-MM-dd") + " 12:00:00 AM";
}
else
{
lblDate.Text = "AS ON " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy");
lblStatement.Text = "TRIAL BALANCE";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-") + "01-01 12:00:00 AM";
}
string toDate = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-MM-dd") + " 11:59:59 PM";
//List<ACC_JournalDetail> journalDetailsCurrentYear = ACC_JournalDetailManager.GetAllACC_JournalDetailForTrialBalance
// (
// fromDateCurrentYear,
// toDate
// );
int L1 = 0;
try
{
L1 = Int32.Parse(Request.QueryString["L1"]);
}
catch (Exception ex)
{ }
int L2 = 0;
try
{
L2 = Int32.Parse(Request.QueryString["L2"]);
}
catch (Exception ex)
{ }
int L3 = 0;
try
{
L3 = Int32.Parse(Request.QueryString["L3"]);
}
catch (Exception ex)
{ }
int L4 = 0;
try
{
L4 = Int32.Parse(Request.QueryString["L4"]);
}
catch (Exception ex)
{ }
List <ACC_JournalDetail> journalDetailsCurrentYear = ACC_JournalDetailManager.GetAllACC_JournalDetailForTrialBalanceLableWise
(L1, L2, L3, L4,
fromDateCurrentYear,
toDate
);
string journalDetailsHTML = @"<table width='100%' id='tblJournalDetails' class='tdBorder' border='0' cellspacing='0' cellpadding='0' style='margin:20px 0;'><tr style='font-weight:bold;font-size:15px;'>
<tr style='font-weight:bold;font-size:15px;'>
<td rowspan='2'>
Account<br/>Code</td>
<td rowspan='2'>
Head of Accounts</td>
<td colspan='2'>
Amount</td>
</tr>
<tr style='font-weight:bold;font-size:15px;'>
<td>
Debit</td>
<td>
Credit</td>
</tr>
";
decimal currentYearDebit = 0;
decimal currentYearCredit = 0;
decimal balance = 0;
foreach (ACC_JournalDetail journalDetail in journalDetailsCurrentYear)
{
balance = journalDetail.Debit - journalDetail.Credit;
if (balance >= 0)
{
journalDetail.Debit = balance;
journalDetail.Credit = 0;
}
else
{
journalDetail.Credit = balance * (-1);
journalDetail.Debit = 0;
}
currentYearDebit += journalDetail.Debit;
currentYearCredit += journalDetail.Credit;
balance = journalDetail.Debit - journalDetail.Credit;
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"</td>
<td>
<a target='_blank' href='GeneralLedgerPrint.aspx?ACC_ChartOfAccountLabel4ID=" + L4.ToString() + @"&ACC_ChartOfAccountLabel3ID=" + journalDetail.ACC_ChartOfAccountLabel3ID
+ "&WorkStationID=0&FromDate=" + fromDateCurrentYear
+ "&ToDate=" + toDate + @"'>" + journalDetail.ACC_ChartOfAccountLabel3Text + @"</a> </td>
";
journalDetailsHTML += @"<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"</td>
</tr>";
}
balance = currentYearDebit - currentYearCredit;
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + currentYearDebit.ToString("0,0.00") + @"</td><td style='text-align:right;'>" + currentYearCredit.ToString("0,0.00") + @"</td></tr>";
if (lblStatement.Text == "TRANSACTION SUMMARY")
{
lblJournalDetials.Text = lblJournalDetials.Text + "<tr><td></td><td><b>Balance:</b></td><td style='text-align:right;'>" + (balance >= 0 ? balance.ToString("0,0.00") : "") + @"</td><td style='text-align:right;'>" + (balance < 0 ? ((-1) * balance).ToString("0,0.00") : "") + @"</td></tr>";
}
lblJournalDetials.Text += "</table>";
}
catch (Exception ex)
{ }
}
private void loadData()
{
try
{
string fromDateCurrentYear = "";
if (Request.QueryString["FromDate"] != null)
{
lblDate.Text = "FOR THE PERIOD FROM " + DateTime.Parse(Request.QueryString["FromDate"]).ToString("dd/MM/yyyy") + " TO " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy") + "";
lblStatement.Text = "INCOME STATEMENT";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["FromDate"]).ToString("yyyy-MM-dd") + " 12:00:00 AM";
}
else
{
lblDate.Text = "AS ON " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy");
lblStatement.Text = "INCOME STATEMENT";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-") + "01-01 12:00:00 AM";
}
string toDate = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-MM-dd") + " 11:59:59 PM";
int L1 = 0;
int L2 = 0;
int L3 = 0;
int L4 = 0;
L1 = 11;
List <ACC_JournalDetail> financilaStatement = new List <ACC_JournalDetail>();
List <ACC_ChartOfAccountLabel1> aCC_ChartOfAccountLabel1s = new List <ACC_ChartOfAccountLabel1>();
aCC_ChartOfAccountLabel1s = ACC_ChartOfAccountLabel1Manager.GetAllACC_ChartOfAccountLabel1s().FindAll(x => x.RowStatusID == 1);
foreach (ACC_ChartOfAccountLabel1 aCC_ChartOfAccountLabel1 in aCC_ChartOfAccountLabel1s)
{
if (aCC_ChartOfAccountLabel1.ExtraField1 == "Expense"
||
aCC_ChartOfAccountLabel1.ExtraField1 == "Income"
)
{
ACC_JournalDetail eachL1 = new ACC_JournalDetail();
List <ACC_JournalDetail> journalDetailsCurrentYear = ACC_JournalDetailManager.GetAllACC_JournalDetailForTrialBalanceLableWiseL2
(aCC_ChartOfAccountLabel1.ACC_ChartOfAccountLabel1ID, L2, L3, L4,
fromDateCurrentYear,
toDate
);
decimal balance = 0;
foreach (ACC_JournalDetail journalDetail in journalDetailsCurrentYear)
{
balance += journalDetail.Debit - journalDetail.Credit;
}
eachL1.ACC_ChartOfAccountLabel3ID = aCC_ChartOfAccountLabel1.ACC_ChartOfAccountLabel1ID;
eachL1.ACC_ChartOfAccountLabel3Text = aCC_ChartOfAccountLabel1.ChartOfAccountLabel1Text;
eachL1.Debit = ((balance >= 0) ? balance : 0);
eachL1.Credit = ((balance < 0) ? (balance * (-1)) : 0);
financilaStatement.Add(eachL1);
}
}
string html = "<table class='tableBorder' cellpadding='0' cellspacing='0'><tr><td colspan='3'></td><td>Debit</td><td>Credit</td><td></td><td></td></tr>";
html += "<tr><td></td><td>Sales Revenue</td><td colspan='5'></td></tr>";
decimal totalOperating_income = 0;
decimal totalSales_Expence = 0;
decimal totalGross_Profit = 0;
decimal totalOperating_Expenses = 0;
decimal totalOperating_Profit = 0;
decimal totalNon_Operating_income = 0;
decimal totalProfit_Before_Tax = 0;
decimal totalIncome_Tax_Expense = 0;
decimal totalNet_Profit = 0;
foreach (ACC_JournalDetail L1_Journal in financilaStatement)
{
if (L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[0] == "(Operating income")
{
totalOperating_income += (L1_Journal.Debit - L1_Journal.Credit);
html += "<tr><td colspan='2'></td><td><a target='_blank' href='TrialBalancePrint.aspx?L4=0&L1=" + L1_Journal.ACC_ChartOfAccountLabel3ID + "&L2=0&L3=0&WorkStationID=0&FromDate=" + fromDateCurrentYear + "&Date=" + toDate + "'>" + L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Substring(1, L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Length - 1) + "</a></td><td class='rightAlign'>" + L1_Journal.Debit.ToString("0,0.00") + "</td><td class='rightAlign'>" + L1_Journal.Credit.ToString("0,0.00") + "</td><td></td><td></td></tr>";
}
}
foreach (ACC_JournalDetail L1_Journal in financilaStatement)
{
if (L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[0] == "(Sales Expence")
{
totalSales_Expence += (L1_Journal.Debit - L1_Journal.Credit);
html += "<tr><td colspan='2'></td><td><a target='_blank' href='TrialBalancePrint.aspx?L4=0&L1=" + L1_Journal.ACC_ChartOfAccountLabel3ID + "&L2=0&L3=0&WorkStationID=0&FromDate=" + fromDateCurrentYear + "&Date=" + toDate + "'>" + L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Substring(1, L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Length - 1) + "</a></td><td class='rightAlign'>" + L1_Journal.Debit.ToString("0,0.00") + "</td><td class='rightAlign'>" + L1_Journal.Credit.ToString("0,0.00") + "</td><td></td><td></td></tr>";
}
}
totalGross_Profit = ((-1) * totalOperating_income) - totalSales_Expence;
html += "<tr><td style='text-align:right;'>Gross Profit(A)</td><td colspan='4'></td><td>" + totalGross_Profit.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td></td><td>Operating Expenses</td><td colspan='5'></td></tr>";
foreach (ACC_JournalDetail L1_Journal in financilaStatement)
{
if (L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[0] == "(Operating Expence")
{
totalOperating_Expenses += (L1_Journal.Debit - L1_Journal.Credit);
html += "<tr><td colspan='2'></td><td><a target='_blank' href='TrialBalancePrint.aspx?L4=0&L1=" + L1_Journal.ACC_ChartOfAccountLabel3ID + "&L2=0&L3=0&WorkStationID=0&FromDate=" + fromDateCurrentYear + "&Date=" + toDate + "'>" + L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Substring(1, L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Length - 1) + "</a></td><td class='rightAlign'>" + L1_Journal.Debit.ToString("0,0.00") + "</td><td class='rightAlign'>" + L1_Journal.Credit.ToString("0,0.00") + "</td><td></td><td></td></tr>";
}
}
html += "<tr><td colspan='2'></td><td style='text-align:right;'>Total Operating Expenses(B)</td><td colspan='2'></td><td>" + totalOperating_Expenses.ToString("0,0.00") + "</td><td></td></tr>";
totalOperating_Profit = totalGross_Profit - totalOperating_Expenses;
html += "<tr><td style='text-align:right;'>Operating Profit[C=(A-B)]</td><td colspan='5'></td><td>" + totalOperating_Profit.ToString("0,0.00") + "</td></tr>";
html += "<tr><td></td><td>Non-Operating income</td><td colspan='5'></td></tr>";
foreach (ACC_JournalDetail L1_Journal in financilaStatement)
{
if (L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[0] == "(Non-Operating income")
{
totalNon_Operating_income += (L1_Journal.Debit - L1_Journal.Credit);
html += "<tr><td colspan='2'></td><td><a target='_blank' href='TrialBalancePrint.aspx?L4=0&L1=" + L1_Journal.ACC_ChartOfAccountLabel3ID + "&L2=0&L3=0&WorkStationID=0&FromDate=" + fromDateCurrentYear + "&Date=" + toDate + "'>" + L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Substring(1, L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Length - 1) + "</a></td><td class='rightAlign'>" + L1_Journal.Debit.ToString("0,0.00") + "</td><td class='rightAlign'>" + L1_Journal.Credit.ToString("0,0.00") + "</td><td></td><td></td></tr>";
}
}
html += "<tr><td colspan='2'></td><td style='text-align:right;'>Total Non-Operating income(D)</td><td colspan='2'></td><td>" + totalNon_Operating_income.ToString("0,0.00") + "</td><td></td></tr>";
totalProfit_Before_Tax = totalOperating_Profit - totalNon_Operating_income;
html += "<tr><td style='text-align:right;'>Profit Before Tax(C-D)</td><td colspan='5'></td><td>" + totalOperating_Profit.ToString("0,0.00") + "</td></tr>";
foreach (ACC_JournalDetail L1_Journal in financilaStatement)
{
if (L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[0] == "(Income Tax Expence")
{
totalIncome_Tax_Expense += (L1_Journal.Debit - L1_Journal.Credit);
html += "<tr><td colspan='2'></td><td><a target='_blank' href='TrialBalancePrint.aspx?L4=0&L1=" + L1_Journal.ACC_ChartOfAccountLabel3ID + "&L2=0&L3=0&WorkStationID=0&FromDate=" + fromDateCurrentYear + "&Date=" + toDate + "'>" + L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Substring(1, L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Length - 1) + "</a></td><td class='rightAlign'>" + L1_Journal.Debit.ToString("0,0.00") + "</td><td class='rightAlign'>" + L1_Journal.Credit.ToString("0,0.00") + "</td><td>" + totalIncome_Tax_Expense.ToString("0,0.00") + "</td><td></td></tr>";
}
}
totalNet_Profit = totalProfit_Before_Tax - totalIncome_Tax_Expense;
html += "<tr><td style='text-align:right;'>Net Profit </td><td colspan='5'></td><td>" + totalNet_Profit.ToString("0,0.00") + "</td></tr>";
html += "</table>";
lblJournalDetials.Text = html;
}
catch (Exception ex)
{ }
}
protected void btnJournalSubmit_Click(object sender, EventArgs e)
{
List <ACC_HeadType> allACC_HeadType = ACC_HeadTypeManager.GetAllACC_HeadTypes();
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = "1";//Voucher Type
aCC_JournalMaster.ExtraField1 = "";
aCC_JournalMaster.ExtraField2 = "";
aCC_JournalMaster.ExtraField3 = "";
aCC_JournalMaster.Note = "";
aCC_JournalMaster.JournalDate = DateTime.Parse(txtJournalDate.Text);
aCC_JournalMaster.AddedBy = getLogin().LoginID;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = getLogin().LoginID;
aCC_JournalMaster.UpdatedDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
int JournalMasterID = 0;
JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
foreach (GridViewRow gvr in gvACC_ChartOfAccountLabel4.Rows)
{
HiddenField hfChartOfAccountLabel4ID = (HiddenField)gvr.FindControl("hfChartOfAccountLabel4ID");
DropDownList ddlBank = (DropDownList)gvr.FindControl("ddlBanks");
Label lblChartOfAccountLabel4Text = (Label)gvr.FindControl("lblChartOfAccountLabel4Text");
TextBox txtCashSales = (TextBox)gvr.FindControl("txtCashSales");
TextBox txtCardSaleDBBL = (TextBox)gvr.FindControl("txtCardSaleDBBL");
TextBox txtCardSaleCITY = (TextBox)gvr.FindControl("txtCardSaleCITY");
TextBox txtbKash = (TextBox)gvr.FindControl("txtbKash");
TextBox txtBankDepostiedAmount = (TextBox)gvr.FindControl("txtBankDepostiedAmount");
TextBox txtDiscountAmount = (TextBox)gvr.FindControl("txtDiscountAmount");
if (txtCashSales.Text == "0" && txtCardSaleDBBL.Text == "0" && txtCardSaleCITY.Text == "0")
{
continue;
}
try
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail.JournalMasterID = JournalMasterID;
aCC_JournalDetail.ExtraField3 = "";
aCC_JournalDetail.ExtraField2 = "";
aCC_JournalDetail.ExtraField1 = "";
aCC_JournalDetail.AddedBy = getLogin().LoginID;
aCC_JournalDetail.AddedDate = DateTime.Now;
aCC_JournalDetail.UpdatedBy = getLogin().LoginID;
aCC_JournalDetail.UpdatedDate = DateTime.Now;
aCC_JournalDetail.RowStatusID = 1;
aCC_JournalDetail.WorkStation = int.Parse(hfChartOfAccountLabel4ID.Value);
aCC_JournalDetail.WorkStationName = lblChartOfAccountLabel4Text.Text;
//Discount
if (txtDiscountAmount.Text != "0")
{
//discount Expence
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Discount";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 181;
aCC_JournalDetail.Debit = Decimal.Parse(txtDiscountAmount.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
//Sales revinew discount
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Sales revinew discount";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 180;
aCC_JournalDetail.Credit = Decimal.Parse(txtDiscountAmount.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
////Money entry for cash sale
//aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value);
//aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text;
//aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash in Hand";
//aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1;
//aCC_JournalDetail.WorkStation = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID;
//aCC_JournalDetail.WorkStationName = aCC_JournalDetail.ACC_ChartOfAccountLabel4Text;
//aCC_JournalDetail.Debit = Decimal.Parse(txtCashSales.Text);
//aCC_JournalDetail.Credit = Decimal.Parse("0");
//if (txtCashSales.Text !="0")
//ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
//Money entry for bKash Sale
//<option value="1803"> Brac Bank (New Account) A/C (1524-2029-8148-6001)</option>
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 1803;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "Brac Bank A/C (1524-2029-8148-6001)";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3;
aCC_JournalDetail.Debit = Decimal.Parse(txtbKash.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
if (txtbKash.Text != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Money entry for Crard sale CITY
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 823;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "CITY BANK - GentlePark (1401307973001)";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3;
aCC_JournalDetail.Debit = Decimal.Parse(txtCardSaleCITY.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
if (txtCardSaleCITY.Text != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Money entry for Crard sale DBBL
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 828;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "DBBL-126-110-11033";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3;
aCC_JournalDetail.Debit = Decimal.Parse(txtCardSaleDBBL.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
if (txtCardSaleDBBL.Text != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//bKash sales
//<option value="315">bKash Sales ( (Operating income)-Sales Revenue -> Sales Revenue)</option>
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "bKash sales";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 315;
aCC_JournalDetail.Credit = Decimal.Parse(txtbKash.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
if (txtbKash.Text != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Cash Sales DBBL
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Card Sales (DBBL)";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 107;
aCC_JournalDetail.Credit = Decimal.Parse(txtCardSaleDBBL.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
if (txtCardSaleDBBL.Text != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Cash Sales CITY
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Card Sales (CITY)";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 143;
aCC_JournalDetail.Credit = Decimal.Parse(txtCardSaleCITY.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
if (txtCardSaleCITY.Text != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
if (ddlBank.SelectedValue != "0" && txtCashSales.Text != "0")
//if (ddlBank.SelectedValue != "0" && txtBankDepostiedAmount.Text != "0")
{
//Cash Sales
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 829;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "All products";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash Sale";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 106;
aCC_JournalDetail.Credit = Decimal.Parse(txtCashSales.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
////Bank Deposit
//aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value);
//aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text;
//aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash in Hand";
//aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1;
//aCC_JournalDetail.WorkStation = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID;
//aCC_JournalDetail.WorkStationName = aCC_JournalDetail.ACC_ChartOfAccountLabel4Text;
////aCC_JournalDetail.Credit = Decimal.Parse(txtBankDepostiedAmount.Text);
//aCC_JournalDetail.Credit = Decimal.Parse(txtCashSales.Text);
//aCC_JournalDetail.Debit = Decimal.Parse("0");
//ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlBank.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlBank.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3;
//aCC_JournalDetail.Debit = Decimal.Parse(txtBankDepostiedAmount.Text);
aCC_JournalDetail.Debit = Decimal.Parse(txtCashSales.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
}
catch (Exception ex)
{
}
}
hlnkPrintVoucher.Visible = true;
hlnkPrintVoucher.NavigateUrl = "Voucherprint.aspx?JournalMasterID=" + JournalMasterID;
}
protected void btnJournalSubmit_Click(object sender, EventArgs e)
{
List <ACC_HeadType> allACC_HeadType = ACC_HeadTypeManager.GetAllACC_HeadTypes();
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = "4";//Contra
aCC_JournalMaster.ExtraField1 = "";
aCC_JournalMaster.ExtraField2 = "";
aCC_JournalMaster.ExtraField3 = "";
aCC_JournalMaster.Note = "";
aCC_JournalMaster.JournalDate = DateTime.Parse(txtJournalDate.Text);
aCC_JournalMaster.AddedBy = getLogin().LoginID;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = getLogin().LoginID;
aCC_JournalMaster.UpdatedDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
int JournalMasterID = 0;
JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
foreach (GridViewRow gvr in gvACC_ChartOfAccountLabel4.Rows)
{
HiddenField hfChartOfAccountLabel4ID = (HiddenField)gvr.FindControl("hfChartOfAccountLabel4ID");
DropDownList ddlBanks = (DropDownList)gvr.FindControl("ddlBanks");
DropDownList ddlSupplier = (DropDownList)gvr.FindControl("ddlSupplier");
Label lblChartOfAccountLabel4Text = (Label)gvr.FindControl("lblChartOfAccountLabel4Text");
TextBox txtOpiningBalance = (TextBox)gvr.FindControl("txtOpiningBalance");
TextBox txtCheckDate = (TextBox)gvr.FindControl("txtCheckDate");
TextBox txtCashWithdraw = (TextBox)gvr.FindControl("txtCashWithdraw");
TextBox txtSypplyerPayment = (TextBox)gvr.FindControl("txtSypplyerPayment");
TextBox txtCheckNo = (TextBox)gvr.FindControl("txtCheckNo");
TextBox txtFundTransfer = (TextBox)gvr.FindControl("txtFundTransfer");
TextBox txtDiscountIncome = (TextBox)gvr.FindControl("txtDiscountIncome");
try
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail.JournalMasterID = JournalMasterID;
aCC_JournalDetail.ExtraField3 = "";
aCC_JournalDetail.ExtraField2 = "";
aCC_JournalDetail.ExtraField1 = "";
aCC_JournalDetail.AddedBy = getLogin().LoginID;
aCC_JournalDetail.AddedDate = DateTime.Now;
aCC_JournalDetail.UpdatedBy = getLogin().LoginID;
aCC_JournalDetail.UpdatedDate = DateTime.Now;
aCC_JournalDetail.RowStatusID = 1;
aCC_JournalDetail.WorkStation = 1;
aCC_JournalDetail.WorkStationName = "Heand Office";
//For fund transfer To Bank
if (txtFundTransfer.Text != "0" && ddlBanks.SelectedValue != "0")
{
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlBanks.SelectedValue);
}
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlBanks.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3;
aCC_JournalDetail.Debit = Decimal.Parse(txtFundTransfer.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
if (txtFundTransfer.Text != "0" && ddlBanks.SelectedValue != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//For fund transfer From Bank
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text;
aCC_JournalDetail.Credit = Decimal.Parse(txtFundTransfer.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
if (txtFundTransfer.Text != "0" && ddlBanks.SelectedValue != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Cash Withdrawal for Bank
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3;
aCC_JournalDetail.Credit = Decimal.Parse(txtCashWithdraw.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
if (txtCashWithdraw.Text != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Cash Withdrawal for Head OFfcie
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 1;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "Head Office";
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash in hand";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1;
aCC_JournalDetail.Debit = Decimal.Parse(txtCashWithdraw.Text);
aCC_JournalDetail.Credit = 0;
if (txtCashWithdraw.Text != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Supplier Payment for Bank
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash at Bank";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 3;
aCC_JournalDetail.Credit = Decimal.Parse(txtSypplyerPayment.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
if (txtSypplyerPayment.Text != "0" && ddlSupplier.SelectedValue != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Supplier Payment for Suppliyer
if (txtSypplyerPayment.Text != "0" && ddlSupplier.SelectedValue != "0")
{
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlSupplier.SelectedValue);
}
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlSupplier.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Suppliyer payable";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 43;
aCC_JournalDetail.Debit = Decimal.Parse(txtSypplyerPayment.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
if (txtSypplyerPayment.Text != "0" && ddlSupplier.SelectedValue != "0")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Cash discount supplier payable
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlSupplier.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlSupplier.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Suppliyer payable";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 43;
aCC_JournalDetail.Debit = Decimal.Parse(txtDiscountIncome.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
if (txtDiscountIncome.Text != "0" && txtDiscountIncome.Text != "")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
//Cash discount for Income
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlSupplier.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlSupplier.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cash Discount from Supplier";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 211;
aCC_JournalDetail.Credit = Decimal.Parse(txtDiscountIncome.Text);
aCC_JournalDetail.Debit = Decimal.Parse("0");
if (txtDiscountIncome.Text != "0" && txtDiscountIncome.Text != "")
{
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
}
catch (Exception ex)
{
}
}
hlnkPrintVoucher.Visible = true;
hlnkPrintVoucher.NavigateUrl = "Voucherprint.aspx?JournalMasterID=" + JournalMasterID;
}
private void loadData()
{
try
{
ACC_JournalMaster journalMaster = ACC_JournalMasterManager.GetACC_JournalMasterByID(int.Parse(Request.QueryString["JournalMasterID"]));
List <ACC_JournalDetail> journalDetails = ACC_JournalDetailManager.GetAllACC_JournalDetailByJournalMasterID(int.Parse(Request.QueryString["JournalMasterID"]));
string journalDetailsHTML = @"<table id='tblJournalDetails' class='tdBorder' border='0' cellspacing='0' cellpadding='0' style='margin:20px 0;'>
<tr style='font-weight:bold;font-size:15px;'>
<td width='100px'>
Account Code
</td>
<td width='487px'>
Account Title
</td>
<td width='80px'>
Debit
</td>
<td width='80px'>
Credit
</td>
</tr>";
decimal totalDebit = 0;
decimal totalCredit = 0;
trAddress.Visible = false;
trCheck.Visible = false;
bool defaultJournal = false;
switch (journalMaster.JournalMasterName)
{
case "1": //Receipt Voucher
lblVoucherName.Text = "RECEIPT";
lblVoucherType.Text = "RV";
lblReceivedfromOrPayto.Text = "Received from";
trAddress.Visible = true;
trCheck.Visible = true;
//generate table
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit == 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.000000") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.000000") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit != 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.000000") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.000000") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.Credit == 0)
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.000000") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.000000") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalCredit.ToString("0"))) + " taka only.</td></tr></table>";
break;
case "2": //Payment Voucher
lblVoucherName.Text = "PAYMENT";
lblVoucherType.Text = "PV";
lblReceivedfromOrPayto.Text = "Pay To";
trAddress.Visible = true;
trCheck.Visible = true;
//generate table
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit == 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.000000") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.000000") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit != 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.000000") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.000000") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.Debit == 0)
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.000000") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.000000") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalDebit.ToString("0"))) + " taka only.</td></tr></table>";
break;
case "3": //Journal Voucher
lblVoucherName.Text = "JOURNAL";
lblVoucherType.Text = "JV";
defaultJournal = true;
break;
case "4": //Contra Voucher
lblVoucherName.Text = "CONTRA";
lblVoucherType.Text = "CV";
trCheck.Visible = true;
defaultJournal = true;
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.ExtraField3 != "")
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
break;
default:
break;
}
if (defaultJournal)
{
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.000000") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.000000") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
catch (Exception ex) { }
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.000000") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.000000") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalCredit.ToString("0"))) + " taka only.</td></tr></table>";
}
lblOfficeName.Text = journalDetails[0].WorkStationName;
lblJournalMasterID.Text = Request.QueryString["JournalMasterID"];
if (journalMaster.RowStatusID != 1)
{
lblJournalMasterID.BackColor = System.Drawing.Color.Red;
}
lblDate.Text = journalMaster.JournalDate.ToString("dd MMM yyyy");
lblCustomerName.Text = journalMaster.ExtraField1;
lblAddress.Text = journalMaster.ExtraField2;
if (journalMaster.Note.Contains("Inventory Purchase-"))
{
lblExplanation.Text = "<a href='../Inventory/PurchasePrint.aspx?PurchaseID=" + journalMaster.Note.Replace("Inventory Purchase-", "") + "' target='_blank'>" + journalMaster.Note + "</a>";
}
else
{
lblExplanation.Text = journalMaster.Note;
}
}
catch (Exception ex)
{ }
}
private void loadData()
{
try
{
int ACC_ChartOfAccountLabel4ID = Int32.Parse(Request.QueryString["ACC_ChartOfAccountLabel4ID"]);
int ACC_ChartOfAccountLabel3ID = 0;
int ACC_ChartOfAccountLabel2ID = 0;
try { ACC_ChartOfAccountLabel3ID = Int32.Parse(Request.QueryString["ACC_ChartOfAccountLabel3ID"]); }
catch (Exception ex)
{ ACC_ChartOfAccountLabel3ID = 0; }
try { ACC_ChartOfAccountLabel2ID = Int32.Parse(Request.QueryString["ACC_ChartOfAccountLabel2ID"]); }
catch (Exception ex)
{ ACC_ChartOfAccountLabel2ID = 0; }
int WorkStationID = Int32.Parse(Request.QueryString["WorkStationID"]);
string WorkStationIDs = "";
try
{
WorkStationIDs = Request.QueryString["WorkStationIDs"];
}
catch (Exception ex)
{
WorkStationIDs = "";
}
string FromDate = Request.QueryString["FromDate"];
string ToDate = Request.QueryString["ToDate"];
lblDate.Text = "FOR THE PERIOD FROM " + DateTime.Parse(Request.QueryString["FromDate"]).ToString("dd/MM/yyyy") + " TO " + DateTime.Parse(Request.QueryString["ToDate"]).ToString("dd/MM/yyyy") + "";
List <ACC_JournalDetail> journalDetails = new List <ACC_JournalDetail>();
if (ACC_ChartOfAccountLabel2ID != 0)
{
journalDetails = ACC_JournalDetailManager.GetAllACC_JournalDetailForGeneralLedgerByL2
(
ACC_ChartOfAccountLabel4ID,
ACC_ChartOfAccountLabel2ID,
WorkStationID,
FromDate,
ToDate
);
}
else if (WorkStationIDs == "" || WorkStationIDs == null)
{
journalDetails = ACC_JournalDetailManager.GetAllACC_JournalDetailForGeneralLedger
(
ACC_ChartOfAccountLabel4ID,
ACC_ChartOfAccountLabel3ID,
WorkStationID,
FromDate,
ToDate
);
}
else if (WorkStationIDs != "")
{
journalDetails = ACC_JournalDetailManager.GetAllACC_JournalDetailForGeneralLedgerByWorkStationIDs
(
ACC_ChartOfAccountLabel4ID,
ACC_ChartOfAccountLabel3ID,
WorkStationIDs,
FromDate,
ToDate
);
}
try
{
if (ACC_ChartOfAccountLabel3ID != 0)
{
tableAccountTitle.Visible = true;
lblAccountTitle.Text = journalDetails[0].ACC_ChartOfAccountLabel3Text;
lblAccountCode.Text = journalDetails[0].ACC_ChartOfAccountLabel3Code;
lblTitle.Text = "GENERAL LEDGER";
}
else
{
tableAccountTitle.Visible = false;
lblTitle.Text = "Transaction summary";
}
}
catch (Exception ex) { }
string journalDetailsHTML = @"<table width='100%' id='tblJournalDetails' class='tdBorder' border='0' cellspacing='0' cellpadding='0' style='margin:20px 0;'><tr style='font-weight:bold;font-size:15px;'>
<td rowspan='2'>
Date</td>
<td rowspan='2' width='350px'>
Particulars</td>
<td rowspan='2'>
Voucher<br/> No.</td>
<td colspan='4'>
Amount in Taka</td>
</tr>
<tr style='font-weight:bold;font-size:15px;'>
<td>
Debit</td>
<td>
Credit</td>
<td>
Balance</td>
<td>
Dr/Cr</td>
</tr>";
decimal totalDebit = 0;
decimal totalCredit = 0;
decimal totalDebitSubTotal = 0;
decimal totalCreditSubTotal = 0;
int lastJournalMasterID = 0;
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (lastJournalMasterID == 0)
{
lastJournalMasterID = journalDetail.JournalMasterID;
}
else if (lastJournalMasterID != journalDetail.JournalMasterID)
{
journalDetailsHTML += @"<tr>
<td>
</td>
<td style='text-align:right;'>
Sub Total</td>
<td>
</td>
<td style='text-align:right;'>
" + totalDebitSubTotal.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>
" + totalCreditSubTotal.ToString("0,0.00") + @"</td>
<td></td>
<td>
</td>
</tr>";
totalDebitSubTotal = 0;
totalCreditSubTotal = 0;
lastJournalMasterID = journalDetail.JournalMasterID;
}
string voucherName = "";
switch (journalDetail.JournalMasterName)
{
case "1": //Receipt Voucher
voucherName = "RV";
break;
case "2": //Payment Voucher
voucherName = "PV";
break;
case "3": //Journal Voucher
voucherName = "JV";
break;
case "4": //Contra Voucher
voucherName = "CV";
break;
default:
break;
}
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
totalDebitSubTotal += journalDetail.Debit;
totalCreditSubTotal += journalDetail.Credit;
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.JournalDate.ToString("dd MMM yyyy") + @"</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + @"</td>
<td>
<a style='color:blue;text-decoration:underline;' target='_blank' href='Voucherprint.aspx?JournalMasterID=" + journalDetail.JournalMasterID + "'>" + voucherName + "-" + journalDetail.JournalMasterID + @"</a></td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"</td>
<td>
" + (journalDetail.Debit == 0 ? "Cr" : "Dr") + @"</td>
<td style='text-align:right;'>
" + (totalCredit - totalDebit).ToString("0,0.00") + "(" + (totalCredit >= totalDebit?"Cr":"Dr") + ")" + @"</td>
</tr>";
}
journalDetailsHTML += @"<tr>
<td>
</td>
<td style='text-align:right;'>
Sub Total</td>
<td>
</td>
<td style='text-align:right;'>
" + totalDebitSubTotal.ToString("0,0.00") + @"</td>
<td style='text-align:right;'>
" + totalCreditSubTotal.ToString("0,0.00") + @"</td>
<td>
</td>
<td></td>
</tr>";
if (totalCredit >= totalDebit)
{
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td>Total</td><td></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.00") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.00") + "</td><td></td><td style='text-align:right;'>" + (totalCredit - totalDebit).ToString("0,0.00") + "(Cr)</td></tr></table>";
}
else
{
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td>Total</td><td></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.00") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.00") + "</td><td></td><td style='text-align:right;'>" + (totalDebit - totalCredit).ToString("0,0.00") + "(Dr)</td></tr></table>";
}
}
catch (Exception ex)
{ }
}
private void loadData()
{
try
{
ACC_JournalMaster journalMaster = ACC_JournalMasterManager.GetACC_JournalMasterByID(int.Parse(Request.QueryString["JournalMasterID"]));
List <ACC_JournalDetail> journalDetails = ACC_JournalDetailManager.GetAllACC_JournalDetailByJournalMasterID(int.Parse(Request.QueryString["JournalMasterID"]));
string journalDetailsHTML = @"<table id='tblJournalDetails' class='tdBorder' border='0' cellspacing='0' cellpadding='0' style='margin:20px 0;'>
<tr style='font-weight:bold;font-size:15px;'>
<td width='100px'>
Account Code
</td>
<td width='487px'>
Account Title
</td>
<td width='80px'>
Debit
</td>
<td width='80px'>
Credit
</td>
</tr>";
decimal totalDebit = 0;
decimal totalCredit = 0;
trAddress.Visible = false;
trCheck.Visible = false;
bool defaultJournal = false;
switch (journalMaster.JournalMasterName)
{
case "1": //Receipt Voucher
lblVoucherName.Text = "RECEIPT";
lblVoucherType.Text = "RV";
lblReceivedfromOrPayto.Text = "Received from";
trAddress.Visible = true;
trCheck.Visible = true;
//generate table
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit == 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit != 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.Credit == 0)
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.00") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.00") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalCredit.ToString("0"))) + " taka only.</td></tr></table>";
break;
case "2": //Payment Voucher
lblVoucherName.Text = "PAYMENT";
lblVoucherType.Text = "PV";
lblReceivedfromOrPayto.Text = "Pay To";
trAddress.Visible = true;
trCheck.Visible = true;
//generate table
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit == 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
if (journalDetail.Credit != 0)
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
}
catch (Exception ex) { }
}
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.Debit == 0)
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.00") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.00") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalDebit.ToString("0"))) + " taka only.</td></tr></table>";
break;
case "3": //Journal Voucher
lblVoucherName.Text = "JOURNAL";
lblVoucherType.Text = "JV";
defaultJournal = true;
break;
case "4": //Contra Voucher
lblVoucherName.Text = "CONTRA";
lblVoucherType.Text = "CV";
trCheck.Visible = true;
defaultJournal = true;
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
if (journalDetail.ExtraField3 != "")
{
lblChequeDate.Text = journalDetail.ExtraField1;
lblChequeNo.Text = journalDetail.ExtraField3;
try
{
lblChequeBank.Text = journalDetail.ExtraField2.Split(',')[1];
}
catch (Exception ex) { }
try
{
lblChequeBranch.Text = journalDetail.ExtraField2.Split(',')[0];
}
catch (Exception ex) { }
break;
}
}
break;
default:
break;
}
if (defaultJournal)
{
foreach (ACC_JournalDetail journalDetail in journalDetails)
{
try
{
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"
</td>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.ACC_ChartOfAccountLabel4Text + " (" + journalDetail.WorkStationName + @")
</td>
<td style='text-align:right;'>
" + journalDetail.Debit.ToString("0,0.00") + @"
</td>
<td style='text-align:right;'>
" + journalDetail.Credit.ToString("0,0.00") + @"
</td>
</tr>";
totalCredit += journalDetail.Credit;
totalDebit += journalDetail.Debit;
}
catch (Exception ex) { }
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td style='text-align:right;'>" + totalDebit.ToString("0,0.00") + "</td><td style='text-align:right;'>" + totalCredit.ToString("0,0.00") + "</td></tr><tr><td colspan='4'><b>Taka in words:</b> " + NumberToWords(int.Parse(totalCredit.ToString("0"))) + " taka only.</td></tr></table>";
}
lblOfficeName.Text = journalDetails[0].WorkStationName;
lblJournalMasterID.Text = Request.QueryString["JournalMasterID"];
if (journalMaster.RowStatusID != 1)
{
lblJournalMasterID.BackColor = System.Drawing.Color.Red;
}
lblDate.Text = journalMaster.JournalDate.ToString("dd MMM yyyy");
lblCustomerName.Text = journalMaster.ExtraField1;
lblAddress.Text = journalMaster.ExtraField2;
if (journalMaster.Note.Contains("Inventory Purchase-"))
{
lblExplanation.Text = "<a href='../Inventory/PurchasePrint.aspx?PurchaseID=" + journalMaster.Note.Replace("Inventory Purchase-", "") + "' target='_blank'>" + journalMaster.Note + "</a>";
}
else
{
lblExplanation.Text = journalMaster.Note;
}
gvJournal.DataSource = journalDetails;
gvJournal.DataBind();
List <ACC_ChartOfAccountLabel4> aCC_ChartOfAccountLabel4s = new List <ACC_ChartOfAccountLabel4>();
aCC_ChartOfAccountLabel4s = ACC_ChartOfAccountLabel4Manager.GetAllACC_ChartOfAccountLabel4sForJournalEntry();
DataSet ds = CommonManager.SQLExec(
@"
SELECT
ACC_ChartOfAccountLabel3.ChartOfAccountLabel3Text +'('+ ACC_ChartOfAccountLabel2.ChartOfAccountLabel2Text +')('+
ACC_ChartOfAccountLabel1.ChartOfAccountLabel1Text+')' as Head,
ACC_ChartOfAccountLabel3.ACC_ChartOfAccountLabel3ID
FROM ACC_ChartOfAccountLabel1 INNER JOIN
ACC_ChartOfAccountLabel2 ON
ACC_ChartOfAccountLabel1.ACC_ChartOfAccountLabel1ID = ACC_ChartOfAccountLabel2.ACC_ChartOfAccountLabel1ID INNER JOIN
ACC_ChartOfAccountLabel3 ON ACC_ChartOfAccountLabel2.ACC_ChartOfAccountLabel2ID = ACC_ChartOfAccountLabel3.ACC_ChartOfAccountLabel2ID
where ACC_ChartOfAccountLabel3.RowStatusID=1
order by ACC_ChartOfAccountLabel1.ChartOfAccountLabel1Text,ACC_ChartOfAccountLabel2.ChartOfAccountLabel2Text,ACC_ChartOfAccountLabel3.ChartOfAccountLabel3Text
"
);
ddlL4.Items.Clear();
ddlL3.Items.Clear();
ddlWorkStation.Items.Clear();
ddlL4.Items.Add(new ListItem("N/A", "0"));
ddlL3.Items.Add(new ListItem("N/A", "0"));
ddlWorkStation.Items.Add(new ListItem("N/A", "0"));
foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
{
ddlL4.Items.Add(new ListItem(
(
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 9
? "Access(Prod)" :
(
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 10
? "Access (Non-Prod)" :
(
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 2
? "Fabrics" :
(
aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 3
? "Product" : aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString()
)
)
)
)
+ "-" + aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()));
if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1)
{
ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
ddlWorkStation.Items.Add(item);
}
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
ddlL3.Items.Add(new ListItem(dr["Head"].ToString(), dr["ACC_ChartOfAccountLabel3ID"].ToString()));
}
/*
* //List<ACC_ChartOfAccountLabel3> aCC_ChartOfAccountLabel3s = new List<ACC_ChartOfAccountLabel3>();
* //aCC_ChartOfAccountLabel3s = ACC_ChartOfAccountLabel3Manager.GetAllACC_ChartOfAccountLabel3sForJournalEntryForDropDownList();
*
* foreach (GridViewRow gvr in gvJournal.Rows)
* {
* HiddenField hfWorkStationID = (HiddenField)gvr.FindControl("hfWorkStationID");
* HiddenField hfACC_ChartOfAccountLabel4ID = (HiddenField)gvr.FindControl("hfACC_ChartOfAccountLabel4ID");
* HiddenField hfACC_ChartOfAccountLabel3ID = (HiddenField)gvr.FindControl("hfACC_ChartOfAccountLabel3ID");
* DropDownList ddlWorkStation = (DropDownList)gvr.FindControl("ddlWorkStation");
* DropDownList ddlL3 = (DropDownList)gvr.FindControl("ddlL3");
* DropDownList ddlL4 = (DropDownList)gvr.FindControl("ddlL4");
* foreach (ACC_ChartOfAccountLabel4 aCC_ChartOfAccountLabel4 in aCC_ChartOfAccountLabel4s)
* {
* ddlL4.Items.Add(new ListItem(
* (
* aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 9
* ? "Access(Prod)" :
* (
* aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 10
* ? "Access (Non-Prod)" :
* (
* aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 2
* ? "Fabrics" : aCC_ChartOfAccountLabel4.ACC_HeadTypeID.ToString()
* )
* )
* )
+ "-" + aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString()));
+ if (aCC_ChartOfAccountLabel4.ACC_HeadTypeID == 1)
+ {
+ ListItem item = new ListItem(aCC_ChartOfAccountLabel4.ChartOfAccountLabel4Text.ToString(), aCC_ChartOfAccountLabel4.ACC_ChartOfAccountLabel4ID.ToString());
+ ddlWorkStation.Items.Add(item);
+ }
+ }
+ foreach (DataRow dr in ds.Tables[0].Rows)
+ {
+ ddlL3.Items.Add(new ListItem(dr["Head"].ToString(), dr["ACC_ChartOfAccountLabel3ID"].ToString()));
+ }
+
+ ddlL4.SelectedValue = hfACC_ChartOfAccountLabel4ID.Value;
+ ddlL3.SelectedValue = hfACC_ChartOfAccountLabel3ID.Value;
+ ddlWorkStation.SelectedValue = hfWorkStationID.Value;
+ }
*/
}
catch (Exception ex)
{ }
}
private void showACC_JournalDetailGrid()
{
gvACC_JournalDetail.DataSource = ACC_JournalDetailManager.GetAllACC_JournalDetails();
gvACC_JournalDetail.DataBind();
}
private void loadData()
{
try
{
string fromDateCurrentYear = "";
if (Request.QueryString["FromDate"] != null)
{
lblDate.Text = "FOR THE PERIOD FROM " + DateTime.Parse(Request.QueryString["FromDate"]).ToString("dd/MM/yyyy") + " TO " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy") + "";
lblStatement.Text = "BALANCE SHEET";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["FromDate"]).ToString("yyyy-MM-dd") + " 12:00:00 AM";
}
else
{
lblDate.Text = "AS ON " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy");
lblStatement.Text = "BALANCE SHEET";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-") + "01-01 12:00:00 AM";
}
string toDate = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-MM-dd") + " 11:59:59 PM";
int L1 = 0;
int L2 = 0;
int L3 = 0;
int L4 = 0;
L1 = 11;
List <ACC_JournalDetail> financilaStatement = new List <ACC_JournalDetail>();
List <ACC_ChartOfAccountLabel1> aCC_ChartOfAccountLabel1s = new List <ACC_ChartOfAccountLabel1>();
aCC_ChartOfAccountLabel1s = ACC_ChartOfAccountLabel1Manager.GetAllACC_ChartOfAccountLabel1s().FindAll(x => x.RowStatusID == 1);
foreach (ACC_ChartOfAccountLabel1 aCC_ChartOfAccountLabel1 in aCC_ChartOfAccountLabel1s)
{
if (aCC_ChartOfAccountLabel1.ExtraField1 == "Asset"
||
aCC_ChartOfAccountLabel1.ExtraField1 == "Liability & Equity"
)
{
ACC_JournalDetail eachL1 = new ACC_JournalDetail();
List <ACC_JournalDetail> journalDetailsCurrentYear = ACC_JournalDetailManager.GetAllACC_JournalDetailForTrialBalanceLableWiseL2
(aCC_ChartOfAccountLabel1.ACC_ChartOfAccountLabel1ID, L2, L3, L4,
fromDateCurrentYear,
toDate
);
decimal balance = 0;
foreach (ACC_JournalDetail journalDetail in journalDetailsCurrentYear)
{
balance += journalDetail.Debit - journalDetail.Credit;
}
eachL1.ACC_ChartOfAccountLabel3ID = aCC_ChartOfAccountLabel1.ACC_ChartOfAccountLabel1ID;
eachL1.ACC_ChartOfAccountLabel3Text = aCC_ChartOfAccountLabel1.ChartOfAccountLabel1Text;
eachL1.Debit = ((balance >= 0) ? balance : 0);
eachL1.Credit = ((balance < 0) ? (balance * (-1)) : 0);
financilaStatement.Add(eachL1);
}
}
string html = "<table class='tableBorder' cellpadding='0' cellspacing='0'><tr><td colspan='3'></td><td>Debit</td><td>Credit</td><td></td><td></td></tr>";
html += "<tr><td>Assets:</td><td colspan='6'></td></tr>";
html += "<tr><td></td><td>Current Asset</td><td colspan='5'></td></tr>";
decimal totalAsset = 0;
decimal totalLiability_Equity = 0;
decimal totalLiability = 0;
decimal totalEquity = 0;
decimal totalAssetCurrent_Asset = 0;
decimal totalAssetNon_Current_Asset = 0;
decimal totalLiability_Equity_Current_Liabilities = 0;
decimal totalLiability_Equity_Non_Current_Liabilities = 0;
decimal totalLiability_Equity_Reserves = 0;
decimal totalLiability_Equity_Share_Capital = 0;
bool isPrintedAssetNon_Current_Asset = false;
bool isPrintedLiability_Equity_Current_Liabilities = false;
bool isPrintedLiability_Equity_Non_Current_Liabilities = false;
bool isPrintedLiability_Equity_Reserves = false;
bool isPrintedLiability_Equity_Share_Capital = false;
foreach (ACC_JournalDetail L1_Journal in financilaStatement)
{
switch (L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[0])
{
case "(Current Asset":
totalAsset += (L1_Journal.Debit - L1_Journal.Credit);
totalAssetCurrent_Asset += (L1_Journal.Debit - L1_Journal.Credit);
break;
case "(Non-Current Asset":
if (!isPrintedAssetNon_Current_Asset)
{
html += "<tr><td colspan='2' style='text-align:right;'>Total Current Asset(A):</td><td colspan='3'></td><td>" + totalAssetCurrent_Asset.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td></td><td>Non-Current Asset</td><td colspan='5'></td></tr>";
isPrintedAssetNon_Current_Asset = true;
}
totalAsset += (L1_Journal.Debit - L1_Journal.Credit);
totalAssetNon_Current_Asset += (L1_Journal.Debit - L1_Journal.Credit);
break;
case "(Current Liabilities":
if (!isPrintedLiability_Equity_Current_Liabilities)
{
html += "<tr><td colspan='2' style='text-align:right;'>Total Non-Current Asset(B):</td><td colspan='3'></td><td>" + totalAssetNon_Current_Asset.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td colspan='1' style='text-align:right;'>Total Asset(A+B):</td><td colspan='5'></td><td>" + totalAsset.ToString("0,0.00") + "</td></tr>";
html += "<tr><td colspan='7'></td></tr>";
html += "<tr><td>Liability & Shareholders' Equity:</td><td colspan='6'></td></tr>";
html += "<tr><td> Liabilities:</td><td colspan='6'></td></tr>";
html += "<tr><td></td><td>Current Liabilities</td><td colspan='5'></td></tr>";
isPrintedLiability_Equity_Current_Liabilities = true;
}
totalLiability_Equity += (L1_Journal.Credit - L1_Journal.Debit);
totalLiability += (L1_Journal.Credit - L1_Journal.Debit);
totalLiability_Equity_Current_Liabilities += (L1_Journal.Credit - L1_Journal.Debit);
break;
case "(Non-Current Liabilities":
if (!isPrintedLiability_Equity_Non_Current_Liabilities)
{
html += "<tr><td></td><td colspan='2' style='text-align:right;'>Total Current Liabilities(i):</td><td colspan='2'></td><td>" + totalLiability_Equity_Current_Liabilities.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td></td><td>Non-Current Liabilities</td><td colspan='5'></td></tr>";
isPrintedLiability_Equity_Non_Current_Liabilities = true;
}
totalLiability_Equity += (L1_Journal.Credit - L1_Journal.Debit);
totalLiability += (L1_Journal.Credit - L1_Journal.Debit);
totalLiability_Equity_Non_Current_Liabilities += (L1_Journal.Credit - L1_Journal.Debit);
break;
case "(Reserves":
if (!isPrintedLiability_Equity_Reserves)
{
html += "<tr><td></td><td colspan='2' style='text-align:right;'>Total Non-Current Liabilities(ii):</td><td colspan='2'></td><td>" + totalLiability_Equity_Non_Current_Liabilities.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td></td><td colspan='2' style='text-align:right;'>Total Liabilities[C=(i + ii)]:</td><td colspan='2'></td><td>" + totalLiability.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td> Shareholders' Equity:</td><td colspan='6'></td></tr>";
html += "<tr><td></td><td>Reserves</td><td colspan='5'></td></tr>";
isPrintedLiability_Equity_Reserves = true;
}
totalLiability_Equity += (L1_Journal.Credit - L1_Journal.Debit);
totalEquity += (L1_Journal.Credit - L1_Journal.Debit);
totalLiability_Equity_Reserves += (L1_Journal.Credit - L1_Journal.Debit);
break;
case "(Share Capital":
if (!isPrintedLiability_Equity_Share_Capital)
{
html += "<tr><td></td><td colspan='2' style='text-align:right;'>Total Reserves(iii):</td><td colspan='2'></td><td>" + totalLiability_Equity_Reserves.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td></td><td>Non-Current Liabilities</td><td colspan='5'></td></tr>";
isPrintedLiability_Equity_Share_Capital = true;
}
totalLiability_Equity += (L1_Journal.Credit - L1_Journal.Debit);
totalEquity += (L1_Journal.Credit - L1_Journal.Debit);
totalLiability_Equity_Share_Capital += (L1_Journal.Credit - L1_Journal.Debit);
break;
default:
break;
}
html += "<tr><td colspan='2'></td><td><a target='_blank' href='TrialBalancePrint.aspx?L4=0&L1=" + L1_Journal.ACC_ChartOfAccountLabel3ID + "&L2=0&L3=0&WorkStationID=0&FromDate=" + fromDateCurrentYear + "&Date=" + toDate + "'>" + L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Substring(1, L1_Journal.ACC_ChartOfAccountLabel3Text.Split(')')[1].Length - 1) + "</a></td><td class='rightAlign'>" + L1_Journal.Debit.ToString("0,0.00") + "</td><td class='rightAlign'>" + L1_Journal.Credit.ToString("0,0.00") + "</td><td colspan='2'></td></tr>";
}
html += "<tr><td></td><td colspan='2' style='text-align:right;'>Total Share Capital(iv):</td><td colspan='2'></td><td>" + totalLiability_Equity_Share_Capital.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td></td><td colspan='2' style='text-align:right;'>Total Shareholders' Equity[D=(iii + iv)]:</td><td colspan='2'></td><td>" + totalEquity.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td></td><td colspan='2' style='text-align:right;'>Total Liability & Shareholders' Equity(C+D):</td><td colspan='3'></td><td>" + totalLiability_Equity.ToString("0,0.00") + "</td></tr>";
decimal netProfit_amount = netProfit();
html += "<tr><td><a href='IncomeStatementPrint.aspx?Date=" + Request.QueryString["Date"] + @"' target='_blank'>Net Profit (E)</a></td><td colspan='4'></td><td>" + netProfit_amount.ToString("0,0.00") + "</td><td></td></tr>";
html += "<tr><td></td><td colspan='2' style='text-align:right;'>Total Liability & Shareholders' Equity with Net-Profit (C+D+E):</td><td colspan='3'></td><td>" + (netProfit_amount + totalLiability_Equity).ToString("0,0.00") + "</td></tr>";
html += "</table>";
lblJournalDetials.Text = html;
}
catch (Exception ex)
{ }
}
private void loadData()
{
try
{
string fromDateCurrentYear = "";
if (Request.QueryString["FromDate"] != null)
{
lblDate.Text = "FOR THE PERIOD FROM " + DateTime.Parse(Request.QueryString["FromDate"]).ToString("dd/MM/yyyy") + " TO " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy") + "";
lblStatement.Text = "TRANSACTION SUMMARY";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["FromDate"]).ToString("yyyy-MM-dd") + " 12:00:00 AM";
}
else
{
lblDate.Text = "AS ON " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy");
lblStatement.Text = "TRIAL BALANCE";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-") + "01-01 12:00:00 AM";
}
string toDate = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-MM-dd") + " 11:59:59 PM";
List <ACC_JournalDetail> journalDetailsCurrentYear = ACC_JournalDetailManager.GetAllACC_JournalDetailForTrialBalance
(
fromDateCurrentYear,
toDate
);
string journalDetailsHTML = @"<table width='100%' id='tblJournalDetails' class='tdBorder' border='0' cellspacing='0' cellpadding='0' style='margin:20px 0;'><tr style='font-weight:bold;font-size:15px;'>
<tr style='font-weight:bold;font-size:15px;'>
<td rowspan='2'>
Account<br/>Code</td>
<td rowspan='2'>
Head of Accounts</td>
<td colspan='2'>
Amount</td>
</tr>
<tr style='font-weight:bold;font-size:15px;'>
<td>
Debit</td>
<td>
Credit</td>
</tr>
";
decimal currentYearDebit = 0;
decimal currentYearCredit = 0;
foreach (ACC_JournalDetail journalDetail in journalDetailsCurrentYear)
{
currentYearDebit += journalDetail.Debit;
currentYearCredit += journalDetail.Credit;
journalDetailsHTML += @"<tr>
<td>
" + journalDetail.ACC_ChartOfAccountLabel3Code + @"</td>
<td>
<a target='_blank' href='GeneralLedgerPrint.aspx?ACC_ChartOfAccountLabel4ID=0&ACC_ChartOfAccountLabel3ID=" + journalDetail.ACC_ChartOfAccountLabel3ID
+ "&WorkStationID=" + journalDetail.WorkStation
+ "&FromDate=" + fromDateCurrentYear
+ "&ToDate=" + toDate + @"'>" + journalDetail.ACC_ChartOfAccountLabel3Text + " - " + journalDetail.WorkStationName + @"</a> </td>
";
journalDetailsHTML += @"<td>
" + journalDetail.Debit.ToString("0.00") + @"</td>
<td>
" + journalDetail.Credit.ToString("0.00") + @"</td>
</tr>";
}
lblJournalDetials.Text = journalDetailsHTML + "<tr><td></td><td><b>Total:</b></td><td>" + currentYearDebit.ToString("0.00") + @"</td><td>" + currentYearCredit.ToString("0.00") + @"</td></tr></table>";
}
catch (Exception ex)
{ }
}
protected void btnJournalSubmit_Click(object sender, EventArgs e)
{
List<ACC_HeadType> allACC_HeadType= ACC_HeadTypeManager.GetAllACC_HeadTypes();
foreach (GridViewRow gvr in gvACC_ChartOfAccountLabel3.Rows)
{
HiddenField hfChartOfAccountLabel3ID = (HiddenField)gvr.FindControl("hfChartOfAccountLabel3ID");
//DropDownList ddlACC_ChartOfAccountLabel4 = (DropDownList)gvr.FindControl("ddlACC_ChartOfAccountLabel4");
Label lblChartOfAccountLabel3Text = (Label)gvr.FindControl("lblChartOfAccountLabel3Text");
Label lblJournalMasterID = (Label)gvr.FindControl("lblJournalMasterID");
TextBox txtAmount = (TextBox)gvr.FindControl("txtAmount");
TextBox txtPayto = (TextBox)gvr.FindControl("txtPayto");
TextBox txtAddress = (TextBox)gvr.FindControl("txtAddress");
TextBox txtNote = (TextBox)gvr.FindControl("txtNote");
TextBox txtCheckDate = (TextBox)gvr.FindControl("txtCheckDate");
TextBox txtCheckNo = (TextBox)gvr.FindControl("txtCheckNo");
TextBox txtBank = (TextBox)gvr.FindControl("txtBank");
if (txtAmount.Text == "0")
{
continue;
}
try
{
ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster();
aCC_JournalMaster.JournalMasterName = "2";//Voucher Type
aCC_JournalMaster.ExtraField1 = txtPayto.Text;
aCC_JournalMaster.ExtraField2 = txtAddress.Text;
aCC_JournalMaster.ExtraField3 = "";
aCC_JournalMaster.Note = txtNote.Text;
aCC_JournalMaster.JournalDate = DateTime.Parse(txtJournalDate.Text);
aCC_JournalMaster.AddedBy = getLogin().LoginID;
aCC_JournalMaster.AddedDate = DateTime.Now;
aCC_JournalMaster.UpdatedBy = getLogin().LoginID;
aCC_JournalMaster.UpdatedDate = DateTime.Now;
aCC_JournalMaster.RowStatusID = 1;
int JournalMasterID = 0;
JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster);
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail.JournalMasterID = JournalMasterID;
//if(ddlACC_ChartOfAccountLabel4.SelectedValue != "0")
//{
// aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlACC_ChartOfAccountLabel4.SelectedValue);
// aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlACC_ChartOfAccountLabel4.SelectedItem.Text;
//}
//else
//{
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 0;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "N/A";
//}
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = lblChartOfAccountLabel3Text.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = Int32.Parse(hfChartOfAccountLabel3ID.Value);
string workStationText = "";
foreach (ACC_HeadType item in allACC_HeadType)
{
if (item.ACC_HeadTypeID == 1)
{
workStationText = item.HeadTypeName;
break;
}
}
//if (ddlACC_ChartOfAccountLabel4.SelectedItem.Text.Contains(workStationText))
//{
// aCC_JournalDetail.WorkStation = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID;
// aCC_JournalDetail.WorkStationName = aCC_JournalDetail.ACC_ChartOfAccountLabel4Text;
//}
//else
//{
aCC_JournalDetail.WorkStation = 1;
aCC_JournalDetail.WorkStationName = "Head Office";
//}
aCC_JournalDetail.Debit = Decimal.Parse(txtAmount.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
aCC_JournalDetail.ExtraField3 = "";
aCC_JournalDetail.ExtraField2 = "";
aCC_JournalDetail.ExtraField1 = "";
aCC_JournalDetail.AddedBy = getLogin().LoginID;
aCC_JournalDetail.AddedDate = DateTime.Now;
aCC_JournalDetail.UpdatedBy = getLogin().LoginID;
aCC_JournalDetail.UpdatedDate = DateTime.Now;
aCC_JournalDetail.RowStatusID = 1;
//For Debit part
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
//For Money Entry
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text ="";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = int.Parse(ddlBalance.SelectedValue.Split('@')[0]);
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = int.Parse(ddlBalance.SelectedValue.Split('@')[1]);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "";
aCC_JournalDetail.Debit = 0;
aCC_JournalDetail.Credit = Decimal.Parse(txtAmount.Text);
aCC_JournalDetail.WorkStation = 1;
aCC_JournalDetail.WorkStationName = "Head Office";
aCC_JournalDetail.ExtraField3 = txtCheckNo.Text;
aCC_JournalDetail.ExtraField2 = txtBank.Text;
aCC_JournalDetail.ExtraField1 = txtCheckDate.Text;
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
lblJournalMasterID.Text = "<a href='Voucherprint.aspx?JournalMasterID=" + JournalMasterID.ToString() + "' target='_blank'>PV # " + JournalMasterID.ToString() + "</a>";
//showAlartMessage("Successfully Done.");
}
catch (Exception ex)
{
lblJournalMasterID.Text = "<span style='color:red;'>Error !!</span>";
//showAlartMessage("Error occured");
}
}
}
private decimal loadData(string L1, int L2, int L3, string workStationID)
{
try
{
string fromDateCurrentYear = "";
if (Request.QueryString["FromDate"] != null)
{
lblDate.Text = "FOR THE PERIOD FROM " + DateTime.Parse(Request.QueryString["FromDate"]).ToString("dd/MM/yyyy") + " TO " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy") + "";
lblStatement.Text = "SHOW ROOM TRANSACTION SUMMARY";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["FromDate"]).ToString("yyyy-MM-dd") + " 12:00:00 AM";
}
else
{
lblDate.Text = "AS ON " + DateTime.Parse(Request.QueryString["Date"]).ToString("dd/MM/yyyy");
lblStatement.Text = "TRIAL BALANCE";
fromDateCurrentYear = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-") + "01-01 12:00:00 AM";
}
lblDate.Text += "<br/>" + Request.QueryString["ShowRoomName"];
string toDate = DateTime.Parse(Request.QueryString["Date"]).ToString("yyyy-MM-dd") + " 11:59:59 PM";
int L4 = 0;
try
{
L4 = Int32.Parse(Request.QueryString["L4"]);
}
catch (Exception ex)
{ }
List <ACC_JournalDetail> journalDetailsCurrentYear = ACC_JournalDetailManager.GetAllACC_JournalDetailForTrialBalanceLableWiseWithWorkStationIDShowRoom
(L1, L2, L3, L4, workStationID,
fromDateCurrentYear, Request.QueryString["JournalMasterName"],
toDate
);
string journalDetailsHTML = @"<table width='100%' class='tblJournalDetails' class='tdBorder' border='0' cellspacing='0' cellpadding='0' style='margin:20px 0;'><tr style='font-weight:bold;font-size:15px;'>
<tr style='font-weight:bold;font-size:15px;'>
<td>
" + (lblJournalDetials.Text == "" ? "Income" : "Expence") + @"</td>
<td>
Amount</td>
</tr>
";
decimal currentYearDebit = 0;
decimal currentYearCredit = 0;
decimal balance = 0;
decimal balance_Total = 0;
decimal balanceFinal = 0;
foreach (ACC_JournalDetail journalDetail in journalDetailsCurrentYear)
{
balance = journalDetail.Debit - journalDetail.Credit;
if (balance >= 0)
{
journalDetail.Debit = balance;
journalDetail.Credit = 0;
}
else
{
journalDetail.Credit = balance * (-1);
journalDetail.Debit = 0;
}
//if (!journalDetail.ACC_ChartOfAccountLabel3Text.Contains("Sales Revenue"))
//{
currentYearDebit += journalDetail.Debit;
currentYearCredit += journalDetail.Credit;
//}
balanceFinal += journalDetail.Debit - journalDetail.Credit;
balance_Total += balance < 0?((-1) * balance):balance;
journalDetailsHTML += @"<tr>
<td style='width:577px;'>
<a target='_blank' href='GeneralLedgerPrint.aspx?ACC_ChartOfAccountLabel4ID=" + L4.ToString() + @"&ACC_ChartOfAccountLabel3ID=" + journalDetail.ACC_ChartOfAccountLabel3ID
+ "&WorkStationID=0&&WorkStationIDs=" + workStationID + @"&FromDate=" + fromDateCurrentYear
+ "&ToDate=" + toDate + @"'>" + journalDetail.ACC_ChartOfAccountLabel3Text + @"</a> </td>
";
journalDetailsHTML += @"<td style='text-align:right;'>
" + (journalDetail.Debit == 0 ? journalDetail.Credit : journalDetail.Debit).ToString("0,0.00") + @"</td>
</tr>";
}
//balance = currentYearDebit - currentYearCredit;
lblJournalDetials.Text += journalDetailsHTML + "<tr><td style='width:577px;'><b>Total:</b></td><td style='text-align:right;'>" + (balance_Total > 0 ? balance_Total : ((-1) * balance_Total)).ToString("0,0.00") + @"</td></tr></table>";
return(balance_Total > 0 ? balance_Total : ((-1) * balance_Total));
}
catch (Exception ex)
{ return(0); }
}
