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