private void OrderForm_Load(object sender, EventArgs e) { LayoutAndBindingByAccess(); gridOrder.DataSource = PO.GetOrderForSelection(CurrentContext.UserId, null); LoadDecimalFormatings(); gridLkEditOrderType.Properties.DataSource = POType.GetAllPOTypes(); }
public static string GetDesc(this POType Type) { switch (Type) { case POType.Normal: return(QueryModelResource.POType_Normal); case POType.Return: return(QueryModelResource.POType_Return); case POType.HistoryReturn: return(QueryModelResource.POType_HistoryReturn); case POType.AdjustPrice: return(QueryModelResource.POType_AdjustPrice); default: return(""); } }
private void PODialog_Load(object sender, EventArgs e) { //lookups var poTypes = BLL.Settings.IsCenter ? POType.GetAllPOTypes() : POType.GetAllPOTypesForHub(); var defaultPOTypeID = poTypes != null && poTypes.Count > 0 ? poTypes.FirstOrDefault().ID:-1; //lookups gridLkEditOrderType.Properties.DataSource = poTypes; var suppliers = Supplier.GetSuppliersByPOType(defaultPOTypeID); lkSupplier.Properties.DataSource = suppliers.DefaultView; lkSupplier.EditValue = suppliers.Rows.Count > 0? Convert.ToInt32(suppliers.Rows[0]["ID"]):-1; if (!BLL.Settings.IsCenter) { lkTermOfPayement.Enabled = txtFreight.Enabled = txtTotalValue.Enabled = txtInsurance.Enabled = txtInsuredSum.Enabled = txtNBEServiceCharge.Enabled = false; gridLkEditOrderType.EditValue = POType.MANUAL_DELIVERYNOTE; } lkCurrencyLCID.Properties.DataSource = Helpers.FormattingHelpers.GetCurrencyList(); var etb = Convert.ToInt32(Helpers.FormattingHelpers.GetCurrencyList().ToTable().Select("Symbol = 'ETB'")[0]["ID"]); lkCurrencyLCID.EditValue = etb; //ETB is the default value grdLkEditAccounts.SetupActivityEditor().SetDefaultActivity(); lkTermOfPayement.Properties.DataSource = TermOfPayment.List; LoadDecimalFormatings(); txtExchangeRate.EditValue = 1; if (PoID != 0) { LoadPurchaseOrderForEdit(); } }
private HCMIS.Desktop.Reports.ReceiptConfirmationPrintout PrintReceiptConfirmation(int ReceiptID, int?reprintOfReceiptConfirmationPrintoutID) { ReceiptConfirmationPrintout rc = new ReceiptConfirmationPrintout(); HCMIS.Desktop.Reports.ReceiptConfirmationPrintout printout = new HCMIS.Desktop.Reports.ReceiptConfirmationPrintout(CurrentContext.LoggedInUserName); BLL.ReceiveDoc receiveDoc = new ReceiveDoc(); // receiveDoc.LoadByReferenceNo(reference); receiveDoc.LoadByReceiptID(ReceiptID); var activity = new Activity(); activity.LoadByPrimaryKey(receiveDoc.StoreID); BLL.Supplier supplier = new Supplier(); supplier.LoadByPrimaryKey(receiveDoc.SupplierID); BLL.Receipt receipt = new BLL.Receipt(); receipt.LoadByPrimaryKey(receiveDoc.ReceiptID); BLL.ReceiptInvoice receiptInvoice = new ReceiptInvoice(); receiptInvoice.LoadByPrimaryKey(receipt.ReceiptInvoiceID); BLL.PO po = new PO(); po.LoadByPrimaryKey(receiptInvoice.POID); BLL.POType poType = new POType(); poType.LoadByPrimaryKey(po.PurchaseType); int printedID = 0; string GRNFNo = FiscalYear.Current.GetCode(BLL.ReceiptConfirmationPrintout.GetGRNFNo(ReceiptID)); if (currentMode == Modes.GRVPrinting) //The GRVConfirmation is for reprinting { printout.BranchName.Text = GeneralInfo.Current.HospitalName; PrepareGRVPrintout(printout); // String reference = gridReceiveView.GetFocusedDataRow()["RefNo"].ToString(); if (poType.PurchaseOrderTypeCode == "LP") { printout.xrGRVLabel.Text = "GRV No."; } else { printout.xrGRVLabel.Text = "iGRV No."; } if (supplier.SupplierTypeID == SupplierType.CONSTANTS.HOME_OFFICE || supplier.SupplierTypeID == SupplierType.CONSTANTS.HUBS || supplier.SupplierTypeID == SupplierType.CONSTANTS.ACCOUNTS || supplier.SupplierTypeID == SupplierType.CONSTANTS.STORES) { //printout.xrGRVLabel.Text = "iGRV No."; printout.xrAir.Visible = false; printout.xrAirValue.Visible = false; printout.xrTransit.Visible = false; printout.xrTransitValue.Visible = false; printout.xrInsurance.Visible = false; printout.xrInsuranceValue.Visible = false; printout.xrNumberOfCases.Visible = false; printout.xrNumberOfCasesValue.Visible = false; printout.xrInvoiceNo.Text = "STV No."; printout.xrPurchaseOrderNo.Visible = false; printout.xrPurchaseOrderNoValue.Visible = false; printout.xrLabelGRNF.Text = GRNFNo; printout.xrSTV.Visible = false; printout.xrSTVNoValue.Visible = false; printedID = rc.PrepareDataForPrintout(ReceiptID, CurrentContext.UserId, false, 4, null, reprintOfReceiptConfirmationPrintoutID, FiscalYear.Current); printout.DataSource = rc.DefaultView.ToTable(); CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx(); //dtDate.CustomFormat = "dd/MM/yyyy"; dtDate.Value = receiveDoc.EurDate; printout.Date.Text = dtDate.Text; } else { // printout.xrGRVLabel.Text = "GRV No."; printout.xrSTV.Visible = false; printout.xrSTVNoValue.Visible = false; printedID = rc.PrepareDataForPrintout(ReceiptID, CurrentContext.UserId, false, 2, null, reprintOfReceiptConfirmationPrintoutID, FiscalYear.Current); printout.xrLabelGRNF.Text = GRNFNo; printout.DataSource = rc.DefaultView.ToTable(); CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx(); //dtDate.CustomFormat = "dd/MM/yyyy"; dtDate.Value = receiveDoc.EurDate; printout.Date.Text = dtDate.Text; } } printout.xrLabelStoreName.Text = activity.FullActivityName; if (ReceiveDoc.IsThereShortageOrDamage(ReceiptID)) { HCMIS.Desktop.Reports.ReceiptConfirmationShortagePrintout printoutShortage = PrintReceiptConfirmationForShortage(ReceiptID, printedID); if (currentMode == Modes.GRVPrinting) { PrepareGRVPrintout(printoutShortage); } printout.xrShortageReport.ReportSource = printoutShortage; printout.PrintingSystem.ContinuousPageNumbering = true; } else { printout.ReportFooter.Visible = false; } //Release Product CostCalculator GRV = new CostCalculator(); GRV.LoadGRV(ReceiptID); String reference = gridReceiveView.GetFocusedDataRow()["RefNo"].ToString(); BLL.ReceiveDoc recDoc = new ReceiveDoc(); recDoc.LoadByReceiptID(ReceiptID); recDoc.ConfirmGRVPrinted(CurrentContext.UserId); BLL.Receipt receiptStatus = new BLL.Receipt(); receiptStatus.LoadByPrimaryKey(ReceiptID); receiptStatus.ChangeStatus(ReceiptConfirmationStatus.Constants.GRV_PRINTED, null, this.GetFormIdentifier(), CurrentContext.UserId, "GRV Printed"); BindFormContents(); // LOG Cost Analysis printout in PDF Log MemoryStream stream = new MemoryStream(); printout.ExportToPdf(stream); HCMIS.Core.Distribution.Services.PrintLogService.SavePrintLogNoWait(stream, "GRV/IGRV", true, ReceiptID, CurrentContext.UserId, BLL.DateTimeHelper.ServerDateTime); return(printout); }
private void ReceiptInvoiceDialog_Load(object sender, EventArgs e) { InitializeForm(); LayoutAndBindingByAccess(); LoadDecimalFormatings(); ConstructTableColumns(); gridViewInvoiceDetail.RowStyle += new RowStyleEventHandler(gridInvoiceDetail_RowStyle); lkInvoiceType.Properties.DataSource = BLL.Settings.IsCenter ? ReceiptInvoiceType.GetAllInvoiceTypes() : ReceiptInvoiceType.GetAllInvoiceTypeByCode("INT"); //Internal for Hubs lkInvoiceType.EditValue = BLL.Settings.IsCenter ? -1 : ReceiptInvoiceType.InvoiceType.INTERNAL; lkCurrencyLCID.Properties.DataSource = Helpers.FormattingHelpers.GetCurrencyList(); var etb = Convert.ToInt32(Helpers.FormattingHelpers.GetCurrencyList().ToTable().Select("Symbol = 'ETB'")[0]["ID"]); lkCurrencyLCID.EditValue = etb; //ETB is the default value PO Order = new PO(_orderID); if (_orderID != 0) { Activity act = new Activity(); act.LoadByPrimaryKey(Order.StoreID); lblAccount.Text = act.AccountName; lblAccountDetail.Text = act.AccountName; lblSubAccount.Text = act.SubAccountName; lblSubAccountDetail.Text = act.SubAccountName; lblActivity.Text = act.Name; lblActivityDetail.Text = act.Name; lblPOType.Text = POType.GetPOTypeNameByID(Order.PurchaseType); lblPOTypeDetail.Text = POType.GetPOTypeNameByID(Order.PurchaseType); lblPONumberDetail.Text = Order.PONumber.ToString(); //lblInvoiceNoDetail.Text = var poStatus = new PurchaseOrderStatus(); poStatus.LoadByPrimaryKey(Order.PurchaseOrderStatusID); lblOrderStatus.Text = poStatus.Name; var Mode = new Mode(); Mode.LoadByPrimaryKey(Order.ModeID); lblMode.Text = Mode.TypeName; lblModeDetail.Text = Mode.TypeName; var receiptInvoice = new ReceiptInvoice(); receiptInvoice.LoadForPO(_orderID); try { lblInvoiceNoDetail.Text = !receiptInvoice.IsColumnNull("STVOrInvoiceNo") ? receiptInvoice.STVOrInvoiceNo : "-"; } catch (Exception) { lblInvoiceNoDetail.Text = "-"; } var invoiceType = new ReceiptInvoiceType(); HeaderGroup.Text = "PO No: " + Order.PONumber; } //documentType var po = new PO(_orderID); var documentTypes = BLL.DocumentType.GetDocumentTypesByPOType(po.PurchaseType); lkDocumentType.Properties.DataSource = documentTypes; lkDocumentType.EditValue = documentTypes.Rows.Count > 0 ? documentTypes.Rows[0]["DocumentTypeID"] : -1; if (_receiptInvoiceID != 0) { ReceiptInvoice rinvoice = new ReceiptInvoice(_receiptInvoiceID); //bind data to invoicedetail tab BindInvoiceDetail(rinvoice); lblOrderNumber.Text = rinvoice.PO.PONumber; lblSupplier.Text = rinvoice.PO.Supplier.IsActive ? rinvoice.PO.Supplier.CompanyName : ""; lblRefNo.Text = rinvoice.PO.RefNo != "" ? rinvoice.PO.RefNo : "-"; gridGrv.DataSource = rinvoice.Receipts.DefaultView; txtInsurance.Text = rinvoice.InsurancePolicyNo; txtInvoiceNumber.Text = rinvoice.STVOrInvoiceNo; txtTransitNumber.Text = rinvoice.TransitTransferNo; txtWayBill.Text = rinvoice.WayBillNo; dtInvoiceDate.EditValue = !rinvoice.IsColumnNull("DateofEntry") ? rinvoice.DateOfEntry : DateTimeHelper.ServerDateTime; txtTotalValue.EditValue = !rinvoice.IsColumnNull("TotalValue") ? rinvoice.TotalValue : 0; lkInvoiceType.EditValue = !rinvoice.IsColumnNull("InvoiceTypeID") ? rinvoice.InvoiceTypeID : 0; txtInvoiceAirFreight.EditValue = !rinvoice.IsColumnNull("AirFreight") ? rinvoice.AirFreight : 0; txtInvoiceSeaFreight.EditValue = !rinvoice.IsColumnNull("SeaFreight") ? rinvoice.SeaFreight : 0; txtInvoiceInlandFreight.EditValue = !rinvoice.IsColumnNull("InlandFreight") ? rinvoice.InlandFreight : 0; txtInvoiceCustomDutyTax.EditValue = !rinvoice.IsColumnNull("CustomDutyTax") ? rinvoice.CustomDutyTax : 0; txtInvoiceCBEServiceCharge.EditValue = !rinvoice.IsColumnNull("CBE") ? rinvoice.CBE : 0; txtExchangeRate.EditValue = !rinvoice.IsColumnNull("ExchangeRate") ? rinvoice.ExchangeRate : 1; lkCurrencyLCID.EditValue = _currency = !rinvoice.IsColumnNull("LCID") ? rinvoice.LCID : 0; lkDocumentType.EditValue = !rinvoice.IsColumnNull("DocumentTypeID") ? rinvoice.DocumentTypeID : -1; DisableEditDependingOnSetting(); var activity = new Activity(); activity.LoadByPrimaryKey(rinvoice.ActivityID); if (activity.IsHealthProgram()) { txtInvoiceCustomDutyTax.EditValue = 0; txtInvoiceCustomDutyTax.Enabled = false; } // var receiptINvoice = new ReceiptInvoice(); // receiptINvoice.LoadForPO(_orderID); lblInvoiceNoDetail.Text = rinvoice.STVOrInvoiceNo.ToString(); lblInvoiceTypeDetail.Text = lkInvoiceType.Text; } else { PO PO = new PO(_orderID); lblOrderNumber.Text = PO.PONumber; BindInvoiceDetailByPO(PO.ID); lblSupplier.Text = PO.Supplier.IsActive ? PO.Supplier.CompanyName : "_"; lkCurrencyLCID.EditValue = 1118; //ETB is the dafault lblRefNo.Text = PO.RefNo != "" ? PO.RefNo : "-"; if (PO.StoreID != null) { var activity = new Activity(); activity.LoadByPrimaryKey(po.StoreID); if (activity.IsHealthProgram()) { txtInvoiceCustomDutyTax.EditValue = 0; txtInvoiceCustomDutyTax.Enabled = false; } } layoutGoodsReceived.Enabled = false; } //gridViewInvoiceDetail.ValidateRow += GridViewInvoiceDetailOnValidateRow; }
private void btnSaveInvoice_Click(object sender, EventArgs e) { PO po = new PO(_orderID); if (dxValidation.Validate()) { ReceiptInvoice invoice = new ReceiptInvoice(); if (_receiptInvoiceID != 0) { invoice.LoadByPrimaryKey(_receiptInvoiceID); } else { invoice.AddNew(); } //TODO: save the Invoice Type Here. invoice.InvoiceTypeID = 1; invoice.InsurancePolicyNo = txtInsurance.Text; double TotalValue = 0; if (!invoice.IsColumnNull("TotalValue")) { TotalValue = invoice.TotalValue; } if (_receiptInvoiceID != 0 && po.Remaining + TotalValue < Convert.ToDouble(txtTotalValue.EditValue) && POType.GetModes(po.PurchaseType) == POType.STANDARD) { XtraMessageBox.Show("Invoice value can't be be greater than Order value", "Invalid Value", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } invoice.TotalValue = Convert.ToDouble(txtTotalValue.EditValue); if (po.Remaining < invoice.TotalValue && POType.GetModes(po.PurchaseType) == POType.STANDARD && _receiptInvoiceID == 0) { XtraMessageBox.Show("Invoice value can't be be greater than Order value", "Invalid Value", MessageBoxButtons.OK, MessageBoxIcon.Hand); return; } invoice.WayBillNo = txtWayBill.Text; invoice.TransitTransferNo = txtTransitNumber.Text; invoice.STVOrInvoiceNo = txtInvoiceNumber.Text; invoice.POID = _orderID; invoice.SavedByUserID = CurrentContext.UserId; invoice.AirFreight = Convert.ToDouble(txtInvoiceAirFreight.EditValue); invoice.SeaFreight = Convert.ToDouble(txtInvoiceSeaFreight.EditValue); invoice.InlandFreight = Convert.ToDouble(txtInvoiceInlandFreight.EditValue); invoice.CustomDutyTax = Convert.ToDouble(txtInvoiceCustomDutyTax.EditValue); invoice.CBE = Convert.ToDouble(txtInvoiceCBEServiceCharge.EditValue); invoice.InvoiceTypeID = Convert.ToInt32(lkInvoiceType.EditValue); invoice.DateOfEntry = Convert.ToDateTime(dtInvoiceDate.EditValue); invoice.ExchangeRate = Convert.ToDouble(txtExchangeRate.EditValue); invoice.LCID = Convert.ToInt32(lkCurrencyLCID.EditValue); invoice.ActivityID = po.StoreID; invoice.Rowguid = Guid.NewGuid(); invoice.PrintedDate = dtInvoiceDate.DateTime; invoice.IsVoided = false; invoice.ShippingSite = " "; invoice.IsConvertedFromDeliveryNote = false; invoice.IsDeliveryNote = Convert.ToInt32(lkDocumentType.EditValue) == DocumentType.CONSTANTS.DLVN; if (Convert.ToInt32(lkDocumentType.EditValue) != -1) { invoice.DocumentTypeID = Convert.ToInt32(lkDocumentType.EditValue); } invoice.Save(); this.LogActivity("Save-Invoice", invoice.ID); lblInvoiceNoDetail.Text = txtInvoiceNumber.EditValue.ToString(); lblInvoiceTypeDetail.Text = lkInvoiceType.Text; BLL.Receipt receipt = new BLL.Receipt(); receipt.UpdateInvoiceRelatedHeaders(invoice); _receiptInvoiceID = invoice.ID; MessageBox.Show("Invoice saved!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); HeaderGroupDetail.Text = "Invoice No: " + txtInvoiceNumber.EditValue.ToString(); } }
private void gridOrderView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (e != null && e.PrevFocusedRowHandle < -1) { return; } if (gridOrderView.GetFocusedDataRow() != null) { var dr = gridOrderView.GetFocusedDataRow(); int OrderID = Convert.ToInt32(dr["ID"]); string sharps = Helpers.FormattingHelpers.GetNumberFormatting(); Order = new PO(OrderID); RefreshInvoice(); RefreshPoDetail(); // Layout ... Show the damn correct layout // Hide the empty layout LayoutEmptyDetails.Visibility = LayoutVisibility.Never; LayoutSelectedOrderDetail.Visibility = LayoutVisibility.Always; int Currency = 0x0409; if (!Order.IsColumnNull("LCID")) { Currency = Order.LCID; } if (!string.IsNullOrEmpty(Order.s_PurchaseType)) { PurchaseTypes = POType.GetAllPOTypes().Find(t => t.ID == Order.PurchaseType); } string space = ""; DataRow dar = gridInvoiceView.GetFocusedDataRow(); HeaderGroup.Text = "PO No: " + dr["OrderNumber"].ToString(); if (dar != null) { HeaderGroup.Text = HeaderGroup.Text + space.PadRight(160) + "Invoice No: " + gridInvoiceView.GetFocusedDataRow()["STVOrInvoiceNo"]; } // lblOrderType.Text = PurchaseTypes != null ? string.Format("{0} : {1}" ,PurchaseTypes.Group , PurchaseTypes.Name) : ""; lblPONumber.Text = Order.PONumber; lblTotalValue.Text = Order.TotalValue.ToString(Helpers.FormattingHelpers.GetCurrencyFormatByLCID(Currency)); lblInsurance.Text = Order.Insurance.ToString(Helpers.FormattingHelpers.GetBirrFormatting()); lblNBE.Text = Order.NBE.ToString(Helpers.FormattingHelpers.GetBirrFormatting()); lblSupplier.Text = Order.Supplier.CompanyName; lblShipper.Text = String.IsNullOrEmpty(Order.ShippingSite) ? "-" : Order.ShippingSite; lblLetterNo.Text = String.IsNullOrEmpty(Order.LetterNo) ? "-" : Order.LetterNo; lblPOType.Text = dr["Name"].ToString(); var PaymentType = new PaymentType(); PaymentType.LoadByPrimaryKey(Order.PaymentTypeID); lblPaymentType.Text = String.IsNullOrEmpty(PaymentType.Name) ? "-" : PaymentType.Name; var User = new User(); User.LoadByPrimaryKey(Order.SavedbyUserID); lblPOBy.Text = String.IsNullOrEmpty(User.FullName) ? "-" : User.FullName; if (!Order.IsColumnNull("ModeID")) { var Mode = new Mode(); Mode.LoadByPrimaryKey(Order.ModeID); lblMode.Text = Mode.TypeName; } else { lblMode.Text = "-"; } if (!Order.IsColumnNull("PurchaseOrderStatusID")) { var poStatus = new PurchaseOrderStatus(); poStatus.LoadByPrimaryKey(Order.PurchaseOrderStatusID); lblPOStatus.Text = poStatus.Name; } chkboxIsElectronic.Checked = Order.IsElectronic; lblOrderDate.Text = Order.PODate.ToShortDateString(); lblSyncDate.Text = Order.ModifiedDate == DateTime.MinValue ? "NA" : Order.ModifiedDate.ToString(CultureInfo.InvariantCulture); if (!Order.IsColumnNull("StoreID")) { Activity act = new Activity(); act.LoadByPrimaryKey(Order.StoreID); lblAccount.Text = act.AccountName; lblSubAccount.Text = act.SubAccountName; lblActivity.Text = act.Name; } else { lblAccount.Text = lblSubAccount.Text = lblActivity.Text = "-"; } lblRefNo.Text = String.IsNullOrEmpty(Order.RefNo) ? "-" : Order.RefNo; lblRemainingValue.Text = Order.Remaining.ToString(Helpers.FormattingHelpers.GetCurrencyFormatByLCID(Currency)); if (BLL.Settings.UseNewUserManagement && this.HasPermission("Add-Invoice")) { btnAddInvoice.Enabled = true; } else if (BLL.Settings.UseNewUserManagement) { btnAddInvoice.Enabled = false; } btnAddInvoice.Enabled = btnEditOrder.Enabled = btnAddOrderDetail.Enabled = !Order.IsElectronic; if (Order.IsElectronic) { grdPoDetail.Enabled = false; gridInvoice.Enabled = false; } else { grdPoDetail.Enabled = true; gridInvoice.Enabled = true; } //purchse order details grdPoDetail.DataSource = Order.PurchaseOrderDetail.DefaultView; } else { // Hide the empty layout LayoutEmptyDetails.Visibility = LayoutVisibility.Always; LayoutSelectedOrderDetail.Visibility = LayoutVisibility.Never; } }