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