private void btnReturnToApprovalStep_Click(object sender, EventArgs e)
{
//int ordId = Convert.ToInt32(gridApprovedOrdersView.GetFocusedDataRow()["ID"].ToString());
Order ord = new Order();
ord.LoadByPrimaryKey(_orderID);
if (ord.RowCount == 0)
{
XtraMessageBox.Show("You have to select an Order to return to approval, ", "Error - Select Order");
return;
}
if (!ord.IsColumnNull("OrderTypeID") && ord.OrderTypeID != OrderType.CONSTANTS.STANDARD_ORDER)
{
XtraMessageBox.Show("You cannot return this order to approval, you can either cancel or confirm this order", "Error - You cannot return this order");
return;
}
MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
transaction.BeginTransaction();
if (ord.RowCount > 0 && ord.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
ord.ChangeStatus(OrderStatus.Constant.ORDER_FILLED, CurrentContext.UserId);
BindApprovedOrders();
}
else if (ord.RowCount > 0 && ord.OrderStatusID == OrderStatus.Constant.PICK_LIST_GENERATED)
{
ord.ReleaseReservation();
ord.ChangeStatus(OrderStatus.Constant.ORDER_FILLED, CurrentContext.UserId);
BindApprovedOrders();
}
transaction.CommitTransaction();
}
catch (Exception exp)
{
transaction.RollbackTransaction();
throw exp;
}
gridPickListDetail.DataSource = null;
//HCMISLoader.MarkAsDirtyUsingOrderID(_orderID, NewMainWindow.UserId, true);
if (BLL.Settings.IsCenter)
{
XtraMessageBox.Show("The Issue Order List has been returned to approval stage", "Confirmation",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("The Pick list has been returned to approval stage", "Confirmation",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnDeleteRequisition_Click(object sender, EventArgs e)
{
DataRow dr = gridRequisitionListView.GetFocusedDataRow();
if (dr != null)
{
int orderID = Convert.ToInt32(dr["ID"]);
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
if (ord.OrderStatusID == OrderStatus.Constant.DRAFT_WISHLIST)
{
if (XtraMessageBox.Show("Are you sure you would like to cancel this requisition?", "Are you sure?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (ord.OrderStatusID == OrderStatus.Constant.DRAFT_WISHLIST)
{
ord.ChangeStatus(OrderStatus.Constant.CANCELED, CurrentContext.UserId);
LoadRequisitions();
XtraMessageBox.Show("Your requisisition has been canceled.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
}
LoadRequisitions();
}
}
else
{
XtraMessageBox.Show("This requisition has already been submitted, you cannot resubmit/cancel it.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void btnDeleteRequisition_Click(object sender, EventArgs e)
{
DataRow dr = gridRequisitionListView.GetFocusedDataRow();
if (dr != null)
{
int orderID = Convert.ToInt32(dr["ID"]);
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
if (ord.OrderStatusID == OrderStatus.Constant.DRAFT_WISHLIST)
{
if (XtraMessageBox.Show("Are you sure you would like to cancel this requisition?", "Are you sure?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (ord.OrderStatusID == OrderStatus.Constant.DRAFT_WISHLIST)
{
ord.ChangeStatus(OrderStatus.Constant.CANCELED,CurrentContext.UserId);
LoadRequisitions();
XtraMessageBox.Show("Your requisisition has been canceled.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
}
LoadRequisitions();
}
}
else
{
XtraMessageBox.Show("This requisition has already been submitted, you cannot resubmit/cancel it.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
/// <summary>
/// Undo pick list that has been printed
/// </summary>
/// <param name="orderID">The order ID.</param>
public void CancelOrderWithPickList(int orderID)
{
// Create a pick list entry
Order ord = new Order();
PickList pl = new PickList();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
PalletLocation palletLocation = new PalletLocation();
ord.LoadByPrimaryKey(orderID);
pl.LoadByOrderID(orderID);
pld.LoadByPickListID(pl.ID);
while (!pld.EOF)
{
rp.LoadByPrimaryKey(pld.ReceivePalletID);
rp.ReservedStock -= Convert.ToInt32(pld.QuantityInBU);
if (rp.ReservedStock < 0)
{
rp.ReservedStock = 0; //If there has been no reservation, allow to cancel the picklist too. No need for it to be blocked by the constraint.
}
rp.Save();
palletLocation.LoadByPrimaryKey(pld.PalletLocationID);
if (palletLocation.StorageTypeID.ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(pld.PalletLocationID);
pf.Balance += Convert.ToInt32(pld.QuantityInBU);
pf.Save();
}
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
pld.MoveNext();
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.CANCELED, CurrentContext.UserId);
pl.MarkAsDeleted();
pl.Save();
}
/// <summary>
/// Marks as dispatched.
/// </summary>
/// <param name="userID">The user ID.</param>
/// <param name="prePrintedSTV">The pre printed STV.</param>
/// <returns></returns>
public bool MarkAsDispatched(int userID, int?prePrintedSTV)
{
if (!this.IsColumnNull("VoidRequest"))
{
if ((this.VoidRequest && this.IsColumnNull("VoidApprovedByUserID"))) //If the approver hasn't acted on the void request.
{
return(false);
}
}
//Mark the NoOfPackIssued equal to the NoOfPack. Discrepancies are supposed to be saved after this function has finished running.
var query = HCMIS.Repository.Queries.Issue.UpdateMarkAsDispatched(userID, this.ID);
var queryConfirmIssue = HCMIS.Repository.Queries.Issue.UpdateMarkAsDispatched(this.ID);
if (prePrintedSTV.HasValue)
{
this.PrePrintedInvoiceNo = prePrintedSTV.Value;
this.Save();
}
BLL.Issue s = new Issue();
s.LoadFromRawSql(query);
s.LoadFromRawSql(queryConfirmIssue);
BLL.IssueDoc isDoc = new IssueDoc();
isDoc.Where.STVID.Value = this.ID;
isDoc.Query.Load();
if (isDoc.RowCount > 0)
{
int orderID = isDoc.OrderID;
BLL.Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
if (ord.RowCount > 0)
{
ord.ChangeStatus(OrderStatus.Constant.DISPATCH_CONFIRMED, CurrentContext.UserId);
ord.Save();
}
}
return(true);
}
private void btnSubmitWishlist_Click(object sender, EventArgs e)
{
DataRow dr = gridRequisitionListView.GetFocusedDataRow();
if (dr != null)
{
int orderID = Convert.ToInt32(dr["ID"]);
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
if (ord.OrderStatusID == OrderStatus.Constant.DRAFT_WISHLIST)
{
ord.ChangeStatus(OrderStatus.Constant.ORDER_FILLED, CurrentContext.UserId);
LoadRequisitions();
XtraMessageBox.Show("Your requisisition has been submitted.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("This requisition has already been submitted, you cannot resubmit it.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void btnReturnToApprovalStep_Click(object sender, EventArgs e)
{
//int ordId = Convert.ToInt32(gridApprovedOrdersView.GetFocusedDataRow()["ID"].ToString());
MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
transaction.BeginTransaction();
Order ord = new Order();
ord.LoadByPrimaryKey(_orderID);
if (ord.RowCount > 0 && ord.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
ord.ChangeStatus(OrderStatus.Constant.ORDER_FILLED, CurrentContext.UserId);;
BindApprovedOrders();
}
transaction.CommitTransaction();
this.LogActivity("Return-Pick-List-To-Approval", ord.ID);
}
catch (Exception exp)
{
transaction.RollbackTransaction();
throw exp;
}
gridPickListDetail.DataSource = null;
if (BLL.Settings.IsCenter)
{
XtraMessageBox.Show("The Issue Order List has been returned to approval stage", "Confirmation",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("The Pick list has been returned to approval stage", "Confirmation",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Saves issue order details
/// </summary>
/// <param name="orderID"></param>
/// <param name="dvPickListMakeup"></param>
public void SavePickList(int orderID, DataView dvPickListMakeup, int userID)
{
//~ Check if This Order has a previous Printed Picklist with detail: Note a header only doesnt affect us! //
var pickList = new PickList();
pickList.LoadByOrderID(orderID);
if (pickList.RowCount > 0)
{
var pldetail = new PickListDetail();
pldetail.LoadByPickListID(pickList.ID);
if (pldetail.RowCount > 0)
{
RemoveFakePartialCommitPickListDetails(orderID);
var pickL = new PickList();
pickL.LoadByOrderID(orderID);
if (pickL.RowCount > 0)
{
throw new Exception("Picklist has already been printed for this Order ");
// This error has been apprearing for the last one year so funny! I hope it won't come again! day: 10/21/2014 @yido //
}
}
}
// Create a pick list entry
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
PickList pl = new PickList();
PalletLocation plocation = new PalletLocation();
plocation.LoadByPrimaryKey(Convert.ToInt32(dvPickListMakeup[0]["PalletLocationID"]));
pl.AddNew();
pl.OrderID = orderID;
pl.PickType = "Pick";
pl.PickedBy = userID;
pl.IsConfirmed = false;
pl.IssuedDate = DateTimeHelper.ServerDateTime;
pl.SavedDate = DateTimeHelper.ServerDateTime;
pl.PickedDate = DateTimeHelper.ServerDateTime;
pl.IsWarehouseConfirmed = 0;
pl.WarehouseID = plocation.WarehouseID;
pl.Save();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
foreach (DataRowView drv in dvPickListMakeup)
{
pld.AddNew();
pld.PickListID = pl.ID;
pld.OrderDetailID = Convert.ToInt32(drv["OrderDetailID"]);
pld.ItemID = Convert.ToInt32(drv["ItemID"]);
pld.BatchNumber = (drv["BatchNo"].ToString());
if (drv["ExpDate"] != DBNull.Value)
{
pld.ExpireDate = Convert.ToDateTime(drv["ExpDate"]);
}
pld.ManufacturerID = Convert.ToInt32(drv["ManufacturerID"]);
pld.BoxLevel = Convert.ToInt32(drv["BoxLevel"]);
pld.QtyPerPack = Convert.ToInt32(drv["QtyPerPack"]);
pld.Packs = Convert.ToDecimal(drv["Pack"]);
pld.PalletLocationID = Convert.ToInt32(drv["PalletLocationID"]);
pld.QuantityInBU = Convert.ToDecimal(drv["QtyInBU"]);
pld.ReceiveDocID = Convert.ToInt32(drv["ReceiveDocID"]);
pld.ReceivePalletID = Convert.ToInt32(drv["ReceivePalletID"]);
if (drv["CalculatedCost"] != DBNull.Value)
{
pld.Cost = Convert.ToDouble(drv["CalculatedCost"]);
}
if (drv["UnitPrice"] != DBNull.Value)
{
pld.UnitPrice = Convert.ToDouble(drv["UnitPrice"]);
}
int ReceivePalletID = Convert.ToInt32(drv["ReceivePalletID"]);
rp.LoadByPrimaryKey(ReceivePalletID);
pld.StoreID = Convert.ToInt32(drv["StoreID"]);
if (drv["DeliveryNote"] != null)
{
pld.DeliveryNote = Convert.ToBoolean(drv["DeliveryNote"]);
}
else
{
pld.DeliveryNote = false;
}
if (rp.IsColumnNull("ReservedStock"))
{
rp.ReservedStock = Convert.ToDecimal(pld.QuantityInBU);
}
else
{
rp.ReservedStock += Convert.ToDecimal(pld.QuantityInBU);
}
if (drv["UnitID"] != DBNull.Value)
{
pld.UnitID = Convert.ToInt32(drv["UnitID"]);
}
plocation.LoadByPrimaryKey(Convert.ToInt32(drv["PalletLocationID"]));
pld.PhysicalStoreID = plocation.PhysicalStoreID;
rp.Save();
if (drv["StorageTypeID"].ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(Convert.ToInt32(drv["PalletLocationID"]));
//pf.Balance -= Convert.ToDecimal(pld.QuantityInBU);
pf.Save();
}
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.PICK_LIST_GENERATED, CurrentContext.UserId);
ord.Save();
}
/// <summary>
/// Saves issue order details
/// </summary>
/// <param name="orderID"></param>
/// <param name="dvPickListMakeup"></param>
public void SavePickList(int orderID, DataView dvPickListMakeup, int userID)
{
//~ Check if This Order has a previous Printed Picklist with detail: Note a header only doesnt affect us! //
var pickList = new PickList();
pickList.LoadByOrderID(orderID);
if(pickList.RowCount>0)
{
var pldetail = new PickListDetail();
pldetail.LoadByPickListID(pickList.ID);
if (pldetail.RowCount > 0)
{
RemoveFakePartialCommitPickListDetails(orderID);
var pickL = new PickList();
pickL.LoadByOrderID(orderID);
if (pickL.RowCount > 0)
{
throw new Exception("Picklist has already been printed for this Order ");
// This error has been apprearing for the last one year so funny! I hope it won't come again! day: 10/21/2014 @yido //
}
}
}
// Create a pick list entry
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
PickList pl = new PickList();
PalletLocation plocation = new PalletLocation();
plocation.LoadByPrimaryKey(Convert.ToInt32(dvPickListMakeup[0]["PalletLocationID"]));
pl.AddNew();
pl.OrderID = orderID;
pl.PickType = "Pick";
pl.PickedBy = userID;
pl.IsConfirmed = false;
pl.IssuedDate = DateTimeHelper.ServerDateTime;
pl.SavedDate = DateTimeHelper.ServerDateTime;
pl.PickedDate = DateTimeHelper.ServerDateTime;
pl.IsWarehouseConfirmed = 0;
pl.WarehouseID = plocation.WarehouseID;
pl.Save();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
foreach (DataRowView drv in dvPickListMakeup)
{
pld.AddNew();
pld.PickListID = pl.ID;
pld.OrderDetailID = Convert.ToInt32(drv["OrderDetailID"]);
pld.ItemID = Convert.ToInt32(drv["ItemID"]);
pld.BatchNumber = (drv["BatchNo"].ToString());
if (drv["ExpDate"] != DBNull.Value)
{
pld.ExpireDate = Convert.ToDateTime(drv["ExpDate"]);
}
pld.ManufacturerID = Convert.ToInt32(drv["ManufacturerID"]);
pld.BoxLevel = Convert.ToInt32(drv["BoxLevel"]);
pld.QtyPerPack = Convert.ToInt32(drv["QtyPerPack"]);
pld.Packs = Convert.ToDecimal(drv["Pack"]);
pld.PalletLocationID = Convert.ToInt32(drv["PalletLocationID"]);
pld.QuantityInBU = Convert.ToDecimal(drv["QtyInBU"]);
pld.ReceiveDocID = Convert.ToInt32(drv["ReceiveDocID"]);
pld.ReceivePalletID = Convert.ToInt32(drv["ReceivePalletID"]);
if (drv["CalculatedCost"] != DBNull.Value)
pld.Cost = Convert.ToDouble(drv["CalculatedCost"]);
if (drv["UnitPrice"] != DBNull.Value)
pld.UnitPrice = Convert.ToDouble(drv["UnitPrice"]);
int ReceivePalletID = Convert.ToInt32(drv["ReceivePalletID"]);
rp.LoadByPrimaryKey(ReceivePalletID);
pld.StoreID = Convert.ToInt32(drv["StoreID"]);
if (drv["DeliveryNote"] != null)
pld.DeliveryNote = Convert.ToBoolean(drv["DeliveryNote"]);
else
pld.DeliveryNote = false;
if (rp.IsColumnNull("ReservedStock"))
{
rp.ReservedStock = Convert.ToDecimal(pld.QuantityInBU);
}
else
{
rp.ReservedStock += Convert.ToDecimal(pld.QuantityInBU);
}
if (drv["UnitID"] != DBNull.Value)
{
pld.UnitID = Convert.ToInt32(drv["UnitID"]);
}
plocation.LoadByPrimaryKey(Convert.ToInt32(drv["PalletLocationID"]));
pld.PhysicalStoreID = plocation.PhysicalStoreID;
rp.Save();
if (drv["StorageTypeID"].ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(Convert.ToInt32(drv["PalletLocationID"]));
//pf.Balance -= Convert.ToDecimal(pld.QuantityInBU);
pf.Save();
}
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.PICK_LIST_GENERATED,CurrentContext.UserId);
ord.Save();
}
/// <summary>
/// Undo pick list that has been printed
/// </summary>
/// <param name="orderID">The order ID.</param>
public void CancelOrderWithPickList(int orderID)
{
// Create a pick list entry
Order ord = new Order();
PickList pl = new PickList();
PickListDetail pld = new PickListDetail();
ReceivePallet rp = new ReceivePallet();
ReceiveDoc rd = new ReceiveDoc();
PickFace pf = new PickFace();
PalletLocation palletLocation = new PalletLocation();
ord.LoadByPrimaryKey(orderID);
pl.LoadByOrderID(orderID);
pld.LoadByPickListID(pl.ID);
while (!pld.EOF)
{
rp.LoadByPrimaryKey(pld.ReceivePalletID);
rp.ReservedStock -= Convert.ToInt32(pld.QuantityInBU);
if (rp.ReservedStock < 0)
rp.ReservedStock = 0; //If there has been no reservation, allow to cancel the picklist too. No need for it to be blocked by the constraint.
rp.Save();
palletLocation.LoadByPrimaryKey(pld.PalletLocationID);
if (palletLocation.StorageTypeID.ToString() == StorageType.PickFace)
{
pf.LoadByPalletLocation(pld.PalletLocationID);
pf.Balance += Convert.ToInt32(pld.QuantityInBU);
pf.Save();
}
//Delete from picklistDetail and add to pickListDetailDeleted
PickListDetailDeleted.AddNewLog(pld, BLL.CurrentContext.UserId);
pld.MarkAsDeleted();
pld.MoveNext();
}
pld.Save();
ord.ChangeStatus(OrderStatus.Constant.CANCELED,CurrentContext.UserId);
pl.MarkAsDeleted();
pl.Save();
}
private void btnReturnToApprovalStep_Click(object sender, EventArgs e)
{
//int ordId = Convert.ToInt32(gridApprovedOrdersView.GetFocusedDataRow()["ID"].ToString());
Order ord = new Order();
ord.LoadByPrimaryKey(_orderID);
if (ord.RowCount == 0)
{
XtraMessageBox.Show("You have to select an Order to return to approval, ", "Error - Select Order");
return;
}
if(!ord.IsColumnNull("OrderTypeID") && ord.OrderTypeID != OrderType.CONSTANTS.STANDARD_ORDER)
{
XtraMessageBox.Show("You cannot return this order to approval, you can either cancel or confirm this order", "Error - You cannot return this order");
return;
}
MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
transaction.BeginTransaction();
if (ord.RowCount > 0 && ord.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
ord.ChangeStatus(OrderStatus.Constant.ORDER_FILLED,CurrentContext.UserId);
BindApprovedOrders();
}
else if (ord.RowCount > 0 && ord.OrderStatusID == OrderStatus.Constant.PICK_LIST_GENERATED)
{
ord.ReleaseReservation();
ord.ChangeStatus(OrderStatus.Constant.ORDER_FILLED,CurrentContext.UserId);
BindApprovedOrders();
}
transaction.CommitTransaction();
}
catch(Exception exp)
{
transaction.RollbackTransaction();
throw exp;
}
gridPickListDetail.DataSource = null;
//HCMISLoader.MarkAsDirtyUsingOrderID(_orderID, NewMainWindow.UserId, true);
if (BLL.Settings.IsCenter)
{
XtraMessageBox.Show("The Issue Order List has been returned to approval stage", "Confirmation",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("The Pick list has been returned to approval stage", "Confirmation",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnSubmitWishlist_Click(object sender, EventArgs e)
{
DataRow dr = gridRequisitionListView.GetFocusedDataRow();
if (dr != null)
{
int orderID = Convert.ToInt32(dr["ID"]);
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
if (ord.OrderStatusID == OrderStatus.Constant.DRAFT_WISHLIST)
{
ord.ChangeStatus(OrderStatus.Constant.ORDER_FILLED,CurrentContext.UserId);
LoadRequisitions();
XtraMessageBox.Show("Your requisisition has been submitted.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("This requisition has already been submitted, you cannot resubmit it.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
/// <summary>
/// Marks as dispatched.
/// </summary>
/// <param name="userID">The user ID.</param>
/// <param name="prePrintedSTV">The pre printed STV.</param>
/// <returns></returns>
public bool MarkAsDispatched(int userID, int? prePrintedSTV)
{
if (!this.IsColumnNull("VoidRequest"))
{
if ((this.VoidRequest && this.IsColumnNull("VoidApprovedByUserID"))) //If the approver hasn't acted on the void request.
{
return false;
}
}
//Mark the NoOfPackIssued equal to the NoOfPack. Discrepancies are supposed to be saved after this function has finished running.
var query = HCMIS.Repository.Queries.Issue.UpdateMarkAsDispatched(userID, this.ID);
var queryConfirmIssue = HCMIS.Repository.Queries.Issue.UpdateMarkAsDispatched(this.ID);
if (prePrintedSTV.HasValue)
{
this.PrePrintedInvoiceNo = prePrintedSTV.Value;
this.Save();
}
BLL.Issue s = new Issue();
s.LoadFromRawSql(query);
s.LoadFromRawSql(queryConfirmIssue);
BLL.IssueDoc isDoc = new IssueDoc();
isDoc.Where.STVID.Value = this.ID;
isDoc.Query.Load();
if (isDoc.RowCount > 0)
{
int orderID = isDoc.OrderID;
BLL.Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
if (ord.RowCount > 0)
{
ord.ChangeStatus(OrderStatus.Constant.DISPATCH_CONFIRMED,CurrentContext.UserId);
ord.Save();
}
}
return true;
}
private void btnReturnToApprovalStep_Click(object sender, EventArgs e)
{
//int ordId = Convert.ToInt32(gridApprovedOrdersView.GetFocusedDataRow()["ID"].ToString());
MyGeneration.dOOdads.TransactionMgr transaction = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
transaction.BeginTransaction();
Order ord = new Order();
ord.LoadByPrimaryKey(_orderID);
if (ord.RowCount > 0 && ord.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
ord.ChangeStatus(OrderStatus.Constant.ORDER_FILLED,CurrentContext.UserId);;
BindApprovedOrders();
}
transaction.CommitTransaction();
this.LogActivity("Return-Pick-List-To-Approval", ord.ID);
}
catch(Exception exp)
{
transaction.RollbackTransaction();
throw exp;
}
gridPickListDetail.DataSource = null;
if (BLL.Settings.IsCenter)
{
XtraMessageBox.Show("The Issue Order List has been returned to approval stage", "Confirmation",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
XtraMessageBox.Show("The Pick list has been returned to approval stage", "Confirmation",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void Save(Domain.Request _request,int userID, Domain.OrderStatus orderStatus = Domain.OrderStatus.Submitted)
{
var order = new Order();
order.LoadByPrimaryKey(_request.RequestID);
var dborderStatus = new BLL.OrderStatus();
dborderStatus.LoadByCode(EnumService<Domain.OrderStatus>.GetCode(orderStatus));
order.ChangeStatus(dborderStatus.ID,CurrentContext.UserId);
order.ApprovedBy = userID;
order.ApprovedDate = DateTimeHelper.ServerDateTime;
var orderDetail = new OrderDetail();
orderDetail.LoadAllByOrderID(_request.RequestID);
while (!orderDetail.EOF)
{
var requestDetail = _request.RequestDetails.SingleOrDefault(r => r.RequestDetailId == orderDetail.ID);
if(requestDetail== null)
{
orderDetail.MarkAsDeleted();
}
else
{
//Set Activity
if (requestDetail.ActivityGroup != null)
{
orderDetail.StoreID = requestDetail.ActivityGroup.Activity.ActivityID;
orderDetail.DeliveryNote = requestDetail.ActivityGroup.IsDeliveryNote;
}
else
{
orderDetail.SetColumnNull("StoreID");
}
//Set Manufacturer
if (requestDetail.Manufacturer != null)
{
orderDetail.PreferredManufacturerID = requestDetail.Manufacturer.ManufacturerID;
}
else
{
orderDetail.SetColumnNull("PreferredManufacturerID");
}
//Set PhysicalStore
if (requestDetail.physicalStore != null)
{
orderDetail.PreferredPhysicalStoreID = requestDetail.physicalStore.PhysicalStoreID;
}
else
{
orderDetail.SetColumnNull("PreferredPhysicalStoreID");
}
//Set ExpiryDate
if (requestDetail.ExpiryDate.HasValue)
{
orderDetail.PreferredExpiryDate = requestDetail.ExpiryDate.Value;
}
else
{
orderDetail.SetColumnNull("PreferredExpiryDate");
}
orderDetail.ApprovedQuantity = requestDetail.ApprovedQuantity;
orderDetail.StockedOut = requestDetail.StockedOut;
}
orderDetail.MoveNext();
}
foreach (var requestDetail in _request.RequestDetails.Where(r => r.RequestDetailId == 0).ToList())
{
orderDetail.AddNew();
orderDetail.ItemID = requestDetail.Item.ItemID;
orderDetail.UnitID = requestDetail.Unit.UnitID;
orderDetail.Pack = requestDetail.RequestedQuantity;
orderDetail.OrderID = order.ID;
orderDetail.QtyPerPack = 1;
orderDetail.Quantity = requestDetail.RequestedQuantity;
orderDetail.ApprovedQuantity = requestDetail.ApprovedQuantity;
orderDetail.StockedOut = requestDetail.StockedOut;
if (requestDetail.ActivityGroup != null)
{
orderDetail.StoreID = requestDetail.ActivityGroup.Activity.ActivityID;
orderDetail.DeliveryNote = requestDetail.ActivityGroup.IsDeliveryNote;
}
else
{
orderDetail.SetColumnNull("StoreID");
}
//Set Manufacturer
if (requestDetail.Manufacturer != null)
{
orderDetail.PreferredManufacturerID = requestDetail.Manufacturer.ManufacturerID;
}
else
{
orderDetail.SetColumnNull("PreferredManufacturerID");
}
//Set PhysicalStore
if (requestDetail.physicalStore != null)
{
orderDetail.PreferredPhysicalStoreID = requestDetail.physicalStore.PhysicalStoreID;
}
else
{
orderDetail.SetColumnNull("PreferredPhysicalStoreID");
}
//Set ExpiryDate
if (requestDetail.ExpiryDate.HasValue)
{
orderDetail.PreferredExpiryDate = requestDetail.ExpiryDate.Value;
}
else
{
orderDetail.SetColumnNull("PreferredExpiryDate");
}
}
order.Save();
orderDetail.Save();
}
