private void FillTree()
{
try
{
Entities.Finance.AccountHeadMaster account = new Entities.Finance.AccountHeadMaster();
TreeNode tree = new TreeNode();
tree = account.GetTree(CPublic.GetCompanyID());
moduleTree.Nodes.Add(tree);
moduleTree.CollapseAll();
}
catch (Exception)
{
}
}
protected void moduleTree_SelectedNodeChanged(object sender, EventArgs e)
{
try
{
if (moduleTree.SelectedNode.ChildNodes.Count > 0)
{
Reset();
}
else
{
Entities.Finance.AccountHeadMaster Account = new Entities.Finance.AccountHeadMaster();
try
{
dynamic Accounttree = Entities.Finance.AccountHeadMaster.GetGroupData(Convert.ToInt32(moduleTree.SelectedValue));
txtAccountHeadName.Text = Accounttree.Name;
txtAddress.Text = Accounttree.Address;
txtAmountSQL.Text = Accounttree.AmountSQL;
txtContactPerson.Text = Accounttree.ContactPerson;
txtDataID.Text = Accounttree.SQLID;
txtDataName.Text = Accounttree.SQLName;
txtDescription.Text = Accounttree.Description;
txtEmail.Text = Accounttree.Email;
hdItemId.Value = Convert.ToString(Accounttree.ID);
txtPhoneNumber.Text = Accounttree.Phone;
txtRefenerenceTable.Text = Accounttree.SQLTable;
txtTransactionSQL.Text = Accounttree.TransactionSQL;
txtOpeningDate.Text = Convert.ToString(Accounttree.OpeningDate);
txtOpeningBalance.Text = Convert.ToString(Accounttree.OpeningBalance);
ddlAccountNature.SelectedValue = Convert.ToString(Accounttree.AccountNature);
ddlAccountType.SelectedValue = Convert.ToString(Accounttree.AccountType);
ddlCategory.SelectedValue = Convert.ToString(Accounttree.Category);
ddlIsDebit.SelectedValue = Convert.ToString(Accounttree.IsDebit);
ddlParentGroup.SelectedValue = Convert.ToString(Accounttree.AccountGroupId);
ddlReverseHead.SelectedValue = Convert.ToString(Accounttree.ReverseHeadId);
ddlStatus.SelectedValue = Convert.ToString(Accounttree.status);
txtDataSQL.Text = Convert.ToString(Accounttree.DataSQL);
lblID.Text = "[" + Convert.ToString(Accounttree.ID) + "]";
btnSave.InnerHtml = "Update";
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//Gets the voucher type from url and loads it into hiddenfield
if (Request.QueryString["VOUCHER"] != null)
{
hdnVoucherType.Value = Request.QueryString["VOUCHER"].ToString();
if (Request.QueryString["ID"] != null)
{
hdnGroupID.Value = Request.QueryString["ID"].ToString();
}
}
//If Only ID is Given in the URL
else if (Request.QueryString["ID"] != null)
{
hdnGroupID.Value = Request.QueryString["ID"].ToString();
DataSet VoucherData = new DataSet();
VoucherData = Entities.Finance.VoucherEntry.GetDataset(Convert.ToInt32(hdnGroupID.Value));
hdnVoucherType.Value = VoucherData.Tables[0].Rows[0]["Fve_VoucherType"].ToString();
}
else
{
//If null stores is at JNL voucher type //Default
hdnVoucherType.Value = "8";
}
DataTable dt = new DataTable();
Entities.Finance.AccountHeadMaster account = new Entities.Finance.AccountHeadMaster();
//Datatable to load credit head
dt = account.GetAccountHeadsVoucher(Convert.ToInt32(hdnVoucherType.Value), 1, CPublic.GetCompanyID());
ddlCreditHead.Items.Add(new ListItem("--select--", "0"));
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
//Creates a new list item
ListItem items = new ListItem(item["name"].ToString(), item["parent"].ToString() + "|" + item["ID"].ToString());
ddlCreditHead.Items.Add(items);
}
}
//Datatable to load the debit heads
dt = account.GetAccountHeadsVoucher(Convert.ToInt32(hdnVoucherType.Value), 0, CPublic.GetCompanyID());
ddlDebitDummyHead.Items.Add(new ListItem("--select--", "0"));
ddlDebithead1.Items.Add(new ListItem("--select--", "0"));
ddlDebithead2.Items.Add(new ListItem("--select--", "0"));
ddlDebithead3.Items.Add(new ListItem("--select--", "0"));
ddlDebithead4.Items.Add(new ListItem("--select--", "0"));
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
//Creates a new list item and appends it to the debit dropdownlist and clone dropdownlist
ListItem items = new ListItem(item["name"].ToString(), item["parent"].ToString() + "|" + item["ID"].ToString());
ddlDebitDummyHead.Items.Add(items);
ddlDebithead1.Items.Add(items);
ddlDebithead2.Items.Add(items);
ddlDebithead3.Items.Add(items);
ddlDebithead4.Items.Add(items);
}
}
Entities.Finance.VoucherEntry voucher = new Entities.Finance.VoucherEntry();
//Datatable Loads the Job and appends to all JOb drop downlist
dt = voucher.GetJobs(CPublic.GetCompanyID());
ddlJobs1.Items.Add(new ListItem("--select--", "0"));
ddlJobs2.Items.Add(new ListItem("--select--", "0"));
ddlJobs3.Items.Add(new ListItem("--select--", "0"));
ddlJobs4.Items.Add(new ListItem("--select--", "0"));
ddlDebitDummyJob.Items.Add(new ListItem("--select--", "0"));
ddlCreditJob.Items.Add(new ListItem("--select--", "0"));
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
ListItem items = new ListItem(item["Job_Name"].ToString(), item["Job_Id"].ToString());
ddlJobs1.Items.Add(items);
ddlJobs2.Items.Add(items);
ddlJobs3.Items.Add(items);
ddlJobs4.Items.Add(items);
ddlDebitDummyJob.Items.Add(items);
ddlCreditJob.Items.Add(items);
}
}
//Datatable to load cost center and appends to the cost center dropdownlist
dt = voucher.LoadCostCenter();
ddlDebitDummyCost.Items.Add(new ListItem("--select--", "0"));
ddlDebitCost1.Items.Add(new ListItem("--select--", "0"));
ddlDebitCost2.Items.Add(new ListItem("--select--", "0"));
ddlDebitCost3.Items.Add(new ListItem("--select--", "0"));
ddlDebitCost4.Items.Add(new ListItem("--select--", "0"));
ddlCreditCost.Items.Add(new ListItem("--select--", "0"));
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
ListItem items = new ListItem(item["name"].ToString(), item["id"].ToString());
ddlDebitDummyCost.Items.Add(items);
ddlDebitCost1.Items.Add(items);
ddlDebitCost2.Items.Add(items);
ddlDebitCost3.Items.Add(items);
ddlDebitCost4.Items.Add(items);
ddlCreditCost.Items.Add(items);
}
}
DataSet ds = new DataSet();
//Gets the Url Parameter and changes title and voucher number according to url parameter
ds = voucher.GetVoucherNo(Convert.ToInt32(hdnVoucherType.Value));
VoucherNumber.InnerText = ds.Tables[1].Rows[0]["Fvt_TypeName"].ToString() + ":" + ds.Tables[0].Rows[0]["Number"].ToString();
lblTitle.InnerText = ds.Tables[1].Rows[0]["Fvt_TypeName"].ToString();
hdnVoucherTypeName.Value = ds.Tables[1].Rows[0]["Fvt_TypeName"].ToString();
//Loads the voucher types in the changetype dropdown list
ddlChangeType.LoadVoucherTypes(CPublic.GetCompanyID());
if (hdnGroupID.Value != "0")
{
}
}
catch (Exception ex)
{
}
}
protected void btnSaveConfirmed_Click(object sender, EventArgs e)
{
try
{
Entities.Finance.AccountHeadMaster Account = new Entities.Finance.AccountHeadMaster();
Account.ID = Convert.ToInt32(hdItemId.Value);
Account.Name = txtAccountHeadName.Text;
Account.status = Convert.ToInt32(ddlStatus.SelectedValue);
Account.Description = txtDescription.Text;
Account.IsDebit = Convert.ToInt32(ddlIsDebit.SelectedValue);
Account.ParentId = 0;
Account.CreatedBy = CPublic.GetuserID();
Account.Category = Convert.ToInt32(ddlCategory.SelectedValue);
Account.DataSQL = txtDataSQL.Text;
Account.SQLID = txtDataID.Text;
Account.SQLName = txtDataName.Text;
Account.SQLTable = txtRefenerenceTable.Text;
Account.TransactionSQL = txtTransactionSQL.Text;
Account.AmountSQL = txtAmountSQL.Text;
Account.Phone = txtPhoneNumber.Text;
Account.Email = txtEmail.Text;
if (txtOpeningBalance.Text == "")
{
Account.OpeningBalance = 0;
}
else
{
Account.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text);
}
if (txtOpeningDate.Text == "")
{
Account.OpeningDate = DateTime.UtcNow;
}
else
{
Account.OpeningDate = Convert.ToDateTime(txtOpeningDate.Text);
}
Account.CompanyID = CPublic.GetCompanyID();
Account.ModifiedBy = CPublic.GetuserID();
Account.AccountNature = Convert.ToInt32(ddlAccountNature.SelectedValue);
Account.AccountType = Convert.ToInt32(ddlAccountType.SelectedValue);
Account.Address = txtAddress.Text;
Account.ContactPerson = txtContactPerson.Text;
Account.AccountGroupId = Convert.ToInt32(ddlParentGroup.SelectedValue);
Account.ReverseHeadId = Convert.ToInt32(ddlReverseHead.SelectedValue);
OutputMessage Result = null;
if (Account.ID == 0)
{
Result = Account.Save();
if (Result.Success)
{
Reset();
ddlReverseHead.LoadAccountHeads(CPublic.GetCompanyID());
ClientScript.RegisterStartupScript(this.GetType(), "message", "successAlert('" + Result.Message + "');window.setTimeout(function(){window.location.href = '/Finance/AccountHeadMaster';}, 3000);", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "message", "errorAlert('" + Result.Message + "')", true);
}
}
else
{
Result = Account.Update();
if (Result.Success)
{
Reset();
ClientScript.RegisterStartupScript(this.GetType(), "message", "successAlert('" + Result.Message + "');window.setTimeout(function(){window.location.href = '/Finance/AccountHeadMaster';}, 3000);", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "message", "errorAlert('" + Result.Message + "')", true);
}
}
}
catch (Exception ex)
{
}
}
