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