private void SavePickListItems(object sender, EventArgs e)
{
var ord = new Order();
var rus = new Institution();
ord.LoadByPrimaryKey(_orderID);
rus.LoadByPrimaryKey(ord.RequestedBy);
if (_dvPickListMakeup == null || ValidatePickList())
{
return;
}
// First of all .. print the pick list
var pls = new PickList();
PrintPickList(ord, rus);
MyGeneration.dOOdads.TransactionMgr mgr = MyGeneration.dOOdads.TransactionMgr.ThreadTransactionMgr();
try
{
mgr.BeginTransaction();
pls.SavePickList(_orderID, _dvPickListMakeup, CurrentContext.UserId);
mgr.CommitTransaction();
BindApprovedOrders();
this.LogActivity("Print-Pick-List", ord.ID);
XtraMessageBox.Show("Your pick list has been saved! please continue to the next step or prepare another Picklist here.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception exp)
{
mgr.RollbackTransaction();
ViewHelper.ShowErrorMessage("System couldn't save the Pick List, Please contact administrator for additional help", exp);
ErrorHandler.Handle(exp);
}
}
private void OnUndispatchedIssueClicked(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
var dr = gridUndispatchedIssuesView.GetFocusedDataRow();
_activeSTVID = Convert.ToInt32(dr["STVID"]);
gridUndispatchedIssueDetails.DataSource = BLL.Issue.GetIssueDetails(_activeSTVID);
User usr = new User();
//usr.LoadByPrimaryKey(NewMainWindow.UserId);
usr = CurrentContext.LoggedInUser;
BLL.Issue stv = new BLL.Issue();
stv.LoadByPrimaryKey(_activeSTVID);
var activity = new Activity();
activity.LoadByPrimaryKey(stv.StoreID);
lblMode.Text = activity.ModeName ?? "-";
lblAccount.Text = activity.AccountName ?? "-";
lblActivity.Text = activity.FullActivityName ?? "-";
lblSubAccount.Text = activity.SubAccountName ?? "-";
lblIssueStatus.Text = (string)dr["OrderStatus"] ?? "-";
lblIssueType.Text = (string)dr["OrderType"] ?? "-";
if (!stv.IsColumnNull("ReceivingUnitID"))
{
var institution = new Institution();
institution.LoadByPrimaryKey(stv.ReceivingUnitID);
var ownership = new BLL.OwnershipType();
ownership.LoadByPrimaryKey(institution.Ownership);
lblRegion.Text = institution.RegionName ?? "-";
lblZone.Text = institution.ZoneName ?? "-";
lblWoreda.Text = institution.WoredaName ?? "-";
var space = "";
int length = (institution.Name).Length;
if (stv.IsColumnNull("IsReprintOf"))
{
FacilityGroup.Text = institution.Name ?? "" + space.PadRight(180 - length) + "Invoice No: " + stv.IDPrinted.ToString("00000");
}
lblInstitutionType.Text = institution.InstitutionTypeName;
lblOwnership.Text = ownership.Name;
}
else
{
lblRegion.Text =
lblZone.Text = lblWoreda.Text = "NA";
lblInstitutionType.Text = lblOwnership.Text = "-";
FacilityGroup.Text = "";
}
if (!stv.IsColumnNull("PaymentTypeID"))
{
var paymentType = new BLL.PaymentType();
paymentType.LoadByPrimaryKey(stv.PaymentTypeID);
lblPaymentType.Text = paymentType.Name;
}
else
{
lblPaymentType.Text = "-";
}
if (!stv.IsColumnNull("DocumentTypeID"))
{
lblDocumentedType.Text = DocumentType.GetDocumentType(stv.DocumentTypeID).Name;
}
else
{
lblDocumentedType.Text = "-";
}
lblRequistedDate.Text = dr["VoidRequestDateTime"] == DBNull.Value
? "NA"
: DateTime.Parse(dr["VoidRequestDateTime"].ToString()).ToShortDateString();
lblVoidRequestedBy.Text = dr["VoidRequestedBy"] == DBNull.Value ? "NA" : (string)dr["VoidRequestedBy"];
var user = new BLL.User();
if (dr["VoidApprovedByUserID"] != DBNull.Value)
{
user.LoadByPrimaryKey(Convert.ToInt32(dr["VoidApprovedByUserID"]));
lblVoidConfirmedBy.Text = user.FullName;
}
else
{
lblVoidConfirmedBy.Text = "NA";
}
lblVoidConfirmedDate.Text = dr["VoidApprovalDateTime"] == DBNull.Value
? "NA"
: DateTime.Parse(dr["VoidApprovalDateTime"].ToString()).ToShortDateString();
stv.LoadLatestReprint();
txtIssuedBy.Text = usr.FullName ?? "-";
lblDispatchConfirmedBy.Text = usr.FullName ?? "-";
// txtSTVInvoiceNo.Text = stv.IDPrinted.ToString("00000");
lblSTVNo.Text = stv.IDPrinted.ToString("00000") ?? "-";
lblSTVDate.Text = stv.PrintedDate.ToShortDateString() ?? "-";
user.LoadByPrimaryKey(stv.UserID);
lblSTVPrintedBy.Text = user.FullName ?? "-";
txtPreprintedInvoiceNo.Text = stv.IsColumnNull("PrePrintedInvoiceNo") ? "" : stv.PrePrintedInvoiceNo.ToString();
}
private void OnApprovedOrderRowClicked(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
var gv = (GridView)sender;
var dr = gv.GetFocusedDataRow();
var or = new BLL.Order();
_orderID = Convert.ToInt32(gv.GetFocusedDataRow()["ID"].ToString());
order.LoadByPrimaryKey(_orderID);
// populate the general order variables
txtPickListFromStore.Text = order.GetFromStore();
lblMode.Text = order.GetFromStore();
txtPickListRequestedBy.Text = order.GetFilledBy();
if (!order.IsColumnNull("RequestedBy"))
{
var ins = new Institution();
ins.LoadByPrimaryKey(order.RequestedBy);
var ownership = new BLL.OwnershipType();
ownership.LoadByPrimaryKey(ins.Ownership);
lblOwnership.Text = ownership.Name;
lblInstitutionType.Text = ins.InstitutionTypeName;
lblFacility.Text = ins.Name;
lblWoreda.Text = ins.WoredaName;
lblZone.Text = ins.ZoneName;
lblRegion.Text = ins.RegionName;
lblLetterNum.Text = String.IsNullOrEmpty(order.LetterNo) ? "-" : order.LetterNo;
}
else
{
lblFacility.Text = lblWoreda.Text = lblZone.Text = lblRegion.Text = lblOwnership.Text = "";// lblType.Text = "";
}
int length = order.GetRequestedBy().Length;
string s = "";
HeaderLayoutGroup.Text = order.GetRequestedBy() + s.PadRight(150 - length) + "Order Number:" + order.RefNo;
txtPickListOrderNumber.Text = order.RefNo;
lblOrderNum.Text = order.RefNo;
txtPickListApprovedBy.Text = order.GetApprovedBy();
lblApprovedBy.Text = order.GetApprovedBy();
var orderDetail = new OrderDetail();
orderDetail.LoadAllByOrderID(order.ID);
if (!orderDetail.IsColumnNull("StoreID"))
{
var activity = new Activity();
activity.LoadByPrimaryKey(orderDetail.StoreID);
lblMode.Text = activity.ModeName;
}
lblOrderDate.Text = order.Date.ToShortDateString();
var us = new BLL.User();
us.LoadByPrimaryKey(order.FilledBy);
lblFilledBy.Text = us.FirstName;
lblIssueStatus.Text = (string)dr["OrderStatus"] ?? "-";
lblIssueType.Text = (string)dr["Description"] ?? "-";
var paymentType = new BLL.PaymentType();
paymentType.LoadByPrimaryKey(order.PaymentTypeID);
lblPaymentType.Text = paymentType.Name;
if (order.OrderStatusID == OrderStatus.Constant.ORDER_APPROVED)
{
progressBarControl.Properties.Maximum = order.CountOfDetailItems();
progressBarControl.Properties.DisplayFormat.FormatString = "{0: #,##0}" + string.Format(" of {0}", progressBarControl.Properties.Maximum);
progressBarControl.Properties.DisplayFormat.FormatType = FormatType.Custom;
progressBarControl.EditValue = 0;
this.Enabled = false;
progressBarControl.Visible = true;
bgWorker.RunWorkerAsync(_orderID);
}
}
