internal DataTable GetShowData(DuplicateInvoiceModel objDupInvoicePl)
 {
     try
     {
         ClsCon.cmd             = new SqlCommand();
         ClsCon.cmd.CommandType = CommandType.StoredProcedure;
         ClsCon.cmd.CommandText = "SpDupInvoice";
         ClsCon.cmd.Parameters.AddWithValue("@Ind", objDupInvoicePl.Ind);
         ClsCon.cmd.Parameters.AddWithValue("@OrgID", objDupInvoicePl.OrgID);
         ClsCon.cmd.Parameters.AddWithValue("@DocTypeId", objDupInvoicePl.VoucherType);
         ClsCon.cmd.Parameters.AddWithValue("@IstDate", objDupInvoicePl.IstDate);
         ClsCon.cmd.Parameters.AddWithValue("@LastDate", objDupInvoicePl.LastDate);
         con = ClsCon.SqlConn();
         ClsCon.cmd.Connection = con;
         dtDupInvoice          = new DataTable();
         ClsCon.da             = new SqlDataAdapter(ClsCon.cmd);
         ClsCon.da.Fill(dtDupInvoice);
         dtDupInvoice.TableName = "success";
     }
     catch (Exception ex)
     {
         dtDupInvoice           = new DataTable();
         dtDupInvoice.TableName = "Error";
         return(dtDupInvoice);
     }
     finally
     {
         con.Close();
         con.Dispose();
         ClsCon.da.Dispose();
         ClsCon.cmd.Dispose();
     }
     return(dtDupInvoice);
 }
示例#2
0
        public DataTable ShowData(DuplicateInvoiceModel objDupInvoicePl)
        {
            DataTable DupInvoiceList = ObjDupInvoiceDA.GetShowData(objDupInvoicePl);

            return(DupInvoiceList);
        }
示例#3
0
        public DataTable LoadGetDate(DuplicateInvoiceModel objDupInvoicePl)
        {
            DataTable DupInvoiceList = ObjDupInvoiceDA.GetDate(objDupInvoicePl);

            return(DupInvoiceList);
        }