private void btnProductType_Click(object sender, EventArgs e)
{
DataTable dtCurrency = new DataTable();
string sSqlstr = "SELECT [PRODUCTCODE] ,[DESCRIPTION] FROM [dbo].[PRODUCTTYPEMASTER]";
dtCurrency = GetDataTable(sSqlstr);
if (dtCurrency != null && dtCurrency.Rows.Count > 0)
{
DataRow drCur = null;
Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch oSearch = new Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch(dtCurrency, drCur, "Currency");
oSearch.ShowDialog();
drCur = oSearch.SelectedDataRow;
if (drCur != null)
{
lblProductType.Tag = Convert.ToString(drCur["PRODUCTCODE"]);
lblProductType.Text = Convert.ToString(drCur["PRODUCTCODE"]);
}
}
}
private void btnCurrency_Click(object sender, EventArgs e)
{
DataTable dtCurrency = new DataTable();
string sSqlstr = "SELECT [CURRENCYCODE] ,[TXT] FROM [dbo].[CURRENCY]";
dtCurrency = GetDataTable(sSqlstr);
if (dtCurrency != null && dtCurrency.Rows.Count > 0)
{
DataRow drCur = null;
Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch oSearch = new Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch(dtCurrency, drCur, "Currency");
oSearch.ShowDialog();
drCur = oSearch.SelectedDataRow;
if (drCur != null)
{
lblCurrency.Tag = Convert.ToString(drCur["CURRENCYCODE"]);
lblCurrency.Text = Convert.ToString(drCur["CURRENCYCODE"]);
}
}
}
private void btnCollection_Click(object sender, EventArgs e)
{
DataTable dtCustAgeBracket = new DataTable();
string sSqlstr = "SELECT COLLECTIONCODE,[COLLECTIONDESC] FROM [DBO].[COLLECTIONMASTER]";
dtCustAgeBracket = GetDataTable(sSqlstr);
if (dtCustAgeBracket != null && dtCustAgeBracket.Rows.Count > 0)
{
DataRow drCur = null;
Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch oSearch = new Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch(dtCustAgeBracket, drCur, "Collection");
oSearch.ShowDialog();
drCur = oSearch.SelectedDataRow;
if (drCur != null)
{
lblCollection.Tag = Convert.ToString(drCur["COLLECTIONCODE"]);
lblCollection.Text = Convert.ToString(drCur["COLLECTIONDESC"]);
}
}
}
private void btnSalesPerson_Click(object sender, EventArgs e)
{
DataTable dtSP = new DataTable();
DataRow drSP = null;
SqlConnection conn = new SqlConnection(ApplicationSettings.Database.LocalConnectionString);
conn.Open();
string commandText = string.Empty;
commandText = "select R.STAFFID as Code,R.NAMEONRECEIPT as Name from RETAILSTAFFTABLE r " +
" left join dbo.HCMWORKER as h on h.PERSONNELNUMBER = r.STAFFID " +
" left join dbo.DIRPARTYTABLE as d on d.RECID = h.PERSON ORDER BY R.STAFFID";
SqlCommand command = new SqlCommand(commandText, conn);
command.CommandTimeout = 0;
SqlDataAdapter adapter = new SqlDataAdapter(commandText, conn);
adapter.Fill(dtSP);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch oSearch
= new Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch(dtSP,
drSP = null, "Sales Person Search");
oSearch.ShowDialog();
drSP = oSearch.SelectedDataRow;
if (drSP != null)
{
txtSalesPerson.Text = Convert.ToString(drSP["code"]);
}
}
private void btnSearchGssAccNo_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtCustomerAccount.Text.Trim()))
{
try
{
if (PosApplication.Instance.TransactionServices.CheckConnection())
{
ReadOnlyCollection <object> containerArray;
string sCustAcc = txtCustomerAccount.Text;
containerArray = PosApplication.Instance.TransactionServices.InvokeExtension("GetGSSAccountInfo", sCustAcc);
dsGSSAcInfo = new DataSet();
StringReader srTransDetail = new StringReader(Convert.ToString(containerArray[3]));
if (Convert.ToString(containerArray[3]).Trim().Length > 38)
{
dsGSSAcInfo.ReadXml(srTransDetail);
}
if (dsGSSAcInfo != null && dsGSSAcInfo.Tables[0].Rows.Count > 0)
{
Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch Osearch = new Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch(dsGSSAcInfo.Tables[0], null, "GSS Acc");
Osearch.ShowDialog();
DataRow dr = Osearch.SelectedDataRow;
if (dr != null)
{
txtGSSAccNo.Text = Convert.ToString(dr["GSSAccountNo"]);
txtOpDate.Text = Convert.ToString(dr["OpeningDate"]);
txtAmount.Text = Convert.ToString(dr["InstallmentAmount"]);
}
}
}
}
catch (Exception ex)
{
}
}
else
{
MessageBox.Show("Please select customer account.");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
ReadOnlyCollection <object> containerArray;
string sMsg = string.Empty;
string sPhone = txtSearchPhone.Text;
string sEmail = txtSearchEmail.Text;
if (!string.IsNullOrEmpty(sPhone) || !string.IsNullOrEmpty(sEmail))
{
if (PosApplication.Instance.TransactionServices.CheckConnection())
{
bool bStatus = false;
containerArray = PosApplication.Instance.TransactionServices.InvokeExtension("getFeedBackCustInfo", sEmail, sPhone);
bStatus = Convert.ToBoolean(containerArray[1]);
DataRow drSelected = null;
DataSet dsWH = new DataSet();
DataSet dsDetails = new DataSet();
StringReader srTransH = new StringReader(Convert.ToString(containerArray[3]));
StringReader srTransDetail = new StringReader(Convert.ToString(containerArray[4]));
if (Convert.ToString(containerArray[3]).Trim().Length > 38)
{
dsWH.ReadXml(srTransH);
}
if (dsWH != null && dsWH.Tables[0].Rows.Count > 0)
{
Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch OSearch =
new Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmGenericSearch(dsWH.Tables[0], drSelected, "Customer Feedback");
OSearch.ShowDialog();
drSelected = OSearch.SelectedDataRow;
groupBox1.Enabled = false;
groupBox2.Enabled = false;
btnAddItem.Enabled = false;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
btnSubmit.Enabled = false;
if (Convert.ToString(containerArray[4]).Trim().Length > 38)
{
dsDetails.ReadXml(srTransDetail);
}
DataTable dtDetails = new DataTable();
if (drSelected != null)
{
string sRecId = Convert.ToString(drSelected["RECID"]);
cmbTitle.Text = Convert.ToString(drSelected["Affix"]);
txtFirstName.Text = Convert.ToString(drSelected["FirstName"]);
txtLastName.Text = Convert.ToString(drSelected["LastName"]);
txtPhone.Text = Convert.ToString(drSelected["PhoneNum"]);
cmbCountry.Text = Convert.ToString(drSelected["CountryRegionId"]);
txtEmail.Text = Convert.ToString(drSelected["EmailID"]);
cmbEnOrPurc.Text = Convert.ToString(drSelected["EnquiryOrPurchase"]);
cmbGender.Text = Convert.ToString(drSelected["Gender"]);
if (Convert.ToString(drSelected["Resident"]) == "True")
{
chkResidence.Checked = true;
}
else
{
chkResidence.Checked = false;
}
txtAddress.Text = Convert.ToString(drSelected["FullAddress"]);
if (dsDetails != null && dsDetails.Tables[0].Rows.Count > 0)
{
dtDetails = dsDetails.Tables[0].Select("FeedbackRefRecID = '" + sRecId + "'").CopyToDataTable();
}
if (dtDetails != null && dtDetails.Rows.Count > 0)
{
dtItemInfo = dtDetails;
grItems.DataSource = dtItemInfo;
if (grdView.Columns.Count > 1)
{
grdView.Columns[grdView.Columns.Count - 1].Visible = false;
}
}
}
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("No record found.", MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Customer feedback faild to search.");
}
}