private void btnSelectItems_Click(object sender, EventArgs e)
{
DataSet ds = SelectItems("");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
CustomerOrderDetails oCustOrder = new CustomerOrderDetails(ds, string.Empty);
oCustOrder.ShowDialog();
DataTable dtNew = new DataTable();
dtNew = oCustOrder.dtCustOrderDetails;
if (dtNew != null && dtNew.Rows.Count > 0)
{
tableLayoutPanel1.Visible = true;
grItems.DataSource = dtNew.DefaultView;
}
else
{
tableLayoutPanel1.Visible = false;
}
}
else if (string.IsNullOrEmpty(txtCustomerOrder.Text))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("PLEASE SELECT THE CUSTOMER ORDER.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("NO ITEM DETAILS PRESENT.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
private bool isValid()
{
if (string.IsNullOrEmpty(txtCustomerName.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Customer name can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
txtCustomerName.Focus();
return(false);
}
}
if (string.IsNullOrEmpty(txtaddress.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Customer Address can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
txtaddress.Focus();
return(false);
}
}
if (string.IsNullOrEmpty(txtContactNo.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Contact No cannot be less than Order Date", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
txtContactNo.Focus();
return(false);
}
}
else
{
return(true);
}
}
//public frmCustOrderPaySchedule(DataSet dsSearchedDetails, IPosTransaction posTransaction, IApplication Application, DataTable dtPaySch, decimal dTotAmount)
//{
// InitializeComponent();
// #region
// pos = posTransaction;
// application = Application;
// this.dtPaySched = dtPaySch;
// frmCustOrd = new frmCustomerOrder(posTransaction, Application);
// sOrderNum = frmCustOrd.txtOrderNo.Text;
// DataTable dtTempShow = new DataTable();
// lblOrderNo.Text = sOrderNum;
// lblTotAmt.Text = Convert.ToString(dTotAmount);
// foreach (DataRow dr in dtPaySch.Rows)
// {
// dtTemp.ImportRow(dr);
// }
// gridPaySchedule.DataSource = dtTemp;
// if (dtTemp != null && dtTemp.Rows.Count > 0)
// {
// Decimal dTotalAmount = 0m;
// Decimal dTotPer = 0m;
// foreach (DataRow drTotal in dtTemp.Rows)
// {
// dTotalAmount += Convert.ToDecimal(drTotal["Amount"]);
// dTotPer += Convert.ToDecimal(drTotal["PerAmt"]);
// }
// lblGridTotAmt.Text = Convert.ToString(dTotalAmount);
// lblTotPer.Text = Convert.ToString(dTotPer);
// }
// gridPaySchedule.DataSource = dtPaySch.DefaultView;
// btnCommit.Enabled = false;
// btnAdd.Enabled = false;
// btnEdit.Enabled = false;
// btnDelete.Enabled = false;
// btnClear.Enabled = false;
// #endregion
//}
#region Validate()
bool isValidate()
{
if (string.IsNullOrEmpty(lblTotAmt.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("No Item selected in for the order", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
btnAdd.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtPer.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Percentage can not be Zero.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtAmt.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (Convert.ToDecimal(txtAmt.Text.Trim()) == 0m)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Amount can not be Zero.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtAmt.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
else
{
return(true);
}
}
/// <summary>
/// DEV BY RIPAN HOSSAIN ON 12-03-2013
/// Purpose :: to show validation message commonly
/// </summary>
/// <param name="_msg"></param>
/// <returns></returns>
public string ShowMessage(string _msg)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage(_msg, MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(_msg);
}
}
private bool ValidateControls()
{
if (string.IsNullOrEmpty(txtGSSNo.Text))
{
txtGSSNo.Focus();
MessageBox.Show("GSS Number is Empty.", "GSS Number is Empty.", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (string.IsNullOrEmpty(txtAmount.Text))
{
txtGSSNo.Focus();
MessageBox.Show("Amount cannot be Empty.", "Amount cannot be Empty.", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (drGoldSS != null && Convert.ToString(drGoldSS["SCHEMETYPE"]).ToUpper().Trim() == "FIXED" && string.IsNullOrEmpty(txtMonths.Text))
{
txtMonths.Focus();
MessageBox.Show("No. of Months cannot be Empty.", "No. of Months cannot be Empty.", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (PosApplication.Instance.TransactionServices.CheckConnection())
{
bool bIsValid = false;
ReadOnlyCollection <object> containerArray;
containerArray = PosApplication.Instance.TransactionServices.InvokeExtension("validateGSSTransaction", txtGSSNo.Text, txtMonths.Text, txtAmount.Text);
bIsValid = Convert.ToBoolean(containerArray[1]);
if (!bIsValid)
{
string strMsg = Convert.ToString(containerArray[2]);
MessageBox.Show(strMsg, strMsg, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Transaction Service not found", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
return(false);
}
return(true);
}
private DataSet SelectItems(string linenum)
{
if (!string.IsNullOrEmpty(txtCustomerOrder.Text))
{
DataSet dsCustOrder = new DataSet();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string commandText = string.Empty;
commandText = " SELECT [ORDERNUM],[LINENUM],[STOREID],[TERMINALID],[ITEMID] " +
" ,[CONFIGID],[CODE],[SIZEID] ,[STYLE],[PCS],[QTY],[CRATE] AS [RATE],[RATETYPE] " +
" ,[AMOUNT],[MAKINGRATE],[MAKINGRATETYPE],[MAKINGAMOUNT] " +
" ,[EXTENDEDDETAILSAMOUNT],[DATAAREAID],[CREATEDON],[STAFFID] " +
" FROM [CUSTORDER_DETAILS] " +
" WHERE [ORDERNUM]='" + txtCustomerOrder.Text.Trim() + "' AND isDelivered='0';" +
" SELECT [ORDERNUM],[ORDERDETAILNUM],[LINENUM],[STOREID] " +
" ,[TERMINALID],[ITEMID],[CONFIGID],[CODE],[SIZEID] " +
" ,[STYLE],[PCS],[QTY],[CRATE] AS [RATE],[RATETYPE],[DATAAREAID] " +
" ,[AMOUNT] FROM [CUSTORDER_SUBDETAILS] " +
" WHERE [ORDERNUM]='" + txtCustomerOrder.Text.Trim() + "' ;";
SqlDataAdapter adapter = new SqlDataAdapter(commandText, conn);
adapter.Fill(dsCustOrder);
if (dsCustOrder == null && dsCustOrder.Tables.Count <= 0 && dsCustOrder.Tables[0].Rows.Count <= 0)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("NO ITEM DETAILS PRESENT.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
return(null);
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(dsCustOrder);
}
return(null);
}
/*
* private void txtRate_TextChanged(object sender, EventArgs e)
* {
* if (string.IsNullOrEmpty(txtQuantity.Text.Trim()) && (cmbRateType.SelectedIndex == 0 || cmbRateType.SelectedIndex == 1))
* {
* txtAmount.Text = string.Empty;
* }
*
* cmbRateType_SelectedIndexChanged(sender, e);
* }
*
*/
#endregion
#region Submit Click
private void btnSubmit_Click(object sender, EventArgs e)
{
if (dtItemInfo != null && dtItemInfo.Rows.Count > 0)
{
frmRepairDetail.dtSubOrderDetails = dtItemInfo;
frmRepairDetail.sExtendedDetailsAmount = 0m;// (string.IsNullOrEmpty(Convert.ToString(txtTotalAmount.Text))) ? 0 : Convert.ToDecimal(txtTotalAmount.Text);
this.Close();
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Please select at least one item to submit.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
btnPOSItemSearch.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
private void RefreshGrid()
{
// Pop a "loading..." dialog and refresh the list contents in the background.
using (refreshDialog = new LSRetailPosis.POSProcesses.frmMessage(56141, MessageBoxIcon.Information, true)) //"Searching for orders..."
using (refreshWorker = new BackgroundWorker())
{
//Create a background worker to fetch the data
refreshWorker.DoWork += refreshWorker_DoWork;
refreshWorker.RunWorkerCompleted += refreshWorker_RunWorkerCompleted;
//listen to th OnShow event of the dialog so we can kick-off the thread AFTER the dialog is visible
refreshDialog.Shown += refreshDialog_Shown;
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(refreshDialog);
//Worker thread terminates, which causes the dialog to close, and both can safely dispose at the end of the 'using' scope.
}
}
/// <summary>
/// DEV BY RIPAN HOSSAIN ON 06032013 --txtItemId enter event
/// same as Product search
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtItemId_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue == 13)
{
conn = application.Settings.Database.Connection;
if (isValiedSku(conn, Convert.ToString(txtItemId.Text)))
{
getSkuDetails(Convert.ToString(txtItemId.Text));
txtItemId.Text = string.Empty; // added on 17.08.2013
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Please enter valid SKU.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtItemId.Text = string.Empty; // added on 17.08.2013
txtItemId.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
}
private bool isValid()
{
if (!bIsExistDate(dtpDate.Value) && (!bIsEdit))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Already exist record for this date.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
else if (!bIsValiedDateEntry(dtpDate.Value))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Please enter previous record first.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
else
{
return(true);
}
}
public void ApplicationStart()
{
string source = "IApplicationTriggers.ApplicationStart";
string value = "Application has started";
LSRetailPosis.ApplicationLog.Log(source, value, LSRetailPosis.LogTraceLevel.Debug);
LSRetailPosis.ApplicationLog.WriteAuditEntry(source, value);
// If the store is in Brazil, we should only allow to run the POS if the Functionality profile's ISO locale is Brazil
if (ApplicationSettings.Terminal.StoreCountry.Equals(SupportedCountryRegion.BR.ToString(), StringComparison.OrdinalIgnoreCase) &&
Functions.CountryRegion != SupportedCountryRegion.BR)
{
var message = ApplicationLocalizer.Language.Translate(85082, // The locale must be Brazil. In the POS functionality profile form, on the General tab, in the Locale field, select Brazil.
ApplicationSettings.Terminal.StoreCountry);
using (var form = new LSRetailPosis.POSProcesses.frmMessage(message, MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(form);
}
throw new LSRetailPosis.PosStartupException(message);
}
}
private void btnCommit_Click(object sender, EventArgs e)
{
Decimal MaxAmt = getToleranceAmt() + Convert.ToDecimal(lblTotAmt.Text.Trim());
Decimal MinAmt = Convert.ToDecimal(lblTotAmt.Text.Trim()) - getToleranceAmt();
if (Convert.ToDecimal(lblGridTotAmt.Text.Trim()) > MaxAmt)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Scheduled amount should be equal to total order amount.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtPer.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
else if (Convert.ToDecimal(lblGridTotAmt.Text.Trim()) < MinAmt)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Scheduled amount should be equal to total order amount.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtPer.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
{
if (dtPaySched != null && dtPaySched.Rows.Count > 0)
{
frmCustOrd.dtPaySchedule = dtPaySched;
this.Close();
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Please select at least one item to submit.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
btnAdd.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
}
private void btnProductSearch_Click(object sender, EventArgs e)
{
if (IsEdit)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("You are in editing mode", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return;
}
}
Dialog objdialog = new Dialog();
string str = string.Empty;
DataSet dsItem = new DataSet();
objdialog.MyItemSearch(50000, ref str, out dsItem, " AND I.ITEMID IN (SELECT ITEMID FROM INVENTTABLE WHERE RETAIL=1) ");
saleLineItem = new SaleLineItem();
if (dsItem != null && dsItem.Tables.Count > 0 && dsItem.Tables[0].Rows.Count > 0)
{
if (!string.IsNullOrEmpty(Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMID"])))
{
saleLineItem.ItemId = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMID"]);
txtItemId.Text = saleLineItem.ItemId;
txtItemName.Text = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMNAME"]);
string sPType = string.Empty;
string sSubPType = string.Empty;
string sCollCode = string.Empty;
GetItemInfo(saleLineItem.ItemId, ref sPType, ref sSubPType, ref sCollCode);
lblProductType.Text = sPType;
lblSubCollection.Text = sSubPType;
lblCollection.Text = sCollCode;
}
}
}
private void btnUnlock_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtSKUNo.Text.Trim()))
{
string sRtlTransId = string.Empty;
if (IsLocked(txtSKUNo.Text.Trim(), out sRtlTransId))
{
string sMsg = "Please release the SKU from suspended transaction";
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage(sMsg, MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
return;
}
string sUnlockMsg = IsBookedSKU(txtSKUNo.Text.Trim());
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage(sUnlockMsg, MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
/// <summary>
/// DEV BY RIPAN HOSSAIN ON 14-03-2013
/// </summary>
private void SaveStckTransfer()
{
int iStockTransfer_Header = 0;
int iStockTransfer_Details = 0;
string TransferId = GetStockTransId();
SqlTransaction transaction = null;
//MODIFIED DATE :: 18/03/2013 ; MODIFIED BY : RIPAN HOSSAIN
#region STOCK TRANSFER HEADER
string commandText = " INSERT INTO [SKUTransfer_Header]([STOCKTRANSFERID],[STOCKTRANSFERDATE]," +
" [STOCKTRANSFERTYPE],[FROMCOUNTER],[TOCOUNTER],[RETAILSTOREID],[RETAILTERMINALID],[RETAILSTAFFID]," +
" [DATAAREAID],[CREATEDON])" +
" VALUES(@STOCKTRANSFERID,@STOCKTRANSFERDATE,@STOCKTRANSFERTYPE,@FROMCOUNTER,@TOCOUNTER," +
" @RETAILSTOREID,@RETAILTERMINALID,@RETAILSTAFFID," +
" @DATAAREAID,@CREATEDON)";
SqlConnection connection = new SqlConnection();
try
{
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
transaction = connection.BeginTransaction();
SqlCommand command = new SqlCommand(commandText, connection, transaction);
command.Parameters.Clear();
command.Parameters.Add("@STOCKTRANSFERID", SqlDbType.NVarChar).Value = TransferId.Trim();
command.Parameters.Add("@STOCKTRANSFERDATE", SqlDbType.DateTime).Value = dtpStockTransfe.Value;
command.Parameters.Add("@STOCKTRANSFERTYPE", SqlDbType.NVarChar, 10).Value = cmbTransferType.Text;
command.Parameters.Add("@FROMCOUNTER", SqlDbType.NVarChar, 20).Value = Convert.ToString(txtFromCounter.Text);
command.Parameters.Add("@TOCOUNTER", SqlDbType.NVarChar, 20).Value = Convert.ToString(txtToCounter.Text);
command.Parameters.Add("@RETAILSTOREID", SqlDbType.NVarChar, 10).Value = ApplicationSettings.Terminal.StoreId;
command.Parameters.Add("@RETAILTERMINALID", SqlDbType.NVarChar, 10).Value = ApplicationSettings.Terminal.TerminalId;
command.Parameters.Add("@RETAILSTAFFID", SqlDbType.NVarChar, 10).Value = pos.OperatorId;
if (application != null)
{
command.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar, 4).Value = application.Settings.Database.DataAreaID;
}
else
{
command.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar, 4).Value = ApplicationSettings.Database.DATAAREAID;
}
command.Parameters.Add("@CREATEDON", SqlDbType.DateTime).Value = DateTime.Today.ToShortDateString();
#endregion
command.CommandTimeout = 0;
iStockTransfer_Header = command.ExecuteNonQuery();
if (iStockTransfer_Header == 1)
{
if (skuItem != null && skuItem.Rows.Count > 0)
{
#region ORDER DETAILS
//MODIFIED DATE :: 18/03/2013 ; MODIFIED BY : RIPAN HOSSAIN
string commandCustOrder_Detail = " INSERT INTO [SKUTRANSFER_DETAILS]([STOCKTRANSFERID],[LINENUMBER],[SKUNUMBER],[QTY]," +
" [RETAILSTOREID],[RETAILTERMINALID],[RETAILSTAFFID],[DATAAREAID])" +
" VALUES(@STOCKTRANSFERID ,@LINENUMBER , @SKUNUMBER," +
" @QTY,@RETAILSTOREID,@RETAILTERMINALID,@RETAILSTAFFID,@DATAAREAID) ";
for (int ItemCount = 0; ItemCount < skuItem.Rows.Count; ItemCount++)
{
SqlCommand cmdStcokTransfer_Detail = new SqlCommand(commandCustOrder_Detail, connection, transaction);
cmdStcokTransfer_Detail.Parameters.Add("@STOCKTRANSFERID", SqlDbType.NVarChar, 20).Value = TransferId.Trim();
cmdStcokTransfer_Detail.Parameters.Add("@LINENUMBER", SqlDbType.Int, 10).Value = ItemCount + 1;
if (string.IsNullOrEmpty(Convert.ToString(skuItem.Rows[ItemCount]["SKUNUMBER"])))
{
cmdStcokTransfer_Detail.Parameters.Add("@SKUNUMBER", SqlDbType.NVarChar, 20).Value = DBNull.Value;
}
else
{
cmdStcokTransfer_Detail.Parameters.Add("@SKUNUMBER", SqlDbType.NVarChar, 20).Value = Convert.ToString(skuItem.Rows[ItemCount]["SKUNUMBER"]);
}
if (string.IsNullOrEmpty(Convert.ToString(skuItem.Rows[ItemCount]["QUANTITY"])))
{
cmdStcokTransfer_Detail.Parameters.Add("@QTY", SqlDbType.Decimal).Value = DBNull.Value;
}
else
{
cmdStcokTransfer_Detail.Parameters.Add("@QTY", SqlDbType.Decimal).Value = Convert.ToDecimal(skuItem.Rows[ItemCount]["QUANTITY"]);
}
cmdStcokTransfer_Detail.Parameters.Add("@RETAILSTOREID", SqlDbType.NVarChar, 10).Value = ApplicationSettings.Terminal.StoreId;
cmdStcokTransfer_Detail.Parameters.Add("@RETAILTERMINALID", SqlDbType.NVarChar, 10).Value = ApplicationSettings.Terminal.TerminalId;
cmdStcokTransfer_Detail.Parameters.Add("@RETAILSTAFFID", SqlDbType.NVarChar, 10).Value = pos.OperatorId;
cmdStcokTransfer_Detail.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar, 4).Value = ApplicationSettings.Database.DATAAREAID;
cmdStcokTransfer_Detail.CommandTimeout = 0;
iStockTransfer_Details = cmdStcokTransfer_Detail.ExecuteNonQuery();
cmdStcokTransfer_Detail.Dispose();
#endregion
}
}
}
transaction.Commit();
command.Dispose();
transaction.Dispose();
}
catch (Exception ex)
{
transaction.Rollback();
transaction.Dispose();
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage(ex.Message.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
private void btnPOSItemSearch_Click(object sender, EventArgs e)
{
if (IsEdit)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("You are in editing mode", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return;
}
}
Microsoft.Dynamics.Retail.Pos.Dialog.Dialog objdialog = new Dialog.Dialog();
string str = string.Empty;
DataSet dsItem = new DataSet();
objdialog.MyItemSearch(500, ref str, out dsItem);
saleLineItem = new SaleLineItem();
if (dsItem != null && dsItem.Tables.Count > 0 && dsItem.Tables[0].Rows.Count > 0)
{
saleLineItem.ItemId = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMID"]);
Microsoft.Dynamics.Retail.Pos.Item.Item objItem = new Item.Item();
objItem.MYProcessItem(saleLineItem, application);
Microsoft.Dynamics.Retail.Pos.Dimension.Dimension objDim = new Dimension.Dimension();
DataTable dtDimension = new DataTable();
dtDimension = objDim.GetDimensions(saleLineItem.ItemId);
if (dtDimension != null && dtDimension.Rows.Count > 0)
{
DimensionConfirmation dimConfirmation = new DimensionConfirmation();
dimConfirmation.InventDimCombination = dtDimension;
dimConfirmation.DimensionData = saleLineItem.Dimension;
frmDimensions objfrmDim = new frmDimensions(dimConfirmation);
objfrmDim.ShowDialog();
if (objfrmDim.SelectDimCombination != null)
{
inventDimId = GetInventID(Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[2]));
DataTable dtcmbCode = new DataTable();
dtcmbCode.Columns.Add("CodeID", typeof(string));
dtcmbCode.Columns.Add("CodeValue", typeof(string));
DataRow drCode;
drCode = dtcmbCode.NewRow();
drCode["CodeID"] = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[4]);
drCode["CodeValue"] = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[4]);
dtcmbCode.Rows.Add(drCode);
cmbCode.DataSource = dtcmbCode;
cmbCode.DisplayMember = "CodeValue";
cmbCode.ValueMember = "CodeID";
DataTable dtSize = new DataTable();
dtSize.Columns.Add("SizeID", typeof(string));
dtSize.Columns.Add("SizeValue", typeof(string));
DataRow drSize;
drSize = dtSize.NewRow();
drSize["SizeID"] = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[3]);
drSize["SizeValue"] = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[3]);
dtSize.Rows.Add(drSize);
cmbSize.DataSource = dtSize;
cmbSize.DisplayMember = "SizeID";
cmbSize.ValueMember = "SizeValue";
DataTable dtConfig = new DataTable();
dtConfig.Columns.Add("ConfigID", typeof(string));
dtConfig.Columns.Add("ConfigValue", typeof(string));
DataRow drConfig;
drConfig = dtConfig.NewRow();
drConfig["ConfigID"] = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[6]);
drConfig["ConfigValue"] = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[6]);
dtConfig.Rows.Add(drConfig);
cmbConfig.DataSource = dtConfig;
cmbConfig.DisplayMember = "ConfigID";
cmbConfig.ValueMember = "ConfigValue";
DataTable dtStyle = new DataTable();
dtStyle.Columns.Add("StyleID", typeof(string));
dtStyle.Columns.Add("StyleValue", typeof(string));
DataRow drStyle;
drStyle = dtStyle.NewRow();
drStyle["StyleID"] = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[5]);
drStyle["StyleValue"] = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[5]);
dtStyle.Rows.Add(drStyle);
cmbStyle.DataSource = dtStyle;
cmbStyle.DisplayMember = "StyleID";
cmbStyle.ValueMember = "StyleValue";
cmbConfig.Enabled = false;
cmbCode.Enabled = false;
cmbSize.Enabled = false;
cmbStyle.Enabled = false;
Previewdimensions = ColorSizeStyleConfig();
}
}
else
{
cmbStyle.Text = string.Empty;
cmbConfig.Text = string.Empty;
cmbCode.Text = string.Empty;
cmbSize.Text = string.Empty;
cmbConfig.Enabled = false;
cmbCode.Enabled = false;
cmbSize.Enabled = false;
cmbStyle.Enabled = false;
}
txtPCS.Focus();
txtPCS.Text = "";
SqlConnection conn = new SqlConnection();
if (application != null)
{
conn = application.Settings.Database.Connection;
}
else
{
conn = ApplicationSettings.Database.LocalConnection;
}
txtItemId.Text = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMID"]);
txtItemName.Text = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMNAME"]);
unitid = saleLineItem.BackofficeSalesOrderUnitOfMeasure;
}
}
bool ValidateControls()
{
if (txtItemId.Text.ToUpper().Trim() == "ITEM ID" || string.IsNullOrEmpty(txtItemId.Text))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Item Id can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
btnPOSItemSearch.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (txtItemName.Text.ToUpper().Trim() == "ITEM NAME" || string.IsNullOrEmpty(txtItemName.Text))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Item name can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
btnPOSItemSearch.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
//if(IsCatchWtItem(txtItemId.Text.Trim()))
//{
// if(string.IsNullOrEmpty(txtPCS.Text.Trim()))
// {
// using(LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("PCS can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
// {
// txtPCS.Focus();
// LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
// return false;
// }
// }
//}
//else
//{
// txtPCS.Enabled = false;
//}
if ((string.IsNullOrEmpty(txtPCS.Text.Trim()))) //&& (Convert.ToDecimal(txtPCS.Text) > 1)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("PCS can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtPCS.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtQuantity.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Quantity can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtQuantity.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
else
{
return(true);
}
}
public void PrePayment(IPreTriggerResult preTriggerResult, IPosTransaction posTransaction, object posOperation, string tenderId)
{
RetailTransaction retailTransaction = posTransaction as RetailTransaction;
LSRetailPosis.Transaction.CustomerPaymentTransaction custTrans = posTransaction as LSRetailPosis.Transaction.CustomerPaymentTransaction;
if (custTrans != null)
{
InputConfirmation inputconfirm = new InputConfirmation();
inputconfirm.PromptText = "Remarks ";
inputconfirm.InputType = InputType.Normal;
Interaction.frmInput Oinput = new Interaction.frmInput(inputconfirm);
Oinput.ShowDialog();
if (!string.IsNullOrEmpty(Oinput.InputText))
{
custTrans.PartnerData.Remarks = Oinput.InputText;
}
else
{
custTrans.PartnerData.Remarks = "";
}
if ((PosisOperations)posOperation == PosisOperations.PayCreditMemo)
{
preTriggerResult.ContinueOperation = false;
return;
}
SqlConnection connection = new SqlConnection();
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
Enums.EnumClass oEnum = new Enums.EnumClass();
string sMaxAmount = string.Empty;
string sTerminalID = ApplicationSettings.Terminal.TerminalId;
string sMinAmt = Convert.ToString(oEnum.ValidateMinDeposit(connection, out sMaxAmount, sTerminalID, Convert.ToDecimal((((LSRetailPosis.Transaction.CustomerPaymentTransaction)(posTransaction))).CustomerDepositItem.Amount)));
if (Convert.ToDecimal(sMinAmt) != 0 && Convert.ToDecimal(sMaxAmount) != 0)
{
if (Convert.ToDecimal(sMinAmt) > Convert.ToDecimal((((LSRetailPosis.Transaction.CustomerPaymentTransaction)(posTransaction))).CustomerDepositItem.Amount) ||
Convert.ToDecimal(sMaxAmount) < Convert.ToDecimal((((LSRetailPosis.Transaction.CustomerPaymentTransaction)(posTransaction))).CustomerDepositItem.Amount))
{
preTriggerResult.ContinueOperation = false;
preTriggerResult.MessageId = 50448;
return;
}
}
}
//start : RH on 05/11/2014
if (retailTransaction != null)
{
/* InputConfirmation inC = new InputConfirmation();
* inC.PromptText = "Remarks";
* inC.InputType = InputType.Normal;
*
* Interaction.frmInput Oinput = new Interaction.frmInput(inC);
* Oinput.ShowDialog();
* if(!string.IsNullOrEmpty(Oinput.InputText))
* retailTransaction.PartnerData.Remarks = Oinput.InputText;
* else
* retailTransaction.PartnerData.Remarks = "";*/
int iPM = 100;
int iCF = 100;
int isSale = 0;
foreach (SaleLineItem saleLineItem in retailTransaction.SaleItems)
{
if (!saleLineItem.Voided)
{
isSale = 1;
iPM = getMetalType(saleLineItem.ItemId);
if (iPM == (int)MetalType.PackingMaterial)
{
break;
}
}
}
if (isSale == 1 && string.IsNullOrEmpty(retailTransaction.PartnerData.Remarks))
{
InputConfirmation inC = new InputConfirmation();
inC.PromptText = "Remarks";
inC.InputType = InputType.Normal;
Interaction.frmInput Oinput = new Interaction.frmInput(inC);
Oinput.ShowDialog();
if (!string.IsNullOrEmpty(Oinput.InputText))
{
retailTransaction.PartnerData.Remarks = Oinput.InputText;
}
else
{
retailTransaction.PartnerData.Remarks = "";
}
}
if ((isSale == 1 || retailTransaction.SaleIsReturnSale) && string.IsNullOrEmpty(retailTransaction.PartnerData.TouristNumber))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Tourist VAT Applicable.", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
//command.Parameters.Add("@GOLDFIXING", SqlDbType.Bit).Value = Convert.ToString(dialog.DialogResult).ToUpper().Trim() == "YES" ? "True" : "False";
if (Convert.ToString(dialog.DialogResult).ToUpper().Trim() == "YES")
{
InputConfirmation inC = new InputConfirmation();
inC.PromptText = "Tourist VAT Applicable";
inC.InputType = InputType.Normal;
inC.MaxLength = 20;
Interaction.frmInput Oinput = new Interaction.frmInput(inC);
Oinput.ShowDialog();
if (!string.IsNullOrEmpty(Oinput.InputText))
{
retailTransaction.PartnerData.TouristNumber = Oinput.InputText;
}
else
{
retailTransaction.PartnerData.TouristNumber = "";
}
}
}
}
string sAdjustmentId = AdjustmentItemID();
foreach (SaleLineItem SLineItem in retailTransaction.SaleItems)
{
//if(SLineItem.ItemId == sAdjustmentId && retailTransaction.SaleItems.Count == 1)
//{
// retailTransaction.RefundReceiptId = "1";
// //break;
//}
if (SLineItem.ItemId == sAdjustmentId && retailTransaction.SaleItems.Count > 0)
{
retailTransaction.RefundReceiptId = "1";
}
if (SLineItem.ItemId != sAdjustmentId)
{
retailTransaction.RefundReceiptId = "";
break;
}
}
foreach (SaleLineItem saleLineItem in retailTransaction.SaleItems)
{
if (!saleLineItem.Voided)
{
iCF = getMetalType(saleLineItem.ItemId);
if (iCF == (int)MetalType.Certificate)
{
break;
}
}
}
foreach (SaleLineItem saleLineItem in retailTransaction.SaleItems)
{
if (saleLineItem.ReturnLineId == 0)
{
if (retailTransaction.PartnerData.PackingMaterial != "Y")
{
if (IsRetailItem(saleLineItem.ItemId))
{
if (iPM != (int)MetalType.PackingMaterial)
{
#region Commented
//using(LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Have you issued packing material?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
//{
// LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
// if(Convert.ToString(dialog.DialogResult).ToUpper().Trim() == "NO")
// {
// preTriggerResult.ContinueOperation = false;
// return;
// }
// else
// {
// retailTransaction.PartnerData.PackingMaterial = "Y";
// if(IsCertificateItem(saleLineItem.ItemId))
// {
// if(iCF != (int)MetalType.Certificate)
// {
// using(LSRetailPosis.POSProcesses.frmMessage dialog1 = new LSRetailPosis.POSProcesses.frmMessage("Have you issued the certificate?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
// {
// LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog1);
// if(Convert.ToString(dialog1.DialogResult).ToUpper().Trim() == "NO")
// {
// preTriggerResult.ContinueOperation = false;
// return;
// }
// else
// retailTransaction.PartnerData.CertificateIssue = "Y";
// }
// }
// else
// retailTransaction.PartnerData.CertificateIssue = "Y";
// }
// }
//}
#endregion
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Proceed without packing material?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
if (Convert.ToString(dialog.DialogResult).ToUpper().Trim() == "NO")
{
preTriggerResult.ContinueOperation = false;
return;
}
}
}
else
{
retailTransaction.PartnerData.PackingMaterial = "Y";
#region Commented
//if(IsCertificateItem(saleLineItem.ItemId))
//{
// if(iCF != (int)MetalType.Certificate)
// {
// using(LSRetailPosis.POSProcesses.frmMessage dialog1 = new LSRetailPosis.POSProcesses.frmMessage("Have you issued the certificate?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
// {
// LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog1);
// if(Convert.ToString(dialog1.DialogResult).ToUpper().Trim() == "NO")
// {
// preTriggerResult.ContinueOperation = false;
// return;
// }
// else
// retailTransaction.PartnerData.CertificateIssue = "Y";
// }
// }
// else
// retailTransaction.PartnerData.CertificateIssue = "Y";
//}
#endregion
}
}
}
#region Commented
// else if(retailTransaction.PartnerData.CertificateIssue != "Y")
// {
// if(IsCertificateItem(saleLineItem.ItemId))
// {
// if(iCF != (int)MetalType.Certificate)
// {
// using(LSRetailPosis.POSProcesses.frmMessage dialog1 = new LSRetailPosis.POSProcesses.frmMessage("Have you issued the certificate?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
// {
// LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog1);
// if(Convert.ToString(dialog1.DialogResult).ToUpper().Trim() == "NO")
// {
// preTriggerResult.ContinueOperation = false;
// return;
// }
// else
// retailTransaction.PartnerData.CertificateIssue = "Y";
// }
// }
// else
// retailTransaction.PartnerData.CertificateIssue = "Y";
// }
// }
#endregion
}
}
}
// end: RH on 05/11/2014
LSRetailPosis.ApplicationLog.Log("PaymentTriggers.PrePayment", "On the start of a payment operation...", LSRetailPosis.LogTraceLevel.Trace);
switch ((PosisOperations)posOperation)
{
case PosisOperations.PayCash:
// Insert code here...
break;
case PosisOperations.PayCard:
// Insert code here...
break;
case PosisOperations.PayCheque:
// Insert code here...
break;
case PosisOperations.PayCorporateCard:
// Insert code here...
break;
case PosisOperations.PayCreditMemo:
// Insert code here...
break;
case PosisOperations.PayCurrency:
// Insert code here...
break;
case PosisOperations.PayCustomerAccount:
// Insert code here...
break;
case PosisOperations.PayGiftCertificate:
// Insert code here...
break;
case PosisOperations.PayLoyalty:
// Insert code here...
break;
// etc.....
}
}
private void ShowItemSearch(int fromRow, int numberOfItems)
{
string itemid = string.Empty;
DataTable dtSKUItems = new DataTable();
string commandText = " SELECT ITEMID, ITEMNAME, I.UNITOFMEASURE FROM ( " +
" SELECT IT.ITEMID, COALESCE(TR.NAME, IT.ITEMNAME, IT.ITEMID) AS ITEMNAME, IT.DATAAREAID, " +
" ISNULL(IM.UNITID, '') AS UNITOFMEASURE, ROW_NUMBER() OVER (ORDER BY IT.ITEMNAME ASC) AS ROW " +
" FROM ASSORTEDINVENTITEMS IT JOIN INVENTTABLEMODULE IM ON IT.ITEMID = IM.ITEMID AND IM.MODULETYPE = 2 " +
" JOIN ECORESPRODUCT AS PR ON PR.RECID = IT.PRODUCT " +
// " INNER JOIN SKUTable_Posted ON IT.ITEMID = SKUTable_Posted.SkuNumber " +
" INNER JOIN SKUTableTrans ON IT.ITEMID = SKUTableTrans.SkuNumber " + //SKU Table
" LEFT JOIN ECORESPRODUCTTRANSLATION AS TR " +
" ON PR.RECID = TR.PRODUCT AND TR.LANGUAGEID = @CULTUREID WHERE IT.STORERECID = @STORERECID " +
// " AND SKUTable_Posted.isAvailable='True' AND SKUTable_Posted.isLocked='False' " +
" AND SKUTableTrans.isAvailable='True' AND SKUTableTrans.isLocked='False' " + //SKU Table
" ) I WHERE I.DATAAREAID='" + ApplicationSettings.Database.DATAAREAID + "' AND I.ROW > @FROMROW AND I.ROW <= @TOROW ";
SqlConnection connection = new SqlConnection();
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlCommand command = new SqlCommand(commandText, connection);
SqlParameter languageIdParm = command.Parameters.Add("@CULTUREID", SqlDbType.NVarChar, 7);
languageIdParm.Value = ApplicationSettings.Terminal.CultureName;
SqlParameter dataAreaIdParm = command.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar, 4);
dataAreaIdParm.Value = ApplicationSettings.Database.DATAAREAID;
command.Parameters.AddWithValue("@FROMROW", fromRow);
command.Parameters.AddWithValue("@TOROW", (fromRow + numberOfItems));
command.Parameters.AddWithValue("@STORERECID", ApplicationSettings.Terminal.StorePrimaryId);
command.CommandTimeout = 0;
SqlDataReader reader = command.ExecuteReader();
dtSKUItems.Load(reader);
if (dtSKUItems != null && dtSKUItems.Rows.Count > 0)
{
DataRow drSelected = null;
Dialog.Dialog oDialog = new Dialog.Dialog();
oDialog.GenericSearch(dtSKUItems, ref drSelected, "Select SKU");
if (dtSkuGridItems != null && dtSkuGridItems.Rows.Count > 0)
{
if (drSelected != null)
{
itemid = Convert.ToString(drSelected["ITEMID"]);
dtSkuGridItems.ImportRow(drSelected);
}
}
else
{
if (dtSkuGridItems != null && dtSkuGridItems.Columns.Count > 0)
{
if (drSelected != null)
{
itemid = Convert.ToString(drSelected["ITEMID"]);
dtSkuGridItems.ImportRow(drSelected);
}
}
else
{
dtSkuGridItems = dtSKUItems.Clone();
dtSkuGridItems.Columns.Add("SKUBOOKINGDATE", typeof(DateTime));
if (drSelected != null)
{
itemid = Convert.ToString(drSelected["ITEMID"]);
dtSkuGridItems.ImportRow(drSelected);
dtSkuGridItems.AcceptChanges();
}
}
}
UpdateSKUTable(itemid);
foreach (DataRow dr in dtSkuGridItems.Rows)
{
dr["SKUBOOKINGDATE"] = DateTime.Now.ToShortDateString();
}
grItems.DataSource = dtSkuGridItems;
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("No Item Present.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
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.");
}
}
private void btnPOSItemSearch_Click(object sender, EventArgs e)
{
if (IsEdit)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("You are in editing mode", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return;
}
}
Dialog objdialog = new Dialog();
string str = string.Empty;
DataSet dsItem = new DataSet();
objdialog.MyItemSearch(500, ref str, out dsItem);
saleLineItem = new SaleLineItem();
if (dsItem != null && dsItem.Tables.Count > 0 && dsItem.Tables[0].Rows.Count > 0)
{
saleLineItem.ItemId = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMID"]);
Item objItem = new Item();
objItem.MYProcessItem(saleLineItem, application);
Dimension objDim = new Dimension();
DataTable dtDimension = new DataTable();
dtDimension = objDim.GetDimensions(saleLineItem.ItemId);
if (dtDimension != null && dtDimension.Rows.Count > 0)
{
DimensionConfirmation dimConfirmation = new DimensionConfirmation();
dimConfirmation.InventDimCombination = dtDimension;
dimConfirmation.DimensionData = saleLineItem.Dimension;
frmDimensions objfrmDim = new frmDimensions(dimConfirmation);
objfrmDim.ShowDialog();
if (objfrmDim.SelectDimCombination != null)
{
inventDimId = frmRepairDetail.GetInventID(Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[2]));
#region The following field(code,style,size and configuration are added to this form) @ 01/11/2014
txtCode.Text = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[4]);
txtStyle.Text = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[5]);
txtSize.Text = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[3]);
txtConfig.Text = Convert.ToString(objfrmDim.SelectDimCombination.ItemArray[6]);
#endregion
}
}
txtPCS.Focus();
txtPCS.Text = "1";
SqlConnection conn = new SqlConnection();
if (application != null)
{
conn = application.Settings.Database.Connection;
}
else
{
conn = ApplicationSettings.Database.LocalConnection;
}
string sQty = string.Empty;
sQty = frmRepairDetail.GetStandardQuantityFromDB(conn, Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMID"]));
if (!string.IsNullOrEmpty(sQty))
{
sQty = Convert.ToString(decimal.Round(Convert.ToDecimal(sQty), 3, MidpointRounding.AwayFromZero));
txtQuantity.Text = Convert.ToString(Convert.ToDecimal(sQty) == 0 ? string.Empty : Convert.ToString(sQty));
}
txtItemId.Text = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMID"]);
txtItemName.Text = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMNAME"]);
txtRate.Text = "0.00";// frmRepairDetail.getRateFromMetalTable(txtItemId.Text, cmbConfig.Text, cmbStyle.Text, cmbCode.Text, cmbSize.Text, txtQuantity.Text);
// if (!string.IsNullOrEmpty(txtRate.Text))
// cmbRateType.SelectedIndex = cmbRateType.FindStringExact("Tot");
// txtRate.Text = Convert.ToString(dsItem.Tables[0].Rows[0]["ITEMPRICE"]).Remove(0, 1).Trim();
unitid = saleLineItem.BackofficeSalesOrderUnitOfMeasure;
}
}
public DataRow AmountToBeAdjusted(string custAccount, bool isTranIdExists = false, string custaccount = null, string ordernum = null)
{
string TransID = string.Empty;
#region Multiple Adjustment
if (custaccount != null && ordernum != null)
{
BlankOperations oBlank = new BlankOperations();
DataTable dt = oBlank.CustomerAdvanceData(custAccount);
RetailTransaction retailTrans = pos as RetailTransaction;
string order = Convert.ToString(retailTrans.PartnerData.AdjustmentOrderNum);
string cust = Convert.ToString(retailTrans.PartnerData.AdjustmentCustAccount);
DataRow drReturn = null;
foreach (DataRow drNew in dt.Select("ORDERNUM='" + order + "' AND CustomerAccount='" + cust + "' AND ISADJUSTED=0"))
{
if (string.IsNullOrEmpty(TransID))
{
TransID = "'" + Convert.ToString(drNew["TransactionID"]) + "'";
}
else
{
TransID += ",'" + Convert.ToString(drNew["TransactionID"]) + "'";
}
drNew["ISADJUSTED"] = 1;
drReturn = drNew;
break;
}
return(drReturn);
}
#endregion
#region Single Adjustment
else
{
System.Collections.Generic.LinkedList <LSRetailPosis.Transaction.Line.SaleItem.SaleLineItem> saleline = new System.Collections.Generic.LinkedList <LSRetailPosis.Transaction.Line.SaleItem.SaleLineItem>(((LSRetailPosis.Transaction.RetailTransaction)(pos)).SaleItems);
if (isTranIdExists)
{
foreach (var sale in saleline)
{
if (sale.ItemType == LSRetailPosis.Transaction.Line.SaleItem.SaleLineItem.ItemTypes.Service && !sale.Voided)
{
if (string.IsNullOrEmpty(TransID))
{
TransID = "'" + sale.PartnerData.ServiceItemCashAdjustmentTransactionID + "'";
}
else
{
TransID += ",'" + sale.PartnerData.ServiceItemCashAdjustmentTransactionID + "'";
}
}
}
}
SqlConnection SqlCon = new SqlConnection(ApplicationSettings.Database.LocalConnectionString);
SqlCon.Open();
// Create a Command
SqlCommand SqlComm = new SqlCommand();
SqlComm.Connection = SqlCon;
SqlComm.CommandType = CommandType.Text;
DataRow drSelected = null;
#region Commented qUERY
//SqlComm.CommandText = " SELECT RETAILTRANSACTIONTABLE.TRANSACTIONID AS [Transaction ID], RETAILTRANSACTIONTABLE.CUSTACCOUNT AS [Customer Account], " +
// " DIRPARTYTABLE.NAMEALIAS AS [Customer Name], CAST(SUM(RETAILTRANSACTIONPAYMENTTRANS.AMOUNTCUR) AS NUMERIC(28,3)) AS [Total Amount] " +
// " FROM DIRPARTYTABLE INNER JOIN CUSTTABLE ON DIRPARTYTABLE.RECID = CUSTTABLE.PARTY INNER JOIN " +
// " RETAILTRANSACTIONTABLE INNER JOIN RETAILTRANSACTIONPAYMENTTRANS ON RETAILTRANSACTIONTABLE.TRANSACTIONID = RETAILTRANSACTIONPAYMENTTRANS.TRANSACTIONID ON " +
// " CUSTTABLE.ACCOUNTNUM = RETAILTRANSACTIONTABLE.CUSTACCOUNT WHERE (RETAILTRANSACTIONTABLE.CUSTACCOUNT = '" + custAccount + "') " +
// " AND (RETAILTRANSACTIONPAYMENTTRANS.isAdjusted = 0) AND (RETAILTRANSACTIONTABLE.[TYPE] = 3) ";
//if (isTranIdExists && !string.IsNullOrEmpty(TransID))
//{
// SqlComm.CommandText += " AND (RETAILTRANSACTIONPAYMENTTRANS.TRANSACTIONID NOT IN (" + TransID + ")) ";
//}
//SqlComm.CommandText += " GROUP BY RETAILTRANSACTIONTABLE.TRANSACTIONID, RETAILTRANSACTIONTABLE.CUSTACCOUNT,DIRPARTYTABLE.NAMEALIAS ";
#endregion
////SqlComm.CommandText = " SELECT RETAILADJUSTMENTTABLE.TRANSACTIONID AS [TransactionID], " +
//// " RETAILADJUSTMENTTABLE.CUSTACCOUNT AS [CustomerAccount], " +
//// " DIRPARTYTABLE.NAMEALIAS AS [CustomerName], " +
//// //" CAST(RETAILADJUSTMENTTABLE.AMOUNT AS NUMERIC(28,3)) AS [TotalAmount] " +
//// " CAST(RETAILADJUSTMENTTABLE.AMOUNT AS NUMERIC(28,2)) AS [TotalAmount],ISNULL(GOLDFIXING,0) AS GoldFixing,(CASE WHEN GOLDFIXING = 0 THEN 0 ELSE CAST(ISNULL(GOLDQUANTITY,0) AS NUMERIC(28,3)) END) AS GoldQty " + // Avg Gold Rate Adjustment
//// " ,ISNULL(RETAILADJUSTMENTTABLE.RETAILSTOREID,'') AS RETAILSTOREID,ISNULL(RETAILADJUSTMENTTABLE.RETAILTERMINALID,'') AS RETAILTERMINALID" +
//// " FROM DIRPARTYTABLE INNER JOIN " +
//// " CUSTTABLE ON DIRPARTYTABLE.RECID = CUSTTABLE.PARTY INNER JOIN " +
//// " RETAILADJUSTMENTTABLE ON CUSTTABLE.ACCOUNTNUM = RETAILADJUSTMENTTABLE.CUSTACCOUNT " +
//// " WHERE (RETAILADJUSTMENTTABLE.ISADJUSTED = 0) AND (RETAILADJUSTMENTTABLE.RETAILDEPOSITTYPE = 1) " +
//// " AND (RETAILADJUSTMENTTABLE.CUSTACCOUNT = '" + custAccount + "') ";
try
{
if (PosApplication.Instance.TransactionServices.CheckConnection())
{
ReadOnlyCollection <object> containerArray;
string sStoreId = ApplicationSettings.Terminal.StoreId;
containerArray = PosApplication.Instance.TransactionServices.InvokeExtension("getUnadjustedAdvance", custAccount);
DataSet dsWH = new DataSet();
StringReader srTransDetail = new StringReader(Convert.ToString(containerArray[3]));
if (Convert.ToString(containerArray[3]).Trim().Length > 38)
{
dsWH.ReadXml(srTransDetail);
}
if (dsWH != null && dsWH.Tables[0].Rows.Count > 0)
{
Dialog.WinFormsTouch.frmGenericSearch OSearch = new Dialog.WinFormsTouch.frmGenericSearch(dsWH.Tables[0], drSelected, "Advance Adjustment");
OSearch.ShowDialog();
drSelected = OSearch.SelectedDataRow;
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("No Active Deposit found for the selected customer.", MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
}
catch (Exception ex)
{
}
return(drSelected);
//DataRow drSelected = null;
//DataTable AdjustmentDT = new DataTable();
//SqlDataAdapter SqlDa = new SqlDataAdapter(SqlComm);
//SqlDa.Fill(AdjustmentDT);
//if (AdjustmentDT != null && AdjustmentDT.Rows.Count > 0)
//{
// Dialog.WinFormsTouch.frmGenericSearch OSearch = new Dialog.WinFormsTouch.frmGenericSearch(AdjustmentDT, drSelected, "Advance Adjustment");
// OSearch.ShowDialog();
// drSelected = OSearch.SelectedDataRow;
// return drSelected;
//}
//else
//{
// using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("No Active Deposit found for the selected customer.", MessageBoxButtons.OK, MessageBoxIcon.Error))
// {
// LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
// }
// return null;
//}
}
#endregion
}
private void btnSearchOrder_Click(object sender, EventArgs e)
{
string sCustOrderSearchNumber = string.Empty;
DataTable dtGridItems = new DataTable();
string commandText = string.Empty;
commandText = " SELECT ORDERNUM,CONVERT(VARCHAR(15),ORDERDATE,103) AS ORDERDATE ,CONVERT(VARCHAR(15),DELIVERYDATE,103) AS DELIVERYDATE , " +
" CUSTNAME ,CONVERT(VARCHAR(15),TOTALAMOUNT) AS TOTALAMOUNT FROM CUSTORDER_HEADER ORDER BY ORDERNUM ";
SqlConnection connection = new SqlConnection();
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlCommand command = new SqlCommand(commandText, connection);
command.CommandTimeout = 0;
SqlDataReader reader = command.ExecuteReader();
dtGridItems = new DataTable();
dtGridItems.Load(reader);
if (dtGridItems != null && dtGridItems.Rows.Count > 0)
{
DataRow selRow = null;
Dialog objCustOrderSearch = new Dialog();
objCustOrderSearch.GenericSearch(dtGridItems, ref selRow, "Customer Order");
if (selRow != null)
{
sCustOrderSearchNumber = Convert.ToString(selRow["ORDERNUM"]);
}
else
{
return;
}
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("No Order Exists.", MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
return;
}
if (!string.IsNullOrEmpty(sCustOrderSearchNumber))
{
DataSet dsOrderSearched = new DataSet();
commandText = " SELECT [ORDERNUM],[LINENUM],[STOREID],[TERMINALID],[ITEMID] " +
" ,[CONFIGID] [CONFIGURATION],[CODE] [COLOR],[SIZEID] [SIZE],[STYLE],[INVENTDIMID],[PCS],[QTY] [QUANTITY],[NETTWT],[DIAWT],[DIAAMT],[STNWT] " +
" ,[STNAMT],[TOTALAMT],[DATAAREAID],[STAFFID],[REPLICATIONCOUNTER],[UNITID],[REMARKSDTL],[ISRETURNED] FROM [CUSTORDSAMPLE] WHERE ORDERNUM='" + sCustOrderSearchNumber.Trim() + "' " +
" SELECT [ORDERNUM],[LINENUM],[STOREID],[TERMINALID],[ITEMID] " +
" ,[CODE] [COLOR],[SIZEID] [SIZE],[STYLE],[PCS],[DIAWT],[DIAAMT],[STNWT] " +
" ,[STNAMT],[DATAAREAID],[STAFFID],[REMARKSDTL],[ISRETURNED]" +
" FROM [CUSTORDSTONE] WHERE ORDERNUM='" + sCustOrderSearchNumber.Trim() + "'";
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlCommand command1 = new SqlCommand(commandText, connection);
command1.CommandTimeout = 0;
SqlDataAdapter adapter = new SqlDataAdapter(commandText, connection);
dsOrderSearched = new DataSet();
adapter.Fill(dsOrderSearched);
if (dsOrderSearched != null && dsOrderSearched.Tables.Count > 0)
{
dtSample = dsOrderSearched.Tables[0];
dtStone = dsOrderSearched.Tables[1];
}
}
dtNotReturn = null;
if (iIsStoneRet == 1)
{
dtNotReturn = dtStone.Clone();
}
else
{
dtNotReturn = dtSample.Clone();
}
dtNotReturn.Columns["ISRETURNED"].DataType = typeof(bool);// change the datatype of the column ISRETURNED(int) to bool on 24/09/2014
if (iIsStoneRet == 0)
{
dtSample.Select("ISRETURNED=False").CopyToDataTable(dtNotReturn, LoadOption.PreserveChanges);
sfrmTitle = "Client's Order Sample Return";
}
else
{
dtStone.Select("ISRETURNED=False").CopyToDataTable(dtNotReturn, LoadOption.PreserveChanges);
sfrmTitle = "Client's Order Stone Return";
}
grItems.DataSource = dtNotReturn.DefaultView;
//frmCustOrderSampleReturn objSampleRtn = new frmCustOrderSampleReturn(pos, application, dtSample, objOrderdetails, 0);
if (retailTrans != null)
{
if (!string.IsNullOrEmpty(retailTrans.Customer.PostalCode))
{
sCPinCode = Convert.ToString(retailTrans.Customer.PostalCode);
}
}
//else
//{
// sCPinCode = Convert.ToString(application.BusinessLogic.CustomerSystem.GetCustomerInfo(objCustomerOrder.txtCustomerAccount.Text).PostalCode);
//}
txtOrderNo.Text = sCustOrderSearchNumber;
// grItems.DataSource = dtNotReturn.DefaultView;
}
/// <summary>
/// Created by : Ripan Hossain
/// Created on : 18/09/2013
/// Modified by :
/// Modified on :
/// Purpose : data validation
/// </summary>
/// <returns></returns>
private bool IsValid()
{
if (string.IsNullOrEmpty(txtCustomerAccount.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Customer Account can not be blank and empty.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtCustomerName.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Customer Name can not be blank and empty.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
//if(string.IsNullOrEmpty(cmbSalesPerson.Text.Trim()))
//{
// using(LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Sales person should not be blank.", MessageBoxButtons.OK, MessageBoxIcon.Information))
// {
// LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
// return false;
// }
//}
if (string.IsNullOrEmpty(cmbSchemeCode.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Scheme code can not be blank and empty.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(cmbIdType.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Id type can not be blank and empty.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtIdNo.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Id no should not be blank.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (chkMinor.Checked)
{
if (string.IsNullOrEmpty(txtGuardianName.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Guardian name should not be blank.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtRelationship.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Relationship should not be blank.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
}
//if(string.IsNullOrEmpty(txtNName.Text.Trim()))
//{
// using(LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Nominee name should not be blank.", MessageBoxButtons.OK, MessageBoxIcon.Information))
// {
// LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
// return false;
// }
//}
//else
//{
// return true;
//}
return(true);
}
private void btnReturn_Click(object sender, EventArgs e)
{
if (dtNotReturn.Rows.Count > 0)
{
string orderno = string.Empty;
StringBuilder commandText1 = new StringBuilder();
//added or modified on 16/09/2014 by Palas
if (iIsStoneRet == 1)
{
sTableName = "CUSTORDSTONE";
sStnFlg = "STONEFLAG";
}
else
{
sTableName = "CUSTORDSAMPLE";
sStnFlg = "SAMPLEFLAG";
}
//added or modified on 16/09/2014 by Palas
foreach (DataRow dr in dtNotReturn.Rows)
{
orderno = dr["ORDERNUM"].ToString();
if (Convert.ToBoolean(dr["ISRETURNED"]))
{
commandText1.Append("UPDATE " + sTableName + " SET ISRETURNED=1 ");
commandText1.AppendFormat(" WHERE ORDERNUM='{0}' ", dr["ORDERNUM"]);
commandText1.AppendFormat(" AND LINENUM='{0}' ", dr["LINENUM"]);
commandText1.AppendFormat(" AND STOREID='{0}' ", ApplicationSettings.Terminal.StoreId);
commandText1.AppendFormat(" AND TERMINALID='{0}' ", ApplicationSettings.Terminal.TerminalId);
commandText1.AppendFormat(" AND DATAAREAID='{0}'; ", ApplicationSettings.Database.DATAAREAID);
}
}
commandText1.AppendLine();
commandText1.AppendLine("DECLARE @SAMRETCOUNT INT;");
commandText1.AppendLine(" SELECT @SAMRETCOUNT=COUNT(*) FROM " + sTableName + " ");
commandText1.AppendFormat(" WHERE ORDERNUM='{0}' ", orderno);
commandText1.AppendLine(" AND ISRETURNED=0");
commandText1.AppendFormat(" AND STOREID='{0}' ", ApplicationSettings.Terminal.StoreId);
commandText1.AppendFormat(" AND TERMINALID='{0}' ", ApplicationSettings.Terminal.TerminalId);
commandText1.AppendFormat(" AND DATAAREAID='{0}'; ", ApplicationSettings.Database.DATAAREAID);
commandText1.AppendLine("IF @SAMRETCOUNT <=0 BEGIN UPDATE CUSTORDER_HEADER SET " + sStnFlg + " =0 ");
commandText1.AppendFormat(" WHERE ORDERNUM='{0}' ", orderno);
commandText1.AppendFormat(" AND STOREID='{0}' ", ApplicationSettings.Terminal.StoreId);
commandText1.AppendFormat(" AND TERMINALID='{0}' ", ApplicationSettings.Terminal.TerminalId);
commandText1.AppendFormat(" AND DATAAREAID='{0}' END; ", ApplicationSettings.Database.DATAAREAID);
SqlConnection connection = new SqlConnection();
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
using (SqlCommand command = new SqlCommand(commandText1.ToString(), connection))
{
string Msg = string.Empty;
command.CommandTimeout = 0;
if (command.ExecuteNonQuery() > 0)
{
//update local sample atble
commandText1 = new StringBuilder();
if (iIsStoneRet == 0)
{
commandText1.AppendLine(" SELECT [ORDERNUM],[LINENUM],[STOREID],[TERMINALID],[ITEMID] ");
commandText1.AppendLine(" ,[CONFIGID] [CONFIGURATION],[CODE] [COLOR],[SIZEID] [SIZE],[STYLE],[INVENTDIMID],[PCS],[QTY] [QUANTITY],[NETTWT],[DIAWT],[DIAAMT],[STNWT] ");
commandText1.AppendLine(" ,[STNAMT],[TOTALAMT],[DATAAREAID],[STAFFID],[REPLICATIONCOUNTER],[UNITID],[REMARKSDTL] [RemarksDtl],[ISRETURNED] ");
commandText1.AppendLine(" FROM [CUSTORDSAMPLE] WHERE ORDERNUM='" + orderno + "' ");
Msg = "Customer Order Sample has been returned successfully.";
}
else
{
commandText1.AppendLine(" SELECT [ORDERNUM],[LINENUM],[STOREID],[TERMINALID],[ITEMID],[CODE] [COLOR],[SIZEID] [SIZE] ");
commandText1.AppendLine(" ,[PCS],[DIAWT],[DIAAMT],[STNWT]");
commandText1.AppendLine(" ,[STNAMT],[DATAAREAID],[STAFFID],[REPLICATIONCOUNTER],[REMARKSDTL] [RemarksDtl],[ISRETURNED] ");
commandText1.AppendLine(" FROM [CUSTORDSTONE] WHERE ORDERNUM='" + orderno + "' ");
Msg = "Stones have been returned successfully.";
}
SqlCommand command1 = new SqlCommand(commandText1.ToString(), connection);
command1.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(command1);
DataTable dtNewSample = new DataTable();
da.Fill(dtNewSample);
if (dtNewSample.Rows.Count > 0 && frmOrderDtls != null)
{
frmOrderDtls.UpdatelocalSampleTable(dtNewSample);
}
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage(Msg, MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
this.Close();
}
}
command.Dispose();
}
}
catch (Exception ex)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage(ex.Message.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
orderno = Convert.ToString(dtNotReturn.Rows[0]["ORDERNUM"]);
// PrintVoucher(orderno, iIsStoneRet,dtNotReturn);
}
}
else
{
this.Close();
}
}
bool ValidateControls()
{
if ((string.IsNullOrEmpty(txtReturnNo.Text.Trim())))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Repair Return No can not be blank or empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtReturnNo.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
//repair no
if ((string.IsNullOrEmpty(txtOrderNo.Text.Trim())))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Repair No. can not be blank or empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtReturnNo.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
//dtPickerDeliveryDate
if ((string.IsNullOrEmpty(dtPickerDeliveryDate.Text.Trim())))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Repair Return Date can not be blank or empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
dtPickerDeliveryDate.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
//dTPickerOrderDate
if ((string.IsNullOrEmpty(dTPickerOrderDate.Text.Trim())))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Repair Order date can not be blank or empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
dTPickerOrderDate.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
// dt compare
if (Convert.ToDateTime(dtPickerDeliveryDate.Text) < Convert.ToDateTime(dTPickerOrderDate.Text))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Delivery Date cannot be less than Order Date", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
dtPickerDeliveryDate.Text = dTPickerOrderDate.Text;
return(false);
}
}
//txtItemId
if ((string.IsNullOrEmpty(txtItemId.Text.Trim())))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Item Id can not be blank or empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtItemId.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
// txtCustomerAccount
if ((string.IsNullOrEmpty(txtCustomerAccount.Text.Trim())))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Customer Account can not be blank or empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtCustomerAccount.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
else
{
return(true);
}
}
/// <summary>
/// Print the standard slip, returns false if printing should be aborted altogether.
/// </summary>
/// <param name="formType"></param>
/// <param name="posTransaction"></param>
/// <param name="copyReceipt"></param>
/// <returns></returns>
public bool PrintReceipt(FormType formType, IPosTransaction posTransaction, bool copyReceipt)
{
bool result = false;
if (formType == FormType.Receipt)
{
//SqlConnection SqlCon = new SqlConnection(ApplicationSettings.Database.LocalConnectionString);
SqlConnection connection = new SqlConnection();
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
//Start :02/07/2014
if (posTransaction is IRetailTransaction)
{
RetailTransaction retailTransaction = (RetailTransaction)posTransaction;
SaleLineItem item = retailTransaction.SaleItems.Last.Value;
if (item.Description == "Add to gift card")
{
//====
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
string sTransactionId = retailTransaction.TransactionId;
string sTerminalId = retailTransaction.TerminalId;
string sCardNo = string.Empty;
decimal sAmt = 0;
DataTable dt = GetGiftCardAmountInfo(connection, sTransactionId, sTerminalId);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
if (string.IsNullOrEmpty(sCardNo))
{
sAmt = Convert.ToDecimal(dt.Rows[i]["AMOUNT"]);
sCardNo = Convert.ToString(dt.Rows[i]["COMMENT"]);
sCardNo = new String('x', Convert.ToInt16(sCardNo.Length) - 4) + sCardNo.Substring(Convert.ToInt16(sCardNo.Length) - 4);
}
else
{
sCardNo = sCardNo + " / " + new String('x', Convert.ToInt16(Convert.ToString(dt.Rows[i]["COMMENT"]).Length) - 4) + Convert.ToString(dt.Rows[i]["COMMENT"]).Substring(Convert.ToInt16(Convert.ToString(dt.Rows[i]["COMMENT"]).Length) - 4);
sAmt = sAmt + Convert.ToDecimal(dt.Rows[i]["AMOUNT"]);
}
}
}
frmR_ProductAdvanceReceipt objProdAdv = new frmR_ProductAdvanceReceipt(posTransaction, connection, sTransactionId, Convert.ToString(sAmt), sTerminalId, item.Description, sCardNo);
objProdAdv.ShowDialog();
}
else
{
if (retailTransaction.RefundReceiptId == "1")
{
string sTransactionId = retailTransaction.TransactionId;
string sTerminalId = retailTransaction.TerminalId;
string sCardNo = string.Empty;
decimal sAmt = 0;
DataTable dt = GetGiftCardAmountInfo(connection, sTransactionId, sTerminalId);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
if (string.IsNullOrEmpty(sCardNo))
{
sAmt = Convert.ToDecimal(dt.Rows[i]["AMOUNT"]);
sCardNo = Convert.ToString(dt.Rows[i]["COMMENT"]);
sCardNo = new String('x', Convert.ToInt16(sCardNo.Length) - 4) + sCardNo.Substring(Convert.ToInt16(sCardNo.Length) - 4);
}
else
{
sCardNo = sCardNo + " / " + new String('x', Convert.ToInt16(Convert.ToString(dt.Rows[i]["COMMENT"]).Length) - 4) + Convert.ToString(dt.Rows[i]["COMMENT"]).Substring(Convert.ToInt16(Convert.ToString(dt.Rows[i]["COMMENT"]).Length) - 4);
sAmt = sAmt + Convert.ToDecimal(dt.Rows[i]["AMOUNT"]);
}
}
}
frmR_ProductAdvanceReceipt objProdAdv = new frmR_ProductAdvanceReceipt(posTransaction, connection, sTransactionId, Convert.ToString(sAmt), sTerminalId, item.Description, sCardNo, 1);
objProdAdv.ShowDialog();
}
else
{
if (retailTransaction.SaleIsReturnSale)
{
frmSaleInv reportfrm = new frmSaleInv(posTransaction, connection, copyReceipt, 0, 0, iPrintFromShowJournal);
reportfrm.ShowDialog();
frmSaleInvAccountsCopy reportfrmAcc = new frmSaleInvAccountsCopy(posTransaction, connection, copyReceipt, 0, 0, iPrintFromShowJournal);
reportfrmAcc.ShowDialog();
//frmSaleInvControlCopy reportfrmCon = new frmSaleInvControlCopy(posTransaction, connection, copyReceipt, 0, 0, iPrintFromShowJournal);
//reportfrmCon.ShowDialog();// commented on 080819/ req by Soudip paul
}
else
{
//Microsoft.Dynamics.Retail.Pos.BlankOperations.WinFormsTouch.frmLanguageForInvoice
// objLI = new BlankOperations.WinFormsTouch.frmLanguageForInvoice();
//objLI.ShowDialog();
//int iLanguage = 0;
//if (objLI.isEnglish == true)
// iLanguage = 1;
//else if (objLI.isArabic == true)
// iLanguage = 2;
//else if (objLI.isBoth == true)
// iLanguage = 3;
if (iPrintFromShowJournal == 1)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Is this a gift invoice?", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
if (Convert.ToString(dialog.DialogResult).ToUpper().Trim() == "YES")
{
frmSaleInv reportfrm = new frmSaleInv(posTransaction, connection, copyReceipt, 1, 0, iPrintFromShowJournal);//Default English for Sales Return
reportfrm.ShowDialog();
frmSaleInv reportfrm1 = new frmSaleInv(posTransaction, connection, copyReceipt, 0, 1, iPrintFromShowJournal);
reportfrm1.ShowDialog();
}
else
{
ChooseInvoiceLanguage(posTransaction, copyReceipt, connection, iPrintFromShowJournal);
}
}
iPrintFromShowJournal = 0;
}
else
{
ChooseInvoiceLanguage(posTransaction, copyReceipt, connection, iPrintFromShowJournal);
}
}
}
}
//retailTransaction
}
//End : 02/07/2014
}
else if (formType == FormType.CustomerAccountDeposit)
{
RetailTransaction retailTransaction = posTransaction as RetailTransaction;
string sGSSNo = string.Empty;
if (retailTransaction != null)
{
SqlConnection connection = new SqlConnection();
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
string sTransactionId = retailTransaction.TransactionId;
// string sTerminalId = ApplicationSettings.Terminal.TerminalId;
string sTerminalId = retailTransaction.TerminalId;
DataTable dtAdv = GetAdvanceInfo(connection, sTransactionId, sTerminalId);
if (dtAdv != null && dtAdv.Rows.Count > 0)
{
sGSSNo = Convert.ToString(dtAdv.Rows[0]["GSSNUMBER"]);
if (sGSSNo != string.Empty)
{
frmR_GSSInstalmentReceipt objRGSS = new frmR_GSSInstalmentReceipt(posTransaction, connection, sTransactionId, Convert.ToString(dtAdv.Rows[0]["AMOUNT"]), sGSSNo, sTerminalId);
objRGSS.ShowDialog();
}
else
{
Microsoft.Dynamics.Retail.Pos.BlankOperations.WinFormsTouch.frmLanguageForInvoice
objLI = new BlankOperations.WinFormsTouch.frmLanguageForInvoice();
objLI.ShowDialog();
int iLanguage = 0;
if (objLI.isEnglish == true)
{
iLanguage = 1;
}
else if (objLI.isArabic == true)
{
iLanguage = 2;
}
else if (objLI.isBoth == true)
{
iLanguage = 3;
}
frmR_ProductAdvanceReceipt objProdAdv = new frmR_ProductAdvanceReceipt(posTransaction, connection, sTransactionId, Convert.ToString(dtAdv.Rows[0]["AMOUNT"]), sTerminalId, "", "", 0, iLanguage);
objProdAdv.ShowDialog();
}
}
}
}
else
{
if (FiscalPrinter.FiscalPrinter.Instance.FiscalPrinterEnabled())
{
return(FiscalPrinter.FiscalPrinter.Instance.PrintReceipt(formType, posTransaction, copyReceipt));
}
FormModulation formMod = new FormModulation(Application.Settings.Database.Connection);
IList <PrinterAssociation> printerMapping = PrintingActions.GetActivePrinters(formMod, formType, copyReceipt);
// bool result = false;
foreach (PrinterAssociation printerMap in printerMapping)
{
bool printResult = PrintingActions.PrintFormTransaction(printerMap, formMod, formType, posTransaction, copyReceipt);
result = result || printResult;
}
}
return(result);
}
bool ItemValidate()
{
if (string.IsNullOrEmpty(txtItemId.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Item Id can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
btnPOSItemSearch.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtItemName.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Item name can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
btnPOSItemSearch.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtPCS.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("PCS can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtPCS.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtQuantity.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Quantity can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtQuantity.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
else if (Convert.ToDecimal(txtQuantity.Text.Trim()) == 0m)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Quantity can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtQuantity.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (string.IsNullOrEmpty(txtRate.Text.Trim()))
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Amount can not be blank and empty", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtRate.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
if (!string.IsNullOrEmpty(txtRate.Text.Trim()) && Convert.ToDecimal(txtRate.Text.Trim()) == 0m)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Amount can not be Zero.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
txtRate.Focus();
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
return(false);
}
}
else
{
return(true);
}
}
private void SaveOrder()
{
int iRETAILREPAIRRETURNTRANS = 0;
SqlTransaction transaction = null;
#region Repair Return
string commandText = " SET DATEFORMAT DMY; BEGIN INSERT INTO [RETAILREPAIRRETURNTRANS]([RepairReturnId],[DELIVERYDATE],[RepairId],[ORDERDATE]," +
" [RetailStoreId],[RetailTerminalId],[RetailStaffId],[CUSTACCOUNT],[CUSTNAME],[CUSTADDRESS],[CUSTPHONE],[DATAAREAID] " +
" ,REPAIRADVADJUSTMENTID,REPAIRRECVSTOREID,REPAIRRECVTERMINALID) " +
" VALUES(@RepairReturnId,@DELIVERYDATE,@RepairId,@ORDERDATE," +
" @RetailStoreId,@RetailTerminalId,@RetailStaffId,@CUSTACCOUNT,@CUSTNAME,@CUSTADDRESS,@CUSTPHONE,@DATAAREAID" +
" ,@REPAIRADVADJUSTMENTID,@REPAIRRECVSTOREID,@REPAIRRECVTERMINALID)" +
" UPDATE RetailRepairReturnHdr SET IsDelivered = 1, DeliveryDate = @DELIVERYDATE WHERE RepairId = @RepairId END"
;
//if(!string.IsNullOrEmpty(sAdvAdjustmentId))
//{
// commandText += " BEGIN UPDATE RETAILADJUSTMENTTABLE SET ISADJUSTED = 1 WHERE TRANSACTIONID = '" + sAdvAdjustmentId + "' AND REPAIRID = '" + txtOrderNo.Text.Trim() + "' END";
//}
SqlConnection connection = new SqlConnection();
try
{
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
transaction = connection.BeginTransaction();
SqlCommand command = new SqlCommand(commandText, connection, transaction);
command.Parameters.Clear();
command.Parameters.Add("@RepairReturnId", SqlDbType.NVarChar).Value = txtReturnNo.Text.Trim();
command.Parameters.Add("@DELIVERYDATE", SqlDbType.DateTime).Value = dtPickerDeliveryDate.Value;
command.Parameters.Add("@RepairId", SqlDbType.NVarChar).Value = txtOrderNo.Text.Trim();
command.Parameters.Add("@ORDERDATE", SqlDbType.DateTime).Value = dTPickerOrderDate.Value;
command.Parameters.Add("@RetailStoreId", SqlDbType.NVarChar, 10).Value = ApplicationSettings.Terminal.StoreId;
command.Parameters.Add("@RetailTerminalId", SqlDbType.NVarChar, 10).Value = ApplicationSettings.Terminal.TerminalId;
command.Parameters.Add("@RetailStaffId", SqlDbType.NVarChar, 10).Value = pos.OperatorId;
command.Parameters.Add("@CUSTACCOUNT", SqlDbType.NVarChar, 20).Value = txtCustomerAccount.Text.Trim();
command.Parameters.Add("@CUSTNAME", SqlDbType.NVarChar, 60).Value = txtCustomerName.Text.Trim();
command.Parameters.Add("@CUSTADDRESS", SqlDbType.NVarChar, 250).Value = txtCustomerAddress.Text.Trim();
if (string.IsNullOrEmpty(txtPhoneNumber.Text))
{
command.Parameters.Add("@CUSTPHONE", SqlDbType.NVarChar, 20).Value = "";
}
else
{
command.Parameters.Add(new SqlParameter("@CUSTPHONE", txtPhoneNumber.Text.Trim()));
}
if (application != null)
{
command.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar, 4).Value = application.Settings.Database.DataAreaID;
}
else
{
command.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar, 4).Value = ApplicationSettings.Database.DATAAREAID;
}
command.Parameters.Add("@REPAIRADVADJUSTMENTID", SqlDbType.NVarChar, 20).Value = sAdvAdjustmentId;
command.Parameters.Add("@REPAIRRECVSTOREID", SqlDbType.NVarChar, 20).Value = sStore;
command.Parameters.Add("@REPAIRRECVTERMINALID", SqlDbType.NVarChar, 20).Value = sTerminal;
#endregion
command.CommandTimeout = 0;
iRETAILREPAIRRETURNTRANS = command.ExecuteNonQuery();
transaction.Commit();
command.Dispose();
transaction.Dispose();
if (iRETAILREPAIRRETURNTRANS != -1)
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("Repair Return has been created successfully.", MessageBoxButtons.OK, MessageBoxIcon.Information))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
RetailTransaction retailTrans = pos as RetailTransaction;
if (retailTrans != null)
{
IsRepairReturn = true;
sRepairRetId = txtReturnNo.Text.Trim();
retailTrans.PartnerData.REPAIRRETURNTRANS = true;
retailTrans.PartnerData.REPAIRID = txtOrderNo.Text.Trim();
retailTrans.PartnerData.REPAIRRETURNID = txtReturnNo.Text.Trim();
}
CLearControls();
this.Close();
}
}
else
{
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage("DataBase error occured.Please try again later.", MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
}
catch (Exception ex)
{
transaction.Rollback();
transaction.Dispose();
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage(ex.Message.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
SqlTransaction transaction = null;
int iCustFootFall = 0;
string commandText = string.Empty;
if (isValid())
{
#region Customer Footfall
if (!bIsEdit)
{
commandText = " INSERT INTO [CUSTOMERFOOTFALL]([DATE],[NOOFEXISTCUST]," +
" [NOOFNEWCUST],[NOOFHNICUST],[DATAAREAID],[STOREID],[TERMINALID]," +
" [STAFFID])" +
" VALUES(@DATE,@NOOFEXISTCUST,@NOOFNEWCUST,@NOOFHNICUST,@DATAAREAID," +
" @STOREID,@TERMINALID,@STAFFID)";
}
else
{
commandText = " UPDATE [CUSTOMERFOOTFALL]" +
" SET [DATE]=@DATE," +
" [NOOFEXISTCUST]=@NOOFEXISTCUST," +
" [NOOFNEWCUST]=@NOOFNEWCUST," +
" [NOOFHNICUST]=@NOOFHNICUST," +
" [DATAAREAID]=@DATAAREAID," +
" [STOREID]=@STOREID," +
" [TERMINALID]=@TERMINALID," +
" [STAFFID]=@STAFFID " +
" WHERE REPLICATIONCOUNTER= " + txtExistCust.Tag + "";
}
SqlConnection connection = new SqlConnection();
try
{
if (application != null)
{
connection = application.Settings.Database.Connection;
}
else
{
connection = ApplicationSettings.Database.LocalConnection;
}
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
transaction = connection.BeginTransaction();
SqlCommand command = new SqlCommand(commandText, connection, transaction);
command.Parameters.Clear();
command.Parameters.Add("@DATE", SqlDbType.Date).Value = dtpDate.Value;
if (string.IsNullOrEmpty(txtExistCust.Text.Trim()))
{
command.Parameters.Add("@NOOFEXISTCUST", SqlDbType.Int).Value = 0;
}
else
{
command.Parameters.Add("@NOOFEXISTCUST", SqlDbType.Int).Value = Convert.ToInt32(txtExistCust.Text.Trim());
}
if (string.IsNullOrEmpty(txtNewCust.Text.Trim()))
{
command.Parameters.Add("@NOOFNEWCUST", SqlDbType.Int).Value = 0;
}
else
{
command.Parameters.Add("@NOOFNEWCUST", SqlDbType.Int).Value = Convert.ToInt32(txtNewCust.Text.Trim());
}
if (string.IsNullOrEmpty(txtHNICust.Text.Trim()))
{
command.Parameters.Add("@NOOFHNICUST", SqlDbType.Int).Value = 0;
}
else
{
command.Parameters.Add("@NOOFHNICUST", SqlDbType.Int).Value = Convert.ToInt32(txtHNICust.Text.Trim());
}
if (application != null)
{
command.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar, 4).Value = application.Settings.Database.DataAreaID;
}
else
{
command.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar, 4).Value = ApplicationSettings.Database.DATAAREAID;
}
command.Parameters.Add("@STOREID", SqlDbType.NVarChar, 10).Value = ApplicationSettings.Terminal.StoreId;
command.Parameters.Add("@TERMINALID", SqlDbType.NVarChar, 10).Value = ApplicationSettings.Terminal.TerminalId;
command.Parameters.Add("@STAFFID", SqlDbType.NVarChar, 10).Value = pos.OperatorId;
//=====================================
command.CommandTimeout = 0;
iCustFootFall = command.ExecuteNonQuery();
transaction.Commit();
command.Dispose();
transaction.Dispose();
}
catch (Exception ex)
{
transaction.Rollback();
transaction.Dispose();
using (LSRetailPosis.POSProcesses.frmMessage dialog = new LSRetailPosis.POSProcesses.frmMessage(ex.Message.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error))
{
LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSForm(dialog);
}
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
#endregion
ClearControls();
}
if (bIsEdit)
{
ShowCustFootFallDetails();
bIsEdit = false;
btnEdit.Enabled = false;
}
}
