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(); } }