protected virtual void dvOrderHeader_OnDataBound(Object sender, EventArgs e) { if (dvOrderHeader.CurrentMode == DetailsViewMode.ReadOnly) { if (Session[CONST_ORDERHEADERVALUES] != null) { // this is a update of the header items TrackerDotNet.control.OrderHeaderData _OldOrderHeader = (OrderHeaderData)Session[CONST_ORDERHEADERVALUES]; string _NewDateStr = GetOrderHeaderRequiredByDateStr(); if (!_NewDateStr.Equals(string.Empty)) { DateTime _NewRequireDate = Convert.ToDateTime(GetOrderHeaderRequiredByDateStr()).Date; if (_OldOrderHeader.OrderDate.Date != _NewRequireDate.Date) { UsedItemGroupTbl _UsedItems = new UsedItemGroupTbl(); DropDownList _gvItemDLL = null; // chjeck in each item of the grid if the item was a group item foreach (GridViewRow _gvr in gvOrderLines.Rows) { _gvItemDLL = (DropDownList)_gvr.FindControl("ddlItemDesc"); _UsedItems.UpdateIfGroupItem(_OldOrderHeader.CustomerID, Convert.ToInt32(_gvItemDLL.SelectedValue), _OldOrderHeader.RequiredByDate, _NewRequireDate); } } } } Label lblPurchaseOrder = (Label)dvOrderHeader.FindControl("lblPurchaseOrder"); if ((lblPurchaseOrder != null) && (lblPurchaseOrder.Text.Equals(TrackerTools.CONST_POREQUIRED))) { lblPurchaseOrder.BackColor = System.Drawing.Color.Red; lblPurchaseOrder.ForeColor = System.Drawing.Color.White; } } CheckBox thisCheckBox = (CheckBox)dvOrderHeader.FindControl("cbxDone"); if (thisCheckBox != null) { btnOrderDelivered.Enabled = btnOrderCancelled.Enabled = !thisCheckBox.Checked; } updtButtonPanel.Update(); }
public List <OrderHeaderData> LoadOrderHeader(Int32 pCustomerID, DateTime pPrepDate) { List <OrderHeaderData> ohDetails = new List <OrderHeaderData>(); string _sqlCmd = CONST_ORDERSHEADER_SELECT; OleDbConnection _conn = new OleDbConnection(_connectionString); OleDbCommand _cmd = new OleDbCommand(_sqlCmd, _conn); _cmd.Parameters.Add(new OleDbParameter { Value = pCustomerID }); _cmd.Parameters.Add(new OleDbParameter { Value = pPrepDate }); _conn.Open(); OleDbDataReader objReader = _cmd.ExecuteReader(); while (objReader.Read()) { OrderHeaderData ohDetail = new OrderHeaderData(); ohDetail.CustomerID = (Int32)objReader["CustID"]; // ohDetail.CompanyName = (string)objReader["CompanyName"]; // ohDetail.Abreviation = (string)objReader["Abreviation "]; ohDetail.ToBeDeliveredBy = (long)objReader["PersonsID"]; ohDetail.Notes = (string)objReader["Notes"]; ohDetail.OrderDate = (DateTime)objReader["OrderDate"]; ohDetail.RoastDate = (DateTime)objReader["RoastDate"]; ohDetail.RequiredByDate = (DateTime)objReader["RequiredByDate"]; ohDetail.Confirmed = (bool)objReader["Confirmed"]; ohDetail.Done = (bool)objReader["Done"]; ohDetails.Add(ohDetail); } objReader.Close(); _conn.Close(); return(ohDetails); }
protected virtual void dvOrderHeader_OnModeChanging(Object sender, DetailsViewModeEventArgs e) { if (e.NewMode == DetailsViewMode.Edit) { TrackerDotNet.control.OrderHeaderData _OrderHeader = Get_dvOrderHeaderData(false); Session[CONST_ORDERHEADERVALUES] = _OrderHeader; } else if (e.NewMode == DetailsViewMode.ReadOnly) { if (Session[CONST_ORDERHEADERVALUES] != null) // it has been editted { dvOrderHeader.DataBind(); } //if (Session[CONST_ORDERHEADERVALUES] != null) //{ // TrackerDotNet.control.OrderHeaderData _OldOrderHeader = (OrderHeaderData)Session[CONST_ORDERHEADERVALUES]; // TrackerDotNet.control.OrderHeaderData _NewOrderHeader = Get_dvOrderHeaderData(true); // LogTbl _Log = new LogTbl(); // string _WhatsChanged = string.Empty; // _Log.AddToWhatsChanged("CustomderID", _OldOrderHeader.CustomerID.ToString(),_NewOrderHeader.CustomerID.ToString(), ref _WhatsChanged); // _Log.AddToWhatsChanged("Order Date", string.Format("{0:d}", _OldOrderHeader.OrderDate), string.Format("{0:d}", _NewOrderHeader.OrderDate), ref _WhatsChanged); // _Log.AddToWhatsChanged("Roast Date", string.Format("{0:d}", _OldOrderHeader.RoastDate), string.Format("{0:d}", _NewOrderHeader.RoastDate), ref _WhatsChanged); // _Log.AddToWhatsChanged("ToBeDeliveredBy", _OldOrderHeader.ToBeDeliveredBy.ToString(), _NewOrderHeader.ToBeDeliveredBy.ToString(), ref _WhatsChanged); // _Log.AddToWhatsChanged("RequiredBy Date", string.Format("{0:d}", _OldOrderHeader.RequiredByDate), string.Format("{0:d}", _NewOrderHeader.RequiredByDate), ref _WhatsChanged); // _Log.AddToWhatsChanged("Confirmed", _OldOrderHeader.Confirmed.ToString(), _NewOrderHeader.Confirmed.ToString(), ref _WhatsChanged); // _Log.AddToWhatsChanged("Done", _OldOrderHeader.Done.ToString(), _NewOrderHeader.Done.ToString(), ref _WhatsChanged); // _Log.AddToWhatsChanged("Notes", _OldOrderHeader.Notes.ToString(), _NewOrderHeader.Notes.ToString(), ref _WhatsChanged); // _Log.InsertLogItem(Membership.GetUser().UserName, // SectionTypesTbl.CONST_ORDERS_SECTION_INT, TransactionTypesTbl.CONST_UPDATE_TRANSACTION_INT, // _NewOrderHeader.CustomerID, _WhatsChanged, "Order Header Detail"); //} } }
/// <summary> /// Execute the SQL statement does not return results, such as: delete, update, insert operation /// </summary> /// <param name="strSQL">SQL String of a non Query Type</param> /// <returns>success or failure</returns> public bool UpdateOrderHeader(OrderHeaderData pOrderHeader, List <string> pOrders) { bool _resultState = false; string _strSQL = CONST_ORDERUPDATEHEADER_SQL + " WHERE "; // for all the OrderIds passed create a where clause for (int i = 0; i < pOrders.Count - 1; i++) { _strSQL += " OrderID = " + pOrders[i] + " OR"; } _strSQL += " OrderID = " + pOrders[pOrders.Count - 1]; _TrackerDbConn.Open(); OleDbTransaction _myTrans = _TrackerDbConn.BeginTransaction(); // UPDATE order CustomerId = ?, OrderDate= ?, RoastDate= ?, RequiredByDate= ?, ToBeDeliveredBy= ?, Confirmed= ?, Done= ?, Notes = ? WHERE (OrderId = ?)"; OleDbCommand _command = new OleDbCommand(_strSQL, _TrackerDbConn, _myTrans); // add parameters in the order of the SQL command _command.Parameters.Add(new OleDbParameter { Value = pOrderHeader.CustomerID }); _command.Parameters.Add(new OleDbParameter { Value = pOrderHeader.OrderDate }); _command.Parameters.Add(new OleDbParameter { Value = pOrderHeader.RoastDate }); _command.Parameters.Add(new OleDbParameter { Value = pOrderHeader.RequiredByDate }); _command.Parameters.Add(new OleDbParameter { Value = pOrderHeader.ToBeDeliveredBy }); _command.Parameters.Add(new OleDbParameter { Value = pOrderHeader.Confirmed }); _command.Parameters.Add(new OleDbParameter { Value = pOrderHeader.Done }); _command.Parameters.Add(new OleDbParameter { Value = pOrderHeader.Notes }); // _command.Parameters.Add(new OleDbParameter { Value =pOrderId}); try { _command.ExecuteNonQuery(); _myTrans.Commit(); _resultState = true; } catch { _myTrans.Rollback(); _resultState = false; } finally { _TrackerDbConn.Close(); } return(_resultState); }
public OrderCls() { _Header = new OrderHeaderData(); List <OrderDetailData> _Items = new List <OrderDetailData>(); }
public List <OrderHeaderData> LoadOrderSummary(Int32 CustomerId, DateTime DeliveryDate, String Notes, int MaximumRows, int StartRowIndex) { List <OrderHeaderData> ohSummarys = new List <OrderHeaderData>(); string _sqlCmd = CONST_ORDERSSUMMARY_SELECT; //OleDbConnection _conn = new OleDbConnection(_connectionString); //OleDbCommand _cmd = new OleDbCommand(_sqlCmd, _conn); //_cmd.Parameters.Add(new OleDbParameter { Value = CustomerId }); //_cmd.Parameters.Add(new OleDbParameter { Value = PrepDate } ); OleDbConnection _conn = new OleDbConnection(_connectionString); // customer ZZname = 9 is a general customer name so condition must be to that if (CustomerId == 9) { _sqlCmd += "([CustomerId] = 9) AND ([RequiredByDate] = ?) AND ([Notes] = ?)"; } else { _sqlCmd += "([CustomerId] = ?) AND ([RequiredByDate] = ?)"; } // attach the command OleDbCommand _cmd = new OleDbCommand(_sqlCmd, _conn); if (CustomerId == 9) { _cmd.Parameters.Add(new OleDbParameter { Value = DeliveryDate }); _cmd.Parameters.Add(new OleDbParameter { Value = Notes }); } else { _cmd.Parameters.Add(new OleDbParameter { Value = CustomerId }); _cmd.Parameters.Add(new OleDbParameter { Value = DeliveryDate }); } _conn.Open(); OleDbDataReader _DataReader = _cmd.ExecuteReader(); while (_DataReader.Read()) { OrderHeaderData ohSummary = new OrderHeaderData(); ohSummary.CustomerID = (Int32)_DataReader["CustomerId"]; ohSummary.OrderDate = (DateTime)_DataReader["OrderDate"]; ohSummary.RoastDate = (DateTime)_DataReader["RoastDate"]; ohSummary.RequiredByDate = (DateTime)_DataReader["RequiredByDate"]; ohSummary.ToBeDeliveredBy = (_DataReader["ToBeDeliveredBy"] == DBNull.Value) ? 3 : (Int32)_DataReader["ToBeDeliveredBy"];// 3 is the default ohSummary.Confirmed = (bool)_DataReader["Confirmed"]; ohSummary.Done = (bool)_DataReader["Done"]; ohSummary.Notes = (_DataReader["Notes"] == DBNull.Value) ? "" : (string)_DataReader["Notes"]; ohSummarys.Add(ohSummary); } _DataReader.Close(); _conn.Close(); return(ohSummarys); }