private bool SaveRecord()
{
bool boRetValue = false;
if (string.IsNullOrEmpty(txtCreditCardNo.Text.Trim()))
{
MessageBox.Show("Sorry please enter a valid credit card no.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return boRetValue;
}
DateTime dteExpiryDate = DateTime.MinValue;
try { dteExpiryDate = DateTime.Parse(txtCreditCardExpiryDate.Text); }
catch
{
MessageBox.Show("Please enter a valid expiry date in the ff format: YYYY-MM-dd ", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return boRetValue;
}
decimal decCreditLimit = 0;
try { decCreditLimit = decimal.Parse(txtCreditLimit.Text); }
catch
{
MessageBox.Show("Please enter a valid credit limit amount.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return boRetValue;
}
if (mCreditCardStatus == CreditCardStatus.New)
{
if (MessageBox.Show("Are you sure you want to issue a new credit card to " + mContactDetails.ContactName + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{ return boRetValue; }
}
else if (mCreditCardStatus == CreditCardStatus.Lost || mCreditCardStatus == CreditCardStatus.Expired || mCreditCardStatus == RetailPlus.CreditCardStatus.Suspended)
{
if (MessageBox.Show("Are you sure you want to declare card no: " + txtCreditCardNo.Text + " as " + mCreditCardStatus.ToString("G") + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{ return boRetValue; }
}
else if (mCreditCardStatus == CreditCardStatus.Replaced_Lost || mCreditCardStatus == CreditCardStatus.Replaced_Expired)
{
if (MessageBox.Show("Are you sure you want to replace existing credit card w/ new card no?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{ return boRetValue; }
}
else if (mCreditCardStatus == CreditCardStatus.Reactivated_Lost)
{
if (MessageBox.Show("Are you sure you want to reactivate existing credit card no: " + txtCreditCardNo.Text + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{ return boRetValue; }
}
else if (mCreditCardStatus == CreditCardStatus.ReNew)
{
if (MessageBox.Show("Are you sure you want to renew card no: " + txtCreditCardNo.Text + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{ return boRetValue; }
if (dteExpiryDate < DateTime.Now)
{
MessageBox.Show("Expiry date must not be less than date today. Please enter a valid expiry date. ", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return boRetValue;
}
}
Data.ContactCreditCardInfos clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
Data.ContactCreditCardInfoDetails clsContactCreditCardInfoDetails = clsContactCreditCardInfos.Details(mContactDetails.ContactID);
if (clsContactCreditCardInfoDetails.CustomerID != Constants.ZERO)
{
txtCreditCardNo.Text = clsContactCreditCardInfoDetails.CreditCardNo;
//remove this override
//txtCreditCardExpiryDate.Text = clsContactCreditCardInfoDetails.ExpiryDate.ToString("yyyy-MM-dd");
}
if (((mCreditCardStatus == CreditCardStatus.New && clsContactCreditCardInfoDetails.CustomerID == Constants.ZERO) ||
mCreditCardStatus == CreditCardStatus.Replaced_Lost) && (CardTypeDetails.WithGuarantor))
{
Data.ERPConfig clsERPConfig = new Data.ERPConfig(clsContactCreditCardInfos.Connection, clsContactCreditCardInfos.Transaction);
BarcodeHelper ean13 = new BarcodeHelper(BarcodeHelper.GroupCreditCard_Country_Code, BarcodeHelper.GroupCreditCard_ManufacturerCode, clsERPConfig.get_LastGroupCreditCardNo());
txtCreditCardNo.Text = ean13.CountryCode + ean13.ManufacturerCode + ean13.ProductCode + ean13.ChecksumDigit;
}
else if ((mCreditCardStatus == CreditCardStatus.New && clsContactCreditCardInfoDetails.CustomerID == Constants.ZERO) ||
mCreditCardStatus == CreditCardStatus.Replaced_Lost)
{
Data.ERPConfig clsERPConfig = new Data.ERPConfig(clsContactCreditCardInfos.Connection, clsContactCreditCardInfos.Transaction);
BarcodeHelper ean13 = new BarcodeHelper(BarcodeHelper.CreditCard_Country_Code, BarcodeHelper.CreditCard_ManufacturerCode, clsERPConfig.get_LastCreditCardNo());
txtCreditCardNo.Text = ean13.CountryCode + ean13.ManufacturerCode + ean13.ProductCode + ean13.ChecksumDigit;
}
clsContactCreditCardInfos.CommitAndDispose();
Data.ContactCreditCardInfoDetails clsDetails = new Data.ContactCreditCardInfoDetails();
clsDetails.CustomerID = mContactDetails.ContactID;
clsDetails.CardTypeDetails = CardTypeDetails;
clsDetails.CreditCardNo = txtCreditCardNo.Text;
clsDetails.CreditAwardDate = DateTime.Now;
clsDetails.ExpiryDate = dteExpiryDate;
clsDetails.CreditLimit = decCreditLimit;
clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
clsContactCreditCardInfoDetails = clsContactCreditCardInfos.Details(txtCreditCardNo.Text);
if (clsContactCreditCardInfoDetails.CustomerID != Constants.ZERO)
{
if (mCreditCardStatus == CreditCardStatus.New || (mCreditCardStatus != CreditCardStatus.New && clsContactCreditCardInfoDetails.CustomerID != mContactDetails.ContactID))
{
clsContactCreditCardInfos.CommitAndDispose();
MessageBox.Show("Credit Card No: " + clsContactCreditCardInfoDetails.CreditCardNo + " was already issued on " + clsContactCreditCardInfoDetails.CreditAwardDate.ToString("MMM dd, yyyy") + " to another customer." +
Environment.NewLine + "Please enter another Credit Card No.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCreditCardNo.Focus();
txtCreditCardNo.SelectAll();
return boRetValue;
}
}
clsDetails.GuarantorID = clsContactCreditCardInfoDetails.GuarantorID;
clsDetails.CardTypeDetails = clsContactCreditCardInfoDetails.CardTypeDetails;
if (mCreditCardStatus == CreditCardStatus.New)
{
clsDetails.CreditActive = true;
// override if new
clsDetails.GuarantorID = Guarantor.ContactID;
clsDetails.CardTypeDetails = CardTypeDetails;
}
else if (mCreditCardStatus == CreditCardStatus.Lost || mCreditCardStatus == CreditCardStatus.Expired || mCreditCardStatus == RetailPlus.CreditCardStatus.Suspended)
{
clsDetails.CreditActive = false;
}
else if (mCreditCardStatus == CreditCardStatus.Replaced_Lost ||
mCreditCardStatus == CreditCardStatus.Replaced_Expired ||
mCreditCardStatus == CreditCardStatus.Reactivated_Lost ||
mCreditCardStatus == CreditCardStatus.ReNew)
{
clsDetails.CreditActive = true;
}
clsDetails.CreditCardStatus = mCreditCardStatus;
// do an overwride if the date is already expired
if (dteExpiryDate < new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59))
{
clsDetails.CreditActive = false;
clsDetails.CreditCardStatus = CreditCardStatus.Expired;
}
boRetValue = clsContactCreditCardInfos.Update(clsDetails);
Data.Contacts clsContacts = new Data.Contacts(clsContactCreditCardInfos.Connection, clsContactCreditCardInfos.Transaction);
clsContacts.UpdateRemarks(clsDetails.CustomerID, txtRemarks.Text, "");
mContactDetails.CreditDetails = clsDetails;
clsContactCreditCardInfos.CommitAndDispose();
boRetValue = true;
return boRetValue;
}
private bool SaveRecord()
{
bool boRetValue = false;
if (string.IsNullOrEmpty(txtCreditCardNo.Text.Trim()))
{
MessageBox.Show("Sorry please enter a valid credit card no.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(boRetValue);
}
DateTime dteExpiryDate = DateTime.MinValue;
try { dteExpiryDate = DateTime.Parse(txtCreditCardExpiryDate.Text); }
catch
{
MessageBox.Show("Please enter a valid expiry date in the ff format: YYYY-MM-dd ", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(boRetValue);
}
decimal decCreditLimit = 0;
try { decCreditLimit = decimal.Parse(txtCreditLimit.Text); }
catch
{
MessageBox.Show("Please enter a valid credit limit amount.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(boRetValue);
}
if (mCreditCardStatus == CreditCardStatus.New)
{
if (MessageBox.Show("Are you sure you want to issue a new credit card to " + mContactDetails.ContactName + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return(boRetValue);
}
}
else if (mCreditCardStatus == CreditCardStatus.Lost || mCreditCardStatus == CreditCardStatus.Expired || mCreditCardStatus == RetailPlus.CreditCardStatus.Suspended)
{
if (MessageBox.Show("Are you sure you want to declare card no: " + txtCreditCardNo.Text + " as " + mCreditCardStatus.ToString("G") + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return(boRetValue);
}
}
else if (mCreditCardStatus == CreditCardStatus.Replaced_Lost || mCreditCardStatus == CreditCardStatus.Replaced_Expired)
{
if (MessageBox.Show("Are you sure you want to replace existing credit card w/ new card no?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return(boRetValue);
}
}
else if (mCreditCardStatus == CreditCardStatus.Reactivated_Lost)
{
if (MessageBox.Show("Are you sure you want to reactivate existing credit card no: " + txtCreditCardNo.Text + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return(boRetValue);
}
}
else if (mCreditCardStatus == CreditCardStatus.ReNew)
{
if (MessageBox.Show("Are you sure you want to renew card no: " + txtCreditCardNo.Text + "?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return(boRetValue);
}
if (dteExpiryDate < DateTime.Now)
{
MessageBox.Show("Expiry date must not be less than date today. Please enter a valid expiry date. ", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(boRetValue);
}
}
Data.ContactCreditCardInfos clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
Data.ContactCreditCardInfoDetails clsContactCreditCardInfoDetails = clsContactCreditCardInfos.Details(mContactDetails.ContactID);
if (clsContactCreditCardInfoDetails.CustomerID != Constants.ZERO)
{
txtCreditCardNo.Text = clsContactCreditCardInfoDetails.CreditCardNo;
//remove this override
//txtCreditCardExpiryDate.Text = clsContactCreditCardInfoDetails.ExpiryDate.ToString("yyyy-MM-dd");
}
if (((mCreditCardStatus == CreditCardStatus.New && clsContactCreditCardInfoDetails.CustomerID == Constants.ZERO) ||
mCreditCardStatus == CreditCardStatus.Replaced_Lost) && (CardTypeDetails.WithGuarantor))
{
Data.ERPConfig clsERPConfig = new Data.ERPConfig(clsContactCreditCardInfos.Connection, clsContactCreditCardInfos.Transaction);
BarcodeHelper ean13 = new BarcodeHelper(BarcodeHelper.GroupCreditCard_Country_Code, BarcodeHelper.GroupCreditCard_ManufacturerCode, clsERPConfig.get_LastGroupCreditCardNo());
txtCreditCardNo.Text = ean13.CountryCode + ean13.ManufacturerCode + ean13.ProductCode + ean13.ChecksumDigit;
}
else if ((mCreditCardStatus == CreditCardStatus.New && clsContactCreditCardInfoDetails.CustomerID == Constants.ZERO) ||
mCreditCardStatus == CreditCardStatus.Replaced_Lost)
{
Data.ERPConfig clsERPConfig = new Data.ERPConfig(clsContactCreditCardInfos.Connection, clsContactCreditCardInfos.Transaction);
BarcodeHelper ean13 = new BarcodeHelper(BarcodeHelper.CreditCard_Country_Code, BarcodeHelper.CreditCard_ManufacturerCode, clsERPConfig.get_LastCreditCardNo());
txtCreditCardNo.Text = ean13.CountryCode + ean13.ManufacturerCode + ean13.ProductCode + ean13.ChecksumDigit;
}
clsContactCreditCardInfos.CommitAndDispose();
Data.ContactCreditCardInfoDetails clsDetails = new Data.ContactCreditCardInfoDetails();
clsDetails.CustomerID = mContactDetails.ContactID;
clsDetails.CardTypeDetails = CardTypeDetails;
clsDetails.CreditCardNo = txtCreditCardNo.Text;
clsDetails.CreditAwardDate = DateTime.Now;
clsDetails.ExpiryDate = dteExpiryDate;
clsDetails.CreditLimit = decCreditLimit;
clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
clsContactCreditCardInfoDetails = clsContactCreditCardInfos.Details(txtCreditCardNo.Text);
if (clsContactCreditCardInfoDetails.CustomerID != Constants.ZERO)
{
if (mCreditCardStatus == CreditCardStatus.New || (mCreditCardStatus != CreditCardStatus.New && clsContactCreditCardInfoDetails.CustomerID != mContactDetails.ContactID))
{
clsContactCreditCardInfos.CommitAndDispose();
MessageBox.Show("Credit Card No: " + clsContactCreditCardInfoDetails.CreditCardNo + " was already issued on " + clsContactCreditCardInfoDetails.CreditAwardDate.ToString("MMM dd, yyyy") + " to another customer." +
Environment.NewLine + "Please enter another Credit Card No.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCreditCardNo.Focus();
txtCreditCardNo.SelectAll();
return(boRetValue);
}
}
clsDetails.GuarantorID = clsContactCreditCardInfoDetails.GuarantorID;
clsDetails.CardTypeDetails = clsContactCreditCardInfoDetails.CardTypeDetails;
if (mCreditCardStatus == CreditCardStatus.New)
{
clsDetails.CreditActive = true;
// override if new
clsDetails.GuarantorID = Guarantor.ContactID;
clsDetails.CardTypeDetails = CardTypeDetails;
}
else if (mCreditCardStatus == CreditCardStatus.Lost || mCreditCardStatus == CreditCardStatus.Expired || mCreditCardStatus == RetailPlus.CreditCardStatus.Suspended)
{
clsDetails.CreditActive = false;
}
else if (mCreditCardStatus == CreditCardStatus.Replaced_Lost ||
mCreditCardStatus == CreditCardStatus.Replaced_Expired ||
mCreditCardStatus == CreditCardStatus.Reactivated_Lost ||
mCreditCardStatus == CreditCardStatus.ReNew)
{
clsDetails.CreditActive = true;
}
clsDetails.CreditCardStatus = mCreditCardStatus;
// do an overwride if the date is already expired
if (dteExpiryDate < new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59))
{
clsDetails.CreditActive = false;
clsDetails.CreditCardStatus = CreditCardStatus.Expired;
}
boRetValue = clsContactCreditCardInfos.Update(clsDetails);
Data.Contacts clsContacts = new Data.Contacts(clsContactCreditCardInfos.Connection, clsContactCreditCardInfos.Transaction);
clsContacts.UpdateRemarks(clsDetails.CustomerID, txtRemarks.Text, "");
mContactDetails.CreditDetails = clsDetails;
clsContactCreditCardInfos.CommitAndDispose();
boRetValue = true;
return(boRetValue);
}
