public static TaxGroup GetApplicableTaxes(int itemId, string itemCode, int fromStateId,
int toStateId, string taxTypeCode, string Date, bool IsFormCApplicable, ref string errorMessage,
ref string validationMessage, string sVendorCode, string sLocationCode)
{
DBParameterList dbParam = null;
try
{
TaxGroup returnTaxGroup = null;
dbParam = new DBParameterList();
dbParam.Add(new DBParameter("@itemId", itemId, DbType.Int16));
dbParam.Add(new DBParameter("@itemCode", itemCode, DbType.String));
dbParam.Add(new DBParameter("@fromStateID", fromStateId, DbType.Int16));
dbParam.Add(new DBParameter("@tostateID", toStateId, DbType.Int16));
dbParam.Add(new DBParameter("@TaxTypeCode", taxTypeCode, DbType.String));
dbParam.Add(new DBParameter("@Date", Date, DbType.String));
dbParam.Add(new DBParameter("@IsFormC", IsFormCApplicable, DbType.Boolean));
dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH));
dbParam.Add(new DBParameter("@validationMessage", string.Empty, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH));
dbParam.Add(new DBParameter("@vendorCode", sVendorCode, DbType.Int32));
dbParam.Add(new DBParameter("@locationCode", sLocationCode, DbType.Int32));
DataTaskManager dtManager = new DataTaskManager();
// executing procedure to save the record
DataTable dt = dtManager.ExecuteDataTable(sp_GetTaxGroup, dbParam);
errorMessage = dbParam[Common.PARAM_OUTPUT].Value.ToString();
//If no error then process data
validationMessage = dbParam["@validationMessage"].Value.ToString();
if (!string.IsNullOrEmpty(validationMessage))
{
return(null);
}
if (string.IsNullOrEmpty(errorMessage) && dt != null)
{
int rowCount = dt.Rows.Count;
for (int i = 0; i < rowCount; i++)
{
if (i == 0)
{
returnTaxGroup = new TaxGroup();
returnTaxGroup.TaxGroupId = Convert.ToInt32(dt.Rows[i]["TaxGroupId"]);
returnTaxGroup.TaxGroupCode = dt.Rows[i]["TaxGroupCode"].ToString();
returnTaxGroup.TaxCodeList = new List <TaxDetail>();
}
TaxDetail taxCode = new TaxDetail();
taxCode.TaxCode = dt.Rows[i]["TaxCode"].ToString();
taxCode.TaxCodeId = Convert.ToInt32(dt.Rows[i]["TaxCodeId"]);
taxCode.TaxPercent = Convert.ToDecimal(dt.Rows[i]["TaxPercent"]);
taxCode.GroupOrder = Convert.ToInt32(dt.Rows[i]["GroupOrder"]);
taxCode.IsInclusive = Convert.ToBoolean(dt.Rows[i]["IsInclusive"]);
returnTaxGroup.TaxCodeList.Add(taxCode);
}
}
return(returnTaxGroup);;
}
catch { throw; }
}
/// <summary>
/// Search Tax Group
/// </summary>
/// <param name="errorMsg"></param>
/// <returns>List</returns>
public List <TaxGroup> SearchTaxGroup(ref string errorMsg)
{
List <TaxGroup> listTaxGroup = new List <TaxGroup>();
try
{
String xmlDoc = Common.ToXml(this);
DataTable dt = base.GetSelectedRecords(xmlDoc, SP_TAXGROUP_SEARCH, ref errorMsg);
if (errorMsg.Trim().Length == 0)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TaxGroup taxGroupObj = new TaxGroup();
taxGroupObj.TaxGroupId = Convert.ToInt32(dt.Rows[i]["TaxGroupId"]);
taxGroupObj.TaxGroupCode = Convert.ToString(dt.Rows[i]["TaxGroupCode"]);
taxGroupObj.StartDate = Convert.ToDateTime(dt.Rows[i]["StartDate"]);
taxGroupObj.StartDateVal = Convert.ToDateTime(dt.Rows[i]["StartDate"]).ToString(Common.DTP_DATE_FORMAT);
taxGroupObj.TaxCodeId = Convert.ToInt32(dt.Rows[i]["TaxCodeId"]);
taxGroupObj.TaxCode = Convert.ToString(dt.Rows[i]["TaxCode"]);
taxGroupObj.GroupOrder = Convert.ToInt32(dt.Rows[i]["GroupOrder"]);
taxGroupObj.AppliedOn = Convert.ToString(dt.Rows[i]["AppliedOn"]);
taxGroupObj.AppliedOnText = Convert.ToString(dt.Rows[i]["AppliedOnText"]);
taxGroupObj.Status = Convert.ToInt32(dt.Rows[i]["Status"]);
taxGroupObj.StatusName = Convert.ToString(dt.Rows[i]["StatusName"]);
listTaxGroup.Add(taxGroupObj);
}
}
}
return(listTaxGroup);
}
catch (Exception ex)
{
Common.LogException(ex);
throw ex;
}
}
