public List <DataTable> SalesInvoiceReportFill(DateTime dtfromDate, DateTime dttoDate, decimal decVoucherTypeId, decimal decLedgerId, decimal decAreaId, string strSalesMode, decimal decEmployeeId, string strProductName, string strVoucherNo, string strstatus, decimal decRouteId, decimal decModelNoId, string strProductCode)
{
List <DataTable> listObj = new List <DataTable>();
try
{
listObj = SPSalesMaster.SalesInvoiceReportFill(dtfromDate, dttoDate, decVoucherTypeId, decLedgerId, decAreaId, strSalesMode, decEmployeeId, strProductName, strVoucherNo, strstatus, decRouteId, decModelNoId, strProductCode);
}
catch (Exception ex)
{
MessageBox.Show("PBBLL:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(listObj);
}
/// <summary>
/// Function to fill datagridview
/// </summary>
public void gridFill()
{
try
{
decimal decVoucherTypeId = 0;
decimal decLedgerId = 0;
decimal decRouteId = 0;
decimal decAreaId = 0;
decimal decEmployeeId = 0;
decimal decModelNo = 0;
string strStatus = string.Empty;
string strProductName = string.Empty;
string strProductCode = string.Empty;
string strVoucherNo = string.Empty;
string strSalesMode = string.Empty;
DateTime dtFromdate = this.dtpFrmDate.Value;
DateTime dtTodate = this.dtpToDate.Value;
if (cmbVoucherType.SelectedIndex > -1)
{
if (cmbVoucherType.SelectedValue.ToString() != "System.Data.DataRowView" && cmbVoucherType.Text != "System.Data.DataRowView")
{
if (cmbVoucherType.SelectedIndex == 0 || cmbVoucherType.SelectedIndex == -1)
{
decVoucherTypeId = 0;
}
else
{
decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
}
}
}
if (cmbCashOrParty.SelectedIndex > -1)
{
if (cmbCashOrParty.SelectedValue.ToString() != "System.Data.DataRowView" && cmbCashOrParty.Text != "System.Data.DataRowView")
{
if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1)
{
decLedgerId = 0;
}
else
{
decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
}
}
}
if (cmbArea.SelectedIndex > -1)
{
if (cmbArea.SelectedValue.ToString() != "System.Data.DataRowView" && cmbArea.Text != "System.Data.DataRowView")
{
if (cmbArea.SelectedIndex == 0 || cmbArea.SelectedIndex == -1)
{
decAreaId = 0;
}
else
{
decAreaId = Convert.ToDecimal(cmbArea.SelectedValue.ToString());
}
}
}
if (cmbSalesMan.SelectedIndex > -1)
{
if (cmbSalesMan.SelectedValue.ToString() != "System.Data.DataRowView" && cmbSalesMan.Text != "System.Data.DataRowView")
{
if (cmbSalesMan.SelectedIndex == 0 || cmbSalesMan.SelectedIndex == -1)
{
decEmployeeId = 0;
}
else
{
decEmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
}
}
if (cmbRoute.SelectedIndex > -1)
{
if (cmbRoute.SelectedValue.ToString() != "System.Data.DataRowView" && cmbRoute.Text != "System.Data.DataRowView")
{
if (cmbRoute.SelectedIndex == 0 || cmbRoute.SelectedIndex == -1)
{
decRouteId = 0;
}
else
{
decRouteId = Convert.ToDecimal(cmbRoute.SelectedValue.ToString());
}
}
}
if (cmbModelNo.SelectedIndex > -1)
{
if (cmbModelNo.SelectedValue.ToString() != "System.Data.DataRowView" && cmbRoute.Text != "System.Data.DataRowView")
{
if (cmbModelNo.SelectedIndex == 0 || cmbModelNo.SelectedIndex == -1)
{
decModelNo = 0;
}
else
{
decModelNo = Convert.ToDecimal(cmbModelNo.SelectedValue.ToString());
}
}
}
if (txtVoucherNo.Text == "")
{
strVoucherNo = string.Empty;
}
else
{
strVoucherNo = txtVoucherNo.Text;
}
if (txtProductCode.Text == "")
{
strProductCode = string.Empty;
}
else
{
strProductCode = txtProductCode.Text;
}
if (txtProductName.Text == "")
{
strProductName = string.Empty;
}
else
{
strProductName = txtProductName.Text;
}
if (cmbSalesMode.SelectedIndex == 0 || cmbSalesMode.SelectedIndex == -1)
{
strSalesMode = "All";
}
else
{
strSalesMode = cmbSalesMode.Text;
}
if (cmbStatus.SelectedIndex == 0 || cmbStatus.SelectedIndex == -1)
{
strStatus = "All";
}
else
{
strStatus = cmbStatus.Text;
}
DataTable dtbl = new DataTable();
dtbl = spSalesMaster.SalesInvoiceReportFill(dtFromdate, dtTodate, decVoucherTypeId, decLedgerId, decAreaId, strSalesMode, decEmployeeId, strProductName, strVoucherNo, strStatus, decRouteId, decModelNo, strProductCode);
dgvSIReport.DataSource = dtbl;
}
catch (Exception ex)
{
MessageBox.Show("SIRPT: 08" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}