/// <summary> /// Adds the new receipt. /// </summary> /// <param name="receiptTypeID">The receipt type ID.</param> /// <param name="userID">The user ID.</param> /// <param name="receiptInvoiceID">The receipt invoice ID.</param> /// /// <param name="receiptStatusID">The receipt confirmation status ID.</param> /// <returns></returns> public int AddNewReceipt(int receiptTypeID, int warehouseID, int userID, int receiptInvoiceID, string txtTransitTransferVoucherNoOverride, int receiptStatusID) //, string transitTransferNo, string insurancePolicyNo, string wayBillNo) { this.AddNew(); this.DateOfEntry = DateTimeHelper.ServerDateTime; this.ReceiptTypeID = receiptTypeID; this.SavedByUserID = userID; this.WarehouseID = warehouseID; this.ReceiptInvoiceID = receiptInvoiceID; this.ReceiptStatusID = receiptStatusID; BLL.ReceiptInvoice rctInvoice = new ReceiptInvoice(); rctInvoice.LoadByPrimaryKey(receiptInvoiceID); this.STVOrInvoiceNo = rctInvoice.STVOrInvoiceNo; if (string.IsNullOrEmpty(txtTransitTransferVoucherNoOverride)) { this.TransitTransferNo = rctInvoice.TransitTransferNo; } else { this.TransitTransferNo = txtTransitTransferVoucherNoOverride; } this.InsurancePolicyNo = rctInvoice.InsurancePolicyNo; this.WayBillNo = rctInvoice.WayBillNo; this.Save(); return(this.ID); }
public void LoadByReceiptID(int receiptID) { BLL.Receipt rct = new Receipt(); rct.LoadByPrimaryKey(receiptID); BLL.ReceiptInvoice rctInvoice = new ReceiptInvoice(); rctInvoice.LoadByPrimaryKey(rct.ReceiptInvoiceID); this.LoadByPrimaryKey(rctInvoice.POID); }
private void btnInvoice_Click(object sender, EventArgs e) { BLL.Receipt GRV = new BLL.Receipt(); GRV.LoadByPrimaryKey(ReceiptID); ReceiptInvoice invoice = new ReceiptInvoice(); invoice.LoadByPrimaryKey(GRV.ReceiptInvoiceID); ReceiptInvoiceDialog InvoiceDialog = new ReceiptInvoiceDialog(invoice.POID, invoice.ID); InvoiceDialog.ShowDialog(); LoadSelectedGRVDetailForCostBuildUp(ReceiptID); }
public void LoadCostBuilUp(bool AutoProrate, string GRNFString) { //ToDo: Remove the Setting Before Implementation _CostBuildup = new CostBuildup(); ReceiptInvoice invoice = new ReceiptInvoice(); invoice.LoadByPrimaryKey(GRV.ReceiptInvoiceID); _CostBuildup.UseTransitServiceCharge = false; _CostBuildup.AutoProrate = AutoProrate; _CostBuildup.LoadByReceiptIDInvoiceIDAndPoID(ReceiptID, invoice.ID, invoice.POID, GRNFString, _SubTotal); }
public static void DeleteList(List <int> list) { BLL.ReceiptInvoice bv = new BLL.ReceiptInvoice(); foreach (int v in list) { // try to load by primary key bv.LoadByPrimaryKey(v); // if the entry doesn't exist, create it if (bv.RowCount > 0) { bv.MarkAsDeleted(); bv.Save(); } // populate the contents of v on the to the database list } }
public void SaveAirFreight(double Freight) { ReceiptInvoice receiptInvoice = new ReceiptInvoice(); receiptInvoice.LoadByPrimaryKey(GRV.ReceiptInvoiceID); if (receiptInvoice.InvoiceTypeID == ReceiptInvoiceType.InvoiceType.INVOICE_SEA) { _Freight = Freight; GRV.SeaFreight = _Freight; } else if (receiptInvoice.InvoiceTypeID == ReceiptInvoiceType.InvoiceType.INVOICE_AIR) { _Freight = Freight; GRV.AirFreight = _Freight; } GRV.Save(); LoadGRV(GRV.ID); }
private void PrintReceiptConfirmation(string referenceNumber, int? reprintOfReceiptConfirmationPrintoutID) { var rc = new ReceiptConfirmationPrintout(); var srmPrintout = new HCMIS.Desktop.Reports.SRMPrintout(CurrentContext.LoggedInUserName); int ReceiptID = Convert.ToInt32(gridReceiveView.GetFocusedDataRow()["ReceiptID"]); var receiveDoc = new ReceiveDoc(); receiveDoc.LoadByReceiptID(ReceiptID); ReceiptConfirmationPrintout.GetGRNFNo(ReceiptID); srmPrintout.BranchName.Text = GeneralInfo.Current.HospitalName; rc.PrepareDataForPrintout(ReceiptID, CurrentContext.UserId, false, 3, null, reprintOfReceiptConfirmationPrintoutID,FiscalYear.Current); srmPrintout.DataSource = rc.DefaultView.ToTable(); var rUnit = new Institution(); var idoc = new IssueDoc(); if (!receiveDoc.IsColumnNull("ReturnedFromIssueDocID")) { idoc.LoadByPrimaryKey(receiveDoc.ReturnedFromIssueDocID); rUnit.LoadByPrimaryKey(idoc.ReceivingUnitID); } else { var po = new PO(); po.LoadByReceiptID(receiveDoc.ReceiptID); rUnit.LoadByPrimaryKey(int.Parse(po.RefNo)); } srmPrintout.xrFromValue.Text = rUnit.Name; srmPrintout.xrWoredaValue.Text = rUnit.WoredaText; srmPrintout.xrRegionValue.Text = rUnit.Region; srmPrintout.xrZoneValue.Text = rUnit.ZoneText; if (!receiveDoc.IsColumnNull("ReturnedFromIssueDocID")) { var stvLog = new BLL.Issue(); stvLog.LoadByPrimaryKey(idoc.STVID); srmPrintout.xrIssueDateValue.Text = idoc.Date.ToString("M/d/yyyy"); var activity = new Activity(); activity.LoadByPrimaryKey(idoc.StoreId); srmPrintout.xrAccountName.Text = activity.FullActivityName; var rct = new BLL.Receipt(); rct.LoadByPrimaryKey(ReceiptID); var rctInvoice = new ReceiptInvoice(); rctInvoice.LoadByPrimaryKey(rct.ReceiptInvoiceID); srmPrintout.xrSTVNoValue.Text = rctInvoice.STVOrInvoiceNo; } else { var activity = new Activity(); activity.LoadByPrimaryKey(receiveDoc.StoreID); srmPrintout.xrAccountName.Text = activity.FullActivityName; srmPrintout.xrSTVNoValue.Text = receiveDoc.RefNo; } var dtDate = new DateTimePickerEx(); dtDate.Value = receiveDoc.EurDate; srmPrintout.Date.Text = dtDate.Text; if (srmPrintout.PrintDialog() != DialogResult.OK) { throw new Exception("Print cancelled by user!"); } //Successfully printed //Release Product var GRV = new CostCalculator(); GRV.LoadGRV(ReceiptID); GRV.ReleaseForIssue(); String reference = gridReceiveView.GetFocusedDataRow()["RefNo"].ToString(); var recDoc = new ReceiveDoc(); recDoc.LoadByReferenceNo(reference); 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(); }
private void btnSTV_Click(object sender, EventArgs e) { BLL.Receipt receipt = new BLL.Receipt(); receipt.LoadByPrimaryKey(ReceiptID); receipt.STVOrInvoiceNo = txtSTVNo.EditValue.ToString(); receipt.Save(); ReceiptInvoice invoice = new ReceiptInvoice(); invoice.LoadByPrimaryKey(receipt.ReceiptInvoiceID); invoice.STVOrInvoiceNo = txtSTVNo.EditValue.ToString(); invoice.Save(); this.LogActivity("Set-New-STV-No", ReceiptID); XtraMessageBox.Show("STV Number has been saved"); }
private void LoadItemsFromTransferredReceiptInvoiceDetail(int receiptInvoiceID) { BLL.ReceiptInvoice receiptInvoice = new ReceiptInvoice(); receiptInvoice.LoadByPrimaryKey(receiptInvoiceID); if (receiptInvoice.RowCount == 0) { XtraMessageBox.Show("Invalid STV/Invoice number!", "Error"); return; } DataTable tbl = BLL.Item.GetItemsByReceiptInvoiceNoForSTVTransfer(receiptInvoice.ID); _dtSelectedTable = tbl.Clone(); gridSelected.DataSource = _dtSelectedTable; foreach (DataRow dr in tbl.Rows) { SelectAnItem(dr); } }
private void lkReceiptInvoice_EditValueChanged(object sender, EventArgs e) { ResetFields(); if (lkReceiptInvoice.EditValue != null) { if ((standardRecType == StandardReceiptType.iGRVOnline || deliveryNoteType == DeliveryNoteType.Automatic) && lkReceiptInvoice.EditValue.Equals(-1)) { HandleReceiptTypeChange(true); return; } if (standardRecType == StandardReceiptType.iGRV && !lkReceiptInvoice.EditValue.Equals(-1)) { //This means, the hub has chosen an invoice other than "Not Found" from the list of invoices. Therefore, we want to change the receipt type to be iGRV-Online. HandleReceiptTypeChange(); } BLL.ReceiptInvoice rctInvoice = new ReceiptInvoice(); rctInvoice.LoadByPrimaryKey(Convert.ToInt32(lkReceiptInvoice.EditValue)); var po = new PO(); po.LoadByPrimaryKey(rctInvoice.POID); if (po.IsElectronic == true) { rdIsElectronic.Checked = true; lblSyncDate.Text = rctInvoice.DateOfEntry.ToShortDateString(); txtPassCode.Enabled = true; lcPassCode.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; } else { rdIsElectronic.Checked = false; lblSyncDate.Text = "-"; txtPassCode.Enabled = false; lcPassCode.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; } lblOrderNo.Text = po.PONumber; lblOrderNum.Text = po.PONumber; if (!rctInvoice.IsColumnNull("DocumentTypeID")) { var doctype = new BLL.DocumentType(); doctype.LoadByPrimaryKey(rctInvoice.DocumentTypeID); lblDeliveryNote.Text = doctype.Name; lblHeaderDoc.Text = doctype.Name; } else { lblDeliveryNote.Text = "-"; lblHeaderDoc.Text = "-"; } var mode = new Mode(); mode.LoadByPrimaryKey(po.ModeID); lblMode.Text = mode.TypeName; lblAccount.Text = "-"; lblSubAccount.Text = "-"; lblActivity.Text = "-"; lblReferenceNo.Text = po.RefNo; var payment = new PaymentType(); payment.LoadByPrimaryKey(po.PaymentTypeID); lblPaymentType.Text = payment.Name; lblHeaderPayment.Text = payment.Name; //if (po.IsColumnNull("NBE")) //{ // lblNebService.Text = Convert.ToString(po.NBE); //} //else //{ // lblNebService.Text = "-"; //} if (po.Remaining != -1) lblRemainingValue.Text = po.Remaining.ToString(); else lblRemainingValue.Text = "-"; if (po.TotalValue != -1) lblTotalValue.Text = po.Remaining.ToString(); else lblTotalValue.Text = "-"; if (po.Insurance != -1) lblChargeInsurance.Text = po.Insurance.ToString(); else lblChargeInsurance.Text = "-"; if (po.NBE != -1) lblNebService.Text = po.NBE.ToString(); else lblNebService.Text = "-"; lblOrderDate.Text = po.PODate.ToShortDateString(); lblReceiptDate.Text = rctInvoice.DateOfEntry.ToShortDateString(); var user = new User(); user.LoadByPrimaryKey(po.SavedbyUserID); lblOrderBy.Text = user.FullName; var sup = new Supplier(); lkAccounts.EditValue = rctInvoice.ActivityID; var act = new Activity(); act.LoadByPrimaryKey(rctInvoice.ActivityID); _supplierID = rctInvoice.GetSupplier(); sup.LoadByPrimaryKey(_supplierID); lblSupplier.Text = sup.CompanyName; lblOrdSup.Text = sup.CompanyName; lblInvoiceNo.Text = rctInvoice.STVOrInvoiceNo; lblInvAccount.Text = act.AccountName ?? "-"; lblInvActivity.Text = act.Name ?? "-"; lblAct.Text = act.FullActivityName ?? "-"; lblInvSubAccount.Text = act.SubAccountName ?? "-"; lblInvMode.Text = act.ModeName ?? "-"; lblInvTotalValue.Text = rctInvoice.TotalFOBValue.ToString("N"); lblInsurancePolicy.Text = rctInvoice.InsurancePolicyNo == " "? rctInvoice.InsurancePolicyNo : "-"; var poType = new POType(); poType.LoadByPrimaryKey(po.PurchaseType); lblOrderType.Text = poType.Name ?? "-"; lblPOType.Text = poType.Name ?? "-"; var poStatus = new PurchaseOrderStatus(); poStatus.LoadByPrimaryKey(po.PurchaseOrderStatusID); lblOrderStatus.Text = poStatus.Name ?? "-"; var it = new InvoiceType(); it.LoadByPrimaryKey(rctInvoice.InvoiceTypeID); lblInvType.Text = it.Name; lblInvDate.Text = rctInvoice.DateOfEntry.ToShortDateString(); mode.LoadByPrimaryKey(rctInvoice.ActivityID); lblWayBillNo.Text = rctInvoice.WayBillNo; txtTransitTransferVoucherNo.Text = rctInvoice.TransitTransferNo; txtEditTransferNo.Text = rctInvoice.TransitTransferNo; lblInsurancePolicyNo.Text = rctInvoice.InsurancePolicyNo; BLL.PO order = new PO(); order.LoadByPrimaryKey(rctInvoice.POID); lblRefNo.Text = order.RefNo; lblPoNo.Text = order.PONumber; DataTable relatedReceives = rctInvoice.GetRelatedReceives(); hasPreviousReceive = false; if (relatedReceives.Rows.Count > 0) { XtraMessageBox.Show( "The Invoice you have selected has previous associated receives", "Invoice Detail", MessageBoxButtons.OK, MessageBoxIcon.Warning); colSelectedManufactuerer.Visible = true; colSelectedUnit.Visible = true; colSelectionLineNo.Visible = true; colSelectedReceiveQty.Visible = true; colSelectedInvoiceQty.Visible = true; hasPreviousReceive = true; gridItemsChoice.Enabled = false; colRemainingQty.VisibleIndex = 9; lcItemChoiceGrid.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; _dtSelectedTable = relatedReceives.Clone(); gridSelected.DataSource = _dtSelectedTable; foreach (DataRow dr in relatedReceives.Rows) { SelectAnItem(dr); } } else { hasPreviousReceive = false; colSelectedManufactuerer.Visible = false; colSelectedUnit.Visible = false; colSelectionLineNo.Visible = false; colSelectedReceiveQty.Visible = false; colSelectedInvoiceQty.Visible = false; colRemainingQty.Visible = false; gridItemsChoice.Enabled = true; lcItemChoiceGrid.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; } if (lkAccounts.EditValue != null) { // lcInvoiceDetail.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; } if (standardRecType == StandardReceiptType.iGRVOnline || standardRecType == StandardReceiptType.GRV || deliveryNoteType == DeliveryNoteType.Automatic) { if (!hasPreviousReceive) LoadItemsFromTransferredReceiptInvoiceDetail(rctInvoice.ID); txtRefNo.Text = lkReceiptInvoice.Text; colSelectedReceiveQty.Visible = true; lcItemChoiceGrid.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; lkAccounts.Enabled = false; } else { lkAccounts.Enabled = !BLL.Settings.IsCenter; } if(!BLL.Settings.IsCenter) { //Passcode Textbox var dataRowView = lkReceiptInvoice.GetSelectedDataRow() as DataRowView; if (dataRowView != null) _isElectronic = Convert.ToBoolean(dataRowView["IsElectronic"]); lcPassCode.Visibility = (!_isNonElectronicReceiveOnly) && (_isElectronic) && (standardRecType == StandardReceiptType.iGRVOnline || deliveryNoteType == DeliveryNoteType.Automatic) ? LayoutVisibility.Always : LayoutVisibility.Never; txtPassCode.Text = "HHMM"; } } }
private void lblWaybill_MouseEnter(object sender, EventArgs e) { if (lkReceiptInvoice.EditValue != null) { var receiptInvoice = new ReceiptInvoice(); receiptInvoice.LoadByPrimaryKey((int)lkReceiptInvoice.EditValue); ShowTooltip(receiptInvoice.PrintedDate.ToString()); } }
public void LoadCostBuilUp(bool AutoProrate,string GRNFString) { //ToDo: Remove the Setting Before Implementation _CostBuildup = new CostBuildup(); ReceiptInvoice invoice = new ReceiptInvoice(); invoice.LoadByPrimaryKey(GRV.ReceiptInvoiceID); _CostBuildup.UseTransitServiceCharge = false; _CostBuildup.AutoProrate = AutoProrate; _CostBuildup.LoadByReceiptIDInvoiceIDAndPoID(ReceiptID, invoice.ID, invoice.POID, GRNFString,_SubTotal); }
private void LoadData(int ReceiptID, int InvoiceID, int PoID) { //PO Cost Elements; purchaseOrder.LoadByPrimaryKey(PoID); Invoice.LoadByPrimaryKey(InvoiceID); GRV.LoadByPrimaryKey(ReceiptID); if (Invoice.IsColumnNull("InvoiceTypeID")) { Invoice.InvoiceTypeID = ReceiptInvoiceType.InvoiceType.NON_STANDARD; } if (Invoice.InvoiceTypeID == ReceiptInvoiceType.InvoiceType.INVOICE_SEA) { UseSeaFreight = true; } else { UseSeaFreight = false; } if (!purchaseOrder.IsColumnNull("TotalValue")) { PurchaseOrderTotal = purchaseOrder.TotalValue; } if (!purchaseOrder.IsColumnNull("AirFreight")) { PurchaseOrderAirFreight = purchaseOrder.AirFreight; } if (!purchaseOrder.IsColumnNull("SeaFreight")) { PurchaseOrderSeaFreight = purchaseOrder.SeaFreight; } if (!purchaseOrder.IsColumnNull("Insurance")) { PurchaseOrderInsurance = purchaseOrder.Insurance; } if (!purchaseOrder.IsColumnNull("NBE")) { PurcahseOrderNBE = purchaseOrder.NBE; } //Invoice Cost Elements; if (!Invoice.IsColumnNull("TotalValue")) { InvoiceTotal = Invoice.TotalValue; } if (!Invoice.IsColumnNull("AirFreight")) { InvoiceAirFreight = Invoice.AirFreight; } if (!Invoice.IsColumnNull("SeaFreight")) { InvoiceSeaFreight = Invoice.SeaFreight; } if (!Invoice.IsColumnNull("InlandFreight")) { InvoiceInlandFreight = Invoice.InlandFreight; } if (!Invoice.IsColumnNull("Insurance")) { InvoiceInsurance = Invoice.Insurance; } if (!Invoice.IsColumnNull("NBE")) { InvoiceNBE = Invoice.NBE; } if (!Invoice.IsColumnNull("CBE")) { InvoiceCBE = Invoice.CBE; } if (!Invoice.IsColumnNull("CustomDutyTax")) { InvoiceCustomDutyTax = Invoice.CustomDutyTax; } //GRV Cost Elements if (UseSeaFreight) { if (!GRV.IsColumnNull("SeaFreight")) { GRVSeaFreight = GRV.SeaFreight; } } else { if (!GRV.IsColumnNull("AirFreight")) { GRVAirFreight = GRV.AirFreight; } } if (!GRV.IsColumnNull("InlandFreight")) { GRVInlandFreight = GRV.InlandFreight; } if (!GRV.IsColumnNull("Insurance")) { GRVInsurance = GRV.Insurance; } if (!GRV.IsColumnNull("NBE")) { GRVNBE = GRV.NBE; } if (!GRV.IsColumnNull("CBE")) { GRVCBE = GRV.CBE; } if (!GRV.IsColumnNull("CustomDutyTax")) { GRVCustomDutyTax = GRV.CustomDutyTax; } if (!GRV.IsColumnNull("TransitServiceCharge")) { GRVTransit = GRV.TransitServiceCharge; } else { GRVTransit = UseTransitServiceCharge ? 250 : 0; } //if (!GRV.IsColumnNull("OtherExpenses")) // GRVOtherExpense = GRV; //Exchange rate if (!purchaseOrder.IsColumnNull("ExhangeRate")) { FOBExchangeRate = purchaseOrder.ExhangeRate; } if (!Invoice.IsColumnNull("ExchangeRate")) { FreightExchangeRate = Invoice.ExchangeRate; } }
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 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(); } }
public static void DeleteList(List<int> list) { BLL.ReceiptInvoice bv = new BLL.ReceiptInvoice(); foreach (int v in list) { // try to load by primary key bv.LoadByPrimaryKey(v); // if the entry doesn't exist, create it if (bv.RowCount > 0) { bv.MarkAsDeleted(); bv.Save(); } // populate the contents of v on the to the database list } }
public void LoadByReceiptID(int receiptID) { BLL.Receipt rct = new Receipt(); rct.LoadByPrimaryKey(receiptID); BLL.ReceiptInvoice rctInvoice = new ReceiptInvoice(); rctInvoice.LoadByPrimaryKey(rct.ReceiptInvoiceID); this.LoadByPrimaryKey(rctInvoice.POID); }
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(); } }
public void SaveAirFreight(double Freight) { ReceiptInvoice receiptInvoice = new ReceiptInvoice(); receiptInvoice.LoadByPrimaryKey(GRV.ReceiptInvoiceID); if (receiptInvoice.InvoiceTypeID == ReceiptInvoiceType.InvoiceType.INVOICE_SEA) { _Freight = Freight; GRV.SeaFreight = _Freight; } else if (receiptInvoice.InvoiceTypeID == ReceiptInvoiceType.InvoiceType.INVOICE_AIR) { _Freight = Freight; GRV.AirFreight = _Freight; } GRV.Save(); LoadGRV(GRV.ID); }
//, string transitTransferNo, string insurancePolicyNo, string wayBillNo) /// <summary> /// Adds the new receipt. /// </summary> /// <param name="receiptTypeID">The receipt type ID.</param> /// <param name="userID">The user ID.</param> /// <param name="receiptInvoiceID">The receipt invoice ID.</param> /// /// <param name="receiptStatusID">The receipt confirmation status ID.</param> /// <returns></returns> public int AddNewReceipt(int receiptTypeID,int warehouseID ,int userID, int receiptInvoiceID, string txtTransitTransferVoucherNoOverride, int receiptStatusID) { this.AddNew(); this.DateOfEntry = DateTimeHelper.ServerDateTime; this.ReceiptTypeID = receiptTypeID; this.SavedByUserID = userID; this.WarehouseID = warehouseID; this.ReceiptInvoiceID = receiptInvoiceID; this.ReceiptStatusID = receiptStatusID; BLL.ReceiptInvoice rctInvoice = new ReceiptInvoice(); rctInvoice.LoadByPrimaryKey(receiptInvoiceID); this.STVOrInvoiceNo = rctInvoice.STVOrInvoiceNo; if (string.IsNullOrEmpty(txtTransitTransferVoucherNoOverride)) { this.TransitTransferNo = rctInvoice.TransitTransferNo; } else { this.TransitTransferNo = txtTransitTransferVoucherNoOverride; } this.InsurancePolicyNo = rctInvoice.InsurancePolicyNo; this.WayBillNo = rctInvoice.WayBillNo; this.Save(); return this.ID; }