public static DataSet RetrieveDetail(IInvoiceTax invoice)
{
SqlParameter[] _parameters =
{
new SqlParameter("@InvoiceNo", invoice.InvoiceNumber)
};
return(SqlHelper.ExecuteDataset(ConnectionString, "sp_InvoicesTax_DetailLists", _parameters));
}
public static Int32 Update(IInvoiceTax invoice)
{
SqlParameter[] _parameters =
{
new SqlParameter("@InvoiceNumber", invoice.InvoiceNumber)
, new SqlParameter("@SerialNumber", invoice.SerialNumber)
, new SqlParameter("@InvoiceDate", invoice.InvoiceDate)
};
return(SqlHelper.ExecuteNonQuery(ConnectionString, "sp_InvoicesTax_Allocated_Update", _parameters));
}
public static DataSet RetrieveAll(IInvoiceTax invoice)
{
SqlParameter[] _parameters =
{
new SqlParameter("@InvoiceNo", invoice.InvoiceNumber)
, new SqlParameter("@CustomerCode", invoice.CustomerCode)
, new SqlParameter("@CustomerName", invoice.CustomerName)
, new SqlParameter("@FromInvoiceDate", invoice.FromInvoiceDate)
, new SqlParameter("@ToInvoiceDate", invoice.ToInvoiceDate)
};
return(SqlHelper.ExecuteDataset(ConnectionString, "sp_InvoicesTax_Lists", _parameters));
}
