internal DataTable BindMultiInvoice(PL_MultiInvoice plobjMultiInvoice) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPSearchUtility"; ClsCon.cmd.Parameters.AddWithValue("@Ind", plobjMultiInvoice.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", plobjMultiInvoice.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", plobjMultiInvoice.BrID); ClsCon.cmd.Parameters.AddWithValue("@DocNo", plobjMultiInvoice.InvoiceNo); ClsCon.cmd.Parameters.AddWithValue("@DocDateFrom", plobjMultiInvoice.InvoiceDateFrom); ClsCon.cmd.Parameters.AddWithValue("@DocDateTo", plobjMultiInvoice.InvoiceDateTo); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtMultiInvoice = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtMultiInvoice); dtMultiInvoice.TableName = "success"; } catch (Exception) { dtMultiInvoice = new DataTable(); dtMultiInvoice.TableName = "error"; return(dtMultiInvoice); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtMultiInvoice); }
public DataTable Method_MultiInvoice(PL_MultiInvoice plobjMultiInvoice) { DataTable dtMultiInvoice = dlobjMultiInvoice.BindMultiInvoice(plobjMultiInvoice); return(dtMultiInvoice); }