private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (optDatewise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("SD");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptSales", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else if (optProductwise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(cmbProductName.SelectedIndex == 0 ? "0" : cmbProductName.SelectedValue.ToString());
para_value.Add("SP");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptSales", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else if (optCustomerwise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Customer_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(cmbCustomerName.SelectedIndex == 0 ? "0" : cmbCustomerName.SelectedValue.ToString());
para_value.Add("SK");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptSales", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else
{
}
}
catch (Exception err)
{
err.GetBaseException();
}
clear();
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (optGstr3.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("GT");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptGSTTax", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else if (optGstr1.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("GSTR1");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RPTGSTR", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else if (optGstr2.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("GSTR2");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RPTGSTR", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
}
catch (Exception err)
{ err.GetBaseException(); }
clear();
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
List <string> para_name = new List <string>();
para_name.Add("@Customer_Id");
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(cmbCustomerName.SelectedValue.ToString());
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("CGLN");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("rptCustomerLedgerNew", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
catch (Exception err)
{
err.GetBaseException();
}
clear();
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
List <string> para_name = new List <string>();
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(cmbRootName.SelectedValue.ToString());
para_value.Add("RT");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptRoot", ds, 0);
}
catch (Exception err)
{
err.GetBaseException();
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
module_Rpt function = new module_Rpt();
BUSSINESS_LAYER.BL bl_obj = new BUSSINESS_LAYER.BL();
List <string> para_name = new List <string>();
para_name.Add("@flag");
para_name.Add("@From_Date");
List <string> para_value = new List <string>();
para_value.Add("FR");
para_value.Add(kryptonDateTimePicker1.Value.ToString("yyyy-MM-dd"));
ds = bl_obj.blFill_Para_Name(para_name, para_value, "SP_Report");
function.Show_Report("rptRowMaterialStock", ds, 0);
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
List <string> para_name = new List <string>();
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(txtInvoiceNo.Text);
para_value.Add("SI");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptSalesInvoice", ds, 0);
}
catch (Exception err)
{
err.GetBaseException();
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
module_Rpt function = new module_Rpt();
BUSSINESS_LAYER.BL bl_obj = new BUSSINESS_LAYER.BL();
List <string> para_name = new List <string>();
para_name.Add("@flag");
para_name.Add("@From_Date");
List <string> para_value = new List <string>();
para_value.Add("FG");
para_value.Add(kryptonDateTimePicker1.Value.ToString("yyyy-MM-dd"));
ds = bl_obj.blFill_Para_Name(para_name, para_value, "SP_Report");
function.Show_Report("rptFinishedGoods", ds, 0);
}
catch (Exception err)
{ err.GetBaseException(); }
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("RP");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("rptProductionReport", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
catch (Exception err)
{ err.GetBaseException(); }
clear();
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (txtAmount.Text == "" && cmbCustomerName.SelectedIndex == 0)
{
if (optDatewise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
//para_value.Add(dtpFromDate.Value.ToString("MM/dd/yyyy"));
//para_value.Add(dtpToDate.Value.ToString("MM/dd/yyyy"));
para_value.Add("SR");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptPendingInvoice", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
}
else if (cmbCustomerName.SelectedIndex == 0)
{
if (optAmountwise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(txtAmount.Text);
//para_value.Add(dtpFromDate.Value.ToString("MM/dd/yyyy"));
//para_value.Add(dtpToDate.Value.ToString("MM/dd/yyyy"));
para_value.Add("AA");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptPendingInvoice", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
}
else if (txtAmount.Text == "")
{
if (optCustomerwise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Customer_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(cmbCustomerName.SelectedValue.ToString());
//para_value.Add(dtpFromDate.Value.ToString("MM/dd/yyyy"));
//para_value.Add(dtpToDate.Value.ToString("MM/dd/yyyy"));
para_value.Add("PC"); // PC - Pending Invoice Customerwise
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptPendingInvoiceCustomerwise", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
}
else
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Customer_Id");
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(cmbCustomerName.SelectedValue.ToString());
para_value.Add(txtAmount.Text);
//para_value.Add(dtpFromDate.Value.ToString("MM/dd/yyyy"));
//para_value.Add(dtpToDate.Value.ToString("MM/dd/yyyy"));
para_value.Add("CA");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptPendingInvoice", ds, 1, dtpFromDate.Value, dtpToDate.Value);
}
}
catch (Exception err)
{
err.GetBaseException();
}
clear();
}