/// <summary> /// GetForTaxAndDate /// Calls [usp_select_TaxRate_for_Tax_and_Date] /// </summary> public override TaxRateDetails GetForTaxAndDate(System.Int32?taxNo, System.Int32?clientNo, System.DateTime?taxPoint) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_TaxRate_for_Tax_and_Date", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@TaxNo", SqlDbType.Int).Value = taxNo; cmd.Parameters.Add("@ClientNo", SqlDbType.Int).Value = clientNo; cmd.Parameters.Add("@TaxPoint", SqlDbType.DateTime).Value = taxPoint; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetTaxRateFromReader(reader); TaxRateDetails obj = new TaxRateDetails(); obj.CurrentTaxRate = GetReaderValue_NullableDouble(reader, "CurrentTaxRate", null); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get TaxRate", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
private static TaxRate PopulateFromDBDetailsObject(TaxRateDetails obj) { TaxRate objNew = new TaxRate(); objNew.TaxRateId = obj.TaxRateId; objNew.TaxDate = obj.TaxDate; objNew.TaxNo = obj.TaxNo; objNew.Rate1 = obj.Rate1; objNew.Rate2 = obj.Rate2; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; objNew.CurrentTaxRate = obj.CurrentTaxRate; return(objNew); }
[TestMethod][Ignore]//change to request and response format as json and then run this test public void TaxCodeAddTestUsingoAuth() { String guid = Helper.GetGuid(); GlobalTaxService.GlobalTaxService taxSvc = new GlobalTaxService.GlobalTaxService(qboContextoAuth); Intuit.Ipp.Data.TaxService taxCodetobeAdded = new Data.TaxService(); taxCodetobeAdded.TaxCode = "taxC_" + guid; TaxAgency taxagency = Helper.FindOrAdd <TaxAgency>(qboContextoAuth, new TaxAgency()); List <TaxRateDetails> lstTaxRate = new List <TaxRateDetails>(); TaxRateDetails taxdetail1 = new TaxRateDetails(); taxdetail1.TaxRateName = "taxR1_" + guid; taxdetail1.RateValue = 3m; taxdetail1.RateValueSpecified = true; taxdetail1.TaxAgencyId = taxagency.Id.ToString(); taxdetail1.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; taxdetail1.TaxApplicableOnSpecified = true; lstTaxRate.Add(taxdetail1); TaxRateDetails taxdetail2 = new TaxRateDetails(); taxdetail2.TaxRateName = "taxR2_" + guid; taxdetail2.RateValue = 2m; taxdetail2.RateValueSpecified = true; taxdetail2.TaxAgencyId = taxagency.Id.ToString(); taxdetail2.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; taxdetail2.TaxApplicableOnSpecified = true; lstTaxRate.Add(taxdetail2); //TaxRateDetails taxdetail3 = new TaxRateDetails(); //taxdetail3.TaxRateName = "rate298"; //taxdetail3.TaxRateId = "2"; //lstTaxRate.Add(taxdetail3); taxCodetobeAdded.TaxRateDetails = lstTaxRate.ToArray(); Intuit.Ipp.Data.TaxService taxCodeAdded = taxSvc.AddTaxCode(taxCodetobeAdded); Assert.IsNotNull(taxCodeAdded.TaxCodeId); }
/// <summary> /// Get /// Calls [usp_select_TaxRate] /// </summary> public override TaxRateDetails Get(System.Int32?taxRateId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_TaxRate", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@TaxRateId", SqlDbType.Int).Value = taxRateId; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetTaxRateFromReader(reader); TaxRateDetails obj = new TaxRateDetails(); obj.TaxRateId = GetReaderValue_Int32(reader, "TaxRateId", 0); obj.TaxDate = GetReaderValue_DateTime(reader, "TaxDate", DateTime.MinValue); obj.TaxNo = GetReaderValue_Int32(reader, "TaxNo", 0); obj.Rate1 = GetReaderValue_NullableDouble(reader, "Rate1", null); obj.Rate2 = GetReaderValue_NullableDouble(reader, "Rate2", null); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get TaxRate", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// GetListForTax /// Calls [usp_selectAll_TaxRate_for_Tax] /// </summary> public override List <TaxRateDetails> GetListForTax(System.Int32?taxId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_selectAll_TaxRate_for_Tax", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@TaxId", SqlDbType.Int).Value = taxId; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <TaxRateDetails> lst = new List <TaxRateDetails>(); while (reader.Read()) { TaxRateDetails obj = new TaxRateDetails(); obj.TaxRateId = GetReaderValue_Int32(reader, "TaxRateId", 0); obj.TaxDate = GetReaderValue_DateTime(reader, "TaxDate", DateTime.MinValue); obj.TaxNo = GetReaderValue_Int32(reader, "TaxNo", 0); obj.Rate1 = GetReaderValue_NullableDouble(reader, "Rate1", null); obj.Rate2 = GetReaderValue_NullableDouble(reader, "Rate2", null); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get TaxRates", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
public void AddTaxCodeSyncTest() { try { //GlobalTaxService taxSvc = new GlobalTaxService(context); //Intuit.Ipp.Data.TaxService taxCodetobeAdded = new Data.TaxService(); //taxCodetobeAdded.TaxCode = "taxservic294"; //List<TaxRateDetails> lstTaxRate = new List<TaxRateDetails>(); //TaxRateDetails taxdetail1 = new TaxRateDetails(); //taxdetail1.TaxRateName = "rat296"; //taxdetail1.RateValue = 3m; //taxdetail1.RateValueSpecified = true; //taxdetail1.TaxAgencyId = "1"; //taxdetail1.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; //taxdetail1.TaxApplicableOnSpecified = true; //lstTaxRate.Add(taxdetail1); //TaxRateDetails taxdetail2 = new TaxRateDetails(); //taxdetail2.TaxRateName = "rate297"; //taxdetail2.RateValue = 2m; //taxdetail2.RateValueSpecified = true; //taxdetail2.TaxAgencyId = "1"; //taxdetail2.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; //taxdetail2.TaxApplicableOnSpecified = true; //lstTaxRate.Add(taxdetail2); //TaxRateDetails taxdetail3 = new TaxRateDetails(); //taxdetail3.TaxRateName = "rate298"; //taxdetail3.TaxRateId = "2"; //lstTaxRate.Add(taxdetail3); //taxCodetobeAdded.TaxRateDetails = lstTaxRate.ToArray(); //Intuit.Ipp.Data.TaxService taxCodeAdded = taxSvc.AddTaxCode(taxCodetobeAdded); //Assert.IsNotNull(taxCodeAdded.TaxCodeId); //GlobalTaxService taxSvc = new GlobalTaxService(context); //Intuit.Ipp.Data.TaxService taxCodetobeAdded = new Data.TaxService(); //taxCodetobeAdded.TaxCode = "taxservic296";//change name everytime //List<TaxRateDetails> lstTaxRate = new List<TaxRateDetails>(); //TaxRateDetails taxdetail1 = new TaxRateDetails(); //taxdetail1.TaxRateId = "30"; //lstTaxRate.Add(taxdetail1); //taxCodetobeAdded.TaxRateDetails = lstTaxRate.ToArray(); //Intuit.Ipp.Data.TaxService taxCodeAdded = taxSvc.AddTaxCode(taxCodetobeAdded); GlobalTaxService taxSvc = new GlobalTaxService(context); Intuit.Ipp.Data.TaxService taxCodetobeAdded = new Data.TaxService(); taxCodetobeAdded.TaxCode = "taxC_" + Guid.NewGuid().ToString("N"); QueryService <TaxAgency> taxagency = new QueryService <TaxAgency>(context); TaxAgency taxagencyResult = taxagency.ExecuteIdsQuery("select * from TaxAgency").FirstOrDefault <TaxAgency>(); List <TaxRateDetails> lstTaxRate = new List <TaxRateDetails>(); TaxRateDetails taxdetail1 = new TaxRateDetails(); taxdetail1.TaxRateName = "taxR1_" + Guid.NewGuid().ToString("N"); taxdetail1.RateValue = 3m; taxdetail1.RateValueSpecified = true; taxdetail1.TaxAgencyId = taxagencyResult.Id.ToString(); taxdetail1.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; taxdetail1.TaxApplicableOnSpecified = true; lstTaxRate.Add(taxdetail1); TaxRateDetails taxdetail2 = new TaxRateDetails(); taxdetail2.TaxRateName = "taxR2_" + Guid.NewGuid().ToString("N"); taxdetail2.RateValue = 2m; taxdetail2.RateValueSpecified = true; taxdetail2.TaxAgencyId = taxagencyResult.Id.ToString(); taxdetail2.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; taxdetail2.TaxApplicableOnSpecified = true; lstTaxRate.Add(taxdetail2); //TaxRateDetails taxdetail3 = new TaxRateDetails(); //taxdetail3.TaxRateName = "rate298"; //taxdetail3.TaxRateId = "2"; //lstTaxRate.Add(taxdetail3); taxCodetobeAdded.TaxRateDetails = lstTaxRate.ToArray(); Intuit.Ipp.Data.TaxService taxCodeAdded = taxSvc.AddTaxCode(taxCodetobeAdded); Assert.IsNotNull(taxCodeAdded.TaxCodeId); } catch (System.Exception ex) { Assert.Fail(ex.ToString()); } }
public void AddTaxCodeAsyncTest() { //GlobalTaxService taxSvc = new GlobalTaxService(context); //Intuit.Ipp.Data.TaxService taxCodetobeAdded = new Data.TaxService(); //taxCodetobeAdded.TaxCode = "taxservicetax428"; //List<TaxRateDetails> lstTaxRate = new List<TaxRateDetails>(); //TaxRateDetails taxdetail1 = new TaxRateDetails(); //taxdetail1.TaxRateName = "rate2419"; //taxdetail1.RateValue = 3m; //taxdetail1.RateValueSpecified = true; //taxdetail1.TaxAgencyId = "1"; //taxdetail1.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; //taxdetail1.TaxApplicableOnSpecified = true; //lstTaxRate.Add(taxdetail1); //TaxRateDetails taxdetail2 = new TaxRateDetails(); //taxdetail2.TaxRateName = "rate2429"; //taxdetail2.RateValue = 2m; //taxdetail2.RateValueSpecified = true; //taxdetail2.TaxAgencyId = "1"; //taxdetail2.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; //taxdetail2.TaxApplicableOnSpecified = true; //lstTaxRate.Add(taxdetail2); ////TaxRateDetails taxdetail3 = new TaxRateDetails(); ////taxdetail3.TaxRateName = "rate3"; ////taxdetail3.TaxRateId = "2"; ////lstTaxRate.Add(taxdetail3); //taxCodetobeAdded.TaxRateDetails = lstTaxRate.ToArray(); GlobalTaxService taxSvc = new GlobalTaxService(context); Intuit.Ipp.Data.TaxService taxCodetobeAdded = new Data.TaxService(); taxCodetobeAdded.TaxCode = "taxC_" + Guid.NewGuid().ToString("N"); QueryService <TaxAgency> taxagency = new QueryService <TaxAgency>(context); TaxAgency taxagencyResult = taxagency.ExecuteIdsQuery("select * from TaxAgency").FirstOrDefault <TaxAgency>(); List <TaxRateDetails> lstTaxRate = new List <TaxRateDetails>(); TaxRateDetails taxdetail1 = new TaxRateDetails(); taxdetail1.TaxRateName = "taxR1_" + Guid.NewGuid().ToString("N"); taxdetail1.RateValue = 3m; taxdetail1.RateValueSpecified = true; taxdetail1.TaxAgencyId = taxagencyResult.Id.ToString(); taxdetail1.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; taxdetail1.TaxApplicableOnSpecified = true; lstTaxRate.Add(taxdetail1); TaxRateDetails taxdetail2 = new TaxRateDetails(); taxdetail2.TaxRateName = "taxR2_" + Guid.NewGuid().ToString("N"); taxdetail2.RateValue = 2m; taxdetail2.RateValueSpecified = true; taxdetail2.TaxAgencyId = taxagencyResult.Id.ToString(); taxdetail2.TaxApplicableOn = TaxRateApplicableOnEnum.Sales; taxdetail2.TaxApplicableOnSpecified = true; lstTaxRate.Add(taxdetail2); //TaxRateDetails taxdetail3 = new TaxRateDetails(); //taxdetail3.TaxRateName = "rate298"; //taxdetail3.TaxRateId = "2"; //lstTaxRate.Add(taxdetail3); taxCodetobeAdded.TaxRateDetails = lstTaxRate.ToArray(); try { ManualResetEvent manualEvent = new ManualResetEvent(false); taxSvc.OnAddTaxCodeAsyncCompleted = (sender, e) => { Assert.IsNotNull(e); Intuit.Ipp.Data.TaxService addedTaxCode = e.TaxService; Assert.IsTrue(!string.IsNullOrEmpty(addedTaxCode.TaxCodeId)); manualEvent.Set(); }; taxSvc.AddTaxCodeAsync(taxCodetobeAdded); manualEvent.WaitOne(30000); } catch (System.Exception ex) { Assert.Fail(ex.ToString()); } }