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) { } }