protected void btnAccept_Click(object sender, EventArgs e)
{
ReturnsDAO dao = new ReturnsDAO();
_focusindex = -1;
DataTable dt = (DataTable)ViewState["dt"];
if (dt != null)
{
for (int inx = 0; inx < dt.Rows.Count; inx++)
{
if (_itemHashTable.Contains(inx))
{
DataRow dr = dt.Rows[inx];
_ReturnAction ra = (_ReturnAction)_itemHashTable[inx];
int itemnumber = int.Parse(dr.ItemArray[0].ToString());
int ordernumber = int.Parse(lblOrdernumber.Text);
string actioncode = ra.actionCode;
string taskdescr = ra.taskDescription;
string customerurn = lblCustomerUrn.Text;
string sku = (string)dr.ItemArray[2];
string loginname = User.Identity.Name;
dao.ReturnItem("F", itemnumber, ordernumber, actioncode, taskdescr, customerurn, sku, loginname, System.Net.Dns.GetHostEntry(Request.ServerVariables["remote_addr"]).HostName);
}
}
}
_ordernumber = null;
_itemHashTable = null;
ViewState["dt"] = null;
BindGrid();
}
protected void Page_Load(object sender, EventArgs e)
{
ReturnsDAO dao = new ReturnsDAO();
// ds = dao.searchCustomer(null, "watt", "", "", "", "", "", "", "");
// rgCustomers.DataSource = ds;
//var fds = from r in ds.Tables[0].AsEnumerable() where r.Field<string>("customerurn") == "0011605535" select r.Field<string>("customerurn")
//DataRow [] dt = ds.Tables[0].Select("customerurn='0011605535'");
//RadGrid1.DataSource = ds.Tables[0];
// RadGrid1.MasterTableView.DetailTables[0].DataSource = ds.Tables[1];
//RadGrid1.Enabled = false;
if (!Page.IsPostBack)
{
//rgCustomers.Visible = false;
}
else
{
rgCustomers.Visible = true;
}
}
public OrderHeaderResponse GetResponse(ConsignmentOrderNumberRequest ConsignmentOrderNumber)
{
{
ReturnsDAO dao = new ReturnsDAO();
// to all the Order header deatils
DataSet orderH = dao.getOrderDetails(ConsignmentOrderNumber.SearchKey);
var OrderHdr = orderH.Tables[0];
if (OrderHdr.Rows.Count == 0)
{
return(null);
}
DataSet OrderD = dao.getItemsToReturn(int.Parse(orderH.Tables[0].Rows[0]["ORDERNUMBER"].ToString()));
var OrderDtl = OrderD.Tables[0];
var Hdr = OrderHdr.Rows[0];
var Dtl = OrderDtl.Rows[0];
var itemsList = new List <OrderDetailResponse>();
int?reasonCode;
if (Dtl["action"] == DBNull.Value)
{
reasonCode = null;
}
else
{
reasonCode = int.Parse(Dtl["action"].ToString());
}
foreach (var RowValue in OrderDtl.Rows)
{
var item = new OrderDetailResponse();
item.Sku = int.Parse(Dtl["sku"].ToString());
item.ItemNumber = int.Parse(Dtl["itemnumber"].ToString());
item.Description = Dtl["skudescr"].ToString();
item.ReasonCode = reasonCode;
itemsList.Add(item);
}
return(new OrderHeaderResponse
{
OrderNumber = int.Parse(Hdr["ORDERNUMBER"].ToString()),
CustomerURN = int.Parse(Hdr["CUSTOMERURN"].ToString()),
CustomerName = Hdr["customername"].ToString(),
OrderDate = Hdr["ORDERDATE"].ToString(),
PostCode = Hdr["customername"].ToString(),
Parcel_Scanned_Ind = Hdr["PARCEL_SCANNED_IND"].ToString(),
Items = itemsList
});
}
}
// Customer search
protected void rgCustomers_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
if (!e.IsFromDetailTable)
{
bool dosearch = (rtbAddress.Text != string.Empty) || (rtbAddress.Text != string.Empty) || (rtbPostCode.Text != string.Empty) || (rtbFirstName.Text != string.Empty) || (rtbLastName.Text != string.Empty) || (rtbEmail.Text != string.Empty);
if (dosearch)
{
ReturnsDAO dao = new ReturnsDAO();
ds = dao.searchCustomer(null, rtbLastName.Text, rtbFirstName.Text, rtbPostCode.Text, rtbAddress.Text, "", rtbEmail.Text, rtbTelephone.Text, "");
rgCustomers.DataSource = ds.Tables[0];
}
}
}
//Process all returns
protected void btnAccept_Click(object sender, EventArgs e)
{
ReturnsDAO dao = new ReturnsDAO();
_focusindex = -1;
DataTable dt = (DataTable)ViewState["dt"];
if (dt != null)
{
for (int inx = 0; inx < dt.Rows.Count; inx++)
{
if (_itemHashTable.Contains(inx))
{
DataRow dr = dt.Rows[inx];
_ReturnAction ra = (_ReturnAction)_itemHashTable[inx];
string parcelScannedInd = ViewState["parcelscannedind"] == null || ViewState["parcelscannedind"].ToString() == "F" ? "F" : "T";
int itemnumber = int.Parse(dr.ItemArray[0].ToString());
int ordernumber = int.Parse(lblOrdernumber.Text);
string actioncode = ra.actionCode;
string taskdescr = ra.taskDescription;
string customerurn = lblCustomerUrn.Text;
string sku = (string)dr.ItemArray[2];
string loginname = User.Identity.Name;
if (_storeUser == "N")
{
dao.ReturnItem(parcelScannedInd, itemnumber, ordernumber, actioncode, taskdescr, customerurn, sku,
loginname, System.Net.Dns.GetHostEntry(Request.ServerVariables["remote_addr"]).HostName);
}
else
{
dao.RefundItem(parcelScannedInd, itemnumber, ordernumber, actioncode, taskdescr, customerurn, sku,
_userID, _storeID, _tillID);
}
}
}
}
ViewState["dt"] = null;
if (_itemHashTable != null && _itemHashTable.Count > 0)
{
lblItemsReturned.Visible = true;
lblItemsReturned.Text = _itemHashTable.Count.ToString() + " items returned";
}
_ordernumber = null;
_itemHashTable = null;
BindGrid();
}
//Display of orders/items in customer search screen
protected void rgCustomers_DetailTableDataBind(object sender, GridDetailTableDataBindEventArgs e)
{
ReturnsDAO dao = new ReturnsDAO();
GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
switch (e.DetailTableView.Name)
{
case "orders":
{
string customerurn = dataItem.GetDataKeyValue("customerurn").ToString();
DataSet dsorders = dao.getCustomerOrders(customerurn);
e.DetailTableView.DataSource = dsorders;
break;
}
case "items":
{
int ordernumber = int.Parse(dataItem.GetDataKeyValue("ordernumber").ToString());
DataSet dsitems = dao.getOrderItems(ordernumber);
e.DetailTableView.DataSource = dsitems;
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ReturnsDAO dao = new ReturnsDAO();
_actions = dao.getReturnActions().Tables[0];
_itemHashTable = (Hashtable)ViewState["itemsprocessed"];
if (!IsPostBack)
{
lblMessage.Text = "";
lblMessage.Visible = false;
btnReject.Attributes.Add("onclick", "if(confirm('Are you sure?')){}else{return false}");
if (Request.QueryString["ordernumber"] != null)
{
_ordernumber = int.Parse(Request.QueryString["ordernumber"]);
populateOrderDetails(GetOrder(_ordernumber.ToString()));
_focusindex = -1;
}
BindGrid();
}
else
{
if (ViewState["ordernumber"] != null)
{
_ordernumber = (int)ViewState["ordernumber"];
}
else
{
_ordernumber = null;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// This is really yuck but can't but this in the aspx page because a postback occurs when changing the client id mode to fixed
// When a post back occurs this then fires the windows.beforeunload event which checks whether navigating away.
// The script tag should be necessary either but....
string s =
"<script type=\"text/javascript\">" +
"function handleMouseEvent() {" +
" var idSource = window.event.srcElement.id; " +
//" alert(idSource); " +
" if (idSource == \"\" || idSource.indexOf('RadPageView') != -1) { " +
" var tb = document.getElementById( '" + this.tbPackageBarcode.ClientID + "'); " +
" tb.focus(); " +
" } " +
"}" + "</script>";
string csname = "MouseHandlerScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
if (!cs.IsStartupScriptRegistered(cstype, csname))
{
cs.RegisterClientScriptBlock(cstype, csname, s);
}
ReturnsDAO dao = new ReturnsDAO();
// For Cross border returns, we need to read the user, store and till info from
// the URL querystring.
if (Request.QueryString["username"] != null)
{
_userID = Request.QueryString["username"];
_storeUser = "******";
RadTabStrip1.Tabs[1].Visible = false; // Store user has no access to customer search
Button4.Visible = false; // or to the Print button (Button4).
}
if (Request.QueryString["device"] != null)
{
String[] deviceDetails = Request.QueryString["device"].Split('.');
_storeID = deviceDetails[2];
_tillID = deviceDetails[3];
}
_actions = dao.getReturnActions(_storeUser).Tables[0];
// Make a copy of the _actions data table for use by CBR
// this version of the table will not include the
// customer services option.
_actionsCBR = _actions.Clone();
foreach (DataRow dr in _actions.Rows)
{
if (dr["actioncode"].ToString() != CUSTOMERSERVICERTN)
{
_actionsCBR.Rows.Add(dr.ItemArray);
}
}
_itemHashTable = (Hashtable)ViewState["itemsprocessed"];
_tabselected = ViewState["tabselected"] == null ? 0 : (int)ViewState["tabselected"];
RadTabStrip1.Tabs[_tabselected].Selected = true;
RadMultiPage1.SelectedIndex = _tabselected;
lblMessage.Text = "";
lblMessage.Visible = false;
btnReject.Attributes.Add("onclick", "if(confirm('Are you sure?')){}else{return false}");
if (ViewState["ordernumber"] != null)
{
_ordernumber = (int)ViewState["ordernumber"];
}
else
{
_ordernumber = null;
}
}
protected void displayOrder()
{
ReturnsDAO dao = new ReturnsDAO();
bool skuaAlreadyScanned = false;
string scannstring = Regex.Replace(tbPackageBarcode.Text, "[^.0-9]", "");
tbPackageBarcode.Text = "";
lblMessage.Visible = false;
lblItemsReturned.Text = "";
lblItemsReturned.Visible = false;
if (_ordernumber != null)
{
try
{
_skuToFind = dao.getSKU(scannstring);
}
catch
{
// Not a SKU so if we are not yet editing an order - try and see if it is a valid order
if (_itemHashTable == null || _itemHashTable.Count == 0)
{
DataSet dsorder = GetOrder(scannstring);
if (dsorder.Tables[0].Rows.Count > 0)
{
// If we are called from a store, and the returned order is a store order then
// display error message and don't allow the user to continue.
if (DisplayStoreOrderMessage(scannstring))
{
return;
}
populateOrderDetails(dsorder);
_focusindex = -1;
tbPackageBarcode.Text = "";
createDataTable();
BindGrid();
return;
}
else
{
lblMessage.Visible = true;
lblMessage.Text = "Invalid item/order: " + scannstring;
tbPackageBarcode.Text = "";
return;
}
}
else
{
lblMessage.Visible = true;
lblMessage.Text = "Invalid item: " + scannstring;
tbPackageBarcode.Text = "";
return;
}
}
int inx = 0;
_itemHashTable = (Hashtable)ViewState["itemsprocessed"];
foreach (GridViewRow gridrow in gvItems.Rows)
{
CheckBox cb = (CheckBox)gridrow.Cells[EDITCHECKBOXCELL].FindControl("cbEdited");
bool cbenabled = cb != null && cb.Enabled ? true : false;
if (gridrow.Cells[SKUVALCELL].Text == _skuToFind && cbenabled)
{
if (_itemHashTable == null || !_itemHashTable.Contains(inx))
{
gvItems.EditIndex = inx;
_focusindex = inx;
lblMessage.Text = "";
lblMessage.Visible = false;
BindGrid();
return;
}
skuaAlreadyScanned = true;
}
inx++;
}
// If no SKUs have been processed and an order number has been entered then change to processing new order
if (_itemHashTable == null || _itemHashTable.Count == 0)
{
DataSet dsorder = GetOrder(scannstring);
if (dsorder.Tables[0].Rows.Count > 0)
{
// If we are called from a store, and the returned order is a store order then
// display error message and don't allow the user to continue.
if (DisplayStoreOrderMessage(scannstring))
{
return;
}
populateOrderDetails(dsorder);
_focusindex = -1;
tbPackageBarcode.Text = "";
createDataTable();
BindGrid();
return;
}
else
{
lblMessage.Visible = true;
lblMessage.Text = skuaAlreadyScanned ? "SKU " + _skuToFind + " already scanned" : "SKU " + _skuToFind + " not found on order";
}
}
else
{
lblMessage.Visible = true;
lblMessage.Text = skuaAlreadyScanned ? "SKU " + _skuToFind + " already scanned" : "SKU " + _skuToFind + " not found on order";
}
}
else
{
// If we are called from a store, and the returned order is a store order then
// display error message and don't allow the user to continue.
if (DisplayStoreOrderMessage(scannstring))
{
return;
}
populateOrderDetails(GetOrder(scannstring));
_focusindex = -1;
tbPackageBarcode.Text = "";
createDataTable();
BindGrid();
}
}
protected void rtbPackageBarcode_TextChanged(object sender, EventArgs e)
{
ReturnsDAO dao = new ReturnsDAO();
bool skuaAlreadyScanned = false;
if (_ordernumber != null)
{
try
{
_skuToFind = dao.getSKU(rtbPackageBarcode.Text);
}
catch
{
DataSet dsorder = GetOrder(rtbPackageBarcode.Text);
if (dsorder.Tables[0].Rows.Count > 0)
{
populateOrderDetails(dsorder);
_focusindex = -1;
rtbPackageBarcode.Text = "";
createDataTable();
BindGrid();
return;
}
else
{
lblMessage.Visible = true;
lblMessage.Text = "Invalid scan: " + rtbPackageBarcode.Text;
rtbPackageBarcode.Text = "";
return;
}
}
int inx = 0;
_itemHashTable = (Hashtable)ViewState["itemsprocessed"];
foreach (GridViewRow gridrow in gvItems.Rows)
{
CheckBox cb = (CheckBox)gridrow.Cells[0].FindControl("cbEdited");
bool cbenabled = cb != null && cb.Enabled ? true : false;
if (gridrow.Cells[1].Text == _skuToFind && cbenabled)
{
if (_itemHashTable == null || !_itemHashTable.Contains(inx))
{
gvItems.EditIndex = inx;
_focusindex = inx;
lblMessage.Text = "";
lblMessage.Visible = false;
BindGrid();
return;
}
skuaAlreadyScanned = true;
}
inx++;
}
// If no SKUs have been processed and an order number has been entered then change to processing new order
if (_itemHashTable == null || _itemHashTable.Count > 0)
{
DataSet dsorder = GetOrder(rtbPackageBarcode.Text);
if (dsorder.Tables[0].Rows.Count > 0)
{
populateOrderDetails(dsorder);
_focusindex = -1;
rtbPackageBarcode.Text = "";
createDataTable();
BindGrid();
return;
}
else
{
lblMessage.Visible = true;
lblMessage.Text = skuaAlreadyScanned ? "SKU " + _skuToFind + " already scanned" : "SKU " + _skuToFind + " not found on order";
}
}
else
{
lblMessage.Visible = true;
lblMessage.Text = skuaAlreadyScanned ? "SKU " + _skuToFind + " already scanned" : "SKU " + _skuToFind + " not found on order";
}
}
else
{
populateOrderDetails(GetOrder(rtbPackageBarcode.Text));
_focusindex = -1;
rtbPackageBarcode.Text = "";
createDataTable();
BindGrid();
}
}
