protected void PopulateOpeningBalance()
{
BusinessLayer.Accounts.OpeningBalanceMaster OpBal = new OpeningBalanceMaster();
Entity.Accounts.OpeningBalanceMaster EntOpBal = OpBal.GetById(OpBalId);
LoadLedger();
ddlLedger.SelectedValue = EntOpBal.LedgerId.ToString();
ddlLedger.Enabled = false;
txtOpeningBalance.Text = EntOpBal.OpeningBalance.ToString();
ddlOpeningBalanceType.SelectedValue = EntOpBal.OpeningBalanceType;
btnSave.Text = "Update";
}
protected void ddlLedger_SelectedIndexChanged(object sender, EventArgs e)
{
int LedgerId = Convert.ToInt32(ddlLedger.SelectedValue);
Message.Show = false;
BusinessLayer.Accounts.OpeningBalanceMaster objOpBal = new OpeningBalanceMaster();
DataView DV = new DataView(objOpBal.GetAll());
DV.RowFilter = "LedgerId='" + LedgerId + "' AND FinancialYrId ='" + int.Parse(Session["FinYrID"].ToString()) + "'";
if (DV.ToTable().Rows.Count > 0)
{
lblActualOpeningBalance.Text = "Actual OPBAL: " + DV.ToTable().Rows[0]["ActualOpeningBalance"].ToString();
lblActualOpeningBalance.Visible = true;
ddlOpeningBalanceType.SelectedValue = DV.ToTable().Rows[0]["OpeningBalanceType"].ToString();
}
}
protected void LoadOpeningBalance()
{
string LedgerName = txtLedgerName.Text.Trim();
int FinYrId = int.Parse(Session["FinYrID"].ToString());
BusinessLayer.Accounts.OpeningBalanceMaster objOpBal = new OpeningBalanceMaster();
DataView DV = new DataView(objOpBal.GetAll());
if (LedgerName != "")
{
DV.RowFilter = "LedgerName like '" + LedgerName + "%' AND FinancialYrId='" + FinYrId + "'";
}
else
{
DV.RowFilter = "FinancialYrId='" + FinYrId + "'";
}
if (DV.ToTable().Rows.Count > 0)
{
dgvOpeningBalance.DataSource = DV;
dgvOpeningBalance.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Entity.Accounts.OpeningBalanceMaster OpBal = new Entity.Accounts.OpeningBalanceMaster();
OpBal.OpBalId = OpBalId;
OpBal.CompanyId = int.Parse(Session["CompanyId"].ToString());
OpBal.LedgerId = Convert.ToInt32(ddlLedger.SelectedValue);
OpBal.FinancialYrId = Convert.ToInt32(Session["FinYrID"].ToString());
OpBal.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text.Trim());
OpBal.OpeningBalanceType = ddlOpeningBalanceType.SelectedValue;
OpBal.CreatedBy = int.Parse(Session["UserId"].ToString());
BusinessLayer.Accounts.OpeningBalanceMaster objOpBal = new OpeningBalanceMaster();
int MessageCode = objOpBal.OpeningBalanceSave(OpBal);
if (MessageCode >= 0)
{
Message.IsSuccess = true;
if (MessageCode == 0)
{
Message.Text = "Updated Successfully!";
}
else
{
Message.Text = "Opening Balance Saved Successfully!";
}
}
else
{
Message.IsSuccess = false;
if (MessageCode == -1)
{
Message.Text = "Sorry!! Already Exists OR Duplicate Entry is not allowed";
}
}
Message.Show = true;
ResetControl();
}
public bool Post(OpeningBalanceEntity openingBalanceEntity)
{
OpeningBalanceMaster openingBalance = new OpeningBalanceMaster();
return(openingBalance.InsertOpeningBalanceMaster(openingBalanceEntity));
}
