protected void ddltomain_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
Entities.Finance.VoucherEntry Voucher = new Entities.Finance.VoucherEntry();
decimal OpeningAmount = 0;
string[] words1 = ddltomain.SelectedValue.Split('|');
string headID, childID;
if (words1[0].ToString() == "0")
{
headID = words1[1].ToString();
OpeningAmount = Voucher.CalculateOpeningBalance(Convert.ToInt32(headID), 0);
}
else
{
headID = words1[0].ToString();
childID = words1[1].ToString();
OpeningAmount = Voucher.CalculateOpeningBalance(Convert.ToInt32(headID), Convert.ToInt32(childID));
}
lblToBalance.Text = OpeningAmount.ToString();
}
catch (Exception)
{
}
}
protected void hiddenButton_Click(object sender, EventArgs e)
{
try
{
Entities.Finance.VoucherEntry voucher = new Entities.Finance.VoucherEntry();
voucher.getDataForEdit(Convert.ToInt32(hdItemId.Value), txtDate, txtnarration, ddlVoucherType, txtamount, ddlfrommain, ddltomain, ddltosub, ddlfromsub);
}
catch (Exception)
{
}
}
private void loadVoucherDetails()
{
Entities.Finance.VoucherEntry Voucher = new Entities.Finance.VoucherEntry();
hdItemId.Value = Request.QueryString["id"].ToString();
DataSet ds = new DataSet();
ds = Voucher.GetDatasetForEdit(Convert.ToInt32(hdItemId.Value));
ViewState["DSTemp"] = ds;
string lit = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
lit += "<tr><td>" + ds.Tables[0].Rows[i]["Particulars"].ToString() + "</td><td>" + Math.Round(Convert.ToDecimal(ds.Tables[0].Rows[i]["DebitAmt"])).ToString() + "</td><td>" + Math.Round(Convert.ToDecimal(ds.Tables[0].Rows[i]["CreditAmt"])).ToString() + "</td><td>" + Math.Round(Convert.ToDecimal(ds.Tables[0].Rows[i]["Amount"])).ToString() + "</td></tr>";
}
hdnAmount.Value = Convert.ToDecimal(ds.Tables[0].Rows[0]["Amount"]).ToString();
tableContent.Text = lit;
ddlfrommain.Enabled = false;
Voucher.loadVoucherDetails(Convert.ToInt32(Request.QueryString["id"]), ddlfrommain, ddltomain, ddlVoucherType, txtnarration, txtDate, txtamount);
}
private void AddDatatoDataset(int flag = 0)
{
try
{
DataSet dsTemp = new DataSet();
Entities.Finance.VoucherEntry voucher = new Entities.Finance.VoucherEntry();
if (ViewState["DSTemp"] != null)
{
dsTemp = (DataSet)ViewState["DSTemp"];
}
else
{
dsTemp = voucher.CreateDataset();
ViewState["DSTemp"] = dsTemp;
}
DataRow dr;
try
{
dr = dsTemp.Tables[0].NewRow();
if (flag == 0)
{
dr["ParticularsID"] = ddltomain.SelectedValue;
if (ddltosub.SelectedIndex >= 0)
{
dr["Particulars"] = ddltomain.SelectedItem.Text + "(" + ddltosub.SelectedItem.Text + ")";
dr["CostHead"] = ddltosub.SelectedValue;
}
else
{
dr["Particulars"] = ddltomain.SelectedItem.Text;
dr["CostHead"] = "0";
}
dr["DebitAmt"] = txtamount.Text;
dr["CreditAmt"] = "";
dr["CreditOrDebit"] = "1";
}
else
{
dr["ParticularsID"] = ddlfrommain.SelectedValue;
if (ddlfromsub.SelectedIndex >= 0)
{
dr["Particulars"] = ddlfrommain.SelectedItem.Text + "(" + ddlfromsub.SelectedItem.Text + ")";
dr["CostHead"] = ddlfromsub.SelectedValue;
}
else
{
dr["Particulars"] = ddlfrommain.SelectedItem.Text;
dr["CostHead"] = "0";
}
dr["Particulars"] = ddlfrommain.SelectedItem.Text;
dr["CreditAmt"] = txtamount.Text;
dr["DebitAmt"] = "";
dr["CreditOrDebit"] = "0";
}
dr["CostCenter"] = "1" + "`" + txtamount.Text;
dr["Amount"] = txtamount.Text;
dsTemp.Tables[0].Rows.Add(dr);
dsTemp.AcceptChanges();
DataTable dtviewfilter = new DataTable();
if (dsTemp != null && dsTemp.Tables[0].Rows.Count > 0)
{
dtviewfilter = dsTemp.Tables[0];
DataView dv = new DataView(dtviewfilter);
dv.Sort = "CreditOrDebit DESC";
dtviewfilter = dv.ToTable();
dsTemp.Tables.Clear();
dsTemp.Tables.Add(dtviewfilter);
}
ViewState["DSTemp"] = dsTemp;
}
catch (Exception ex)
{
}
}
catch (Exception)
{
}
}
private OutputMessage UpdateExpense()
{
try
{
Entities.Finance.VoucherEntry Expense = new Entities.Finance.VoucherEntry();
DataSet dsTemp = new DataSet();
StringBuilder StrVType = new StringBuilder();
StringBuilder StrAccID = new StringBuilder();
StringBuilder StrChdID = new StringBuilder();
StringBuilder StrAmount = new StringBuilder();
StringBuilder StrCostCtr = new StringBuilder();
Expense.CreatedBy = CPublic.GetuserID();
if (ViewState["DSTemp"] != null)
{
dsTemp = (DataSet)ViewState["DSTemp"];
}
if (dsTemp != null && dsTemp.Tables[0].Rows.Count > 0)
{
DataRow row;
for (int i = 0; i < dsTemp.Tables[0].Rows.Count; i++)
{
row = dsTemp.Tables[0].Rows[i];
if (Convert.ToString(row["CreditOrDebit"]) != "")
{
if (StrVType.ToString() == "")
{
StrVType.Append(Convert.ToString(row["CreditOrDebit"]));
}
else
{
StrVType.Append("|" + Convert.ToString(row["CreditOrDebit"]));
}
}
if (Convert.ToString(row["ParticularsID"]) != "")
{
if (StrAccID.ToString() == "")
{
StrAccID.Append(Convert.ToString(row["ParticularsID"]));
}
else
{
StrAccID.Append("|" + Convert.ToString(row["ParticularsID"]));
}
}
if (Convert.ToString(row["CostHead"]) != "") //row["CostHead"]
{
if (StrChdID.ToString() == "")
{
StrChdID.Append(Convert.ToString(row["CostHead"])); //row["CostHead"]
}
else
{
StrChdID.Append("|" + Convert.ToString(row["CostHead"])); //row["CostHead"]
}
}
if (Convert.ToString(row["Amount"]) != "")
{
if (StrAmount.ToString() == "")
{
StrAmount.Append(Convert.ToString(row["Amount"]));
}
else
{
StrAmount.Append("|" + Convert.ToString(row["Amount"]));
}
}
if (Convert.ToString(row["CostCenter"]) != "")
{
if (StrCostCtr.ToString() == "")
{
StrCostCtr.Append(Convert.ToString(row["CostCenter"]));
}
else
{
StrCostCtr.Append("|" + Convert.ToString(row["CostCenter"]));
}
}
}
}
Expense.Date = DateTime.Now;
Expense.username = Convert.ToString(Session["UserName"]);
Expense.Description = txtnarration.Text;
Expense.IsCheque = 0;
Expense.ChequeNo = "";
Expense.ChequeDate = DateTime.MinValue;
if (txtNumber.ReadOnly == true)
{
if (txtNumber.Text.Trim() == "")
{
Expense.VoucherNo = 0;
}
else
{
Expense.VoucherNo = Convert.ToInt32(txtNumber.Text);
}
}
Expense.VoucherTypeID = Convert.ToInt32(ddlVoucherType.SelectedValue);
Expense.VoucherType = StrVType.ToString();
Expense.AccountHead = StrAccID.ToString();
Expense.AccountChild = StrChdID.ToString();
Expense.Amount = StrAmount.ToString();
Expense.CostCenter = StrCostCtr.ToString();
Expense.ModifiedBy = CPublic.GetuserID();
Expense.ID = Convert.ToInt32(hdItemId.Value);
DataSet dsVoucherEntryDet = new DataSet();
OutputMessage result = null;
result = Expense.Update(StrVType.ToString(), StrAccID.ToString(), StrChdID.ToString(), StrAmount.ToString(), StrCostCtr.ToString());
return(result);
}
catch (Exception)
{
return(null);
}
}
private OutputMessage UpdateVoucher()
{
try
{
OutputMessage result = null;
Entities.Finance.VoucherEntry Voucher = new Entities.Finance.VoucherEntry();
Voucher.CreatedBy = CPublic.GetuserID();
DataSet dsTemp = new DataSet();
if (ViewState["DSTemp"] != null)
{
dsTemp = (DataSet)ViewState["DSTemp"];
}
if (dsTemp != null && dsTemp.Tables[0].Rows.Count > 0)
{
DataRow row;
Voucher.DeleteVoucher(Convert.ToInt32(hdItemId.Value));
for (int i = 0; i < dsTemp.Tables[0].Rows.Count; i++)
{
Voucher.Frm_TransID = 0;
Voucher.ToTransID = 0;
Voucher.FrmTransChildID = 0;
Voucher.ToTransChildID = 0;
row = dsTemp.Tables[0].Rows[i];
if (Convert.ToString(row["CreditOrDebit"]) != "")
{
Voucher.VoucherType = Convert.ToString(row["CreditOrDebit"]);
}
if (Convert.ToString(row["ParticularsID"]) != "")
{
if (Voucher.VoucherType == "0")
{
Voucher.Frm_TransID = Convert.ToInt32(row["ParticularsID"]);
}
else
{
Voucher.ToTransID = Convert.ToInt32(row["ParticularsID"]);
}
}
if (Convert.ToString(row["CostHead"]) != "") //row["CostHead"]
{
if (Voucher.VoucherType == "0")
{
if (Voucher.Frm_TransID != 0)
{
Voucher.FrmTransChildID = Convert.ToInt32(row["CostHead"]);
}
else
{
//Voucher.FrmTransChildID == 0 ? null : Convert.ToInt32(row["CostHead"]);
}
}
else
{
Voucher.ToTransChildID = Convert.ToInt32(row["CostHead"]);
}
}
if (Convert.ToString(row["Amount"]) != "")
{
Voucher.AmountNew = Convert.ToDecimal(row["Amount"]);
}
if (Convert.ToString(row["CostCenter"]) != "")
{
Voucher.CostCenter = Convert.ToString(row["CostCenter"]);
}
Voucher.Date = Convert.ToDateTime(txtDate.Text); //DateTime.Now.ToString();
Voucher.username = Convert.ToString(Session["UserName"]);
Voucher.Description = txtnarration.Text;
Voucher.IsCheque = 0;
Voucher.ChequeNo = "";
Voucher.ChequeDate = null;
Voucher.IsVoucher = 1;
Voucher.VoucherTypeID = Convert.ToInt32(ddlVoucherType.SelectedValue);
if (txtNumber.ReadOnly == true)
{
if (txtNumber.Text.Trim() == "")
{
Voucher.VoucherNo = 0;
}
else
{
Voucher.VoucherNo = Convert.ToInt32(txtNumber.Text);
}
}
Voucher.groupID = Convert.ToInt32(hdItemId.Value);
result = Voucher.Save();
//hdnGroupID.Value = Convert.ToString(result.Object);
}
}
return(result);
}
catch (Exception ex)
{
return(null);
}
}
private OutputMessage SaveVoucherEntry()
{
try
{
OutputMessage result = null;
Entities.Finance.VoucherEntry Voucher = new Entities.Finance.VoucherEntry();
Voucher.CreatedBy = CPublic.GetuserID();
DataSet dsTemp = new DataSet();
StringBuilder StrVType = new StringBuilder();
StringBuilder StrAccID = new StringBuilder();
StringBuilder StrChdID = new StringBuilder();
StringBuilder StrAmount = new StringBuilder();
StringBuilder StrCostCtr = new StringBuilder();
if (ViewState["DSTemp"] != null)
{
dsTemp = (DataSet)ViewState["DSTemp"];
}
if (dsTemp != null && dsTemp.Tables[0].Rows.Count > 0)
{
DataRow row;
for (int i = 0; i < dsTemp.Tables[0].Rows.Count; i++)
{
row = dsTemp.Tables[0].Rows[i];
if (Convert.ToString(row["CreditOrDebit"]) != "")
{
if (StrVType.ToString() == "")
{
StrVType.Append(Convert.ToString(row["CreditOrDebit"]));
}
else
{
StrVType.Append("|" + Convert.ToString(row["CreditOrDebit"]));
}
}
if (Convert.ToString(row["ParticularsID"]) != "")
{
if (StrAccID.ToString() == "")
{
StrAccID.Append(Convert.ToString(row["ParticularsID"]));
}
else
{
StrAccID.Append("|" + Convert.ToString(row["ParticularsID"]));
}
}
if (Convert.ToString(row["CostHead"]) != "")
{
if (StrChdID.ToString() == "")
{
StrChdID.Append(Convert.ToString(row["CostHead"]));
}
else
{
StrChdID.Append("|" + Convert.ToString(row["CostHead"]));
}
}
if (Convert.ToString(row["Amount"]) != "")
{
if (StrAmount.ToString() == "")
{
StrAmount.Append(Convert.ToString(row["Amount"]));
}
else
{
StrAmount.Append("|" + Convert.ToString(row["Amount"]));
}
}
if (Convert.ToString(row["CostCenter"]) != "")
{
if (StrCostCtr.ToString() == "")
{
StrCostCtr.Append(Convert.ToString(row["CostCenter"]));
}
else
{
StrCostCtr.Append("|" + Convert.ToString(row["CostCenter"]));
}
}
}
}
//string Vtype = "", StrAccID="", StrChdID="", StrAmount="", StrCostCtr="";
//if (ViewState["DSTemp"] != null)
//{
// dsTemp = (DataSet)ViewState["DSTemp"];
//}
//if (dsTemp != null && dsTemp.Tables[0].Rows.Count > 0)
//{
// DataRow row;
// for (int i = 0; i < dsTemp.Tables[0].Rows.Count; i++)
// {
// Voucher.Frm_TransID = 0;
// Voucher.ToTransID = 0;
// Voucher.FrmTransChildID = 0;
// Voucher.ToTransChildID = 0;
// row = dsTemp.Tables[0].Rows[i];
// //if (Convert.ToString(row["CreditOrDebit"]) != "")
// //{
// // //Voucher.VoucherType = Convert.ToString(row["CreditOrDebit"]);
// // Vtype += Convert.ToString(row["CreditOrDebit"]) + "|";
// //}
// //if (Convert.ToString(row["ParticularsID"]) != "")
// //{
// // StrAccID += Convert.ToInt32(row["ParticularsID"]) + "|";
// // //if (Voucher.VoucherType=="1")
// // //{
// // // //Voucher.Frm_TransID = Convert.ToInt32(row["ParticularsID"]);
// // //}
// // //else
// // //{
// // // StrAccID += Convert.ToInt32(row["ParticularsID"]) + "|";
// // // Voucher.ToTransID = Convert.ToInt32(row["ParticularsID"]);
// // //}
// //}
// if (Convert.ToString(row["CostHead"]) != ""||Convert.ToString(row["CostHead"])!="0") //row["CostHead"]
// {
// if (Voucher.VoucherType == "0")
// {
// if (Voucher.Frm_TransID!=0)
// {
// Voucher.FrmTransChildID = Convert.ToInt32(row["CostHead"]);
// }
// else
// {
// //Voucher.FrmTransChildID == 0 ? null : Convert.ToInt32(row["CostHead"]);
// }
// }
// else
// {
// Voucher.ToTransChildID = Convert.ToInt32(row["CostHead"]);
// }
// }
// if (Convert.ToString(row["Amount"]) != "")
// {
// Voucher.AmountNew = Convert.ToDecimal(row["Amount"]);
// }
// if (Convert.ToString(row["CostCenter"]) != "")
// {
// Voucher.CostCenter = Convert.ToString(row["CostCenter"]);
// }
Voucher.Date = Convert.ToDateTime(txtDate.Text); //DateTime.Now.ToString();
Voucher.username = Convert.ToString(Session["UserName"]);
Voucher.Description = txtnarration.Text;
Voucher.IsCheque = 0;
Voucher.ChequeNo = "";
Voucher.ChequeDate = null;
Voucher.IsVoucher = 1;
Voucher.VoucherTypeID = Convert.ToInt32(ddlVoucherType.SelectedValue);
if (txtNumber.ReadOnly == true)
{
if (txtNumber.Text.Trim() == "")
{
Voucher.VoucherNo = 0;
}
else
{
Voucher.VoucherNo = Convert.ToInt32(txtNumber.Text);
}
}
// Voucher.groupID = Convert.ToInt32(hdnGroupID.Value);
// }
result = Voucher.Save(Convert.ToString(StrVType), Convert.ToString(StrAccID), Convert.ToString(StrChdID), Convert.ToString(StrAmount), Convert.ToString(StrCostCtr), "", "");
// hdnGroupID.Value = Convert.ToString(result.Object);
//}
return(result);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Used For display the credit and debit in the table
/// </summary>
/// <param name="flag">0 for credit and 1 for debit</param>
private void AddDatatoDataset(int flag = 0)
{
try
{
decimal Amount = 0;
if (hdnAmount.Value != "0" && flag == 1)
{
Amount = Convert.ToDecimal(hdnAmount.Value) + Convert.ToDecimal(txtamount.Text); //Amount Addition for debit
}
else if (txtamount.Text != "")
{
Amount = Convert.ToDecimal(txtamount.Text);
}
else
{
Amount = 0;
}
DataSet dsTemp = new DataSet();
Entities.Finance.VoucherEntry voucher = new Entities.Finance.VoucherEntry();
if (ViewState["DSTemp"] != null)
{
dsTemp = (DataSet)ViewState["DSTemp"];
}
else
{
dsTemp = voucher.CreateDataset();
ViewState["DSTemp"] = dsTemp;
}
DataRow dr;
try
{
dr = dsTemp.Tables[0].NewRow();
if (flag == 0)
{
string head = "";
//string child = "";
string[] words = ddltomain.SelectedValue.Split('|'); // for Voucher entry only
if (words[0].ToString() == "0")
{
head = words[1].ToString();
}
else
{
head = words[0].ToString();
}
dr["ParticularsID"] = head;//ddltomain.SelectedValue;
if (words[0].ToString() != "0")
{
dr["Particulars"] = ddlfrommain.SelectedItem.Text + "[" + ddltomain.SelectedItem.Text + "]";
dr["CostHead"] = words[1].ToString();
}
//if (ddltosub.SelectedIndex >= 0)
//{
// dr["Particulars"] = ddltomain.SelectedItem.Text + "(" + ddltosub.SelectedItem.Text + ")";
// dr["CostHead"] = ddltosub.SelectedValue;
//}
else
{
dr["Particulars"] = ddltomain.SelectedItem.Text + "[" + ddlfrommain.SelectedItem.Text + "]";
dr["CostHead"] = "0";
}
dr["CreditAmt"] = txtamount.Text;
dr["DebitAmt"] = 0;
dr["CreditOrDebit"] = "1";
}
else
{
try
{
dsTemp.Tables[0].Rows[0].Delete(); // deleting the top debit row if exists
}
catch (Exception)
{
}
string headID = "";
//string child = "";
string[] words1 = ddlfrommain.SelectedValue.Split('|');
if (Session["type"].ToString() == "Normal")
{
if (words1[0].ToString() == "0")
{
headID = words1[1].ToString();
}
else
{
headID = words1[0].ToString();
}
}
else
{
headID = ddlfrommain.SelectedValue;
}
dr["ParticularsID"] = headID;
//dr["ParticularsID"] = ddlfrommain.SelectedValue;
try
{
if (words1[0].ToString() != "0")
{
dr["Particulars"] = ddlfrommain.SelectedItem.Text;
dr["CostHead"] = words1[1].ToString();
}
//if (ddlfromsub.SelectedIndex >= 0)
//{
// dr["Particulars"] = ddlfrommain.SelectedItem.Text + "(" + ddlfromsub.SelectedItem.Text + ")";
// dr["CostHead"] = ddlfromsub.SelectedValue;
//}
else
{
dr["Particulars"] = ddlfrommain.SelectedItem.Text;
dr["CostHead"] = "0";
}
}
catch (Exception)
{
dr["Particulars"] = ddlfrommain.SelectedItem.Text;
dr["CostHead"] = "0";
}
//dr["CostHead"] = "0";
//dr["Particulars"] = ddlfrommain.SelectedItem.Text;
dr["DebitAmt"] = Amount;
dr["CreditAmt"] = 0;
dr["CreditOrDebit"] = "0";
}
dr["CostCenter"] = "1" + "`" + txtamount.Text;
dr["Amount"] = Amount;
dsTemp.Tables[0].Rows.Add(dr);
dsTemp.AcceptChanges();
DataTable dtviewfilter = new DataTable();
if (dsTemp != null && dsTemp.Tables[0].Rows.Count > 0)
{
dtviewfilter = dsTemp.Tables[0];
DataView dv = new DataView(dtviewfilter);
dv.Sort = "CreditOrDebit ASC";
dtviewfilter = dv.ToTable();
dsTemp.Tables.Clear();
dsTemp.Tables.Add(dtviewfilter);
}
ViewState["DSTemp"] = dsTemp;
string lit = "";
//Adding Cntents to table
for (int i = 0; i < dsTemp.Tables[0].Rows.Count; i++)
{
lit += "<tr><td>" + dsTemp.Tables[0].Rows[i]["Particulars"].ToString() + "</td><td>" + Math.Round(Convert.ToDecimal(dsTemp.Tables[0].Rows[i]["DebitAmt"])).ToString() + "</td><td>" + Math.Round(Convert.ToDecimal(dsTemp.Tables[0].Rows[i]["CreditAmt"])).ToString() + "</td><td>" + Math.Round(Convert.ToDecimal(dsTemp.Tables[0].Rows[i]["Amount"])).ToString() + "</td></tr>";
}
tableContent.Text = lit;
Amount = Math.Round(Convert.ToDecimal(dsTemp.Tables[0].Rows[0]["Amount"]));
hdnAmount.Value = Amount.ToString();
}
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)
{
}
}
