protected void Page_Load(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
Entities.Finance.FinancialTransactions fin = new Entities.Finance.FinancialTransactions();
dt = fin.GetAccountGroups(CPublic.GetCompanyID());
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
ListItem items = new ListItem(item["name"].ToString(), item["id"].ToString());
ddlAccountGroups.Items.Add(items);
}
}
dt = fin.GetAccountHeads(Convert.ToInt32(ddlAccountGroups.SelectedValue));
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
ListItem items = new ListItem(item["Fah_Name"].ToString(), item["Fah_ID"].ToString());
ddlTransHead.Items.Add(items);
}
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
//Initilization at Pageload
ddlTransHead.LoadAccountHeads(CPublic.GetCompanyID());
Entities.Finance.FinancialTransactions fin = new Entities.Finance.FinancialTransactions();
DateTime newDate = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, 1);//From date(First day of the current month)
txtFromDate.Text = newDate.ToString("dd-MMM-yyyy");
txtToDate.Text = DateTime.UtcNow.ToString("dd-MMM-yyyy");
ddlCostCenter.LoadCost(CPublic.GetCompanyID());
ddlTransHead.SelectedValue = "6";
if (ddlTransHead.SelectedValue != "0")
{
lblLedgerHead.InnerText = ddlTransHead.SelectedItem.Text;
}
else
{
lblLedgerHead.InnerText = "Cash";
}
lblDate.InnerText = "From " + txtFromDate.Text + " to " + txtToDate.Text;
literalGrid.Text = fin.BindGrid(hiddenChildId.Value, ddlChildHead.SelectedValue, ddlTransHead.SelectedValue, txtFromDate.Text, txtToDate.Text, ddlCostCenter.SelectedValue);
}
catch (Exception)
{
}
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
try
{
Entities.Finance.FinancialTransactions fin = new Entities.Finance.FinancialTransactions();
if (Convert.ToDateTime(txtFromDate.Text) > Convert.ToDateTime(txtToDate.Text))
{
string strSaveScript = "<script language='javascript' type='text/javascript'>errorAlert('From date is greater than to date')</script>";
ClientScript.RegisterStartupScript(typeof(string), "SaveSCript", strSaveScript);
}
else
{
fin.FromDate = Convert.ToDateTime(txtFromDate.Text);
fin.ToDate = Convert.ToDateTime(txtToDate.Text);
grdCash.DataSource = fin.ShowDailyStatement();
grdCash.DataBind();
grdCash.Visible = true;
}
}
catch (Exception ex)
{
string strSaveScript = "<script language='javascript' type='text/javascript'>errorAlert('Something Went wrong')</script>";
ClientScript.RegisterStartupScript(typeof(string), "SaveSCript", strSaveScript);
}
}
protected void page_LoadComplete(object sender, EventArgs e)
{
if (!IsPostBack)
{
Entities.Finance.FinancialTransactions fin = new Entities.Finance.FinancialTransactions();
string GetDate = "";
GetDate = fin.GetFinancialYear();
txtFromDate.Text = GetDate;
txtToDate.Text = DateTime.UtcNow.ToString("dd-MMM-yyyy");
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
customerDropdown.LoadCustomer(Publics.CPublic.GetCompanyID());
supplierDropdown.LoadSupplier(Publics.CPublic.GetCompanyID());
DataTable dt = new DataTable();
Entities.Finance.FinancialTransactions fin = new Entities.Finance.FinancialTransactions();
dt = fin.GetAccountHeads(45);//The Parent group of Bank group is 45.
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
ListItem items = new ListItem(item["Fah_Name"].ToString(), item["Fah_ID"].ToString());
ddlPaymentBank.Items.Add(items);
}
}
}
protected void btnBalanceSheet_Click(object sender, EventArgs e)
{
try
{
Entities.Finance.FinancialTransactions fin = new Entities.Finance.FinancialTransactions();
int reportID = 1;
hiddenCompanyId.Value = CPublic.GetCompanyID().ToString();
if (Convert.ToDateTime(txtFromDate.Text) > Convert.ToDateTime(txtToDate.Text))
{
ClientScript.RegisterStartupScript(this.GetType(), "message", "errorAlert('Enter Valid Date');", true);
}
else
{
grdLiteral.Text = fin.getbalanceSheet(hiddenCompanyId, hiddenReportId, txtFromDate, txtToDate, ddlCostCenter, reportID);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "message", "errorAlert('Something Went Wrong. " + ex.Message + "');", true);
}
}
