public static ACC_JournalDetail GetACC_JournalDetailByID(int id)
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
SqlACC_JournalDetailProvider sqlACC_JournalDetailProvider = new SqlACC_JournalDetailProvider();
aCC_JournalDetail = sqlACC_JournalDetailProvider.GetACC_JournalDetailByID(id);
return aCC_JournalDetail;
}
public bool UpdateACC_JournalDetail(ACC_JournalDetail aCC_JournalDetail)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateACC_JournalDetail", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ACC_JournalDetailID", SqlDbType.Int).Value = aCC_JournalDetail.ACC_JournalDetailID;
cmd.Parameters.Add("@JournalMasterID", SqlDbType.Int).Value = aCC_JournalDetail.JournalMasterID;
cmd.Parameters.Add("@ACC_ChartOfAccountLabel4ID", SqlDbType.Int).Value = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID;
cmd.Parameters.Add("@ACC_ChartOfAccountLabel3ID", SqlDbType.Int).Value = aCC_JournalDetail.ACC_ChartOfAccountLabel3ID;
cmd.Parameters.Add("@WorkStation", SqlDbType.Int).Value = aCC_JournalDetail.WorkStation;
cmd.Parameters.Add("@Debit", SqlDbType.Decimal).Value = aCC_JournalDetail.Debit;
cmd.Parameters.Add("@Credit", SqlDbType.Decimal).Value = aCC_JournalDetail.Credit;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = aCC_JournalDetail.ExtraField3;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = aCC_JournalDetail.ExtraField2;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = aCC_JournalDetail.ExtraField1;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = aCC_JournalDetail.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = aCC_JournalDetail.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = aCC_JournalDetail.UpdatedBy;
cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = aCC_JournalDetail.UpdatedDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_JournalDetail.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
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 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");
}
public static ACC_JournalDetail GetACC_JournalDetailByID(int id)
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
SqlACC_JournalDetailProvider sqlACC_JournalDetailProvider = new SqlACC_JournalDetailProvider();
aCC_JournalDetail = sqlACC_JournalDetailProvider.GetACC_JournalDetailByID(id);
return(aCC_JournalDetail);
}
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");
}
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 List <ACC_JournalDetail> loadFromGrid()
{
List <ACC_JournalDetail> aCC_JournalDetails = new List <ACC_JournalDetail>();
int i = 0;
foreach (GridViewRow gvr in gvACC_JournalDetail.Rows)
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail.ACC_JournalDetailID = int.Parse(((HiddenField)gvr.FindControl("hfACC_JournalDetailID")).Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ((Label)gvr.FindControl("lblACC_ChartOfAccountLabel4ID")).Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(((HiddenField)gvr.FindControl("hfACC_ChartOfAccountLabel4ID")).Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = ((Label)gvr.FindControl("lblACC_ChartOfAccountLabel3ID")).Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = Int32.Parse(((HiddenField)gvr.FindControl("hfACC_ChartOfAccountLabel3ID")).Value);
aCC_JournalDetail.WorkStation = Int32.Parse(((HiddenField)gvr.FindControl("hfWorkStation")).Value);
aCC_JournalDetail.WorkStationName = ((Label)gvr.FindControl("lblWorkStation")).Text;;
aCC_JournalDetail.Debit = Decimal.Parse(((Label)gvr.FindControl("lblDebit")).Text);
aCC_JournalDetail.Credit = Decimal.Parse(((Label)gvr.FindControl("lblCredit")).Text);
aCC_JournalDetail.ExtraField3 = "";
aCC_JournalDetail.ExtraField2 = "";
aCC_JournalDetail.ExtraField1 = ((HiddenField)gvr.FindControl("hfExtraField1")).Value;
aCC_JournalDetail.ExtraField2 = ((HiddenField)gvr.FindControl("hfExtraField2")).Value;
aCC_JournalDetail.ExtraField3 = ((HiddenField)gvr.FindControl("hfExtraField3")).Value;
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_JournalDetails.Add(aCC_JournalDetail);
}
return(aCC_JournalDetails);
}
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 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 = "2";//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 ddlSupplier = (DropDownList)gvr.FindControl("ddlSupplier");
Label lblChartOfAccountLabel4Text = (Label)gvr.FindControl("lblChartOfAccountLabel4Text");
TextBox txtOpiningBalance = (TextBox)gvr.FindControl("txtOpiningBalance");
TextBox txtSypplyerPayment = (TextBox)gvr.FindControl("txtSypplyerPayment");
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";
//Supplier Payment for Cash in hand
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(hfChartOfAccountLabel4ID.Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = lblChartOfAccountLabel4Text.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Cahs in Hand";
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1;
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 != "" && ddlSupplier.SelectedValue != "0")
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 != "" && ddlSupplier.SelectedValue != "0")
ACC_JournalDetailManager.InsertACC_JournalDetail(aCC_JournalDetail);
}
catch (Exception ex)
{
}
}
hlnkPrintVoucher.Visible = true;
hlnkPrintVoucher.NavigateUrl = "Voucherprint.aspx?JournalMasterID=" + JournalMasterID;
}
public static int InsertACC_JournalDetailTmp(ACC_JournalDetail aCC_JournalDetail)
{
SqlACC_JournalDetailProvider sqlACC_JournalDetailProvider = new SqlACC_JournalDetailProvider();
return sqlACC_JournalDetailProvider.InsertACC_JournalDetailTmp(aCC_JournalDetail);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (ddlACC_ChartOfAccountLabel3.SelectedValue != "0" &&
((ddlACC_ChartOfAccountLabel4.Items.Count != 0 && ddlACC_ChartOfAccountLabel4.SelectedValue != "0") ||
(ddlACC_ChartOfAccountLabel4.Items.Count == 0)) &&
(ddlWorkSatation.SelectedValue != "0" || rbtnHeadType.SelectedItem.Text == "Work Station") &&
txtAmount.Text != "" && decimal.Parse(txtAmount.Text) != 0 &&
(Request.QueryString["Type"] == "1" || Request.QueryString["Type"] == "2" || rbtnDebitOrCredit.SelectedItem.Text == "Credit" || rbtnDebitOrCredit.SelectedItem.Text == "Debit")
)
{
List <ACC_JournalDetail> aCC_JournalDetails = new List <ACC_JournalDetail>();
aCC_JournalDetails = loadFromGrid();
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail.JournalMasterID = aCC_JournalDetails.Count;
try
{
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlACC_ChartOfAccountLabel4.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlACC_ChartOfAccountLabel4.SelectedItem.Text;
}
catch (Exception ex)
{
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 0;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "N/A";
}
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = ddlACC_ChartOfAccountLabel3.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = Int32.Parse(ddlACC_ChartOfAccountLabel3.SelectedValue);
try
{
if (ddlACC_ChartOfAccountLabel4.Items[0].Text.Contains("Work Station"))
{
ddlWorkSatation.SelectedValue = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID.ToString();
}
aCC_JournalDetail.WorkStation = int.Parse(ddlWorkSatation.SelectedValue);
aCC_JournalDetail.WorkStationName = ddlWorkSatation.SelectedItem.Text;
}
catch (Exception ex)
{
aCC_JournalDetail.WorkStation = 0;
aCC_JournalDetail.WorkStationName = "N/A";
}
if (rbtnDebitOrCredit.SelectedItem.Text == "Credit")
{
aCC_JournalDetail.Debit = Decimal.Parse("0");
aCC_JournalDetail.Credit = Decimal.Parse(txtAmount.Text);
}
else
{
aCC_JournalDetail.Debit = Decimal.Parse(txtAmount.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
}
aCC_JournalDetail.ExtraField3 = txtChequeNo.Text;
aCC_JournalDetail.ExtraField2 = txtBankNBranchDetails.Text;
aCC_JournalDetail.ExtraField1 = txtChequeDate.Text;
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_JournalDetails.Add(aCC_JournalDetail);
if (Request.QueryString["Tmp"] != null)
{
aCC_JournalDetail = new ACC_JournalDetail();
try
{
aCC_JournalDetail.WorkStation = int.Parse(ddlWorkSatation.SelectedValue);
aCC_JournalDetail.WorkStationName = ddlWorkSatation.SelectedItem.Text;
}
catch (Exception ex)
{
aCC_JournalDetail.WorkStation = 0;
aCC_JournalDetail.WorkStationName = "N/A";
}
aCC_JournalDetail.ExtraField3 = txtChequeNo.Text;
aCC_JournalDetail.ExtraField2 = txtBankNBranchDetails.Text;
aCC_JournalDetail.ExtraField1 = txtChequeDate.Text;
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.ACC_ChartOfAccountLabel4ID = int.Parse(ddlWorkSatation.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlWorkSatation.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Petty Cash in Hand";
aCC_JournalDetail.Debit = 0;
aCC_JournalDetail.Credit = Decimal.Parse(txtAmount.Text);
aCC_JournalDetails.Add(aCC_JournalDetail);
}
BindJournalGrid(aCC_JournalDetails);
cleanData();
trWorkStation.Visible = false;
}
else
{
showAlartMessage("Please check the Data carefully");
}
}
public static bool UpdateACC_JournalDetail(ACC_JournalDetail aCC_JournalDetail)
{
SqlACC_JournalDetailProvider sqlACC_JournalDetailProvider = new SqlACC_JournalDetailProvider();
return sqlACC_JournalDetailProvider.UpdateACC_JournalDetail(aCC_JournalDetail);
}
public ACC_JournalDetail GetACC_JournalDetailFromReader(IDataReader reader)
{
try
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
try
{ aCC_JournalDetail.ACC_JournalDetailID = DataAccessObject.IsNULL <int>(reader["ACC_JournalDetailID"]); }
catch (Exception ex) { aCC_JournalDetail.ACC_JournalDetailID = 0; } try
{ aCC_JournalDetail.JournalMasterID = DataAccessObject.IsNULL <int>(reader["JournalMasterID"]); }
catch (Exception ex) { aCC_JournalDetail.JournalMasterID = 0; } try
{ aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = DataAccessObject.IsNULL <int>(reader["ACC_ChartOfAccountLabel4ID"]); }
catch (Exception ex) { aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 0; } try
{ aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = DataAccessObject.IsNULL <int>(reader["ACC_ChartOfAccountLabel3ID"]); }
catch (Exception ex) { aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 0; } try
{ aCC_JournalDetail.WorkStation = DataAccessObject.IsNULL <int>(reader["WorkStation"]); }
catch (Exception ex) { aCC_JournalDetail.WorkStation = 0; } try
{
aCC_JournalDetail.Debit = DataAccessObject.IsNULL <decimal>(reader["Debit"]);
}
catch (Exception ex) { aCC_JournalDetail.Debit = 0; } try
{
aCC_JournalDetail.Credit = DataAccessObject.IsNULL <decimal>(reader["Credit"]);
}
catch (Exception ex) { aCC_JournalDetail.Credit = 0; } try
{
aCC_JournalDetail.ExtraField3 = DataAccessObject.IsNULL <string>(reader["ExtraField3"].ToString());
}
catch (Exception ex) { aCC_JournalDetail.ExtraField3 = ""; } try
{
aCC_JournalDetail.ExtraField2 = DataAccessObject.IsNULL <string>(reader["ExtraField2"].ToString());
}
catch (Exception ex) { aCC_JournalDetail.ExtraField2 = ""; } try
{
aCC_JournalDetail.ExtraField1 = DataAccessObject.IsNULL <string>(reader["ExtraField1"].ToString());
}
catch (Exception ex) { aCC_JournalDetail.ExtraField1 = ""; } try
{
aCC_JournalDetail.AddedBy = DataAccessObject.IsNULL <int>(reader["AddedBy"]);
}
catch (Exception ex) { aCC_JournalDetail.AddedBy = 0; } try
{
aCC_JournalDetail.AddedDate = DataAccessObject.IsNULL <DateTime>(reader["AddedDate"]);
}
catch (Exception ex) { aCC_JournalDetail.AddedDate = DateTime.Today;; } try
{ aCC_JournalDetail.UpdatedBy = DataAccessObject.IsNULL <int>(reader["UpdatedBy"]); }
catch (Exception ex) { aCC_JournalDetail.UpdatedBy = 0; } try
{
aCC_JournalDetail.UpdatedDate = DataAccessObject.IsNULL <DateTime>(reader["UpdatedDate"]);
}
catch (Exception ex) { aCC_JournalDetail.UpdatedDate = DateTime.Today; } try
{
aCC_JournalDetail.RowStatusID = DataAccessObject.IsNULL <int>(reader["RowStatusID"]);
}
catch (Exception ex) { aCC_JournalDetail.RowStatusID = 0; }
try
{ aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = reader["ChartOfAccountLabel4Text"].ToString(); }
catch (Exception ex) { aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ""; }
try
{ aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = reader["ChartOfAccountLabel3Text"].ToString(); }
catch (Exception ex) { aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = ""; }
try
{ aCC_JournalDetail.ACC_ChartOfAccountLabel3Code = reader["ChartOfAccountLabel3Code"].ToString(); }
catch (Exception ex) { aCC_JournalDetail.ACC_ChartOfAccountLabel3Code = ""; }
try
{ aCC_JournalDetail.WorkStationName = reader["WorkStationName"].ToString(); }
catch (Exception ex) { }
try
{ aCC_JournalDetail.JournalDate = (DateTime)reader["JournalDate"]; }
catch (Exception ex) { }
try
{ aCC_JournalDetail.JournalMasterName = reader["JournalMasterName"].ToString(); }
catch (Exception ex) { }
return(aCC_JournalDetail);
}
catch (Exception ex)
{
return(null);
}
}
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;
}
public static int InsertACC_JournalDetailTmp(ACC_JournalDetail aCC_JournalDetail)
{
SqlACC_JournalDetailProvider sqlACC_JournalDetailProvider = new SqlACC_JournalDetailProvider();
return(sqlACC_JournalDetailProvider.InsertACC_JournalDetailTmp(aCC_JournalDetail));
}
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 txtJournalDate = (TextBox)gvr.FindControl("txtJournalDate");
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");
}
}
}
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);
}
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)
{ }
}
public static bool UpdateACC_JournalDetail(ACC_JournalDetail aCC_JournalDetail)
{
SqlACC_JournalDetailProvider sqlACC_JournalDetailProvider = new SqlACC_JournalDetailProvider();
return(sqlACC_JournalDetailProvider.UpdateACC_JournalDetail(aCC_JournalDetail));
}
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 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)
{
if (ddlACC_ChartOfAccountLabel3.SelectedValue != "0"
&& ((ddlACC_ChartOfAccountLabel4.Items.Count != 0 && ddlACC_ChartOfAccountLabel4.SelectedValue != "0")
|| (ddlACC_ChartOfAccountLabel4.Items.Count == 0))
&& (ddlWorkSatation.SelectedValue != "0" || rbtnHeadType.SelectedItem.Text == "Work Station")
&& txtAmount.Text != "" && decimal.Parse(txtAmount.Text) != 0
&& (Request.QueryString["Type"] == "1" || Request.QueryString["Type"] == "2" || rbtnDebitOrCredit.SelectedItem.Text == "Credit" || rbtnDebitOrCredit.SelectedItem.Text == "Debit")
)
{
List<ACC_JournalDetail> aCC_JournalDetails = new List<ACC_JournalDetail>();
aCC_JournalDetails = loadFromGrid();
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail.JournalMasterID = aCC_JournalDetails.Count;
try
{
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(ddlACC_ChartOfAccountLabel4.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlACC_ChartOfAccountLabel4.SelectedItem.Text;
}
catch (Exception ex)
{
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = 0;
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = "N/A";
}
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = ddlACC_ChartOfAccountLabel3.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = Int32.Parse(ddlACC_ChartOfAccountLabel3.SelectedValue);
try
{
if (ddlACC_ChartOfAccountLabel4.Items[0].Text.Contains("Work Station"))
{
ddlWorkSatation.SelectedValue = aCC_JournalDetail.ACC_ChartOfAccountLabel4ID.ToString();
}
aCC_JournalDetail.WorkStation = int.Parse(ddlWorkSatation.SelectedValue);
aCC_JournalDetail.WorkStationName = ddlWorkSatation.SelectedItem.Text;
}
catch (Exception ex)
{
aCC_JournalDetail.WorkStation = 0;
aCC_JournalDetail.WorkStationName = "N/A";
}
if (rbtnDebitOrCredit.SelectedItem.Text == "Credit")
{
aCC_JournalDetail.Debit = Decimal.Parse("0");
aCC_JournalDetail.Credit = Decimal.Parse(txtAmount.Text);
}
else
{
aCC_JournalDetail.Debit = Decimal.Parse(txtAmount.Text);
aCC_JournalDetail.Credit = Decimal.Parse("0");
}
aCC_JournalDetail.ExtraField3 = txtChequeNo.Text;
aCC_JournalDetail.ExtraField2 = txtBankNBranchDetails.Text;
aCC_JournalDetail.ExtraField1 = txtChequeDate.Text;
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_JournalDetails.Add(aCC_JournalDetail);
if (Request.QueryString["Tmp"] != null)
{
aCC_JournalDetail = new ACC_JournalDetail();
try
{
aCC_JournalDetail.WorkStation = int.Parse(ddlWorkSatation.SelectedValue);
aCC_JournalDetail.WorkStationName = ddlWorkSatation.SelectedItem.Text;
}
catch (Exception ex)
{
aCC_JournalDetail.WorkStation = 0;
aCC_JournalDetail.WorkStationName = "N/A";
}
aCC_JournalDetail.ExtraField3 = txtChequeNo.Text;
aCC_JournalDetail.ExtraField2 = txtBankNBranchDetails.Text;
aCC_JournalDetail.ExtraField1 = txtChequeDate.Text;
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.ACC_ChartOfAccountLabel4ID = int.Parse(ddlWorkSatation.SelectedValue);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ddlWorkSatation.SelectedItem.Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = 1;
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = "Petty Cash in Hand";
aCC_JournalDetail.Debit = 0;
aCC_JournalDetail.Credit =Decimal.Parse(txtAmount.Text);
aCC_JournalDetails.Add(aCC_JournalDetail);
}
BindJournalGrid(aCC_JournalDetails);
cleanData();
trWorkStation.Visible = false;
}
else
{
showAlartMessage("Please check the Data carefully");
}
}
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 List<ACC_JournalDetail> loadFromGrid()
{
List<ACC_JournalDetail> aCC_JournalDetails = new List<ACC_JournalDetail>();
int i = 0;
foreach (GridViewRow gvr in gvACC_JournalDetail.Rows)
{
ACC_JournalDetail aCC_JournalDetail = new ACC_JournalDetail();
aCC_JournalDetail.ACC_JournalDetailID = int.Parse(((HiddenField)gvr.FindControl("hfACC_JournalDetailID")).Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel4Text = ((Label)gvr.FindControl("lblACC_ChartOfAccountLabel4ID")).Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel4ID = Int32.Parse(((HiddenField)gvr.FindControl("hfACC_ChartOfAccountLabel4ID")).Value);
aCC_JournalDetail.ACC_ChartOfAccountLabel3Text = ((Label)gvr.FindControl("lblACC_ChartOfAccountLabel3ID")).Text;
aCC_JournalDetail.ACC_ChartOfAccountLabel3ID = Int32.Parse(((HiddenField)gvr.FindControl("hfACC_ChartOfAccountLabel3ID")).Value);
aCC_JournalDetail.WorkStation = Int32.Parse(((HiddenField)gvr.FindControl("hfWorkStation")).Value);
aCC_JournalDetail.WorkStationName = ((Label)gvr.FindControl("lblWorkStation")).Text; ;
aCC_JournalDetail.Debit = Decimal.Parse(((Label)gvr.FindControl("lblDebit")).Text);
aCC_JournalDetail.Credit = Decimal.Parse(((Label)gvr.FindControl("lblCredit")).Text);
aCC_JournalDetail.ExtraField3 = "";
aCC_JournalDetail.ExtraField2 = "";
aCC_JournalDetail.ExtraField1 = ((HiddenField)gvr.FindControl("hfExtraField1")).Value;
aCC_JournalDetail.ExtraField2 = ((HiddenField)gvr.FindControl("hfExtraField2")).Value;
aCC_JournalDetail.ExtraField3 = ((HiddenField)gvr.FindControl("hfExtraField3")).Value;
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_JournalDetails.Add(aCC_JournalDetail);
}
return aCC_JournalDetails;
}
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();
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 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)
{ }
}
