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