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)); }