public List <PurchaseOrderTaxDetail> Search() { List <PurchaseOrderTaxDetail> purchaseOrderTaxList = new List <PurchaseOrderTaxDetail>(); System.Data.DataTable dTable = new DataTable(); try { string errorMessage = string.Empty; dTable = GetSelectedRecords(Common.ToXml(this), SP_POTAXDETAIL_SEARCH, ref errorMessage); if (dTable != null) { foreach (System.Data.DataRow drow in dTable.Rows) { PurchaseOrderTaxDetail _purchase = CreateTaxDetailObject(drow); purchaseOrderTaxList.Add(_purchase); } } } catch (Exception ex) { throw ex; } return(purchaseOrderTaxList); }
public List <PurchaseOrderTaxDetail> GetTaxDetail() { try { PurchaseOrderTaxDetail _tax = new PurchaseOrderTaxDetail(); _tax.PONumber = PONumber; _tax.AmendmentNo = AmendmentNo; _tax.ItemID = ItemID; return(_tax.Search()); } catch (Exception ex) { throw ex; } }
private void GetTaxes(string sVendorCode, string sLocationCode) { try { string errorMessage = string.Empty; string validationMessage = string.Empty; //TaxGroup tg = TaxApplication.GetApplicableTaxes(ItemID, "", m_fromStateId, m_toStateId, // Tax.TaxType.SOTAX.ToString(), "", m_isFormCApplicable, ref errorMessage, // ref validationMessage, sVendorCode, sLocationCode); TaxGroup tg = TaxApplication.GetApplicableTaxes(ItemID, "", m_fromStateId, m_toStateId, Tax.TaxType.POTAX.ToString(), "", m_isFormCApplicable, ref errorMessage, ref validationMessage, sVendorCode, sLocationCode); if (string.IsNullOrEmpty(errorMessage)) { //If no error message then process data if (tg != null && !(string.IsNullOrEmpty(tg.TaxGroupCode) && tg.TaxCodeList != null && tg.TaxCodeList.Count > 0)) { this.TaxGroupCode = tg.TaxGroupCode; this.PurchaseOrderTaxDetail = new List <PurchaseOrderTaxDetail>(); int rowno = 1; for (int i = 0; i < tg.TaxCodeList.Count; i++) { PurchaseOrderTaxDetail potd = new PurchaseOrderTaxDetail(); potd.TaxCode = tg.TaxCodeList[i].TaxCode; potd.TaxPercentage = tg.TaxCodeList[i].TaxPercent; potd.GroupOrder = tg.TaxCodeList[i].GroupOrder; potd.ItemID = ItemID; potd.Direction = (int)Tax.TaxDirection.In; potd.TaxGroup = tg.TaxGroupCode; potd.PONumber = PONumber; potd.RowNo = rowno++; potd.IsInclusive = tg.TaxCodeList[i].IsInclusive; this.PurchaseOrderTaxDetail.Add(potd); this.IsInclusive = potd.IsInclusive; } } } else { //Log error //Show message } } catch (Exception ex) { throw ex; } }
public static PurchaseOrderTaxDetail CreateTaxDetailObject(DataRow drow) { try { PurchaseOrderTaxDetail _purchase = new PurchaseOrderTaxDetail(); if (drow.Table.Columns.Contains(CON_FIELD_PONUMBER)) { _purchase.PONumber = Convert.ToString(drow[CON_FIELD_PONUMBER]); } if (drow.Table.Columns.Contains(CON_FIELD_ITEMID)) { _purchase.ItemID = Convert.ToInt32(drow[CON_FIELD_ITEMID]); } if (drow.Table.Columns.Contains(CON_FIELD_ROWNO)) { _purchase.RowNo = Convert.ToInt32(drow[CON_FIELD_ROWNO]); } if (drow.Table.Columns.Contains(CON_FIELD_AMENDMENTNO)) { _purchase.AmendmentNo = Convert.ToInt32(drow[CON_FIELD_AMENDMENTNO]); } if (drow.Table.Columns.Contains(CON_FIELD_TAXCODE)) { _purchase.TaxCode = Convert.ToString(drow[CON_FIELD_TAXCODE]); } if (drow.Table.Columns.Contains(CON_FIELD_TAXPERCENT)) { _purchase.TaxPercentage = Convert.ToDecimal(drow[CON_FIELD_TAXPERCENT]); } if (drow.Table.Columns.Contains(CON_FIELD_TAXGROUPCODE)) { _purchase.TaxGroup = Convert.ToString(drow[CON_FIELD_TAXGROUPCODE]); } if (drow.Table.Columns.Contains(CON_FIELD_TAXAMOUNT)) { _purchase.TaxAmount = Convert.ToDecimal(drow[CON_FIELD_TAXAMOUNT]); } if (drow.Table.Columns.Contains(CON_FIELD_GROUPORDER)) { _purchase.GroupOrder = Convert.ToInt32(drow[CON_FIELD_GROUPORDER]); } if (drow.Table.Columns.Contains(CON_FIELD_CREATEDBY)) { _purchase.CreatedBy = Convert.ToInt32(drow[CON_FIELD_CREATEDBY]); } if (drow.Table.Columns.Contains(CON_FIELD_CREATEDDATE)) { _purchase.CreatedDate = Convert.ToDateTime(drow[CON_FIELD_CREATEDDATE]); } if (drow.Table.Columns.Contains(CON_FIELD_MODIFIEDBY)) { _purchase.ModifiedBy = Convert.ToInt32(drow[CON_FIELD_MODIFIEDBY]); } if (drow.Table.Columns.Contains(CON_FIELD_MODIFIEDDATE)) { _purchase.ModifiedDate = Convert.ToDateTime(drow[CON_FIELD_MODIFIEDDATE]); } return(_purchase); } catch (Exception ex) { throw ex; } }