private void ContactAdd()
{
if (!TerminalDetails.ShowCustomerSelection)
{
ContactAddDetWnd addwnd = new ContactAddDetWnd();
addwnd.Caption = "Quickly add new customer.";
addwnd.ShowDialog(this);
DialogResult addresult = addwnd.Result;
Data.ContactDetails details = addwnd.ContactDetails;
addwnd.Close();
addwnd.Dispose();
if (addresult == DialogResult.OK)
{
txtSearch.Text = details.ContactCode;
LoadContactData();
}
}
else
{
ContactAddWnd addwnd = new ContactAddWnd();
addwnd.Caption = "Quickly add new customer.";
addwnd.ShowDialog(this);
DialogResult addresult = addwnd.Result;
Data.ContactDetails details = addwnd.ContactDetails;
addwnd.Close();
addwnd.Dispose();
if (addresult == DialogResult.OK)
{
txtSearch.Text = details.ContactCode;
LoadContactData();
}
}
}
private void SelectContact()
{
try
{
ContactSelectWnd clsContactWnd = new ContactSelectWnd();
clsContactWnd.EnableContactAddUpdate = false;
clsContactWnd.SysConfigDetails = SysConfigDetails;
clsContactWnd.TerminalDetails = TerminalDetails;
clsContactWnd.ContactGroupCategory = AceSoft.RetailPlus.Data.ContactGroupCategory.CUSTOMER;
clsContactWnd.ShowDialog(this);
Data.ContactDetails details = clsContactWnd.Details;
DialogResult result = clsContactWnd.Result;
clsContactWnd.Close();
clsContactWnd.Dispose();
if (clsContactWnd.Result == DialogResult.OK)
{
if (details.ContactID <= Constants.C_RETAILPLUS_CUSTOMERID)
{
MessageBox.Show("Sorry, you cannot use the default customer." +
"Please select another customer...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
SelectContact();
}
else
{
txtContact.Text = details.ContactName;
txtContact.Tag = details.ContactID.ToString();
}
}
}
catch { }
}
private void cmdTable_Click(object sender, EventArgs e)
{
try
{
ProductButton cmdTable = (ProductButton)sender;
Data.Contacts clsContact = new Contacts();
Data.ContactDetails clsContactDetails = clsContact.Details(long.Parse(cmdTable.Tag.ToString()));
clsContact.CommitAndDispose();
if (mlstTables.Exists(i => i.ContactID == clsContactDetails.ContactID))
{
mlstTables.Remove(clsContactDetails);
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Visible = false;
if (cmdTable.GradientBottom == System.Drawing.Color.DarkRed)
{
cmdTable.GradientTop = System.Drawing.Color.Red;
}
else
{
cmdTable.GradientTop = System.Drawing.Color.LightBlue;
}
}
else
{
mlstTables.Add(clsContactDetails);
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Visible = true;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Text = "Merged to " + MainTableToMerge.ContactCode;
cmdTable.GradientTop = System.Drawing.Color.Orange;
}
}
catch { }
}
private void LoadContactData()
{
Contacts clsContact = new Contacts();
try
{
string searchkey = "" + txtSearch.Text;
System.Data.DataTable dt;
if (mContactGroupCategory == ContactGroupCategory.AGENT)
{
dt = clsContact.AgentsAsDataTable(searchkey, 50, "ContactName", SortOption.Ascending);
}
else
{
dt = clsContact.CustomersDataTable(searchkey, 50, HasCreditOnly, "ContactName", SortOption.Ascending);
}
if (!TerminalDetails.ShowCustomerSelection && dt.Rows.Count == 0)
{
Data.ContactDetails clsContactDetails = clsContact.DetailsByCreditCardNo(txtSearch.Text);
//remove this coz it's slow
//if (clsContactDetails.ContactID == 0 && txtSearch.Text.Length == 7) clsContactDetails = clsContact.DetailsByCreditCardNo("888880" + txtSearch.Text);
//if (clsContactDetails.ContactID == 0 && txtSearch.Text.Length == 7) clsContactDetails = clsContact.DetailsByCreditCardNo("800000" + txtSearch.Text);
//if (clsContactDetails.ContactID == 0 && txtSearch.Text.Length == 9) clsContactDetails = clsContact.DetailsByCreditCardNo(BarcodeHelper.GroupCreditCard_Country_Code + BarcodeHelper.GroupCreditCard_ManufacturerCode + txtSearch.Text);
//if (clsContactDetails.ContactID == 0 && txtSearch.Text.Length == 9) clsContactDetails = clsContact.DetailsByCreditCardNo(BarcodeHelper.CustomerCode_Country_Code + BarcodeHelper.CustomerCode_ManufacturerCode + txtSearch.Text);
//if (clsContactDetails.ContactID == 0 && txtSearch.Text.Length == 9) clsContactDetails = clsContact.DetailsByCreditCardNo(BarcodeHelper.GroupCreditCard_Country_Code + BarcodeHelper.GroupCreditCard_ManufacturerCode_Manual + txtSearch.Text);
//if (clsContactDetails.ContactID == 0 && txtSearch.Text.Length == 9) clsContactDetails = clsContact.DetailsByCreditCardNo(BarcodeHelper.CreditCard_Country_Code + BarcodeHelper.CreditCard_ManufacturerCode + txtSearch.Text);
if (clsContactDetails.ContactID != 0)
{
searchkey = clsContactDetails.ContactCode;
if (mContactGroupCategory == ContactGroupCategory.AGENT)
{
dt = clsContact.AgentsAsDataTable(searchkey, 50, "ContactName", SortOption.Ascending);
}
else
{
dt = clsContact.CustomersDataTable(searchkey, 50, HasCreditOnly, "ContactName", SortOption.Ascending);
}
}
}
clsContact.CommitAndDispose();
this.dgStyle.MappingName = dt.TableName;
dgContacts.DataSource = dt;
dgContacts.Select(0);
dgContacts.CurrentRowIndex = 0;
}
catch (IndexOutOfRangeException) {}
catch (Exception ex)
{
clsContact.CommitAndDispose();
MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ContactAdd()
{
if (!EnableContactAddUpdate)
{
return;
}
Data.ContactDetails details = new Data.ContactDetails();
DialogResult addresult = System.Windows.Forms.DialogResult.Cancel;
switch (SysConfigDetails.ContactAddWndType)
{
case ContactAddWndType.ContactAddWnd:
case ContactAddWndType.ContactAddNoLTOWnd:
ContactAddWnd clsContactAddWnd = new ContactAddWnd();
clsContactAddWnd.Caption = "Quickly add new customer.";
clsContactAddWnd.ContactDetails = details;
clsContactAddWnd.TerminalDetails = TerminalDetails;
clsContactAddWnd.SysConfigDetails = SysConfigDetails;
clsContactAddWnd.ShowDialog(this);
addresult = clsContactAddWnd.Result;
details = clsContactAddWnd.ContactDetails;
clsContactAddWnd.Close();
clsContactAddWnd.Dispose();
break;
case ContactAddWndType.ContactAddHCareWnd:
ContactAddHCareWnd clsContactAddHCareWnd = new ContactAddHCareWnd();
clsContactAddHCareWnd.Caption = "Quickly add new customer.";
clsContactAddHCareWnd.ContactDetails = details;
clsContactAddHCareWnd.TerminalDetails = TerminalDetails;
clsContactAddHCareWnd.ShowDialog(this);
addresult = clsContactAddHCareWnd.Result;
details = clsContactAddHCareWnd.ContactDetails;
clsContactAddHCareWnd.Close();
clsContactAddHCareWnd.Dispose();
break;
default:
ContactAddDetWnd clsContactAddDetWnd = new ContactAddDetWnd();
clsContactAddDetWnd.Caption = "Quickly add new customer.";
clsContactAddDetWnd.ContactDetails = details;
clsContactAddDetWnd.TerminalDetails = TerminalDetails;
clsContactAddDetWnd.ShowDialog(this);
addresult = clsContactAddDetWnd.Result;
details = clsContactAddDetWnd.ContactDetails;
clsContactAddDetWnd.Close();
clsContactAddDetWnd.Dispose();
break;
}
if (addresult == DialogResult.OK)
{
txtSearch.Text = details.ContactCode;
LoadContactData();
}
}
public int Post(Core.ContactDetails contactDetails)
{
Data.ContactDetails contact = mapper.Map <Data.ContactDetails>(contactDetails);
var insertPetapoco = database.Insert(contact); //Petapoco
var insertDapper = connection.Insert(contact); //Dapper
return((int)insertDapper);
}
private bool SaveRecord()
{
Data.ContactDetails clsDetails = new Data.ContactDetails();
clsDetails = mContactDetails;
clsDetails.ContactCode = txtCustomerName.Text;
clsDetails.ContactName = txtCustomerName.Text;
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelNo.Text;
// Jul 22, 2014
clsDetails.Debit = mContactDetails.Debit;
clsDetails.Credit = mContactDetails.Credit;
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
clsDetails.CreditLimit = decimal.Parse(txtCreditLimit.Text);
clsDetails.Terms = int.Parse(txtTerms.Text);
clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboTerms.SelectedItem.ToString());
Data.Contacts clsContact = new Data.Contacts();
if (mContactDetails.ContactID == 0)
{
if (mstCaption == "Please enter customer name for deposit.")
{
clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_DEPOSIT;
}
else if (mstCaption == "Quickly add new customer")
{
clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_QUICKLY_ADDED_FROM_FE;
}
else if (mContactDetails.ContactID == 0) // means not edit
{
clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_CLIENT;
}
clsDetails.ContactGroupID = Constants.CONTACT_GROUP_CUSTOMER;
clsDetails.PositionID = Constants.C_RETAILPLUS_AGENT_POSITIONID;
clsDetails.DepartmentID = Constants.C_RETAILPLUS_AGENT_DEPARTMENTID;
clsDetails.ContactID = clsContact.Insert(clsDetails);
}
else
{
clsDetails.ContactCode = mContactDetails.ContactCode;
clsDetails.ContactGroupID = mContactDetails.ContactGroupID;
clsDetails.ContactGroupName = mContactDetails.ContactGroupName;
clsContact.Update(clsDetails);
}
clsContact.CommitAndDispose();
mContactDetails = clsDetails;
return(true);
}
protected void cboSupplier_SelectedIndexChanged(object sender, System.EventArgs e)
{
Data.Contacts clsContact = new Data.Contacts();
Data.ContactDetails clsDetails = clsContact.Details(Convert.ToInt64(cboSupplier.SelectedItem.Value));
clsContact.CommitAndDispose();
txtSupplierContact.Text = clsDetails.ContactName;
txtSupplierTelephoneNo.Text = clsDetails.TelephoneNo;
lblTerms.Text = clsDetails.Terms.ToString("##0");
lblModeOfterms.Text = clsDetails.ModeOfTerms.ToString("G");
txtSupplierAddress.Text = clsDetails.Address;
}
private void ContactAdd()
{
Data.ContactDetails details = new Data.ContactDetails();
System.Windows.Forms.DialogResult addresult = System.Windows.Forms.DialogResult.Cancel;
switch (SysConfigDetails.ContactAddWndType)
{
case ContactAddWndType.ContactAddWnd:
ContactAddWnd clsContactAddWnd = new ContactAddWnd();
clsContactAddWnd.Caption = "Please enter customer name for deposit.";
clsContactAddWnd.ContactDetails = details;
clsContactAddWnd.TerminalDetails = TerminalDetails;
clsContactAddWnd.ShowDialog(this);
addresult = clsContactAddWnd.Result;
details = clsContactAddWnd.ContactDetails;
clsContactAddWnd.Close();
clsContactAddWnd.Dispose();
break;
case ContactAddWndType.ContactAddHCareWnd:
ContactAddHCareWnd clsContactAddHCareWnd = new ContactAddHCareWnd();
clsContactAddHCareWnd.Caption = "Please enter customer name for deposit.";
clsContactAddHCareWnd.ContactDetails = details;
clsContactAddHCareWnd.TerminalDetails = TerminalDetails;
clsContactAddHCareWnd.ShowDialog(this);
addresult = clsContactAddHCareWnd.Result;
details = clsContactAddHCareWnd.ContactDetails;
clsContactAddHCareWnd.Close();
clsContactAddHCareWnd.Dispose();
break;
default:
ContactAddDetWnd clsContactAddDetWnd = new ContactAddDetWnd();
clsContactAddDetWnd.Caption = "Please enter customer name for deposit.";
clsContactAddDetWnd.ContactDetails = details;
clsContactAddDetWnd.TerminalDetails = TerminalDetails;
clsContactAddDetWnd.ShowDialog(this);
addresult = clsContactAddDetWnd.Result;
details = clsContactAddDetWnd.ContactDetails;
clsContactAddDetWnd.Close();
clsContactAddDetWnd.Dispose();
break;
}
if (addresult == DialogResult.OK)
{
txtContact.Text = details.ContactName;
txtContact.Tag = details.ContactID.ToString();
}
}
protected void cboContact_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (cboContact.SelectedItem.Value != Constants.ZERO_STRING)
{
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.CreditDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.CreditDetails = true;
Int64 iGuarantorID = Int64.Parse(cboContact.SelectedItem.Value);
Contacts clsContact = new Contacts();
Data.ContactDetails clsContactDetails = clsContact.Details(iGuarantorID);
System.Data.DataTable dt = clsContact.CustomersWithCredits(clsContactColumns, iGuarantorID, SortField: "CreditCardNo"); // "", dteExpiryDateFrom, dteExpiryDateTo, enumCreditCardStatus, Int32.Parse(cboCreditType.SelectedItem.Value),
clsContact.CommitAndDispose();
lstItemCustomer.DataSource = dt.DefaultView;
lstItemCustomer.DataBind();
txtCreditCardTypeCode.Text = clsContactDetails.CreditDetails.CardTypeDetails.CardTypeCode;
txtCreditCardTypeCode.ToolTip = clsContactDetails.CreditDetails.CardTypeDetails.CardTypeID.ToString();
divGuarantorInfo.Visible = true;
}
else
{
divGuarantorInfo.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void CreateDetails(int iRow)
{
mDetails = new ContactDetails();
Customer clsCustomer = new Customer();
mDetails = clsCustomer.Details(Convert.ToInt64(dgContacts[iRow, 0].ToString()));
clsCustomer.CommitAndDispose();
////int iRow = dgContacts.CurrentRowIndex;
//mDetails.ContactID = Convert.ToInt64(dgContacts[iRow, 0].ToString());
//mDetails.ContactCode = dgContacts[iRow, 1].ToString();
//mDetails.ContactName = dgContacts[iRow, 2].ToString();
//mDetails.Debit = Convert.ToDecimal(dgContacts[iRow, 3].ToString());
//mDetails.Credit = Convert.ToDecimal(dgContacts[iRow, 4].ToString());
//mDetails.CreditLimit = Convert.ToDecimal(dgContacts[iRow, 5].ToString());
//mDetails.IsCreditAllowed = Convert.ToInt16(dgContacts[iRow, 6].ToString());
//mDetails.PositionName = dgContacts[iRow, 7].ToString();
//mDetails.DepartmentName = dgContacts[iRow, 8].ToString();
}
protected void cboPayee_SelectedIndexChanged(object sender, System.EventArgs e)
{
long payeeid = Convert.ToInt64(cboPayee.SelectedItem.Value);
Data.Contacts clsContact = new Data.Contacts();
Data.ContactDetails clsDetails = clsContact.Details(payeeid);
clsContact.CommitAndDispose();
txtPayeeName.Text = clsDetails.ContactName;
DataClass clsDataClass = new DataClass();
PO clsPO = new PO();
lstPO.DataSource = clsDataClass.DataReaderToDataTable(clsPO.ListForPayment(payeeid, "POID", SortOption.Ascending)).DefaultView;
lstPO.DataBind();
clsPO.CommitAndDispose();
Label lblAmount;
Label lblPaidAmount;
Label lblUnpaidAmount;
decimal decAmount = 0;
decimal decPaidAmount = 0;
decimal decUnpaidAmount = 0;
foreach (DataListItem item in lstPO.Items)
{
lblAmount = (Label)item.FindControl("lblAmount");
lblPaidAmount = (Label)item.FindControl("lblPaidAmount");
lblUnpaidAmount = (Label)item.FindControl("lblUnpaidAmount");
decAmount += Convert.ToDecimal(lblAmount.Text);
decPaidAmount += Convert.ToDecimal(lblPaidAmount.Text);
decUnpaidAmount += Convert.ToDecimal(lblUnpaidAmount.Text);
}
lblPOTotalAmount.Text = decAmount.ToString("#,##0.#0");
lblPOTotalPaidAmount.Text = decPaidAmount.ToString("#,##0.#0");
lblPOTotalUnpaidAmount.Text = decUnpaidAmount.ToString("#,##0.#0");
}
private void cmdTable_Click(object sender, EventArgs e)
{
try
{
ProductButton cmdTable = (ProductButton)sender;
Data.Contacts clsContact = new Contacts();
mDetails = clsContact.Details(long.Parse(cmdTable.Tag.ToString()));
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(clsContact.Connection, clsContact.Transaction);
string stTransactionNo = clsSalesTransactions.getSuspendedTransactionNo(mDetails.ContactID, mclsTerminalDetails.TerminalNo, mclsTerminalDetails.BranchID);
Data.SalesTransactionDetails clsSalesTransactionDetails = new SalesTransactionDetails();
if (!string.IsNullOrEmpty(stTransactionNo))
{
clsSalesTransactionDetails = clsSalesTransactions.Details(stTransactionNo, mclsTerminalDetails.TerminalNo, mclsTerminalDetails.BranchID);
}
clsContact.CommitAndDispose();
if (!string.IsNullOrEmpty(stTransactionNo) && clsSalesTransactionDetails.TransactionStatus == TransactionStatus.SuspendedOpen)
{
if (MessageBox.Show("This transaction is already open in another terminal. Please suspend in the other terminal first before opening." + Environment.NewLine + "Would you like to force open this transaction?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
//LoadContactData(System.Data.SqlClient.SortOrder.Ascending);
return;
}
else
{
DialogResult resResumeSuspendedOpenTransaction = GetWriteAccessAndLogin(CashierID, AccessTypes.ResumeSuspendedOpenTransaction);
if (resResumeSuspendedOpenTransaction != System.Windows.Forms.DialogResult.OK)
{
//LoadContactData(System.Data.SqlClient.SortOrder.Ascending);
return;
}
}
}
dialog = DialogResult.OK;
this.Hide();
}
catch { }
}
private void cboCardType_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboCardType.Text == "No available cards to issue")
{
grpCardInfo.Visible = false;
}
else
{
Data.CardType clsCardType = new Data.CardType();
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
if (clsCardTypeDetails.CardTypeID == 0)
{
grpCardInfo.Visible = false;
CardTypeDetails = new Data.CardTypeDetails();
}
else
{
grpCardInfo.Visible = true;
grpCardInfo.Text = cboCardType.Text + " Information";
lblCardTypeCode.Text = clsCardTypeDetails.CardTypeCode;
lblFinanceCharge.Text = clsCardTypeDetails.CreditFinanceCharge.ToString("##0.#0");
lblPenaltyCharge.Text = clsCardTypeDetails.CreditLatePenaltyCharge.ToString("##0.#0");
lblMinimumPercentageDue.Text = clsCardTypeDetails.CreditMinimumPercentageDue.ToString("##0.#0");
lblMinimumAmountDue.Text = clsCardTypeDetails.CreditMinimumAmountDue.ToString("##0.#0");
chkWithGuarantor.Checked = clsCardTypeDetails.WithGuarantor;
CardTypeDetails = clsCardTypeDetails;
if (!clsCardTypeDetails.WithGuarantor)
{
mclsGuarantor = new Data.ContactDetails();
}
else
{
}
}
}
}
protected void cboContact_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (cboContact.SelectedItem.Value != Constants.ZERO_STRING)
{
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactID = true;
clsContactColumns.ContactCode = true;
clsContactColumns.ContactName = true;
clsContactColumns.CreditDetails = true;
ContactColumns clsSearchColumns = new ContactColumns();
clsSearchColumns.ContactCode = true;
clsSearchColumns.ContactName = true;
clsSearchColumns.CreditDetails = true;
Int64 iContactID = Int64.Parse(cboContact.SelectedItem.Value);
Contacts clsContact = new Contacts();
Data.ContactDetails clsContactDetails = clsContact.Details(iContactID);
Data.ContactDetails clsGuarantorDetails = clsContact.Details(clsContactDetails.CreditDetails.GuarantorID);
clsContact.CommitAndDispose();
txtGuarantorName.Text = clsGuarantorDetails.ContactName.ToString();
txtGuarantorName.ToolTip = clsGuarantorDetails.ContactID.ToString();
divContactInfo.Visible = true;
}
else
{
divContactInfo.Visible = false;
}
}
catch (Exception ex)
{
throw ex;
}
}
private bool SaveRecord()
{
Data.ContactDetails clsDetails = new Data.ContactDetails();
clsDetails.ContactCode = txtCustomerName.Text;
clsDetails.ContactName = txtCustomerName.Text;
clsDetails.ContactGroupID = Constants.CONTACT_GROUP_CUSTOMER;
clsDetails.ModeOfTerms = 0;
clsDetails.Terms = 0;
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelNo.Text;
if (mstCaption == "Please enter customer name for deposit.")
{
clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_DEPOSIT;
}
else if (mstCaption == "Quickly add new customer")
{
clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_QUICKLY_ADDED_FROM_FE;
}
else
{
clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_CLIENT;
}
clsDetails.Debit = 0;
clsDetails.Credit = 0;
clsDetails.IsCreditAllowed = true;
clsDetails.CreditLimit = 0;
clsDetails.PositionID = Constants.C_RETAILPLUS_AGENT_POSITIONID;
clsDetails.DepartmentID = Constants.C_RETAILPLUS_AGENT_DEPARTMENTID;
Data.Contacts clsContact = new Data.Contacts();
clsDetails.ContactID = clsContact.Insert(clsDetails);
clsContact.CommitAndDispose();
mContactDetails = clsDetails;
return(true);
}
private void IssueCreditCard()
{
if (mboIsInTransaction)
{
MessageBox.Show("Sorry you cannot issue a Credit Card while there is an ongoing transaction. Please finish the transaction first.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DialogResult loginresult = GetWriteAccessAndLogin(mclsSalesTransactionDetails.CashierID, AccessTypes.CreditCardIssuance);
if (loginresult == DialogResult.OK)
{
try
{
DialogResult result;
Data.CardTypeDetails clsCardTypeDetails = new Data.CardTypeDetails();
Data.ContactDetails clsGuarantorDetails = new AceSoft.RetailPlus.Data.ContactDetails();
ContactCreditTypeSelectWnd clsContactCreditTypeSelectWnd = new ContactCreditTypeSelectWnd();
clsContactCreditTypeSelectWnd.TerminalDetails = mclsTerminalDetails;
clsContactCreditTypeSelectWnd.ShowDialog(this);
clsCardTypeDetails = clsContactCreditTypeSelectWnd.CardTypeDetails;
result = clsContactCreditTypeSelectWnd.Result;
clsContactCreditTypeSelectWnd.Close();
clsContactCreditTypeSelectWnd.Dispose();
if (result != DialogResult.OK)
{ return; }
Data.ContactDetails clsContactDetails;
ContactSelectWnd clsContactWnd = new ContactSelectWnd();
clsContactWnd.EnableContactAddUpdate = GetWriteAccess(mclsSalesTransactionDetails.CashierID, AccessTypes.Contacts) == System.Windows.Forms.DialogResult.OK;
clsContactWnd.SysConfigDetails = mclsSysConfigDetails;
clsContactWnd.TerminalDetails = mclsTerminalDetails;
if (clsCardTypeDetails.WithGuarantor)
{
MessageBox.Show("Please select a GUARANTOR to issue Credit Card.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
clsContactWnd.ContactGroupCategory = AceSoft.RetailPlus.Data.ContactGroupCategory.CUSTOMER;
clsContactWnd.Header = "Select GUARANTOR to issue Credit Card.";
clsContactWnd.ShowDialog(this);
clsGuarantorDetails = clsContactWnd.Details;
result = clsContactWnd.Result;
clsContactWnd.Close();
clsContactWnd.Dispose();
if (result != DialogResult.OK)
{ return; }
MessageBox.Show(clsGuarantorDetails.ContactName + " has been selected as guarantor." + Environment.NewLine + "Please select the CUSTOMER to issue Credit Card.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
clsContactWnd = new ContactSelectWnd();
clsContactWnd.EnableContactAddUpdate = GetWriteAccess(mclsSalesTransactionDetails.CashierID, AccessTypes.Contacts) == System.Windows.Forms.DialogResult.OK;
clsContactWnd.SysConfigDetails = mclsSysConfigDetails;
clsContactWnd.TerminalDetails = mclsTerminalDetails;
clsContactWnd.ContactGroupCategory = AceSoft.RetailPlus.Data.ContactGroupCategory.CUSTOMER;
clsContactWnd.Header = "Select CUSTOMER to issue Credit Card.";
clsContactWnd.ShowDialog(this);
clsContactDetails = clsContactWnd.Details;
result = clsContactWnd.Result;
clsContactWnd.Close();
clsContactWnd.Dispose();
if (result != DialogResult.OK)
{ return; }
if (clsContactDetails.ContactID == Constants.ZERO || clsContactDetails.ContactID == Constants.C_RETAILPLUS_CUSTOMERID)
{ return; }
// if no guarantor
if (!clsCardTypeDetails.WithGuarantor) clsGuarantorDetails = new Data.ContactDetails();
clsEvent.AddEvent("[" + lblCashier.Text + "] Issuing credit card no to " + clsContactDetails.ContactName);
Data.Contacts clsContact = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContact.Connection; mTransaction = clsContact.Transaction;
clsContactDetails = clsContact.Details(clsContactDetails.ContactID);
clsContact.CommitAndDispose();
if (clsContactDetails.CreditDetails.CreditCardNo != string.Empty && clsContactDetails.CreditDetails.CreditCardNo != null)
{
clsEvent.AddEventLn("Cancelled!");
clsEvent.AddEventLn("Credit Card No: " + clsContactDetails.CreditDetails.CreditCardNo + " was already issued to " + clsContactDetails.ContactName + " on " + clsContactDetails.CreditDetails.CreditAwardDate.ToString("MMM dd, yyyy hh:mm tt"));
MessageBox.Show("Credit Card No: " + clsContactDetails.CreditDetails.CreditCardNo + " was already issued to " + clsContactDetails.ContactName + " on " + clsContactDetails.CreditDetails.CreditAwardDate.ToString("MMM dd, yyyy hh:mm tt") + "." +
Environment.NewLine + " Please select another customer to issue Credit Card.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
clsEvent.AddEvent("[" + lblCashier.Text + "] Issuing credit card no to " + clsContactDetails.ContactName);
ContactCreditWnd clsContactCreditWnd = new ContactCreditWnd();
clsContactCreditWnd.Header = "Credit Card Issuance";
clsContactCreditWnd.CardTypeDetails = clsCardTypeDetails;
clsContactCreditWnd.Guarantor = clsGuarantorDetails;
clsContactCreditWnd.ContactDetails = clsContactDetails;
clsContactCreditWnd.CreditCardStatus = CreditCardStatus.New;
clsContactCreditWnd.TerminalDetails = mclsTerminalDetails;
clsContactCreditWnd.ShowDialog(this);
result = clsContactCreditWnd.Result;
clsContactDetails = clsContactCreditWnd.ContactDetails;
clsContactCreditWnd.Close();
clsContactCreditWnd.Dispose();
if (result == DialogResult.OK)
{
Data.Products clsProducts = new Data.Products(mConnection, mTransaction);
mConnection = clsProducts.Connection; mTransaction = clsProducts.Transaction;
string strProductBarcode = Data.Products.DEFAULT_CREDIT_CARD_MEMBERSHIP_FEE_BARCODE;
//override if with Guarantor
if (clsCardTypeDetails.WithGuarantor)
strProductBarcode = Data.Products.DEFAULT_SUPER_CARD_MEMBERSHIP_FEE_BARCODE;
if (clsProducts.Details(strProductBarcode).ProductID == 0)
{
if (!clsCardTypeDetails.WithGuarantor)
clsProducts.CREATE_CREDIT_CARD_MEMBERSHIP_FEE_BARCODE_PRODUCT();
else
clsProducts.CREATE_SUPER_CARD_MEMBERSHIP_FEE_BARCODE_PRODUCT();
Methods.InsertAuditLog(mclsTerminalDetails, "System Administrator", AccessTypes.RewardCardChange, strProductBarcode + " product has been created coz it's not configured");
}
clsProducts.CommitAndDispose();
MessageBox.Show("Credit Card No: " + clsContactDetails.CreditDetails.CreditCardNo + " was issued to " + clsContactDetails.ContactName + "." +
Environment.NewLine + "Please collect the payment then close the transaction.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
clsEvent.AddEventLn("Done!", true);
clsEvent.AddEventLn("Credit Card No: " + clsContactDetails.CreditDetails.CreditCardNo + " was issued to " + clsContactDetails.ContactName + ".", true);
LocalDB clsLocalDB = new LocalDB(mConnection, mTransaction);
mConnection = clsLocalDB.Connection; mTransaction = clsLocalDB.Transaction;
clsEvent.AddEvent("[" + lblCashier.Text + "] Creating " + strProductBarcode + "transaction for customer: ");
LoadContact(AceSoft.RetailPlus.Data.ContactGroupCategory.CUSTOMER, clsContactDetails);
if (!this.CreateTransaction()) return;
txtBarCode.Text = strProductBarcode;
ReadBarCode();
int iRow = dgItems.CurrentRowIndex;
txtBarCode.Text = "";
CloseTransaction();
clsLocalDB.CommitAndDispose();
}
else { clsEvent.AddEventLn("Cancelled!"); }
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERROR!!! Issuing internal credit-card.");
}
Cursor.Current = Cursors.Default;
}
}
private bool SuspendTransaction(bool ShowNotificationWindow = true)
{
bool boRetValue = false;
if (!mboIsInTransaction)
{
MessageBox.Show("Sorry you cannot suspend an empty transaction.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return boRetValue;
}
//if (mboIsRefund)
//{
// MessageBox.Show("Sorry you cannot suspend a REFUND transaction.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return boRetValue;
//}
DialogResult loginresult = GetWriteAccessAndLogin(mclsSalesTransactionDetails.CashierID, AccessTypes.SuspendTransaction);
if (loginresult == DialogResult.OK)
{
if (mclsSalesTransactionDetails.TransactionStatus == TransactionStatus.Closed)
{
this.LoadOptions();
boRetValue = true;
return boRetValue;
}
if (mclsSalesTransactionDetails.CustomerID == Constants.C_RETAILPLUS_CUSTOMERID)
{
try
{
clsEvent.AddEvent("[" + lblCashier.Text + "] Suspending transaction no. " + lblTransNo.Text);
Data.ContactDetails details = new Data.ContactDetails();
DialogResult addresult = System.Windows.Forms.DialogResult.Cancel;
switch (mclsSysConfigDetails.ContactAddWndType)
{
case ContactAddWndType.ContactAddWnd:
case ContactAddWndType.ContactAddNoLTOWnd:
ContactAddWnd clsContactAddWnd = new ContactAddWnd();
clsContactAddWnd.Caption = "Suspend Transaction: Please Enter Customer Name";
clsContactAddWnd.ContactDetails = details;
clsContactAddWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddWnd.SysConfigDetails = mclsSysConfigDetails;
clsContactAddWnd.ShowDialog(this);
addresult = clsContactAddWnd.Result;
details = clsContactAddWnd.ContactDetails;
clsContactAddWnd.Close();
clsContactAddWnd.Dispose();
break;
case ContactAddWndType.ContactAddHCareWnd:
ContactAddHCareWnd clsContactAddHCareWnd = new ContactAddHCareWnd();
clsContactAddHCareWnd.Caption = "Suspend Transaction: Please Enter Customer Name";
clsContactAddHCareWnd.ContactDetails = details;
clsContactAddHCareWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddHCareWnd.CashierID = mclsSalesTransactionDetails.CashierID;
clsContactAddHCareWnd.ShowDialog(this);
addresult = clsContactAddHCareWnd.Result;
details = clsContactAddHCareWnd.ContactDetails;
clsContactAddHCareWnd.Close();
clsContactAddHCareWnd.Dispose();
break;
default:
ContactAddDetWnd clsContactAddDetWnd = new ContactAddDetWnd();
clsContactAddDetWnd.Caption = "Suspend Transaction: Please Enter Customer Name";
clsContactAddDetWnd.ContactDetails = details;
clsContactAddDetWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddDetWnd.ShowDialog(this);
addresult = clsContactAddDetWnd.Result;
details = clsContactAddDetWnd.ContactDetails;
clsContactAddDetWnd.Close();
clsContactAddDetWnd.Dispose();
break;
}
if (addresult == DialogResult.OK)
{
Cursor.Current = Cursors.WaitCursor;
LoadContact(Data.ContactGroupCategory.CUSTOMER, details);
lblCustomer.Text = details.ContactName;
lblCustomer.Tag = details.ContactID.ToString();
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(mConnection, mTransaction);
mConnection = clsSalesTransactions.Connection; mTransaction = clsSalesTransactions.Transaction;
clsSalesTransactions.Suspend(mclsSalesTransactionDetails.TransactionID, mclsSalesTransactionDetails.GrossSales, mclsSalesTransactionDetails.SubTotal, mclsSalesTransactionDetails.NetSales, details);
// Sep 24, 2014 : update back the LastCheckInDate to min date
Data.Contacts clsContact = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContact.Connection; mTransaction = clsContact.Transaction;
clsContact.UpdateLastCheckInDate(mclsSalesTransactionDetails.CustomerID, mclsSalesTransactionDetails.TransactionDate);
InsertAuditLog(AccessTypes.SuspendTransaction, "Suspend transaction #: " + lblTransNo.Text + " @ Branch: " + mclsTerminalDetails.BranchDetails.BranchCode);
if (mclsTerminalDetails.AutoPrint == PrintingPreference.Auto)
PrintReportFooterSection(true, TransactionStatus.Suspended, mclsSalesTransactionDetails.ItemSold, mclsSalesTransactionDetails.QuantitySold, mclsSalesTransactionDetails.SubTotal, mclsSalesTransactionDetails.Discount, mclsSalesTransactionDetails.Charge, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, null, null);
clsSalesTransactions.CommitAndDispose();
clsEvent.AddEventLn("Done!", true);
// Added Jun 30, 2013
if (mclsTerminalDetails.IsParkingTerminal)
{
if (MessageBox.Show("Would you like to print the Parking Ticket?", "Print Parking Ticket", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
PrintParkingTicket();
}
this.LoadOptions();
MessageBox.Show("Transaction has been SUSPENDED. Press OK button to continue...", "RetailPlus", MessageBoxButtons.OK);
boRetValue = true;
Cursor.Current = Cursors.Default;
}
else { clsEvent.AddEventLn("Cancelled!"); }
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERROR!!! Suspending transaction.");
}
}
else
{
try
{
clsEvent.AddEvent("[" + lblCashier.Text + "] Suspending transaction no. " + lblTransNo.Text);
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(mConnection, mTransaction);
mConnection = clsSalesTransactions.Connection; mTransaction = clsSalesTransactions.Transaction;
clsSalesTransactions.Suspend(mclsSalesTransactionDetails.TransactionID, mclsSalesTransactionDetails.GrossSales, mclsSalesTransactionDetails.SubTotal, mclsSalesTransactionDetails.NetSales);
InsertAuditLog(AccessTypes.SuspendTransaction, "Suspend transaction #: " + lblTransNo.Text + " @ Branch: " + mclsTerminalDetails.BranchDetails.BranchCode);
if (mclsTerminalDetails.AutoPrint == PrintingPreference.Auto)
PrintReportFooterSection(true, TransactionStatus.Suspended, mclsSalesTransactionDetails.ItemSold, mclsSalesTransactionDetails.QuantitySold, mclsSalesTransactionDetails.SubTotal, mclsSalesTransactionDetails.Discount, mclsSalesTransactionDetails.Charge, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, null, null);
clsSalesTransactions.CommitAndDispose();
clsEvent.AddEventLn("Done!", true);
// Added Jun 30, 2013
if (mclsTerminalDetails.IsParkingTerminal)
{
if (MessageBox.Show("Would you like to print the Parking Ticket?", "Print Parking Ticket", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
PrintParkingTicket();
}
this.LoadOptions();
MessageBox.Show("Transaction has been SUSPENDED. Press OK button to continue...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
boRetValue = true;
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERROR!!! Suspending transaction.");
}
}
}
return boRetValue;
}
private void UpdateContact()
{
try {
DialogResult loginresult = GetWriteAccessAndLogin(mclsSalesTransactionDetails.CashierID, AccessTypes.Contacts);
if (loginresult == DialogResult.OK)
{
loginresult = System.Windows.Forms.DialogResult.Cancel;
Data.ContactDetails clsContactDetails = new Data.ContactDetails();
if (mclsSalesTransactionDetails.CustomerID != 0 && mclsSalesTransactionDetails.CustomerID != Constants.C_RETAILPLUS_CUSTOMERID)
{
Data.Contacts clsContact = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContact.Connection; mTransaction = clsContact.Transaction;
clsContactDetails = clsContact.Details(mclsSalesTransactionDetails.CustomerID);
clsContact.CommitAndDispose();
loginresult = System.Windows.Forms.DialogResult.OK;
}
else
{
ContactSelectWnd clsContactWnd = new ContactSelectWnd();
clsContactWnd.EnableContactAddUpdate = GetWriteAccess(mclsSalesTransactionDetails.CashierID, AccessTypes.Contacts) == System.Windows.Forms.DialogResult.OK;
clsContactWnd.SysConfigDetails = mclsSysConfigDetails;
clsContactWnd.TerminalDetails = mclsTerminalDetails;
clsContactWnd.ContactGroupCategory = Data.ContactGroupCategory.CUSTOMER;
clsContactWnd.ShowDialog(this);
clsContactDetails = clsContactWnd.Details;
loginresult = clsContactWnd.Result;
clsContactWnd.Close();
clsContactWnd.Dispose();
}
if (loginresult == System.Windows.Forms.DialogResult.OK)
{
DialogResult addresult = System.Windows.Forms.DialogResult.Cancel;
switch (mclsSysConfigDetails.ContactAddWndType)
{
case ContactAddWndType.ContactAddWnd:
case ContactAddWndType.ContactAddNoLTOWnd:
ContactAddWnd clsContactAddWnd = new ContactAddWnd();
clsContactAddWnd.Caption = "Update Customer [" + mclsContactDetails.ContactName + "]";
clsContactAddWnd.ContactDetails = clsContactDetails;
clsContactAddWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddWnd.SysConfigDetails = mclsSysConfigDetails;
clsContactAddWnd.ShowDialog(this);
addresult = clsContactAddWnd.Result;
clsContactDetails = clsContactAddWnd.ContactDetails;
clsContactAddWnd.Close();
clsContactAddWnd.Dispose();
break;
case ContactAddWndType.ContactAddHCareWnd:
ContactAddHCareWnd clsContactAddHCareWnd = new ContactAddHCareWnd();
clsContactAddHCareWnd.Caption = "Update Customer [" + mclsContactDetails.ContactName + "]";
clsContactAddHCareWnd.ContactDetails = clsContactDetails;
clsContactAddHCareWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddHCareWnd.ShowDialog(this);
addresult = clsContactAddHCareWnd.Result;
clsContactDetails = clsContactAddHCareWnd.ContactDetails;
clsContactAddHCareWnd.Close();
clsContactAddHCareWnd.Dispose();
break;
default:
ContactAddDetWnd clsContactAddDetWnd = new ContactAddDetWnd();
clsContactAddDetWnd.Caption = "Update Customer [" + mclsContactDetails.ContactName + "]";
clsContactAddDetWnd.ContactDetails = clsContactDetails;
clsContactAddDetWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddDetWnd.ShowDialog(this);
addresult = clsContactAddDetWnd.Result;
clsContactDetails = clsContactAddDetWnd.ContactDetails;
clsContactAddDetWnd.Close();
clsContactAddDetWnd.Dispose();
break;
}
if (addresult == DialogResult.OK)
{
if (mboIsInTransaction)
{
LoadContact(Data.ContactGroupCategory.CUSTOMER, clsContactDetails);
}
MessageBox.Show("Customer has been updated and the details has been reloaded for this transaction.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
catch { }
}
private void cmdTable_Click(object sender, EventArgs e)
{
try
{
ProductButton cmdTable = (ProductButton)sender;
Data.Contacts clsContact = new Contacts();
mDetails = clsContact.Details(long.Parse(cmdTable.Tag.ToString()));
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(clsContact.Connection, clsContact.Transaction);
string stTransactionNo = clsSalesTransactions.getSuspendedTransactionNo(mDetails.ContactID, mclsTerminalDetails.TerminalNo, mclsTerminalDetails.BranchID);
Data.SalesTransactionDetails clsSalesTransactionDetails = new SalesTransactionDetails();
if (!string.IsNullOrEmpty(stTransactionNo))
{
clsSalesTransactionDetails = clsSalesTransactions.Details(stTransactionNo, mclsTerminalDetails.TerminalNo, mclsTerminalDetails.BranchID);
}
clsContact.CommitAndDispose();
if (!string.IsNullOrEmpty(stTransactionNo) && clsSalesTransactionDetails.TransactionStatus == TransactionStatus.SuspendedOpen)
{
if (MessageBox.Show("This transaction is already open in another terminal. Please suspend in the other terminal first before opening." + Environment.NewLine + "Would you like to force open this transaction?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
//LoadContactData(System.Data.SqlClient.SortOrder.Ascending);
return;
}
else
{
DialogResult resResumeSuspendedOpenTransaction = GetWriteAccessAndLogin(CashierID, AccessTypes.ResumeSuspendedOpenTransaction);
if (resResumeSuspendedOpenTransaction != System.Windows.Forms.DialogResult.OK)
{
//LoadContactData(System.Data.SqlClient.SortOrder.Ascending);
return;
}
}
}
dialog = DialogResult.OK;
this.Hide();
}
catch { }
}
private bool SaveRecord()
{
Data.ContactDetails clsDetails = new Data.ContactDetails();
clsDetails = mContactDetails;
clsDetails.ContactCode = txtCustomerName.Text;
clsDetails.ContactName = txtCustomerName.Text;
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelNo.Text;
// Jul 22, 2014
clsDetails.Debit = mContactDetails.Debit;
clsDetails.Credit = mContactDetails.Credit;
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
clsDetails.CreditLimit = decimal.Parse(txtCreditLimit.Text);
clsDetails.Terms = int.Parse(txtTerms.Text);
clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboTerms.SelectedItem.ToString());
Data.Contacts clsContact = new Data.Contacts();
if (mContactDetails.ContactID == 0)
{
if (mstCaption == "Please enter customer name for deposit.")
{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_DEPOSIT; }
else if (mstCaption == "Quickly add new customer")
{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_QUICKLY_ADDED_FROM_FE; }
else if (mContactDetails.ContactID == 0) // means not edit
{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_CLIENT; }
clsDetails.ContactGroupID = Constants.CONTACT_GROUP_CUSTOMER;
clsDetails.PositionID = Constants.C_RETAILPLUS_AGENT_POSITIONID;
clsDetails.DepartmentID = Constants.C_RETAILPLUS_AGENT_DEPARTMENTID;
clsDetails.ContactID = clsContact.Insert(clsDetails);
}
else
{
clsDetails.ContactCode = mContactDetails.ContactCode;
clsDetails.ContactGroupID = mContactDetails.ContactGroupID;
clsDetails.ContactGroupName = mContactDetails.ContactGroupName;
clsContact.Update(clsDetails);
}
clsContact.CommitAndDispose();
mContactDetails = clsDetails;
return true;
}
private void txtCardNo_TextChanged(object sender, EventArgs e)
{
mclsCreditorDetails = new Data.ContactDetails();
if (!string.IsNullOrEmpty(txtCardNo.Text)
&& txtScan.Text.Length >= 12
&& txtScan.Text != mclsCreditorDetails.CreditDetails.CreditCardNo)
{
Data.Contacts clsContacts = new Data.Contacts();
mclsCreditorDetails = clsContacts.DetailsByCreditCardNo(txtCardNo.Text);
//if (mclsCreditorDetails.ContactID == 0)
//{
// //mContactDetails = clsContacts.DetailsByCreditCardNo(txtScan.Text.Remove(txtScan.Text.Length - 1));
// if (mclsCreditorDetails.ContactID == 0 && txtScan.Text.Length == 7) mclsCreditorDetails = clsContacts.DetailsByCreditCardNo("888880" + txtScan.Text);
// if (mclsCreditorDetails.ContactID == 0 && txtScan.Text.Length == 7) mclsCreditorDetails = clsContacts.DetailsByCreditCardNo("800000" + txtScan.Text);
// if (mclsCreditorDetails.ContactID == 0 && txtScan.Text.Length == 9) mclsCreditorDetails = clsContacts.DetailsByCreditCardNo(BarcodeHelper.GroupCreditCard_Country_Code + BarcodeHelper.GroupCreditCard_ManufacturerCode + txtScan.Text);
// if (mclsCreditorDetails.ContactID == 0 && txtScan.Text.Length == 9) mclsCreditorDetails = clsContacts.DetailsByCreditCardNo(BarcodeHelper.CreditCard_Country_Code + BarcodeHelper.CreditCard_ManufacturerCode + txtScan.Text);
//}
clsContacts.CommitAndDispose();
}
//this means that this uses an internal credit card
setCreditor();
if (mclsCreditorDetails.ContactID != 0)
setCreditCardChargeAmount();
else
unsetCreditCardCharge();
}
private bool setCreditor()
{
if (string.IsNullOrEmpty(txtCardNo.Text))
{
mclsCreditorDetails = new Data.ContactDetails();
}
if (!string.IsNullOrEmpty(txtCardNo.Text))
{
string strContactCardNo = txtCardNo.Text;
Data.Contacts clsContacts = new Data.Contacts();
mclsCreditorDetails = clsContacts.DetailsByCreditCardNo(strContactCardNo);
if (mclsCreditorDetails.ContactID == 0)
{
strContactCardNo = strContactCardNo.Remove(strContactCardNo.Length - 1);
mclsCreditorDetails = clsContacts.DetailsByCreditCardNo(strContactCardNo);
}
clsContacts.CommitAndDispose();
if(mclsCreditorDetails.ContactID != 0)
{
cboCardType.SelectedText = mclsCreditorDetails.CreditDetails.CardTypeDetails.CardTypeName;
cboCardType.Text = mclsCreditorDetails.CreditDetails.CardTypeDetails.CardTypeName;
cboCardType_SelectedIndexChanged(null, null);
txtCardHolder.Text = mclsCreditorDetails.ContactName;
if (mclsCreditorDetails.CreditDetails.ExpiryDate == Constants.C_DATE_MIN_VALUE)
txtValidityDates.Text = "";
else
txtValidityDates.Text = mclsCreditorDetails.CreditDetails.ExpiryDate.ToString("MMyy");
}
}
return true;
}
private void ContactAdd()
{
if (!EnableContactAddUpdate) return;
Data.ContactDetails details = new Data.ContactDetails();
DialogResult addresult = System.Windows.Forms.DialogResult.Cancel;
switch (SysConfigDetails.ContactAddWndType)
{
case ContactAddWndType.ContactAddWnd:
case ContactAddWndType.ContactAddNoLTOWnd:
ContactAddWnd clsContactAddWnd = new ContactAddWnd();
clsContactAddWnd.Caption = "Quickly add new customer.";
clsContactAddWnd.ContactDetails = details;
clsContactAddWnd.TerminalDetails = TerminalDetails;
clsContactAddWnd.SysConfigDetails = SysConfigDetails;
clsContactAddWnd.ShowDialog(this);
addresult = clsContactAddWnd.Result;
details = clsContactAddWnd.ContactDetails;
clsContactAddWnd.Close();
clsContactAddWnd.Dispose();
break;
case ContactAddWndType.ContactAddHCareWnd:
ContactAddHCareWnd clsContactAddHCareWnd = new ContactAddHCareWnd();
clsContactAddHCareWnd.Caption = "Quickly add new customer.";
clsContactAddHCareWnd.ContactDetails = details;
clsContactAddHCareWnd.TerminalDetails = TerminalDetails;
clsContactAddHCareWnd.ShowDialog(this);
addresult = clsContactAddHCareWnd.Result;
details = clsContactAddHCareWnd.ContactDetails;
clsContactAddHCareWnd.Close();
clsContactAddHCareWnd.Dispose();
break;
default:
ContactAddDetWnd clsContactAddDetWnd = new ContactAddDetWnd();
clsContactAddDetWnd.Caption = "Quickly add new customer.";
clsContactAddDetWnd.ContactDetails = details;
clsContactAddDetWnd.TerminalDetails = TerminalDetails;
clsContactAddDetWnd.ShowDialog(this);
addresult = clsContactAddDetWnd.Result;
details = clsContactAddDetWnd.ContactDetails;
clsContactAddDetWnd.Close();
clsContactAddDetWnd.Dispose();
break;
}
if (addresult == DialogResult.OK)
{
txtSearch.Text = details.ContactCode;
LoadContactData();
}
}
private void LoadOptions()
{
mContactDetails = new Data.ContactDetails();
mGuarantorDetails = new Data.ContactDetails();
txtScan.Focus();
txtScan.Size = new Size(726, 30);
switch (SysConfigDetails.CreditPaymentType)
{
case CreditPaymentType.MPC:
case CreditPaymentType.Normal:
default:
lblF11.Visible = true; labelF11.Visible = true;
txtScan.Size = new Size(558, 30);
break;
}
}
private void ContactAdd()
{
Data.ContactDetails details = new Data.ContactDetails();
System.Windows.Forms.DialogResult addresult = System.Windows.Forms.DialogResult.Cancel;
switch (SysConfigDetails.ContactAddWndType)
{
case ContactAddWndType.ContactAddWnd:
ContactAddWnd clsContactAddWnd = new ContactAddWnd();
clsContactAddWnd.Caption = "Please enter customer name for deposit.";
clsContactAddWnd.ContactDetails = details;
clsContactAddWnd.TerminalDetails = TerminalDetails;
clsContactAddWnd.ShowDialog(this);
addresult = clsContactAddWnd.Result;
details = clsContactAddWnd.ContactDetails;
clsContactAddWnd.Close();
clsContactAddWnd.Dispose();
break;
case ContactAddWndType.ContactAddHCareWnd:
ContactAddHCareWnd clsContactAddHCareWnd = new ContactAddHCareWnd();
clsContactAddHCareWnd.Caption = "Please enter customer name for deposit.";
clsContactAddHCareWnd.ContactDetails = details;
clsContactAddHCareWnd.TerminalDetails = TerminalDetails;
clsContactAddHCareWnd.ShowDialog(this);
addresult = clsContactAddHCareWnd.Result;
details = clsContactAddHCareWnd.ContactDetails;
clsContactAddHCareWnd.Close();
clsContactAddHCareWnd.Dispose();
break;
default:
ContactAddDetWnd clsContactAddDetWnd = new ContactAddDetWnd();
clsContactAddDetWnd.Caption = "Please enter customer name for deposit.";
clsContactAddDetWnd.ContactDetails = details;
clsContactAddDetWnd.TerminalDetails = TerminalDetails;
clsContactAddDetWnd.ShowDialog(this);
addresult = clsContactAddDetWnd.Result;
details = clsContactAddDetWnd.ContactDetails;
clsContactAddDetWnd.Close();
clsContactAddDetWnd.Dispose();
break;
}
if (addresult == DialogResult.OK)
{
txtContact.Text = details.ContactName;
txtContact.Tag = details.ContactID.ToString();
}
}
/// <summary>
/// This is to print the Internal Credit Card used for payment
/// </summary>
/// <param name="clsChargeSlipType"></param>
public void PrintChargeSlip(ChargeSlipType clsChargeSlipType)
{
try
{
decimal decInternalCreditCardPayment = 0;
Data.ContactDetails clsCreditorDetails = new Data.ContactDetails();
Data.ContactDetails clsGuarantorDetails = new Data.ContactDetails();
Data.CardTypeDetails clsCreditCardTypeDetails = new Data.CardTypeDetails();
foreach (Data.CreditCardPaymentDetails clsCreditCardPaymentDetails in mclsSalesTransactionDetails.PaymentDetails.arrCreditCardPaymentDetails)
{
if (clsCreditCardPaymentDetails.CardTypeDetails.CreditCardType == CreditCardTypes.Internal)
{
decInternalCreditCardPayment += clsCreditCardPaymentDetails.Amount;
clsCreditCardTypeDetails = clsCreditCardPaymentDetails.CardTypeDetails;
clsCreditorDetails = clsCreditCardPaymentDetails.CreditorDetails;
Data.Contacts clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
if (clsCreditCardTypeDetails.WithGuarantor)
{
clsGuarantorDetails = new Data.Contacts(mConnection, mTransaction).Details(clsCreditorDetails.CreditDetails.GuarantorID);
}
clsContacts.CommitAndDispose();
}
}
if (decInternalCreditCardPayment != 0)
{
PrintingPreference oldCONFIG_AutoPrint = mclsTerminalDetails.AutoPrint;
mclsTerminalDetails.AutoPrint = PrintingPreference.Normal;
PrintReportHeaderSection(false, DateTime.MinValue);
if (!string.IsNullOrEmpty(mclsSysConfigDetails.ChargeSlipHeaderLabel))
{
msbToPrint.Append(CenterString(mclsSysConfigDetails.ChargeSlipHeaderLabel, mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append(CenterString(Constants.C_FE_NOT_VALID_AS_RECEIPT, mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
}
msbToPrint.Append(Environment.NewLine);
msbToPrint.Append(Environment.NewLine);
msbToPrint.Append("Trans. Date".PadRight(15) + ":" + mclsSalesTransactionDetails.TransactionDate.ToString("yyyy-MM-dd").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 16) + Environment.NewLine);
msbToPrint.Append("OR #".PadRight(15) + ":" + mclsSalesTransactionDetails.ORNo.PadLeft(mclsTerminalDetails.MaxReceiptWidth - 16) + Environment.NewLine);
// print the guarantor if with guarantor
if (clsCreditCardTypeDetails.WithGuarantor)
{
msbToPrint.Append(CenterString(clsGuarantorDetails.ContactCode, mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadLeft(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Guarantor", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
}
msbToPrint.Append(Environment.NewLine);
// print the charge slip header
if (string.IsNullOrEmpty(clsCreditCardTypeDetails.CardTypeName))
{ msbToPrint.Append(CenterString("CHARGE SLIP", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine); }
else { msbToPrint.Append(CenterString(clsCreditCardTypeDetails.CardTypeName + " CHARGE SLIP", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine); }
// print the amount and agreement
msbToPrint.Append(Environment.NewLine);
msbToPrint.Append("Amount of Purchase".PadRight(18) + ":" + decInternalCreditCardPayment.ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 19) + Environment.NewLine);
msbToPrint.Append(Environment.NewLine);
if (mclsTerminalDetails.IncludeCreditChargeAgreement)
{
msbToPrint.Append("I hereby agree to pay the total amount" + Environment.NewLine);
msbToPrint.Append("stated herein including any charges due" + Environment.NewLine);
msbToPrint.Append("thereon subject to the pertinent" + Environment.NewLine);
msbToPrint.Append("contract governing the use of this" + Environment.NewLine);
msbToPrint.Append("Credit Card." + Environment.NewLine);
msbToPrint.Append(Environment.NewLine);
msbToPrint.Append(Environment.NewLine);
}
msbToPrint.Append("-".PadLeft(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString(mclsSalesTransactionDetails.CustomerName, mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append(Environment.NewLine);
msbToPrint.Append(Environment.NewLine);
msbToPrint.Append("-".PadLeft(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString(mclsSalesTransactionDetails.CashierName, mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append(CenterString("Cashier", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append(Environment.NewLine);
switch (clsChargeSlipType)
{
case ChargeSlipType.Customer:
msbToPrint.Append(CenterString("Customer's Copy", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
break;
case ChargeSlipType.Original:
msbToPrint.Append(CenterString("Original Copy", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
break;
case ChargeSlipType.Guarantor:
msbToPrint.Append(CenterString("Guarantor's Copy", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
break;
}
msbToPrint.Append(CenterString("Check Ctr:" + Int64.Parse(mclsSalesTransactionDetails.TransactionNo).ToString(), mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
PrintPageAndReportFooterSection(false, DateTime.MinValue);
mclsTerminalDetails.AutoPrint = oldCONFIG_AutoPrint;
InsertAuditLog(AccessTypes.PrintTransactionHeader, "Print Charge Slip: " + clsChargeSlipType.ToString("G") + " TerminalNo=" + mclsTerminalDetails.TerminalNo + " @ Branch: " + mclsTerminalDetails.BranchDetails.BranchCode);
}
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERROR!!! Printing Charge Slip: " + clsChargeSlipType.ToString("G"));
}
Cursor.Current = Cursors.Default;
}
private void ShowCreditCardPaymentWindow(string sender = "f3")
{
CreditCardPaymentWnd clsCreditCardPaymentWnd = new CreditCardPaymentWnd();
clsCreditCardPaymentWnd.IsCreditChargeExcluded = mboIsCreditChargeExcluded;
clsCreditCardPaymentWnd.TerminalDetails = TerminalDetails;
clsCreditCardPaymentWnd.SysConfigDetails = SysConfigDetails;
clsCreditCardPaymentWnd.OfflineProduct = OfflineProductDesc;
clsCreditCardPaymentWnd.SalesTransactionDetails = mclsSalesTransactionDetails;
if (sender == "f4") clsCreditCardPaymentWnd.CreditorDetails = mclsCustomerDetails;
clsCreditCardPaymentWnd.arrCreditCardPaymentDetails = marrCreditCardPaymentDetails;
clsCreditCardPaymentWnd.IsRefund = mboIsRefund;
clsCreditCardPaymentWnd.BalanceAmount = Convert.ToDecimal(lblBalance.Text);
clsCreditCardPaymentWnd.ShowDialog(this);
DialogResult result = clsCreditCardPaymentWnd.Result;
Data.CreditCardPaymentDetails creditcardDetails = clsCreditCardPaymentWnd.Details;
mclsCreditorDetails = clsCreditCardPaymentWnd.CreditorDetails;
clsCreditCardPaymentWnd.Close();
clsCreditCardPaymentWnd.Dispose();
if (result == DialogResult.OK)
{
// set the credit card charges for inhouse credit cards
if (creditcardDetails.AdditionalCharge != 0)
{
lblCharge.Text = (decimal.Parse(lblCharge.Text) + creditcardDetails.AdditionalCharge).ToString("#,##0.#0");
mclsSalesTransactionDetails.CreditChargeAmount = creditcardDetails.AdditionalCharge;
}
lblAmountPaid.Text = Convert.ToDecimal(Convert.ToDecimal(lblAmountPaid.Text) + creditcardDetails.Amount).ToString("#,##0.#0");
marrCreditCardPaymentDetails.Add(creditcardDetails);
ComputePayments();
lblCreditCard.Tag = Convert.ToDecimal(Convert.ToDecimal(lblCreditCard.Tag) + creditcardDetails.Amount - Convert.ToDecimal(lblChange.Text)).ToString("#,##0.#0");
if (mPaymentType == PaymentTypes.NotYetAssigned)
mPaymentType = PaymentTypes.CreditCard;
else
mPaymentType = PaymentTypes.Combination;
}
}
private bool SaveRecord()
{
if (MessageBox.Show("Please validate the customer information details before proceeding. Are you sure you want to continue?", "RetailPlus ™", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No)
{
return(false);
}
else
{
Data.ContactDetails clsDetails = new Data.ContactDetails();
clsDetails = mContactDetails;
clsDetails.ContactCode = txtContactCode.Text;
clsDetails.ContactName = txtContactName.Text;
clsDetails.ContactGroupID = Convert.ToInt32(Constants.CONTACT_GROUP_CUSTOMER);
clsDetails.ModeOfTerms = ModeOfTerms.Days;
clsDetails.Terms = Convert.ToInt32("0");
clsDetails.TINNo = txtTelephoneNo.Tag == null ? "" : txtTelephoneNo.Tag.ToString();
clsDetails.LTONo = txtRemarks.Tag == null ? "" : txtRemarks.Tag.ToString();
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelephoneNo.Text;
clsDetails.Remarks = txtRemarks.Text;
//clsDetails.Debit = Convert.ToDecimal("0");
//clsDetails.Credit = Convert.ToDecimal(txtCredit.Text);
//clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
//clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text);
//clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value);
//clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value);
Data.ContactAddOnDetails clsAddOnDetails = new Data.ContactAddOnDetails();
clsAddOnDetails.ContactID = clsDetails.ContactID;
clsAddOnDetails.Salutation = cboSalutation.SelectedValue.ToString();
clsAddOnDetails.FirstName = txtFirstName.Text;
clsAddOnDetails.MiddleName = txtMiddleName.Text;
clsAddOnDetails.LastName = txtLastName.Text;
clsAddOnDetails.SpouseName = "";
DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE;
dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.BirthDate = dteBirthDate;
clsAddOnDetails.SpouseBirthDate = Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.AnniversaryDate = Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.Address1 = txtAddress.Text;
clsAddOnDetails.Address2 = string.Empty;
clsAddOnDetails.City = string.Empty;
clsAddOnDetails.State = string.Empty;
clsAddOnDetails.ZipCode = string.Empty;
clsAddOnDetails.CountryID = Constants.C_DEF_COUNTRY_ID;
clsAddOnDetails.CountryCode = Constants.C_DEF_COUNTRY_CODE;
clsAddOnDetails.BusinessPhoneNo = txtTelephoneNo.Text;
clsAddOnDetails.HomePhoneNo = string.Empty;
clsAddOnDetails.MobileNo = txtMobileNo.Text;
clsAddOnDetails.FaxNo = string.Empty;
clsAddOnDetails.EmailAddress = string.Empty;
clsDetails.AdditionalDetails = clsAddOnDetails;
Data.Contacts clsContact = new Data.Contacts();
if (mContactDetails.ContactID == 0)
{
clsDetails.ContactGroupID = Constants.CONTACT_GROUP_CUSTOMER;
clsDetails.PositionID = Constants.C_RETAILPLUS_AGENT_POSITIONID;
clsDetails.DepartmentID = Constants.C_RETAILPLUS_AGENT_DEPARTMENTID;
clsDetails.ContactID = clsContact.Insert(clsDetails);
}
else
{
clsDetails.PositionID = mContactDetails.PositionID;
clsDetails.DepartmentID = mContactDetails.DepartmentID;
clsDetails.ContactGroupID = mContactDetails.ContactGroupID;
clsDetails.ContactGroupName = mContactDetails.ContactGroupName;
clsContact.Update(clsDetails);
}
clsContact.CommitAndDispose();
mContactDetails = clsDetails;
return(true);
}
}
private bool isValuesAssigned()
{
decimal mdecAmount = 0;
try
{
mdecAmount = Convert.ToDecimal(txtAmount.Text);
}
catch
{
txtAmount.Focus();
MessageBox.Show("Sorry you have entered an invalid amount for credit card payment. Please type a valid credit amount.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
if (string.IsNullOrEmpty(cboCardType.Text))
{
cboCardType.Focus();
MessageBox.Show("Please select a valid Card Type.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
if (txtCardNo.Text == null || txtCardNo.Text == "")
{
txtCardNo.Focus();
MessageBox.Show("Please type a valid Card No.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
if (txtCardHolder.Text == null || txtCardHolder.Text == "")
{
txtCardHolder.Focus();
MessageBox.Show("Please type a valid Card Holder.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
DateTime ValidityDate = DateTime.MinValue;
if (string.IsNullOrEmpty(txtValidityDates.Text))
{
txtValidityDates.Focus();
MessageBox.Show("Please type a valid Validity Date.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
else if (!string.IsNullOrEmpty(txtValidityDates.Text))
{
try
{
string Month = txtValidityDates.Text.Substring(0, 2);
string Year = "20" + txtValidityDates.Text.Substring(2, 2);
string Day = DateTime.DaysInMonth(Convert.ToInt32(Year), Convert.ToInt32(Month)).ToString();
ValidityDate = new DateTime(int.Parse(Year), int.Parse(Month), int.Parse(Day));
}
catch
{
txtValidityDates.Focus();
MessageBox.Show("Please type a valid Validity Date. Format must be mmyy", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
if (!IsRefund) // check only if it's not refund
{
if (!mboIsCreditChargeExcluded) // check only if it's not chargeexcluded or offline trx
{
if (ValidityDate < DateTime.Now)
{
txtValidityDates.Focus();
MessageBox.Show("Card has been expired, please ask for a valid credit card.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
}
}
}
// make sure that only 1 INTERNAL CREDIT CARD can be use per transaction
if (mclsCardTypeDetails.CreditCardType == CreditCardTypes.Internal)
{
foreach (Data.CreditCardPaymentDetails clsCreditCardPaymentDetails in marrCreditCardPaymentDetails)
{
if (clsCreditCardPaymentDetails.CardTypeDetails.CreditCardType == CreditCardTypes.Internal)
{
MessageBox.Show("Sorry an INTERNAL CREDIT CARD has only been use to pay. Please use another credit card or another mode of payment (e.g. cash).", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
}
}
decimal decAdditionalCreditCharge = 0;
if (mclsCreditorDetails.ContactID != 0)
{
// add only the charge if the credit is chargeable
if (panCharge.Visible) mdecAmount += decimal.Parse(txtCreditCardCharge.Text);
decimal mdecAllowedCredit = mclsCreditorDetails.CreditLimit - mclsCreditorDetails.Credit;
if (!IsRefund) // check only if it's not refund
{
if (!mboIsCreditChargeExcluded) // check only if it's not chargeexcluded or offline trx
{
if (mdecAmount > mdecAllowedCredit)
{
MessageBox.Show("Amount must be less than the credit limit (" + mdecAllowedCredit.ToString("#,##0.#0") + "). Please enter a lower amount for credit payment.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtAmount.Focus();
return false;
}
if (mdecAmount <= 0)
{
MessageBox.Show("Amount must be greater than zero. Please enter a higher amount for credit payment.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtAmount.Focus();
return false;
}
if (!mclsCreditorDetails.CreditDetails.CreditActive)
{
MessageBox.Show("Sorry the credit card status is " + mclsCreditorDetails.CreditDetails.CreditCardStatus.ToString("G") + ". Please enter an active credit card no.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtScan.Focus();
return false;
}
if (mclsCardTypeDetails.WithGuarantor)
{
Data.Contacts clsContacts = new Data.Contacts();
mclsGuarantorDetails = clsContacts.Details(mclsCreditorDetails.CreditDetails.GuarantorID);
clsContacts.CommitAndDispose();
if (!mclsGuarantorDetails.CreditDetails.CreditActive)
{
MessageBox.Show("Sorry the Guarantor's credit card status is " + mclsGuarantorDetails.CreditDetails.CreditCardStatus.ToString("G") + ". Please enter an active credit card no.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtScan.Focus();
return false;
}
}
}
}
if (mboIsCreditChargeExcluded) // exclude if it's an special item
{ decAdditionalCreditCharge = 0; }
else if (mclsCardTypeDetails.ExemptInTerminalCharge) // exclude if it's an exemption
{ decAdditionalCreditCharge = 0; }
else if (mclsCardTypeDetails.WithGuarantor && TerminalDetails.GroupChargeType.ChargeTypeID != 0)
{
if (panCharge.Visible) decAdditionalCreditCharge = decimal.Parse(txtCreditCardCharge.Text);
//if (TerminalDetails.GroupChargeType.InPercent)
// decAdditionalCreditCharge = mdecBalanceAmount * (TerminalDetails.GroupChargeType.ChargeAmount / 100);
//else
// decAdditionalCreditCharge = mdecBalanceAmount + TerminalDetails.GroupChargeType.ChargeAmount;
}
else if (!mclsCardTypeDetails.WithGuarantor && TerminalDetails.PersonalChargeType.ChargeTypeID != 0)
{
if (panCharge.Visible) decAdditionalCreditCharge = decimal.Parse(txtCreditCardCharge.Text);
//if (TerminalDetails.PersonalChargeType.InPercent)
// decAdditionalCreditCharge = mdecBalanceAmount * (TerminalDetails.PersonalChargeType.ChargeAmount / 100);
//else
// decAdditionalCreditCharge = mdecBalanceAmount + TerminalDetails.PersonalChargeType.ChargeAmount;
}
if (!IsRefund) // check only if it's not refund
{
if (!mboIsCreditChargeExcluded) // check only if it's not chargeexcluded or offline trx
{
if (decAdditionalCreditCharge == 0)
{
if (mdecAmount > mdecBalanceAmount + decAdditionalCreditCharge)
{
txtAmount.Focus();
MessageBox.Show("Amount must be less than the balance amount (" + mdecBalanceAmount.ToString("#,##0.#0") + "). Please enter a lower or equal amount for credit payment.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
}
}
}
}
if (mclsCreditorDetails.ContactID == 0 && mclsCardTypeDetails.CreditCardType == CreditCardTypes.Internal)
{
MessageBox.Show("Please enter a valid card no for " + cboCardType.Text + ".", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
mDetails.BranchDetails = TerminalDetails.BranchDetails;
mDetails.TerminalNo = TerminalDetails.TerminalNo;
mDetails.TransactionID = mclsSalesTransactionDetails.TransactionID;
mDetails.TransactionNo = mclsSalesTransactionDetails.TransactionNo;
mDetails.TransactionDate = mclsSalesTransactionDetails.TransactionDate;
mDetails.CashierName = mclsSalesTransactionDetails.CashierName;
mDetails.Amount = mdecAmount;
mDetails.AdditionalCharge = decAdditionalCreditCharge;
mDetails.CardTypeID = mclsCardTypeDetails.CardTypeID;
mDetails.CardTypeCode = mclsCardTypeDetails.CardTypeCode;
mDetails.CardTypeName = mclsCardTypeDetails.CardTypeName;
mDetails.CardNo = txtCardNo.Text;
mDetails.CardHolder = txtCardHolder.Text;
mDetails.ValidityDates = ValidityDate.ToString("MMddyy");
mDetails.Remarks = (OfflineProduct + " " + txtRemarks.Text).Trim();
mDetails.CardTypeDetails = mclsCardTypeDetails;
mDetails.CreditorDetails = mclsCreditorDetails;
mDetails.IsRefund = IsRefund;
mDetails.CreatedOn = mclsSalesTransactionDetails.TransactionDate;
return true;
}
private void cboCardType_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboCardType.Text == "No available cards to issue")
grpCardInfo.Visible = false;
else
{
Data.CardType clsCardType = new Data.CardType();
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
if (clsCardTypeDetails.CardTypeID == 0)
{
grpCardInfo.Visible = false;
CardTypeDetails = new Data.CardTypeDetails();
}
else
{
grpCardInfo.Visible = true;
lblCardTypeCode.Text = clsCardTypeDetails.CardTypeCode;
lblFinanceCharge.Text = clsCardTypeDetails.CreditFinanceCharge.ToString("##0.#0");
lblPenaltyCharge.Text = clsCardTypeDetails.CreditLatePenaltyCharge.ToString("##0.#0");
lblMinimumPercentageDue.Text = clsCardTypeDetails.CreditMinimumPercentageDue.ToString("##0.#0");
lblMinimumAmountDue.Text = clsCardTypeDetails.CreditMinimumAmountDue.ToString("##0.#0");
chkWithGuarantor.Checked = clsCardTypeDetails.WithGuarantor;
CardTypeDetails = clsCardTypeDetails;
if (!clsCardTypeDetails.WithGuarantor)
{
mclsGuarantor = new Data.ContactDetails();
}
else
{
}
}
}
}
private void CreditsItemizeWnd_KeyDown(object sender, KeyEventArgs e)
{
switch (e.KeyData)
{
case Keys.Escape:
if (grpSearch.Visible)
{
grpSearch.Visible = false;
dgvItems.Focus();
cmdEnter.Text = "Enter";
}
else
{
this.Hide();
}
break;
case Keys.Enter:
if (grpSearch.Visible)
{
LoadData();
}
else if (Convert.ToDecimal(lblBalanceSelected.Text) > 0)
{
Data.Products clsProducts = new Data.Products();
if (clsProducts.Details(Data.Products.DEFAULT_CREDIT_PAYMENT_BARCODE).ProductID == 0)
{
clsProducts.CREATE_CREDITPAYMENT_PRODUCT();
Methods.InsertAuditLog(TerminalDetails, "System Administrator", AccessTypes.EnterCreditPayment, "CREDIT PAYMENT product has been created coz it's not configured");
}
clsProducts.CommitAndDispose();
dialog = ShowPayment();
if (dialog == DialogResult.OK)
{ mKeyData = Keys.Enter; this.Hide(); }
}
else
this.Hide();
break;
case Keys.F3:
CreditSalesWnd clsCreditSalesWnd = new CreditSalesWnd();
clsCreditSalesWnd.TerminalDetails = TerminalDetails;
clsCreditSalesWnd.SysConfigDetails = mclsSysConfigDetails;
clsCreditSalesWnd.CustomerDetails = mclsCustomerDetails;
clsCreditSalesWnd.ShowDialog(this);
clsCreditSalesWnd.Close();
clsCreditSalesWnd.Dispose();
break;
case Keys.F4:
CreditPaymentsWnd clsCreditPaymentsWnd = new CreditPaymentsWnd();
clsCreditPaymentsWnd.TerminalDetails = TerminalDetails;
clsCreditPaymentsWnd.SysConfigDetails = mclsSysConfigDetails;
clsCreditPaymentsWnd.CustomerDetails = mclsCustomerDetails;
clsCreditPaymentsWnd.CashierID = CashierID;
clsCreditPaymentsWnd.ShowDialog(this);
DialogResult result = clsCreditPaymentsWnd.Result;
mclsCustomerDetails = clsCreditPaymentsWnd.CustomerDetails;
clsCreditPaymentsWnd.Close();
clsCreditPaymentsWnd.Dispose();
if (result == System.Windows.Forms.DialogResult.OK)
{
LoadData();
}
break;
case Keys.F5:
if (!lblF5.Visible) return;
grpSearch.Visible = !grpSearch.Visible;
if (grpSearch.Visible)
{
txtTrxStartDate.Focus();
cmdEnter.Text = "Search";
}
else
{
dgvItems.Focus();
cmdEnter.Text = "Enter";
}
break;
case Keys.F11:
if (!lblF11.Visible) return;
if (dgvItems.Rows.Count > 0)
{
PrintSOA();
}
break;
case Keys.F12:
if (!lblF12.Visible) return;
TransactionNoToReprint = ""; TerminalNoToReprint = "";
foreach (DataGridViewRow dr in dgvItems.SelectedRows)
{
TransactionNoToReprint = dr.Cells["TransactionNo"].Value.ToString();
TerminalNoToReprint = dr.Cells["TerminalNo"].Value.ToString();
dialog = System.Windows.Forms.DialogResult.OK;
mKeyData = Keys.F12;
this.Hide();
break;
}
break;
}
}
private bool SaveRecord()
{
Data.ContactDetails clsDetails = new Data.ContactDetails();
clsDetails.ContactCode = txtCustomerName.Text;
clsDetails.ContactName = txtCustomerName.Text;
clsDetails.ContactGroupID = Constants.CONTACT_GROUP_CUSTOMER;
clsDetails.ModeOfTerms = 0;
clsDetails.Terms = 0;
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelNo.Text;
if (mstCaption == "Please enter customer name for deposit.")
{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_DEPOSIT; }
else if (mstCaption == "Quickly add new customer")
{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_QUICKLY_ADDED_FROM_FE; }
else
{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_CLIENT; }
clsDetails.Debit = 0;
clsDetails.Credit = 0;
clsDetails.IsCreditAllowed = true;
clsDetails.CreditLimit = 0;
clsDetails.PositionID = Constants.C_RETAILPLUS_AGENT_POSITIONID;
clsDetails.DepartmentID = Constants.C_RETAILPLUS_AGENT_DEPARTMENTID;
Data.Contacts clsContact = new Data.Contacts();
clsDetails.ContactID = clsContact.Insert(clsDetails);
clsContact.CommitAndDispose();
mContactDetails = clsDetails;
return true;
}
private void LoadContactData(System.Data.SqlClient.SortOrder SequenceSortOrder)
{
try
{
tblLayout.Controls.Clear();
Int64 intSequenceNoStart = 0;
if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
{
try { intSequenceNoStart = long.Parse(cmdTableLeft.Tag.ToString()); }
catch { }
}
else
{
try { intSequenceNoStart = long.Parse(cmdTableRight.Tag.ToString()); }
catch { }
}
// Sep 24, 2014 put an override if cmdSubGroupLeft.Tag = 0
// always do an asceding coz its already the end.
if (intSequenceNoStart < Constants.C_RESTOPLUS_MAX_TABLES)
{
intSequenceNoStart = 0; //reset to 0 if it's 1
}
if (intSequenceNoStart == 0)
{
SequenceSortOrder = System.Data.SqlClient.SortOrder.Ascending;
}
ContactColumns clsContactColumns = new ContactColumns();
clsContactColumns.ContactCode = true;
clsContactColumns.LastCheckInDate = true;
ContactColumns clsSearchColumns = new ContactColumns();
Contacts clsContact = new Contacts();
System.Data.DataTable dtContact;
if (ContactGroupCategory == Data.ContactGroupCategory.TABLES)
{
dtContact = clsContact.Tables(clsContactColumns, intSequenceNoStart, SequenceSortOrder, clsSearchColumns, string.Empty, SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending ? Constants.C_RESTOPLUS_MAX_TABLES : Constants.C_RESTOPLUS_MAX_TABLES + 1, false, "SequenceNo", SequenceSortOrder);
}
else
{
dtContact = clsContact.Customers(clsContactColumns, intSequenceNoStart, SequenceSortOrder, clsSearchColumns, string.Empty, SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending ? Constants.C_RESTOPLUS_MAX_TABLES : Constants.C_RESTOPLUS_MAX_TABLES + 1, false, "SequenceNo", SequenceSortOrder);
}
// re-order the products by sequence no
if (dtContact.Rows.Count > 0)
{
System.Data.DataView dv = dtContact.DefaultView;
dv.Sort = "ContactCode";
dtContact = dv.ToTable();
}
int iRow = 0;
int iCol = 0;
int iCtr = 1;
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(clsContact.Connection, clsContact.Transaction);
Data.SalesTransactionDetails clsSalesTransactionDetails = new Data.SalesTransactionDetails();
Data.MergeTable clsMergeTable = new Data.MergeTable(clsContact.Connection, clsContact.Transaction);
Data.MergeTableDetails clsMergeTableDetails = new Data.MergeTableDetails();
if (dtContact.Rows.Count == 0)
{
cmdTableLeft.Tag = "0".ToString(); // reset the sequenceno to 0 if no record
cmdTableRight.Tag = "0".ToString(); // reset the sequenceno to 0 if no record
}
foreach (System.Data.DataRow dr in dtContact.Rows)
{
//if (iCol == 5) { iCol = 0; iRow++; }
if (iCtr > Constants.C_RESTOPLUS_MAX_TABLES)
{
break;
}
if (iCtr == 1)
{
cmdTableLeft.Tag = dr[Data.ContactColumnNames.SequenceNo].ToString();
}
if (iCtr >= 1 && dtContact.Rows.Count > Constants.C_RESTOPLUS_MAX_TABLES)
{
cmdTableRight.Tag = dr[Data.ContactColumnNames.SequenceNo].ToString();
}
ProductButton cmdTable = new ProductButton();
cmdTable.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;
cmdTable.BackColor = System.Drawing.Color.Red;
cmdTable.Dock = System.Windows.Forms.DockStyle.Fill;
cmdTable.FlatAppearance.BorderColor = System.Drawing.Color.Gold;
cmdTable.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
cmdTable.ForeColor = System.Drawing.SystemColors.ControlText;
cmdTable.GradientBottom = System.Drawing.Color.DarkRed;
cmdTable.GradientTop = System.Drawing.Color.Red;
cmdTable.ImageAlign = System.Drawing.ContentAlignment.TopCenter;
cmdTable.Location = new System.Drawing.Point(3, 3);
cmdTable.Size = new System.Drawing.Size(245, 90);
cmdTable.TabIndex = 118;
cmdTable.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
cmdTable.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
cmdTable.UseVisualStyleBackColor = false;
cmdTable.Name = "cmdTable" + iCtr.ToString();
cmdTable.Text = dr[Data.ContactColumnNames.ContactCode].ToString();
cmdTable.Tag = dr[Data.ContactColumnNames.ContactID].ToString();
cmdTable.Click += new System.EventHandler(cmdTable_Click);
if (DateTime.Parse(dr[Data.ContactColumnNames.LastCheckInDate].ToString()) != Constants.C_DATE_MIN_VALUE)
{
TimeSpan iLapse = DateTime.Now - DateTime.Parse(dr[Data.ContactColumnNames.LastCheckInDate].ToString());
Label lblLastCheckInDate = new System.Windows.Forms.Label();
lblLastCheckInDate.AutoSize = true;
lblLastCheckInDate.BackColor = System.Drawing.Color.Transparent;
lblLastCheckInDate.Font = new System.Drawing.Font("Tahoma", 7.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lblLastCheckInDate.ForeColor = System.Drawing.Color.Blue;
lblLastCheckInDate.Location = new System.Drawing.Point(5, 5);
lblLastCheckInDate.Name = "lblLastCheckInDate" + iCtr.ToString();
lblLastCheckInDate.TabIndex = 1;
lblLastCheckInDate.Text = "CheckIn: " + DateTime.Parse(dr[Data.ContactColumnNames.LastCheckInDate].ToString()).ToString("dd-MMM hh:mm tt") + " [" + iLapse.Hours.ToString("0#") + "hrs " + iLapse.Minutes.ToString("0#") + "mins]";
cmdTable.Controls.Add(lblLastCheckInDate);
}
string stTransactionNo = clsSalesTransactions.getSuspendedTransactionNo(long.Parse(dr[Data.ContactColumnNames.ContactID].ToString()), TerminalDetails.TerminalNo, TerminalDetails.BranchID);
if (stTransactionNo != string.Empty)
{
clsSalesTransactionDetails = clsSalesTransactions.Details(stTransactionNo, TerminalDetails.TerminalNo, TerminalDetails.BranchID);
cmdTable.Text = dr[Data.ContactColumnNames.ContactCode].ToString();
decimal decAmountDue = Convert.ToDecimal(clsSalesTransactionDetails.SubTotal + clsSalesTransactionDetails.Charge - clsSalesTransactionDetails.Discount);
cmdTable.Text += Environment.NewLine + Environment.NewLine + "Amount Due:" + decAmountDue.ToString("#,###.#0");
Label lblNoOfPax = new System.Windows.Forms.Label();
lblNoOfPax.AutoSize = true;
lblNoOfPax.BackColor = System.Drawing.Color.Transparent;
lblNoOfPax.Font = new System.Drawing.Font("Tahoma", 7.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lblNoOfPax.ForeColor = System.Drawing.Color.White;
lblNoOfPax.Location = new System.Drawing.Point(210, 75);
lblNoOfPax.Name = "lblNoOfPax" + iCtr.ToString();
lblNoOfPax.TabIndex = 1;
lblNoOfPax.Text = clsSalesTransactionDetails.PaxNo.ToString() + "Pax";
cmdTable.Controls.Add(lblNoOfPax);
if (mboShowAvailableTableOnly)
{
cmdTable.BackColor = System.Drawing.Color.DarkGray;
cmdTable.GradientBottom = System.Drawing.Color.DarkGray;
cmdTable.GradientTop = System.Drawing.Color.LightGray;
cmdTable.Enabled = false;
}
else
{
cmdTable.BackColor = System.Drawing.Color.DarkBlue;
cmdTable.GradientBottom = System.Drawing.Color.DarkBlue;
cmdTable.GradientTop = System.Drawing.Color.LightBlue;
}
}
Label lblMerge = new System.Windows.Forms.Label();
lblMerge.AutoSize = true;
lblMerge.BackColor = System.Drawing.Color.Transparent;
lblMerge.Font = new System.Drawing.Font("Tahoma", 7.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lblMerge.ForeColor = System.Drawing.Color.White;
lblMerge.Location = new System.Drawing.Point(5, 75);
lblMerge.Name = "lblMerge" + iCtr.ToString();
lblMerge.TabIndex = 1;
lblMerge.Text = "Merged";
lblMerge.Visible = false;
cmdTable.Controls.Add(lblMerge);
clsMergeTableDetails = clsMergeTable.Details(dr[Data.ContactColumnNames.ContactCode].ToString());
if (MainTableToMerge.ContactCode == dr[Data.ContactColumnNames.ContactCode].ToString())
{
cmdTable.BackColor = System.Drawing.Color.LightGreen;
cmdTable.GradientBottom = System.Drawing.Color.LightGreen;
cmdTable.GradientTop = System.Drawing.Color.DarkGreen;
cmdTable.Enabled = false;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Visible = true;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Text = "Merged to this table";
}
else if (clsMergeTableDetails.MainTableCode == dr[Data.ContactColumnNames.ContactCode].ToString())
{
cmdTable.BackColor = System.Drawing.Color.DarkGray;
cmdTable.GradientBottom = System.Drawing.Color.DarkGray;
cmdTable.GradientTop = System.Drawing.Color.LightGray;
cmdTable.Enabled = false;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Visible = true;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Text = "Merged - Main Table";
}
else if (clsMergeTableDetails.ChildTableCode == dr[Data.ContactColumnNames.ContactCode].ToString() &&
MainTableToMerge.ContactCode != clsMergeTableDetails.MainTableCode)
{
cmdTable.BackColor = System.Drawing.Color.DarkGray;
cmdTable.GradientBottom = System.Drawing.Color.DarkGray;
cmdTable.GradientTop = System.Drawing.Color.LightGray;
cmdTable.Enabled = false;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Visible = true;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Text = "Merged to " + clsMergeTableDetails.MainTableCode;
}
else if (clsMergeTableDetails.ChildTableCode == dr[Data.ContactColumnNames.ContactCode].ToString() &&
MainTableToMerge.ContactCode == clsMergeTableDetails.MainTableCode)
{
Data.ContactDetails clsContactDetails = clsContact.Details(long.Parse(cmdTable.Tag.ToString()));
mlstTables.Add(clsContactDetails);
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Visible = true;
cmdTable.Controls["lblMerge" + cmdTable.Name.Replace("cmdTable", "")].Text = "Merged to " + clsMergeTableDetails.MainTableCode;
cmdTable.GradientTop = System.Drawing.Color.Orange;
}
tblLayout.Controls.Add(cmdTable, iCol, iRow);
iCol++; iCtr++;
}
clsContact.CommitAndDispose();
}
catch (IndexOutOfRangeException) {}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private bool SaveRecord()
{
if (MessageBox.Show("Please validate the customer information details before proceeding. Are you sure you want to continue?", "RetailPlus ™", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No)
{
return false;
}
else
{
Data.ContactDetails clsDetails = new Data.ContactDetails();
clsDetails = mContactDetails;
clsDetails.ContactCode = txtContactCode.Text;
clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + (string.IsNullOrEmpty(txtMiddleName.Text) ? "" : "," + txtMiddleName.Text);
clsDetails.ContactGroupID = Convert.ToInt32(Constants.CONTACT_GROUP_CUSTOMER);
clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboTerms.SelectedItem.ToString());
clsDetails.Terms = int.Parse(txtTerms.Text);
clsDetails.TINNo = txtTelephoneNo.Tag == null ? "" : txtTelephoneNo.Tag.ToString();
clsDetails.LTONo = txtRemarks.Tag == null ? "" : txtRemarks.Tag.ToString();
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = "";
clsDetails.TelephoneNo = txtTelephoneNo.Text;
clsDetails.Remarks = txtRemarks.Text;
clsDetails.Debit = Convert.ToDecimal("0");
clsDetails.Credit = Convert.ToDecimal(txtCredit.Text);
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text);
Data.ContactAddOnDetails clsAddOnDetails = new Data.ContactAddOnDetails();
clsAddOnDetails.ContactID = clsDetails.ContactID;
clsAddOnDetails.Salutation = cboSalutation.SelectedValue.ToString();
clsAddOnDetails.FirstName = txtFirstName.Text;
clsAddOnDetails.MiddleName = txtMiddleName.Text;
clsAddOnDetails.LastName = txtLastName.Text;
clsAddOnDetails.SpouseName = "";
DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE;
dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.BirthDate = dteBirthDate;
clsAddOnDetails.SpouseBirthDate = Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.AnniversaryDate = Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.Address1 = txtAddress.Text;
clsAddOnDetails.Address2 = string.Empty;
clsAddOnDetails.City = string.Empty;
clsAddOnDetails.State = string.Empty;
clsAddOnDetails.ZipCode = string.Empty;
clsAddOnDetails.CountryID = Constants.C_DEF_COUNTRY_ID;
clsAddOnDetails.CountryCode = Constants.C_DEF_COUNTRY_CODE;
clsAddOnDetails.BusinessPhoneNo = txtTelephoneNo.Text;
clsAddOnDetails.HomePhoneNo = string.Empty;
clsAddOnDetails.MobileNo = txtMobileNo.Text;
clsAddOnDetails.FaxNo = string.Empty;
clsAddOnDetails.EmailAddress = string.Empty;
clsAddOnDetails.Sex = (Sex) Enum.Parse(typeof(Sex), cboSex.SelectedValue.ToString());
clsAddOnDetails.AttendingPhysician = txtAttendingPhysician.Text;
clsDetails.AdditionalDetails = clsAddOnDetails;
Data.Contacts clsContact = new Data.Contacts();
if (mContactDetails.ContactID == 0)
{
clsDetails.ContactGroupID = Constants.CONTACT_GROUP_CUSTOMER;
clsDetails.PositionID = Constants.C_RETAILPLUS_AGENT_POSITIONID;
clsDetails.DepartmentID = Constants.C_RETAILPLUS_AGENT_DEPARTMENTID;
clsDetails.ContactID = clsContact.Insert(clsDetails);
}
else
{
clsDetails.PositionID = mContactDetails.PositionID;
clsDetails.DepartmentID = mContactDetails.DepartmentID;
clsDetails.ContactGroupID = mContactDetails.ContactGroupID;
clsDetails.ContactGroupName = mContactDetails.ContactGroupName;
clsContact.Update(clsDetails);
}
clsContact.CommitAndDispose();
mContactDetails = clsDetails;
return true;
}
}
private void ContactUpdate()
{
try
{
if (!EnableContactAddUpdate)
{
return;
}
Int64 iContactID = Convert.ToInt64(dgContacts[dgContacts.CurrentRowIndex, 0].ToString());
if (iContactID != 0 && iContactID != Constants.C_RETAILPLUS_CUSTOMERID)
{
Data.Contacts clsContact = new Data.Contacts();
Data.ContactDetails details = clsContact.Details(iContactID);
clsContact.CommitAndDispose();
DialogResult addresult = System.Windows.Forms.DialogResult.Cancel;
switch (SysConfigDetails.ContactAddWndType)
{
case ContactAddWndType.ContactAddWnd:
case ContactAddWndType.ContactAddNoLTOWnd:
ContactAddWnd clsContactAddWnd = new ContactAddWnd();
clsContactAddWnd.Caption = "Update Customer [" + details.ContactName + "]";
clsContactAddWnd.ContactDetails = details;
clsContactAddWnd.TerminalDetails = TerminalDetails;
clsContactAddWnd.SysConfigDetails = SysConfigDetails;
clsContactAddWnd.ShowDialog(this);
addresult = clsContactAddWnd.Result;
details = clsContactAddWnd.ContactDetails;
clsContactAddWnd.Close();
clsContactAddWnd.Dispose();
break;
case ContactAddWndType.ContactAddHCareWnd:
ContactAddHCareWnd clsContactAddHCareWnd = new ContactAddHCareWnd();
clsContactAddHCareWnd.Caption = "Update Customer [" + details.ContactName + "]";
clsContactAddHCareWnd.ContactDetails = details;
clsContactAddHCareWnd.TerminalDetails = TerminalDetails;
clsContactAddHCareWnd.ShowDialog(this);
addresult = clsContactAddHCareWnd.Result;
details = clsContactAddHCareWnd.ContactDetails;
clsContactAddHCareWnd.Close();
clsContactAddHCareWnd.Dispose();
break;
default:
ContactAddDetWnd clsContactAddDetWnd = new ContactAddDetWnd();
clsContactAddDetWnd.Caption = "Update Customer [" + details.ContactName + "]";
clsContactAddDetWnd.ContactDetails = details;
clsContactAddDetWnd.TerminalDetails = TerminalDetails;
clsContactAddDetWnd.ShowDialog(this);
addresult = clsContactAddDetWnd.Result;
details = clsContactAddDetWnd.ContactDetails;
clsContactAddDetWnd.Close();
clsContactAddDetWnd.Dispose();
break;
}
if (addresult == DialogResult.OK)
{
txtSearch.Text = details.ContactCode;
LoadContactData();
}
}
}
catch { }
}
private void CreateDetails(int iRow)
{
mDetails = new ContactDetails();
Customer clsCustomer = new Customer();
mDetails = clsCustomer.Details(Convert.ToInt64(dgContacts[iRow, 0].ToString()));
clsCustomer.CommitAndDispose();
////int iRow = dgContacts.CurrentRowIndex;
//mDetails.ContactID = Convert.ToInt64(dgContacts[iRow, 0].ToString());
//mDetails.ContactCode = dgContacts[iRow, 1].ToString();
//mDetails.ContactName = dgContacts[iRow, 2].ToString();
//mDetails.Debit = Convert.ToDecimal(dgContacts[iRow, 3].ToString());
//mDetails.Credit = Convert.ToDecimal(dgContacts[iRow, 4].ToString());
//mDetails.CreditLimit = Convert.ToDecimal(dgContacts[iRow, 5].ToString());
//mDetails.IsCreditAllowed = Convert.ToInt16(dgContacts[iRow, 6].ToString());
//mDetails.PositionName = dgContacts[iRow, 7].ToString();
//mDetails.DepartmentName = dgContacts[iRow, 8].ToString();
}
private bool SaveRecord()
{
if (MessageBox.Show("Please validate the customer information details before proceeding. Are you sure you want to continue?", "RetailPlus ™", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No)
{
return false;
}
else
{
Data.ContactDetails clsDetails = new Data.ContactDetails();
clsDetails = mContactDetails;
clsDetails.ContactCode = txtContactCode.Text;
clsDetails.ContactName = txtCustomerName.Text;
clsDetails.TINNo = txtTINNo.Text;
clsDetails.LTONo = txtLTONo.Text;
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelNo.Text;
// Jul 22, 2014
clsDetails.Debit = mContactDetails.Debit;
clsDetails.Credit = mContactDetails.Credit;
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
clsDetails.CreditLimit = decimal.Parse(txtCreditLimit.Text);
clsDetails.Terms = int.Parse(txtTerms.Text);
clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboTerms.SelectedItem.ToString());
Data.Contacts clsContact = new Data.Contacts();
Data.ContactGroups clsContactGroups = new Data.ContactGroups(clsContact.Connection, clsContact.Transaction);
clsDetails.ContactGroupID = clsContactGroups.DetailsByName(cboGroup.SelectedItem.ToString()).ContactGroupID;
if (mContactDetails.ContactID == 0)
{
//if (mstCaption == "Please enter customer name for deposit.")
//{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_DEPOSIT; }
//else if (mstCaption == "Quickly add new customer")
//{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_QUICKLY_ADDED_FROM_FE; }
//else if (mContactDetails.ContactID == 0) // means not edit
//{ clsDetails.Remarks = Data.Contacts.DEFAULT_REMARKS_FOR_ADDED_FROM_CLIENT; }
clsDetails.Remarks = txtRemarks.Text;
clsDetails.PositionID = Constants.C_RETAILPLUS_AGENT_POSITIONID;
clsDetails.DepartmentID = Constants.C_RETAILPLUS_AGENT_DEPARTMENTID;
clsDetails.ContactID = clsContact.Insert(clsDetails);
}
else
{
clsDetails.PositionID = mContactDetails.PositionID;
clsDetails.DepartmentID = mContactDetails.DepartmentID;
clsDetails.ContactGroupID = mContactDetails.ContactGroupID;
clsDetails.ContactGroupName = mContactDetails.ContactGroupName;
clsContact.Update(clsDetails);
}
clsContact.CommitAndDispose();
mContactDetails = clsDetails;
return true;
}
}
private void PriceInquiryWnd_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
switch (e.KeyData)
{
case Keys.Escape:
dialog = DialogResult.Cancel;
this.Hide();
break;
case Keys.Enter:
if (txtBarCode.Text.Trim() != string.Empty)
{
ClearProduct();
Data.Products clsProduct = new Data.Products();
Data.ProductDetails clsProductDetails = clsProduct.Details(TerminalDetails.BranchID, txtBarCode.Text.Trim());
if (clsProductDetails.ProductID == 0)
{
string strContactCardNo = txtBarCode.Text.Trim();
Data.Contacts clsContact = new Data.Contacts(clsProduct.Connection, clsProduct.Transaction);
Data.ContactDetails clsContactDetails = clsContact.DetailsByRewardCardNo(strContactCardNo);
if (clsContactDetails.ContactID == 0)
{
clsContactDetails = clsContact.DetailsByCreditCardNo(strContactCardNo);
if (clsContactDetails.ContactID == 0)
{
strContactCardNo = strContactCardNo.Remove(strContactCardNo.Length - 1);
clsContactDetails = clsContact.DetailsByRewardCardNo(strContactCardNo);
if (clsContactDetails.ContactID == 0)
{
clsContactDetails = clsContact.DetailsByCreditCardNo(strContactCardNo);
if (clsContactDetails.ContactID == 0)
{
ClearProduct();
}
else
{
decimal decAvailableCreditLimit = clsContactDetails.CreditLimit - clsContactDetails.Credit;
lblProductDescription.Text = clsContactDetails.ContactName + " - " + clsContactDetails.CreditDetails.CreditCardNo;
lblPrice.Text = decAvailableCreditLimit.ToString("#,##0.#0");
lblPriceLabel.Text = "AVAILABLE CREDITS:";
if (clsContactDetails.CreditDetails.CreditCardStatus == CreditCardStatus.Expired ||
clsContactDetails.CreditDetails.CreditCardStatus == CreditCardStatus.Lost)
{
lblProductDescription.Text += "(" + clsContactDetails.CreditDetails.CreditCardStatus.ToString("G").ToLower() + ")";
}
else
{
lblProductDescription.Text += "(active)";
}
}
}
else
{
lblProductDescription.Text = clsContactDetails.ContactName + " - " + clsContactDetails.RewardDetails.RewardCardNo;
lblPrice.Text = clsContactDetails.RewardDetails.RewardPoints.ToString("#,##0.#0");
lblPriceLabel.Text = "AVAILABLE POINTS:";
if (clsContactDetails.RewardDetails.RewardCardStatus == RewardCardStatus.Expired ||
clsContactDetails.RewardDetails.RewardCardStatus == RewardCardStatus.Lost)
{
lblProductDescription.Text += "(" + clsContactDetails.RewardDetails.RewardCardStatus.ToString("G").ToLower() + ")";
}
else
{
lblProductDescription.Text += "(active)";
}
}
}
else
{
decimal decAvailableCreditLimit = clsContactDetails.CreditLimit - clsContactDetails.Credit;
lblProductDescription.Text = clsContactDetails.ContactName + " - " + clsContactDetails.CreditDetails.CreditCardNo;
lblPrice.Text = decAvailableCreditLimit.ToString("#,##0.#0");
lblPriceLabel.Text = "AVAILABLE CREDITS:";
if (clsContactDetails.CreditDetails.CreditCardStatus == CreditCardStatus.Expired ||
clsContactDetails.CreditDetails.CreditCardStatus == CreditCardStatus.Lost)
{
lblProductDescription.Text += "(" + clsContactDetails.CreditDetails.CreditCardStatus.ToString("G").ToLower() + ")";
}
else
{
lblProductDescription.Text += "(active)";
}
}
}
else
{
lblProductDescription.Text = clsContactDetails.ContactName + " - " + clsContactDetails.RewardDetails.RewardCardNo;
lblPrice.Text = clsContactDetails.RewardDetails.RewardPoints.ToString("#,##0.#0");
lblPriceLabel.Text = "AVAILABLE POINTS:";
if (clsContactDetails.RewardDetails.RewardCardStatus == RewardCardStatus.Expired ||
clsContactDetails.RewardDetails.RewardCardStatus == RewardCardStatus.Lost)
{
lblProductDescription.Text += "(" + clsContactDetails.RewardDetails.RewardCardStatus.ToString("G").ToLower() + ")";
}
else
{
lblProductDescription.Text += "(active)";
}
}
}
else
{
lblProductDescription.Text = clsProductDetails.ProductDesc;
lblPrice.Text = clsProductDetails.Price.ToString("#,##0.#0");
lblPriceLabel.Text = "PRICE:";
}
clsProduct.CommitAndDispose();
txtBarCode.Text = "";
}
txtBarCode.Focus();
txtBarCode.SelectAll();
break;
}
}
private void LoadData()
{
mContactDetails = new Data.ContactDetails();
mGuarantorDetails = new Data.ContactDetails();
Data.Contacts clsContacts = new Data.Contacts();
switch (SysConfigDetails.CreditPaymentType)
{
case CreditPaymentType.Houseware:
mContactDetails = clsContacts.DetailsByCreditCardNo(txtScan.Text);
break;
case CreditPaymentType.Normal:
case CreditPaymentType.MPC:
default:
mContactDetails = clsContacts.Details(txtScan.Text);
break;
}
if (mContactDetails.ContactID == 0)
{
//mContactDetails = clsContacts.DetailsByCreditCardNo(txtScan.Text.Remove(txtScan.Text.Length - 1));
if (mContactDetails.ContactID == 0 && txtScan.Text.Length == 7) mContactDetails = clsContacts.DetailsByCreditCardNo("888880" + txtScan.Text);
if (mContactDetails.ContactID == 0 && txtScan.Text.Length == 7) mContactDetails = clsContacts.DetailsByCreditCardNo("800000" + txtScan.Text);
if (mContactDetails.ContactID == 0 && txtScan.Text.Length == 9) mContactDetails = clsContacts.DetailsByCreditCardNo(BarcodeHelper.GroupCreditCard_Country_Code + BarcodeHelper.GroupCreditCard_ManufacturerCode + txtScan.Text);
if (mContactDetails.ContactID == 0 && txtScan.Text.Length == 9) mContactDetails = clsContacts.DetailsByCreditCardNo(BarcodeHelper.CreditCard_Country_Code + BarcodeHelper.CreditCard_ManufacturerCode + txtScan.Text);
}
//get the guarantor details if with details
if (mContactDetails.ContactID != 0)
if (mContactDetails.ContactID == mContactDetails.CreditDetails.GuarantorID)
mGuarantorDetails = mContactDetails;
else if (mGuarantorDetails.ContactID != mContactDetails.CreditDetails.GuarantorID)
mGuarantorDetails = clsContacts.Details(mContactDetails.CreditDetails.GuarantorID);
clsContacts.CommitAndDispose();
if (mContactDetails.ContactID == 0)
{
grpContactDetails.Visible = false;
grpPurchases.Visible = false;
labelGuarantor.Visible = false;
txtGuarantor.Visible = false;
}
else
{
grpContactDetails.Visible = true;
grpPurchases.Visible = true;
txtScan.Text = mContactDetails.CreditDetails.CreditCardNo;
txtCustomerName.Text = mContactDetails.ContactName;
txtMobileNo.Text = mContactDetails.AdditionalDetails.MobileNo;
txtTelNo.Text = mContactDetails.TelephoneNo;
txtAddress.Text = mContactDetails.Address;
txtRemarks.Text = mContactDetails.Remarks;
txtCreditCardStatus.Text = mContactDetails.CreditDetails.CreditActive ? "Active" : "InActive";
txtCreditCardStatus.Text += "(" + mContactDetails.CreditDetails.CreditCardStatus.ToString("G") + ")";
txtCreditLimit.Text = mContactDetails.CreditLimit.ToString("#,##0.#0");
txtCredit.Text = mContactDetails.Credit.ToString("#,##0.#0");
txtAvailableCredit.Text = (mContactDetails.CreditLimit - mContactDetails.Credit).ToString("#,##0.#0");
if (!mContactDetails.CreditDetails.CardTypeDetails.WithGuarantor) //no guarantor
{
labelCreditStatus.Location = new Point(71, 133);
txtCreditCardStatus.Location = new Point(174, 133);
txtCreditCardStatus.Size = new Size(439, 30);
labelGuarantor.Visible = false;
txtGuarantor.Visible = false;
}
else if (mContactDetails.CreditDetails.CardTypeDetails.WithGuarantor) //with guarantor
{
labelCreditStatus.Location = new Point(627, 133);
txtCreditCardStatus.Location = new Point(731, 133);
txtCreditCardStatus.Size = new Size(269, 30);
labelGuarantor.Visible = true;
txtGuarantor.Visible = true;
txtGuarantor.Text = "[" + (mGuarantorDetails.CreditDetails.CreditActive ? "Active" : "InActive") + "] " + mGuarantorDetails.ContactCode + ":" + mGuarantorDetails.ContactName;
}
LoadPurchases();
lblBalance.Text = mContactDetails.Credit.ToString("#,##0.#0");
}
}