private void BindFormElements() { //Bind the Region Lookup (Zone and Woredas will be bind after selection Region) lkRegion.Properties.DataSource = BLL.Region.GetAllRegions().DefaultView; lkRegion.EditValue = regionId; //Bind the Receiving units Types Lookup InstitutionType institutionsTypes = new InstitutionType(); institutionsTypes.LoadAll(); institutionsTypes.Sort = "Name ASC"; lkType.Properties.DataSource = institutionsTypes.DefaultView; lkType.EditValue = ruType; //Bind the Ownership Type Lookup OwnershipType ownershipTypes = new OwnershipType(); ownershipTypes.LoadAll(); ownershipTypes.Sort = "Name ASC"; lkOwnership.Properties.DataSource = ownershipTypes.DefaultView; lkOwnership.EditValue = OwnershipType.Constants.Public; //Bind the Active lookup lkActive.Properties.ValueMember = lkActive.Properties.DisplayMember = "Column"; lkActive.Properties.DataSource = new string[3] { "All", "Active", "InActive" }; lkActive.ItemIndex = 0; //Bind the others LoadZones(); lkZone.EditValue = zoneID; LoadWoredas(); lkWoreda.EditValue = woredaID; LoadReceivingUnits(); }
/// <summary> /// Gets the ownership type by region and number RU. /// </summary> /// <param name="WoredaID">The woreda ID.</param> /// <returns></returns> public static DataTable GetOwnershipTypeByRegionAndNumberRU(int WoredaID) { OwnershipType ownershipType = new OwnershipType(); string query = HCMIS.Repository.Queries.OwnershipType.SelectGetOwnershipTypeByRegionAndNumberRU(WoredaID); ownershipType.LoadFromRawSql(query); return ownershipType.DataTable; }
/// <summary> /// Gets the ownership type by region and number RU. /// </summary> /// <param name="WoredaID">The woreda ID.</param> /// <returns></returns> public static DataTable GetOwnershipTypeByRegionAndNumberRU(int WoredaID) { OwnershipType ownershipType = new OwnershipType(); string query = HCMIS.Repository.Queries.OwnershipType.SelectGetOwnershipTypeByRegionAndNumberRU(WoredaID); ownershipType.LoadFromRawSql(query); return(ownershipType.DataTable); }
/// <summary> /// Gets the ownership type by region and number RU. /// </summary> /// <param name="receivingUnitTypeID">The receiving unit type ID.</param> /// <param name="storeID">The store ID.</param> /// <param name="hasBeenIssuedTo">if set to <c>true</c> [has been issued to].</param> /// <returns></returns> public static DataTable GetOwnershipTypeByRegionAndNumberRU(int receivingUnitTypeID, int storeID, bool hasBeenIssuedTo) { OwnershipType ownershipType = new OwnershipType(); string query = ""; query = HCMIS.Repository.Queries.OwnershipType.SelectGetOwnershipTypeByRegionAndNumberRU(receivingUnitTypeID, storeID); ownershipType.LoadFromRawSql(query); return ownershipType.DataTable; }
/// <summary> /// Gets the ownership type by region and number RU. /// </summary> /// <param name="receivingUnitTypeID">The receiving unit type ID.</param> /// <param name="storeID">The store ID.</param> /// <param name="hasBeenIssuedTo">if set to <c>true</c> [has been issued to].</param> /// <returns></returns> public static DataTable GetOwnershipTypeByRegionAndNumberRU(int receivingUnitTypeID, int storeID, bool hasBeenIssuedTo) { OwnershipType ownershipType = new OwnershipType(); string query = ""; query = HCMIS.Repository.Queries.OwnershipType.SelectGetOwnershipTypeByRegionAndNumberRU(receivingUnitTypeID, storeID); ownershipType.LoadFromRawSql(query); return(ownershipType.DataTable); }
private void gridItemsView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { DataRow dr = gridItemsView.GetFocusedDataRow(); lblIssueType.Text = dr["OrderType"]!=DBNull.Value ? (string) dr["OrderType"] : "-"; if ((dr["ReceivingUnitID"]) != DBNull.Value) { var ins = new Institution(); ins.LoadByPrimaryKey(Convert.ToInt32(dr["ReceivingUnitID"])); lblRegion.Text = ins.RegionName ?? "-"; lblWoreda.Text = ins.WoredaName ?? "-"; lblZone.Text = ins.ZoneName ?? "-"; var own = new OwnershipType(); own.LoadByPrimaryKey(ins.Ownership); lblOwnership.Text = own.Name ?? "-"; var iss = new Issue(); iss.LoadByPrimaryKey(Convert.ToInt32(dr["STVID"])); if (!iss.IsColumnNull("PaymentTypeID")) { var pType = new PaymentType(); pType.LoadByPrimaryKey(iss.PaymentTypeID); lblPaymentType.Text = pType.Name; } lblPaymentType.Text = "-"; if (!iss.IsColumnNull("VoidRequestDateTime")) lblVoidRequestedDate.Text = iss.VoidRequestDateTime.ToShortDateString(); else { lblVoidRequestedDate.Text = "-"; } if(!iss.IsColumnNull("VoidApprovalDateTime")) lblVoidConfirmedDate.Text= iss.VoidApprovalDateTime.ToShortDateString(); else { lblVoidConfirmedDate.Text = "-"; } var user = new User(); if (!iss.IsColumnNull("VoidRequestUserID")) { user.LoadByPrimaryKey(iss.VoidRequestUserID); lblVoidRequestedBy.Text = user.FullName; } else lblVoidRequestedBy.Text = "-"; if (!iss.IsColumnNull("VoidApprovedByUserID")) { user.LoadByPrimaryKey(iss.VoidApprovedByUserID); lblVoidConfirmedBy.Text = user.FullName; } else lblVoidConfirmedBy.Text = "-"; lblInstitutionType.Text = ins.InstitutionTypeName; if (!iss.IsColumnNull("DocumentTypeID")) { lblDocumentType.Text = DocumentType.GetDocumentType(iss.DocumentTypeID).Name; } else lblDocumentType.Text = ""; } else { lblRegion.Text = lblWoreda.Text = lblZone.Text = "-"; } lblPrintedDate.Text = string.IsNullOrEmpty((Convert.ToDateTime(dr["PrintedDate"].ToString())).ToShortDateString()) ? "-" : (Convert.ToDateTime(dr["PrintedDate"].ToString())).ToShortDateString(); lblAccount.Text = string.IsNullOrEmpty(dr["AccountName"].ToString()) ? "-" : dr["AccountName"].ToString(); lblSubAccount.Text = string.IsNullOrEmpty(dr["SubAccountName"].ToString()) ? "-" : dr["SubAccountName"].ToString(); lblActivity.Text = string.IsNullOrEmpty(dr["ActivityName"].ToString()) ? "-" : dr["ActivityName"].ToString(); lblPrintedBy.Text = string.IsNullOrEmpty(dr["IssuedBy"].ToString()) ? "-" : dr["IssuedBy"].ToString(); lblIssueStatus.Text = string.IsNullOrEmpty(dr["Status"].ToString()) ? "-" : dr["Status"].ToString(); int accountid = Convert.ToInt32(dr["AccountID"]); Account account = new Account(); account.LoadByPrimaryKey(accountid); Mode mode = new Mode(); mode.LoadByPrimaryKey(account.ModeID); lblMode.Text = mode.TypeName; }
/// <summary> /// Handles the FocusedRowChanged event of the gridViewReferences control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs" /> instance containing the event data.</param> private void gridViewReferences_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (e != null && e.PrevFocusedRowHandle < -1) return; dtDate.Value = DateTimeHelper.ServerDateTime; _reprintId = null; DataRow dr = gridViewReferences.GetFocusedDataRow(); if (dr == null) { return; } string[] referenceNo = new string[2]; referenceNo[0] = dr["RefNo"].ToString(); if (Convert.ToBoolean(dr["isConvertedDN"])) { _isConvertedDn = true; _stvLogIdChosen = (int?)dr["IsReprintOf"]; } else if (dr != null && dr["ID"] != DBNull.Value) { _isConvertedDn = false; _stvLogIdChosen = (int?)dr["ID"]; } UpdateReprintedNumbers(dr); // Enable and disable STV reprint // STV SHouldn't be reprinted off a reprint. if (dr["IsReprintOf"] != DBNull.Value && !Convert.ToBoolean(dr["isConvertedDN"])) { btnExport.Enabled = btnReprint.Enabled = false; var permission = (BLL.Settings.UseNewUserManagement) ? this.HasPermission("Print") : true; btnPrint.Enabled = permission; _reprintId = _stvLogIdChosen; _stvLogIdChosen = Convert.ToInt32(dr["IsReprintOf"]); } else if (dr["IsDeliveryNote"] != DBNull.Value && Convert.ToBoolean(dr["IsDeliveryNote"])) { btnExport.Enabled = false; btnReprint.Enabled = (BLL.Settings.UseNewUserManagement) ? this.HasPermission("Re-Print") : true; btnPrint.Enabled = false; } else { btnPrint.Enabled = this.HasPermission("Print"); btnReprint.Enabled = this.HasPermission("Re-Print"); btnExport.Enabled = this.HasPermission("Export"); } if (_stvLogIdChosen != null) { Issue log = new Issue(); log.LoadByPrimaryKey(_stvLogIdChosen.Value); Institution rus = new Institution(); IssueDoc iss = new IssueDoc(); if (!log.IsColumnNull("ReceivingUnitID")) { rus.LoadByPrimaryKey(log.ReceivingUnitID); //FacilityName.Text = rus.Name; HeaderSection.Text = rus.Name; var activity = new Activity(); activity.LoadByPrimaryKey(log.StoreID); lblActivity.Text = activity.Name; lblSubAccount.Text = activity.SubAccountName; lblMode.Text = activity.ModeName; lblAccount.Text = activity.AccountName; lblRegion.Text = rus.RegionName; lblWoreda.Text = rus.WoredaName; lblZone.Text = rus.ZoneName; lblInstType.Text = rus.InstitutionTypeName; var ownership = new OwnershipType(); ownership.LoadByPrimaryKey(rus.Ownership); lblOwnership.Text = ownership.Name; lblVoidConDate.Text = (dr["approvalDate"]) != DBNull.Value ? Convert.ToDateTime(dr["approvalDate"]).ToShortDateString(): "-"; lblIssueType.Text = (string)dr["OrderType"]; User user = new User(); if (dr["approvedBy"] != DBNull.Value) { user.LoadByPrimaryKey(Convert.ToInt32(dr["approvedBy"])); lblConfirmedBy.Text = user.FullName; } else { lblConfirmedBy.Text = "-"; } var doc = new DocumentType(); doc.LoadByPrimaryKey(log.DocumentTypeID); lblDocType.Text = doc.Name; lblPrintedDate.Text = log.PrintedDate.ToShortDateString(); var pt = new PaymentType(); if (!rus.IsColumnNull("PaymentTypeID")) { pt.LoadByPrimaryKey(rus.PaymentTypeID); lblPaymentType.Text = pt.Name; } else { lblPaymentType.Text = "-"; } // Show user name user.LoadByPrimaryKey(log.UserID); lblPrintedBy.Text = (user.FullName == "") ? user.UserName : user.FullName; // show contact person PickList pl = new PickList(); pl.LoadByPrimaryKey(log.PickListID); Order order = new Order(); order.LoadByPrimaryKey(pl.OrderID); var os = new OrderStatus(); os.LoadByPrimaryKey(order.OrderStatusID); lblIssueStatus.Text = os.OrderStatus; if (!order.IsColumnNull("ContactPerson")) { lblRecivedBy.Text = order.ContactPerson; } else { lblRecivedBy.Text = @"-"; } lblReceivedDate.Text = order.EurDate.ToShortDateString(); } dtDate.Value = log.PrintedDate; //PrintedDate.Text = dtDate.Text; lblPrintedDate.Text = dtDate.Text; gridTransactions.DataSource = iss.GetIssueBySTV(_stvLogIdChosen.Value); layoutUnconfirmedSTVs.Visibility = LayoutVisibility.Never; if (BLL.Settings.ShowMissingSTVsOnIssueLog) { DataView view = iss.GetPossibleUnconfirmedIssues(_stvLogIdChosen.Value); if (view.Count > 0) { gridUnconfirmed.DataSource = view; layoutUnconfirmedSTVs.Visibility = LayoutVisibility.Always; } else { layoutUnconfirmedSTVs.Visibility = LayoutVisibility.Never; } } } }
private void LoadReceivingUnits() { BLL.Region reg = new BLL.Region(); reg.LoadAll(); lkRegion.Properties.DataSource = reg.DefaultView; BLL.InstitutionType ruType = new InstitutionType(); ruType.Where.IsActive.Value = 1; ruType.Query.Load(); lkRUType.Properties.DataSource = ruType.DefaultView; BLL.OwnershipType ownershipType = new OwnershipType(); ownershipType.LoadAll(); lkOwnership.Properties.DataSource = ownershipType.DefaultView; Route r = new Route(); r.LoadAll(); lkRoute.Properties.DataSource = r.DefaultView; }
/// <summary> /// Called when [outstanding picklist selected]. /// </summary> /// <param name="sender">The sender.</param> /// <param name="e">The <see cref="DevExpress.XtraGrid.Views.Grid.RowClickEventArgs" /> instance containing the event data.</param> private void OnOutstandingPicklistSelected(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { var dr = gridOutstandingPickListView.GetFocusedDataRow(); _orderID = Convert.ToInt32(dr["ID"]); var order = new BLL.Order(); order.LoadByPrimaryKey(_orderID); // load payment type options int?requestedBy = null; var usr = new User(); lblIssueStatus.Text = (string)dr["OrderStatus"]; lblIssueTypes.Text = (string)dr["Description"]; if (!order.IsColumnNull("RequestedBy")) { var ins = new Institution(); requestedBy = order.RequestedBy; lkPaymentType.Properties.DataSource = PaymentType.GetAllowedTypes(order.FromStore, requestedBy); ins.LoadByPrimaryKey(order.RequestedBy); try { lblWoreda.Text = ins.WoredaName ?? "-"; lblRegion.Text = ins.RegionName ?? "-"; lblZone.Text = ins.ZoneName ?? "-"; lblInstitutionType.Text = ins.InstitutionTypeName ?? "-"; var ownership = new BLL.OwnershipType(); if (!ins.IsColumnNull("Ownership")) { ownership.LoadByPrimaryKey(ins.Ownership); lblOwnership.Text = ownership.Name; } } catch (NullReferenceException ex) { //when transfer, institution has no woreda, zone or region, ignore the error } } else { lblWoreda.Text = lblRegion.Text = lblZone.Text = lblInstitutionType.Text = lblOwnership.Text = "NA"; } //usr.LoadByPrimaryKey(NewMainWindow.UserId); usr = CurrentContext.LoggedInUser; txtIssuedBy.Text = usr.FullName ?? "-"; PickList pl = new PickList(); _dvOutstandingPickList = pl.GetPickListDetailsForOrder(_orderID, CurrentContext.LoggedInUserName); gridOutstandingPicklistDetail.DataSource = _dvOutstandingPickList; if (order.FromStore != Mode.Constants.HEALTH_PROGRAM) { colSKUPicked.Visible = false; } else { colSKUPicked.Visible = true; } txtConfirmFromStore.Text = order.GetFromStore(); txtConfirmRequestedBy.Text = order.GetRequestedBy(); int length = order.GetRequestedBy().Length; string s = ""; HeaderSection.Text = order.GetRequestedBy() + s.PadRight(150 - length) + "Order Number: " + order.RefNo; txtConfirmOrderNumber.Text = order.RefNo; //txtConfirmApprovedBy.Text = order.GetApprovedBy() ?? "-"; lblApprovedBy.Text = order.GetApprovedBy() ?? "-"; lkPaymentType.EditValue = order.PaymentTypeID; // Temporarily copy the STV txtIssueRefNo.Text = order.RefNo; //""; lblRefNo.Text = order.RefNo ?? "-"; var paymentType = new BLL.PaymentType(); paymentType.LoadByPrimaryKey(order.PaymentTypeID); lblPaymentType.Text = paymentType.Name ?? "-"; lblMode.Text = order.GetFromStore() ?? "-"; lblissuedDate.Text = order.Date.ToShortDateString(); lblIssuedBy.Text = order.GetFilledBy(); lblPicklistPrintedDate.Text = pl.PickedDate.ToShortDateString() != "" ? pl.PickedDate.ToShortDateString() : "-"; var us = new User(); pl.LoadByOrderID(_orderID); if (!pl.IsColumnNull("PickedBy")) { us.LoadByPrimaryKey(pl.PickedBy); lblPicklistConfirmedBy.Text = us.FullName; } else { lblPicklistConfirmedBy.Text = "-"; } }
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 gridRequisitionListView_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e) { if (e != null && e.PrevFocusedRowHandle < -1) return; try { DataRow dr = gridRequisitionListView.GetFocusedDataRow(); if (dr == null) return; int orderID = Convert.ToInt32(dr["ID"]); gridRequisitionDetails.DataSource = Order.GetRequisitionDetails(orderID); //lblOrderStatus.Text = Order.GetOrderStatus(orderID); BLL.Order order = new BLL.Order(); order.LoadByPrimaryKey(orderID); Institution ins = new Institution(); ins.LoadByPrimaryKey(order.RequestedBy); lblWoreda.Text = ins.WoredaName; lblZone.Text = ins.ZoneName; lblRegion.Text = ins.RegionName; lblRequestedDate.Text = order.EurDate.ToShortDateString(); lblRequestedBy.Text = order.GetFilledBy(); OrderStatus os = new OrderStatus(); os.LoadByPrimaryKey(order.OrderStatusID); lblStatus.Text = os.OrderStatus; int length = order.GetRequestedBy().Length; string s = ""; headerSection.Text = order.GetRequestedBy() + s.PadRight(200 - length) + "Order Number: " + order.RefNo; var ownership = new BLL.OwnershipType(); ownership.LoadByPrimaryKey(ins.Ownership); lblOwnership.Text = ownership.Name; var paymentType = new BLL.PaymentType(); paymentType.LoadByPrimaryKey(order.PaymentTypeID); lblPaymentType.Text = paymentType.Name; lblMode.Text = order.GetFromStore(); DataRow facilityHis = BLL.Issue.GetVisitHistoryForFacility(Convert.ToInt32(dr["InstitutionID"])); if (facilityHis != null) { lblLastVisit.Text = Convert.ToDateTime(facilityHis["LastVisit"]).TimeAgo() ?? "-"; lblNoOfReq.Text = Convert.ToString(facilityHis["VisitCount"]) ?? "-"; lblIssueType.Text = Convert.ToString(facilityHis["Description"]) ?? "-"; } else { lblLastVisit.Text = lblNoOfReq.Text = lblIssueType.Text = "-"; } } catch (NullReferenceException ex) { MessageBox.Show(ex.Message); } }
private void OnApprovedOrderRowClicked(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { if (e != null && e.RowHandle < -1) { return; } var gv = (GridView)sender; var dr = gv.GetFocusedDataRow(); _orderID = Convert.ToInt32(dr["ID"].ToString()); order.LoadByPrimaryKey(_orderID); // populate the general order variables txtPickListFromStore.Text = order.GetFromStore(); lblMode.Text = order.GetFromStore() ?? "-"; txtPickListRequestedBy.Text = order.GetRequestedBy(); labelControl9.Text = order.GetRequestedBy() ?? "-"; var us = new BLL.User(); us.LoadByPrimaryKey(order.FilledBy); lblFilledBy.Text = us.FullName ?? "-"; string s = ""; lblLetterNum.Text = String.IsNullOrEmpty(order.LetterNo) ? "-" : order.LetterNo; var orderDetail = new OrderDetail(); orderDetail.LoadAllByOrderID(order.ID); var paymentType = new BLL.PaymentType(); paymentType.LoadByPrimaryKey(order.PaymentTypeID); if (!orderDetail.IsColumnNull("StoreID")) { var activity = new Activity(); activity.LoadByPrimaryKey(orderDetail.StoreID); lblMode.Text = activity.ModeName ?? "-"; } lblIssueStatus.Text = (string)dr["OrderStatus"] ?? "-"; lblIssueType.Text = (string)dr["Description"] ?? "-"; if (!order.IsColumnNull("RequestedBy")) { var ins = new Institution(); ins.LoadByPrimaryKey(order.RequestedBy); var ownership = new BLL.OwnershipType(); ownership.LoadByPrimaryKey(ins.Ownership); int length = ins.Name.Length; HeaderSection.Text = ins.Name + s.PadRight(150 - length) + "Order Number: " + order.RefNo; lblOwnership.Text = ownership.Name ?? "-"; lblZone.Text = ins.ZoneName ?? "-"; lblWoreda.Text = ins.WoredaName ?? "-"; lblRegion.Text = ins.RegionName ?? "-"; lblInstitutionType.Text = ins.InstitutionTypeName ?? "-"; } else { HeaderSection.Text = lblOwnership.Text = lblZone.Text = lblWoreda.Text = lblRegion.Text = lblInstitutionType.Text = "-"; } lblPaymentType.Text = paymentType.Name; lblOrderDate.Text = order.Date.ToShortDateString(); txtPickListOrderNumber.Text = order.RefNo; labelControl12.Text = order.RefNo; txtPickListApprovedBy.Text = order.GetApprovedBy(); labelControl13.Text = order.GetApprovedBy(); if (order.OrderStatusID == OrderStatus.Constant.PICK_LIST_GENERATED) { PickList pl = new PickList(); gridPickListDetail.DataSource = pl.GetPickListDetailsForOrder(_orderID); btnPrintAndSavePickList.Text = @"Confirm"; colPrice.FieldName = "Cost"; colSKU.FieldName = "Packs"; btnCancelPickList.Enabled = (BLL.Settings.UseNewUserManagement)? this.HasPermission("Cancel-Pick-List"):true; pl.LoadByOrderID(_orderID); if (!pl.IsColumnNull("PickedBy")) { us.LoadByPrimaryKey(pl.PickedBy); lblPicklistPrintedBy.Text = us.FullName; } else { lblPicklistPrintedBy.Text = "-"; } lblPicklistPrintedDate.Text = !pl.IsColumnNull("SavedDate") ? pl.SavedDate.ToShortDateString() : "-"; lblPicklistNo.Text = !pl.IsColumnNull("PrintedID") ? pl.PrintedID.ToString() : "-"; } //gridPickListView.EndSummaryUpdate(); }
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); } }
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 gridRequisitionListView_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e) { if (e != null && e.PrevFocusedRowHandle < -1) { return; } try { DataRow dr = gridRequisitionListView.GetFocusedDataRow(); if (dr == null) { return; } int orderID = Convert.ToInt32(dr["ID"]); gridRequisitionDetails.DataSource = Order.GetRequisitionDetails(orderID); //lblOrderStatus.Text = Order.GetOrderStatus(orderID); BLL.Order order = new BLL.Order(); order.LoadByPrimaryKey(orderID); Institution ins = new Institution(); ins.LoadByPrimaryKey(order.RequestedBy); lblWoreda.Text = ins.WoredaName; lblZone.Text = ins.ZoneName; lblRegion.Text = ins.RegionName; lblRequestedDate.Text = order.EurDate.ToShortDateString(); lblRequestedBy.Text = order.GetFilledBy(); OrderStatus os = new OrderStatus(); os.LoadByPrimaryKey(order.OrderStatusID); lblStatus.Text = os.OrderStatus; int length = order.GetRequestedBy().Length; string s = ""; headerSection.Text = order.GetRequestedBy() + s.PadRight(200 - length) + "Order Number: " + order.RefNo; var ownership = new BLL.OwnershipType(); ownership.LoadByPrimaryKey(ins.Ownership); lblOwnership.Text = ownership.Name; var paymentType = new BLL.PaymentType(); paymentType.LoadByPrimaryKey(order.PaymentTypeID); lblPaymentType.Text = paymentType.Name; lblMode.Text = order.GetFromStore(); DataRow facilityHis = BLL.Issue.GetVisitHistoryForFacility(Convert.ToInt32(dr["InstitutionID"])); if (facilityHis != null) { lblLastVisit.Text = Convert.ToDateTime(facilityHis["LastVisit"]).TimeAgo() ?? "-"; lblNoOfReq.Text = Convert.ToString(facilityHis["VisitCount"]) ?? "-"; lblIssueType.Text = Convert.ToString(facilityHis["Description"]) ?? "-"; } else { lblLastVisit.Text = lblNoOfReq.Text = lblIssueType.Text = "-"; } } catch (NullReferenceException ex) { MessageBox.Show(ex.Message); } }
private void OnApprovedOrderRowClicked(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { if (e != null && e.RowHandle < -1) return; var gv = (GridView)sender; var dr = gv.GetFocusedDataRow(); _orderID = Convert.ToInt32(dr["ID"].ToString()); order.LoadByPrimaryKey(_orderID); // populate the general order variables txtPickListFromStore.Text = order.GetFromStore(); lblMode.Text = order.GetFromStore() ?? "-"; txtPickListRequestedBy.Text = order.GetRequestedBy(); labelControl9.Text = order.GetRequestedBy() ?? "-"; var us = new BLL.User(); us.LoadByPrimaryKey(order.FilledBy); lblFilledBy.Text = us.FullName ?? "-"; string s = ""; lblLetterNum.Text = String.IsNullOrEmpty(order.LetterNo) ? "-" : order.LetterNo; var orderDetail = new OrderDetail(); orderDetail.LoadAllByOrderID(order.ID); var paymentType = new BLL.PaymentType(); paymentType.LoadByPrimaryKey(order.PaymentTypeID); if (!orderDetail.IsColumnNull("StoreID")) { var activity = new Activity(); activity.LoadByPrimaryKey(orderDetail.StoreID); lblMode.Text = activity.ModeName ?? "-"; } lblIssueStatus.Text = (string)dr["OrderStatus"] ?? "-"; lblIssueType.Text = (string)dr["Description"] ?? "-"; if (!order.IsColumnNull("RequestedBy")) { var ins = new Institution(); ins.LoadByPrimaryKey(order.RequestedBy); var ownership = new BLL.OwnershipType(); ownership.LoadByPrimaryKey(ins.Ownership); int length = ins.Name.Length; HeaderSection.Text = ins.Name + s.PadRight(150 - length) + "Order Number: " + order.RefNo; lblOwnership.Text = ownership.Name ?? "-"; lblZone.Text = ins.ZoneName ?? "-"; lblWoreda.Text = ins.WoredaName ?? "-"; lblRegion.Text = ins.RegionName ?? "-"; lblInstitutionType.Text = ins.InstitutionTypeName ?? "-"; } else { HeaderSection.Text =lblOwnership.Text = lblZone.Text =lblWoreda.Text =lblRegion.Text = lblInstitutionType.Text = "-"; } lblPaymentType.Text = paymentType.Name; lblOrderDate.Text = order.Date.ToShortDateString(); txtPickListOrderNumber.Text = order.RefNo; labelControl12.Text = order.RefNo; txtPickListApprovedBy.Text = order.GetApprovedBy(); labelControl13.Text = order.GetApprovedBy(); if (order.OrderStatusID == OrderStatus.Constant.PICK_LIST_GENERATED) { PickList pl = new PickList(); gridPickListDetail.DataSource = pl.GetPickListDetailsForOrder(_orderID); btnPrintAndSavePickList.Text = @"Confirm"; colPrice.FieldName = "Cost"; colSKU.FieldName = "Packs"; btnCancelPickList.Enabled = (BLL.Settings.UseNewUserManagement)? this.HasPermission("Cancel-Pick-List"):true; pl.LoadByOrderID(_orderID); if (!pl.IsColumnNull("PickedBy")) { us.LoadByPrimaryKey(pl.PickedBy); lblPicklistPrintedBy.Text = us.FullName; } else lblPicklistPrintedBy.Text = "-"; lblPicklistPrintedDate.Text = !pl.IsColumnNull("SavedDate") ? pl.SavedDate.ToShortDateString() : "-"; lblPicklistNo.Text = !pl.IsColumnNull("PrintedID") ? pl.PrintedID.ToString() : "-"; } //gridPickListView.EndSummaryUpdate(); }
/// <summary> /// Called when [outstanding picklist selected]. /// </summary> /// <param name="sender">The sender.</param> /// <param name="e">The <see cref="DevExpress.XtraGrid.Views.Grid.RowClickEventArgs" /> instance containing the event data.</param> private void OnOutstandingPicklistSelected(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { var dr = gridOutstandingPickListView.GetFocusedDataRow(); _orderID = Convert.ToInt32(dr["ID"]); var order = new BLL.Order(); order.LoadByPrimaryKey(_orderID); // load payment type options int? requestedBy = null; var usr = new User(); lblIssueStatus.Text = (string)dr["OrderStatus"]; lblIssueTypes.Text = (string) dr["Description"]; if (!order.IsColumnNull("RequestedBy")) { var ins = new Institution(); requestedBy = order.RequestedBy; lkPaymentType.Properties.DataSource = PaymentType.GetAllowedTypes(order.FromStore, requestedBy); ins.LoadByPrimaryKey(order.RequestedBy); try { lblWoreda.Text = ins.WoredaName ?? "-"; lblRegion.Text = ins.RegionName ?? "-"; lblZone.Text = ins.ZoneName ?? "-"; lblInstitutionType.Text = ins.InstitutionTypeName ?? "-"; var ownership = new BLL.OwnershipType(); if (!ins.IsColumnNull("Ownership")) { ownership.LoadByPrimaryKey(ins.Ownership); lblOwnership.Text = ownership.Name; } } catch (NullReferenceException ex) { //when transfer, institution has no woreda, zone or region, ignore the error } } else lblWoreda.Text = lblRegion.Text = lblZone.Text = lblInstitutionType.Text = lblOwnership.Text = "NA"; //usr.LoadByPrimaryKey(NewMainWindow.UserId); usr = CurrentContext.LoggedInUser; txtIssuedBy.Text = usr.FullName ?? "-"; PickList pl = new PickList(); _dvOutstandingPickList = pl.GetPickListDetailsForOrder(_orderID, CurrentContext.LoggedInUserName); gridOutstandingPicklistDetail.DataSource = _dvOutstandingPickList; if (order.FromStore != Mode.Constants.HEALTH_PROGRAM) { colSKUPicked.Visible = false; } else { colSKUPicked.Visible = true; } txtConfirmFromStore.Text = order.GetFromStore(); txtConfirmRequestedBy.Text = order.GetRequestedBy(); int length = order.GetRequestedBy().Length; string s = ""; HeaderSection.Text = order.GetRequestedBy() + s.PadRight(150-length)+"Order Number: " + order.RefNo; txtConfirmOrderNumber.Text = order.RefNo; //txtConfirmApprovedBy.Text = order.GetApprovedBy() ?? "-"; lblApprovedBy.Text = order.GetApprovedBy() ?? "-"; lkPaymentType.EditValue = order.PaymentTypeID; // Temporarily copy the STV txtIssueRefNo.Text = order.RefNo; //""; lblRefNo.Text = order.RefNo ?? "-"; var paymentType = new BLL.PaymentType(); paymentType.LoadByPrimaryKey(order.PaymentTypeID); lblPaymentType.Text = paymentType.Name ?? "-"; lblMode.Text = order.GetFromStore() ?? "-"; lblissuedDate.Text = order.Date.ToShortDateString(); lblIssuedBy.Text = order.GetFilledBy(); lblPicklistPrintedDate.Text = pl.PickedDate.ToShortDateString()!="" ? pl.PickedDate.ToShortDateString() : "-"; var us = new User(); pl.LoadByOrderID(_orderID); if (!pl.IsColumnNull("PickedBy")) { us.LoadByPrimaryKey(pl.PickedBy); lblPicklistConfirmedBy.Text = us.FullName; } else lblPicklistConfirmedBy.Text = "-"; }