private ContactDetails setDetails(System.Data.DataTable dt)
{
ContactDetails Details = new ContactDetails();
try
{
foreach(System.Data.DataRow dr in dt.Rows)
{
Details.ContactID = Int64.Parse(dr["ContactID"].ToString());
Details.SequenceNo = Int32.Parse(dr["SequenceNo"].ToString());
Details.ContactCode = "" + dr["ContactCode"].ToString();
Details.ContactName = "" + dr["ContactName"].ToString();
Details.ContactGroupID = Int32.Parse(dr["ContactGroupID"].ToString());
Details.ContactGroupName = "" + dr["ContactGroupName"].ToString();
Details.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), dr["ModeOfTerms"].ToString());
Details.Terms = Int32.Parse(dr["Terms"].ToString());
Details.Address = "" + dr["Address"].ToString();
Details.BusinessName = "" + dr["BusinessName"].ToString();
Details.TelephoneNo = "" + dr["TelephoneNo"].ToString();
Details.Remarks = "" + dr["Remarks"].ToString();
Details.Debit = decimal.Parse(dr["Debit"].ToString());
Details.Credit =decimal.Parse(dr["Credit"].ToString());
Details.CreditLimit = decimal.Parse(dr["CreditLimit"].ToString());
Details.IsCreditAllowed = bool.Parse(dr["IsCreditAllowed"].ToString());
Details.DateCreated = DateTime.Parse(dr["DateCreated"].ToString());
Details.Deleted = bool.Parse(dr["Deleted"].ToString());
Details.DepartmentID = Int16.Parse(dr["DepartmentID"].ToString());
Details.DepartmentName = "" + dr["DepartmentName"].ToString();
Details.PositionID = Int16.Parse(dr["PositionID"].ToString());
Details.PositionName = "" + dr["PositionName"].ToString();
Details.LastCheckInDate = DateTime.Parse(dr["LastCheckInDate"].ToString());
Details.TINNo = "" + dr["TINNo"].ToString();
Details.LTONo = "" + dr["LTONo"].ToString();
Details.PriceLevel = (PriceLevel)Enum.Parse(typeof(PriceLevel), dr["PriceLevel"].ToString());
Details.isLock = bool.Parse(dr["isLock"].ToString());
}
// Sep 14, 2011 : Lemu - for reward points
ContactReward clsContactReward = new ContactReward(base.Connection, base.Transaction);
Details.RewardDetails = clsContactReward.Details(Details.ContactID);
// Nov 2, 2011 : Lemu - for credit
ContactCreditCardInfos clsContactCredit = new ContactCreditCardInfos(base.Connection, base.Transaction);
Details.CreditDetails = clsContactCredit.Details(Details.ContactID);
Details.CreditDetails.CreditLimit = Details.CreditLimit;
if (!Details.IsCreditAllowed)
Details.CreditDetails.CreditActive = Details.IsCreditAllowed;
else
{
Details.CreditDetails.CreditActive = checkCreditActive(Details.CreditDetails.CreditCardStatus);
}
// Oct 12, 2013 : - get additional details
Details.AdditionalDetails = new ContactAddOns(base.Connection, base.Transaction).Details(Details.ContactID);
}
catch (Exception ex) { throw base.ThrowException(ex); }
return Details;
}
