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