public void SaveDetails(int DocNo)
{
try
{
if (Session["UserName"] != null)
{
VirtualStockDetails vd = new VirtualStockDetails();
vd.VMasterID = DocNo;
vd.CreatedBy = Session["UserName"].ToString();
foreach (GridViewRow gv in gvDetails.Rows)
{
vd.IsActive = true;
vd.DetailID = Convert.ToInt32(((Label)gv.FindControl("lblDetailId")).Text);
vd.BookCode = ((Label)gv.FindControl("lblCode")).Text;
vd.BookName = ((Label)gv.FindControl("lblName")).Text;
vd.Quantity = Convert.ToInt32(((Label)gv.FindControl("lblQuantity")).Text);
vd.Standard = ((Label)gv.FindControl("lblstandard")).Text;
vd.FY = Convert.ToInt32(strFY);
vd.Save();
}
}
}
catch
{ }
}
public void BindReport(string Flag)
{
//Get_VirtualStockDatails
DataTable dt = new DataTable();
dt = VirtualStockDetails.Get_VirtualStockDatails(Convert.ToInt32(txtinvoice.Text), Convert.ToInt32(strFY)).Tables[0];
if (dt.Rows.Count > 0)
{
if (Flag == "Report")
{
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("Report/printVirtualStock.rpt"));
rd.Database.Tables[0].SetDataSource(dt);
// rd.Database.Tables[1].SetDataSource(dv2);
//rd.SetDataSource(ds);
VirtualstockView.ReportSource = rd;
// grdvirualDetails.DataSource = VirtualStockDetails.Get_VirtualStockDatails(Convert.ToInt32(txtinvoice.Text), Convert.ToInt32(strFY));
// grdvirualDetails.DataBind();
}
else
{
grdvirualDetails.DataSource = dt;
grdvirualDetails.DataBind();
pnlVirtual.Visible = true;
txtInvoiceNo.Text = dt.Rows[0]["InvoiceNo"].ToString();
txtRemark.Text = dt.Rows[0]["Remark"].ToString();
txtDate.Text = dt.Rows[0]["InvoiceDate"].ToString();
lblID.Text = dt.Rows[0]["AutoID"].ToString();
btn_Save.Visible = true;
txtInvoiceNo.Enabled = false;
}
}
else
{
// grdvirualDetails.DataBind();
MessageBox("Record Not Found");
txtinvoice.Focus();
}
}
public void BindReport()
{
//Get_VirtualStockDatails
DataTable dt = new DataTable();
dt = VirtualStockDetails.Get_VirtualStockDatails(Convert.ToInt32(txtinvoice.Text), Convert.ToInt32(strFY)).Tables[0];
if (dt.Rows.Count > 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("Report/printVirtualStock.rpt"));
rd.Database.Tables[0].SetDataSource(dt);
// rd.Database.Tables[1].SetDataSource(dv2);
//rd.SetDataSource(ds);
VirtualstockView.ReportSource = rd;
// grdvirualDetails.DataSource = VirtualStockDetails.Get_VirtualStockDatails(Convert.ToInt32(txtinvoice.Text), Convert.ToInt32(strFY));
// grdvirualDetails.DataBind();
}
else
{
// grdvirualDetails.DataBind();
MessageBox("Record Not Found");
txtinvoice.Focus();
}
}
