/// <summary>
/// Get Tax Exempt Card Holder
/// </summary>
/// <param name="customerId"></param>
/// <returns></returns>
public teCardholder GetTaxExemptCustomer(string customerId)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,CustomerService,GetTaxExemptCustomer,{string.Empty},{DateTime.Now:hh.mm.ss.ffffff}");
var cardHolder = new teCardholder();
bool returnValue = false;
var dt = GetRecords("Select * From Client where CL_Code = \'" + customerId + "\'", DataSource.CSCMaster);
if (dt != null && dt.Rows.Count > 0)
{
if (CommonUtility.GetBooleanValue(dt.Rows[0]["TaxExempt"]))
{
returnValue = true;
cardHolder.Name = CommonUtility.GetStringValue(dt.Rows[0]["Cl_Name"]);
cardHolder.Address = CommonUtility.GetStringValue(dt.Rows[0]["CL_Add1"]);
cardHolder.City = CommonUtility.GetStringValue(dt.Rows[0]["CL_City"]);
cardHolder.PlateNumber = CommonUtility.GetStringValue(dt.Rows[0]["PlateNumber"]);
cardHolder.PostalCode = CommonUtility.GetStringValue(dt.Rows[0]["CL_Postal"]);
cardHolder.Note = CommonUtility.GetStringValue(dt.Rows[0]["CL_Note"]);
cardHolder.CardholderID = customerId;
cardHolder.CardNumber = customerId;
}
cardHolder.IsValidCardHolder = Convert.ToBoolean(returnValue);
}
_performancelog.Debug($"End,CustomerService,GetTaxExemptCustomer,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
return(cardHolder);
}
/// <summary>
/// Method to check if valid tax exempt customer
/// </summary>
/// <param name="cardHolder">Card holder</param>
/// <param name="customerId">Customer Id</param>
/// <returns>True or false</returns>
public bool ValidTaxExemptCustomer(ref teCardholder cardHolder, string customerId)
{
cardHolder = _customerService.GetTaxExemptCustomer(customerId);
var returnValue = cardHolder.IsValidCardHolder;
return(returnValue);
}
/// <summary>
/// Update tax exempt card holder
/// </summary>
/// <param name="taxExemptCardHolder">tax exempt card holder</param>
public void UpdateTaxExemptCardHolder(teCardholder taxExemptCardHolder)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,TaxService,UpdateTaxExemptCardHolder,{string.Empty},{dateStart:hh.mm.ss.ffffff}");
var rsCardHolder = new DataTable();
_connection = new SqlConnection(GetConnectionString(DataSource.CSCMaster));
if (_connection.State == ConnectionState.Closed)
{
_connection.Open();
}
_adapter = new SqlDataAdapter("select * from TaxExemptCardRegistry Where CardholderID= \'" + taxExemptCardHolder.CardholderID + "\'", _connection);
_adapter.Fill(rsCardHolder);
if (rsCardHolder.Rows.Count > 0)
{
rsCardHolder.Rows[0]["TobaccoQuota"] = taxExemptCardHolder.TobaccoQuota;
rsCardHolder.Rows[0]["GasQuota"] = taxExemptCardHolder.GasQuota;
rsCardHolder.Rows[0]["PropaneQuota"] = taxExemptCardHolder.PropaneQuota;
SqlCommandBuilder builder = new SqlCommandBuilder(_adapter);
_adapter.UpdateCommand = builder.GetUpdateCommand();
_adapter.Update(rsCardHolder);
_connection.Close();
_adapter?.Dispose();
}
_performancelog.Debug($"End,TaxService,UpdateTaxExemptCardHolder,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
}
/// <summary>
/// Method to get card holder
/// </summary>
/// <param name="isBarCode">Is bar code or not</param>
/// <param name="strNumber">Number</param>
/// <param name="matchCount">Match count</param>
/// <param name="ageRestrict">Age restriction</param>
/// <returns>Tax exempt card holder</returns>
public teCardholder GetCardHolder(bool isBarCode, string strNumber, out short matchCount, int ageRestrict)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,CustomerService,GetCardHolder,{string.Empty},{DateTime.Now:hh.mm.ss.ffffff}");
string strSql;
teCardholder cardHolder = new teCardholder {
IsValidCardHolder = false
};
if (isBarCode)
{
strSql = "Select * from TaxExemptCardRegistry where BarCode=\'" + strNumber + "\' OR AltBarCode=\'" + strNumber + "\'";
}
else
{
strSql = "Select * from TaxExemptCardRegistry where CardNumber=\'" + strNumber + "\' OR AltCardNumber=\'" + strNumber + "\'";
}
var dt = GetRecords(strSql, DataSource.CSCMaster);
matchCount = 0;
if (dt != null && dt.Rows.Count > 0)
{
matchCount = Convert.ToInt16(dt.Rows.Count);
if (matchCount > 1)
{
cardHolder.IsValidCardHolder = false;
return(cardHolder);
}
DateTime mBirthDate;
if (CommonUtility.GetBooleanValue(dt.Rows[0]["Birthdate"]))
{
mBirthDate = DateAndTime.DateAdd(DateInterval.Year, Convert.ToDouble(-1 * (ageRestrict + 1)), DateAndTime.Today);
}
else
{
mBirthDate = CommonUtility.GetDateTimeValue(dt.Rows[0]["Birthdate"]);
}
cardHolder.Birthdate = mBirthDate;
cardHolder.Name = CommonUtility.GetStringValue(dt.Rows[0]["Name"]);
cardHolder.CardholderID = CommonUtility.GetStringValue(dt.Rows[0]["CardholderID"]);
cardHolder.IsValidCardHolder = false;
if (isBarCode)
{
if (CommonUtility.GetStringValue(dt.Rows[0]["Barcode"]) == strNumber)
{
cardHolder.ValidateMode = 1;
cardHolder.CardNumber = CommonUtility.GetStringValue(dt.Rows[0]["CardNumber"]);
}
else
{
cardHolder.ValidateMode = 2;
cardHolder.CardNumber = CommonUtility.GetStringValue(dt.Rows[0]["AltCardNumber"]);
}
cardHolder.Barcode = strNumber;
}
else
{
if (CommonUtility.GetStringValue(dt.Rows[0]["CardNumber"]) == strNumber)
{
cardHolder.ValidateMode = 3;
cardHolder.Barcode = CommonUtility.GetStringValue(dt.Rows[0]["Barcode"]);
}
else
{
cardHolder.ValidateMode = 4;
cardHolder.Barcode = CommonUtility.GetStringValue(dt.Rows[0]["AltBarCode"]);
}
cardHolder.CardNumber = strNumber;
}
cardHolder.GasQuota = CommonUtility.GetFloatValue(dt.Rows[0]["GasQuota"]);
cardHolder.PropaneQuota = CommonUtility.GetFloatValue(dt.Rows[0]["PropaneQuota"]);
cardHolder.TobaccoQuota = CommonUtility.GetFloatValue(dt.Rows[0]["TobaccoQuota"]);
cardHolder.IsValidCardHolder = true;
}
_performancelog.Debug($"End,CustomerService,GetCardHolder,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
return(cardHolder);
}
/// <summary>
/// Method to get valid card holder
/// </summary>
/// <param name="cardHolder">Card holder</param>
/// <param name="isBarCode">Bar code exists or not</param>
/// <param name="strNumber">Number</param>
/// <param name="matchCount">Match count</param>
/// <returns>True or false</returns>
public bool ValidCardHolder(ref teCardholder cardHolder, bool isBarCode, string strNumber, ref short matchCount)
{
cardHolder = _customerService.GetCardHolder(isBarCode, strNumber, out matchCount, _policyManager.AgeRestrict);
return(cardHolder.IsValidCardHolder);
}
