/// <summary> /// Method to load GST exempt /// </summary> /// <param name="taxExemptSale">Tax exempt sale</param> /// <param name="sn">Sale number</param> /// <param name="tillId">Till number</param> /// <param name="db">Data source</param> /// <returns>True or false</returns> public bool LoadGstExempt(ref TaxExemptSale taxExemptSale, int sn, byte tillId, DataSource db) { var rsLine = GetRecords("select * from SALELINE " + " where SALE_NO=" + Convert.ToString(sn) + " AND TILL_NUM=" + Convert.ToString(tillId), db); if (rsLine.Rows.Count == 0) { return(false); } foreach (DataRow line in rsLine.Rows) { var rsTaxCreditLine = GetRecords("SELECT * from TaxCreditLine where TILL_NUM=" + Convert.ToString(tillId) + " AND SALE_NO=" + Convert.ToString(sn) + " AND Line_No=" + Convert.ToString(line["Line_Num"]), db); if (rsTaxCreditLine.Rows.Count == 0) { continue; } var tx = new TaxCreditLine { Line_Num = CommonUtility.GetShortValue(line["Line_Num"]) }; foreach (DataRow taxCreditLine in rsTaxCreditLine.Rows) { var lt = new Line_Tax { Tax_Name = CommonUtility.GetStringValue(taxCreditLine["Tax_Name"]), Tax_Code = CommonUtility.GetStringValue(taxCreditLine["Tax_Code"]), Tax_Rate = CommonUtility.GetFloatValue(taxCreditLine["Tax_Rate"]), Tax_Included = CommonUtility.GetBooleanValue(taxCreditLine["Tax_Included"]), Tax_Added_Amount = CommonUtility.GetFloatValue(taxCreditLine["Tax_Added_Amount"]), Tax_Incl_Amount = CommonUtility.GetFloatValue(taxCreditLine["Tax_Included_Amount"]) }; tx.Line_Taxes.AddTaxLine(lt, ""); } taxExemptSale.TaxCreditLines.AddLine(tx.Line_Num, tx, ""); } var rsTaxCredit = GetRecords("SELECT * from TaxCredit where TILL_NUM=" + Convert.ToString(tillId) + " AND SALE_NO=" + Convert.ToString(sn), db); foreach (DataRow taxCredit in rsTaxCredit.Rows) { var sx = new Sale_Tax { Tax_Name = CommonUtility.GetStringValue(taxCredit["Tax_Name"]), Tax_Code = CommonUtility.GetStringValue(taxCredit["Tax_Code"]), Tax_Rate = CommonUtility.GetFloatValue(taxCredit["Tax_Rate"]), Taxable_Amount = CommonUtility.GetDecimalValue(taxCredit["Taxable_Amount"]), Tax_Added_Amount = CommonUtility.GetDecimalValue(taxCredit["Tax_Added_Amount"]), Tax_Included_Amount = CommonUtility.GetDecimalValue(taxCredit["Tax_Included_Amount"]), Tax_Included_Total = CommonUtility.GetDecimalValue(taxCredit["Tax_Included_Total"]) }; taxExemptSale.TaxCredit.Add(sx.Tax_Name, sx.Tax_Code, sx.Tax_Rate, sx.Taxable_Amount, sx.Tax_Added_Amount, sx.Tax_Included_Amount, sx.Tax_Included_Amount, sx.Tax_Rebate_Rate, sx.Tax_Rebate, sx.Tax_Name + sx.Tax_Code); // - gave mismatch type error for AITE } return(true); }
/// <summary> /// Get Sale_tax Test Data /// </summary> /// <returns></returns> private List <Sale_Tax> GetSaleTaxTestData() { var taxes = new List <Sale_Tax>(); var tax1 = new Sale_Tax { Tax_Name = "PST", Tax_Code = "1", Tax_Rate = 10, Tax_Included = true, }; var tax2 = new Sale_Tax { Tax_Name = "HST", Tax_Code = "2", Tax_Rate = 20, Tax_Included = false, }; taxes.Add(tax1); taxes.Add(tax2); return(taxes); }