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