public static List<InvoiceDetailsInfo> GetInvoiceDetailsList(int offset, System.Nullable<int> limit, InvoiceBasicInfo invoiceObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<InvoiceDetailsInfo> lstInvoiceDetail = AspxInvoiceMgntProvider.GetInvoiceDetailsList(offset, limit, invoiceObj, aspxCommonObj);
return lstInvoiceDetail;
}
catch (Exception e)
{
throw e;
}
}
public static List<InvoiceDetailsInfo> GetInvoiceDetailsList(int offset, System.Nullable<int> limit, InvoiceBasicInfo invoiceObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@offset", offset));
parameter.Add(new KeyValuePair<string, object>("@limit", limit));
parameter.Add(new KeyValuePair<string, object>("@InvoiceNumber", invoiceObj.InvoiceNumber));
parameter.Add(new KeyValuePair<string, object>("@BillToName", invoiceObj.BillToName));
parameter.Add(new KeyValuePair<string, object>("@OrderStatusID", invoiceObj.OrderStatusName));
SQLHandler sqlH = new SQLHandler();
List<InvoiceDetailsInfo> lstInvoiceDetail = sqlH.ExecuteAsList<InvoiceDetailsInfo>("usp_Aspx_GetInvoiceDetails", parameter);
return lstInvoiceDetail;
}
catch (Exception e)
{
throw e;
}
}
public static List <InvoiceDetailsInfo> GetInvoiceDetailsList(int offset, System.Nullable <int> limit, InvoiceBasicInfo invoiceObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <InvoiceDetailsInfo> lstInvoiceDetail = AspxInvoiceMgntProvider.GetInvoiceDetailsList(offset, limit, invoiceObj, aspxCommonObj);
return(lstInvoiceDetail);
}
catch (Exception e)
{
throw e;
}
}
public static List <InvoiceDetailsInfo> GetInvoiceDetailsList(int offset, System.Nullable <int> limit, InvoiceBasicInfo invoiceObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
parameter.Add(new KeyValuePair <string, object>("@InvoiceNumber", invoiceObj.InvoiceNumber));
parameter.Add(new KeyValuePair <string, object>("@BillToName", invoiceObj.BillToName));
parameter.Add(new KeyValuePair <string, object>("@OrderStatusID", invoiceObj.OrderStatusName));
SQLHandler sqlH = new SQLHandler();
List <InvoiceDetailsInfo> lstInvoiceDetail = sqlH.ExecuteAsList <InvoiceDetailsInfo>("usp_Aspx_GetInvoiceDetails", parameter);
return(lstInvoiceDetail);
}
catch (Exception e)
{
throw e;
}
}
