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