void backgroundWorker_DoWork(object sender, DoWorkEventArgs e) { DataSet ds = new DataSet(); DateTime dateFrom = dtFrom.Value; DateTime dateTo = dtTo.Value; ds.Tables.Add(IssueDoc.GetIssueSummaryBySupplier(dateFrom, dateTo, _chosenStoreTypeID)); ds.Tables[0].TableName = "SupplierSummary"; ds.Tables.Add(IssueDoc.GetIssueBreakdownBySupplier(dateFrom, dateTo, _chosenStoreTypeID)); ds.Tables[1].TableName = "SupplierBreakdown"; var _distributionBreakdow = new DistributionBreakdown { HubName = { Text = GeneralInfo.Current.HospitalName }, DateRange = { Text = string.Format("{0} to {1}", dtFrom.Text, dtTo.Text) }, DataSource = ds }; e.Result = _distributionBreakdow; }
private void gridView1_DoubleClick(object sender, EventArgs e) { DataRow dr = gridView1.GetFocusedDataRow(); if (dr == null) { return; } int tranId = Convert.ToInt32(dr["ID"]); ReceiveDoc rec = new ReceiveDoc(); rec.LoadByPrimaryKey(tranId); _dtDate.Value = DateTime.Now; _dtDate.CustomFormat = "MM/dd/yyyy"; IssueDoc iss = new IssueDoc(); iss.GetIssueByBatchAndId(rec.ItemID, rec.BatchNo, rec.ID); DateTime dtCurrent = ConvertDate.DateConverter(_dtDate.Text); if ((rec.Date.Year != dtCurrent.Year && rec.Date.Month < 11) || (iss.RowCount != 0)) { //XtraMessageBox.Show("Unable to edit, This Transaction has been processed. Try Loss and Adjustment.", "Unable to Edit", MessageBoxButtons.OK, MessageBoxIcon.Stop); EditReceive edRec = new EditReceive(tranId, true); MainWindow.ShowForms(edRec); } else { EditReceive edRec = new EditReceive(tranId, false); MainWindow.ShowForms(edRec); } }
private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { var us = new User(); var userID = MainWindow.LoggedinId; us.LoadByPrimaryKey(userID); var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode); if (dr == null) { return; } if (us.UserName != "admin") { XtraMessageBox.Show("You don't have the privilege to update reference number!", "Caution"); return; } if (XtraMessageBox.Show("Are You Sure, You want to delete this?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { var dis = new IssueDoc(); DataTable dtbl = dis.GetTransactionByRefNo((string)dr["RefNo"]); foreach (DataRow dataRow in dtbl.Rows) { AddIssueDocDeleted(dataRow); DeletedRelatedModel(dataRow); dataRow.Delete(); } dis.MarkAsDeleted(); dis.Save(); XtraMessageBox.Show("Item successfully deleted.", "Success"); } }
/// <summary> /// Gets the cost of good sold. /// </summary> /// <param name="AccountID">The account ID.</param> /// <returns></returns> public static DataView GetCostOfGoodSold(int AccountID, DateTime aDate, DateTime bDate) { IssueDoc report = new IssueDoc(); var query = HCMIS.Repository.Queries.IssueDoc.SelectGetCostOfGoodSold(AccountID, aDate, bDate); report.LoadFromRawSql(query); return report.DefaultView; }
private void lstTree_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx { CustomFormat = "MM/dd/yyyy", Value = DateTime.Now }; DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text); DataRowView dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode); if (dr == null) { return; } //lstTransactions.Items.Clear(); IssueDoc iss = new IssueDoc(); DataTable dtRec; if (dr["ParentID"] == DBNull.Value) { EthiopianDate.EthiopianDate ethiopianDate = new EthiopianDate.EthiopianDate(Convert.ToInt32(dr["ID"]), 1, 1); dtRec = iss.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), ethiopianDate.StartOfFiscalYear.ToGregorianDate(), ethiopianDate.EndOfFiscalYear.ToGregorianDate()); string dateString = dr["RefNo"].ToString(); lblIssDate.Text = dateString; } else { //dtRec = iss.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString()); dtRec = iss.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToDateTime(dr["Date"])); lblIssDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy"); } gridIssues.DataSource = dtRec; }
private static void AddIssueLodDelete(IssueDoc iss) { IssueDocDeleted isdelete = new IssueDocDeleted(); isdelete.AddNew(); isdelete.ID = iss.ID; isdelete.ItemID = iss.ItemID; isdelete.StoreId = iss.StoreId; isdelete.ReceivingUnitID = iss.ReceivingUnitID; isdelete.LocalBatchNo = iss.LocalBatchNo; isdelete.Quantity = iss.Quantity; isdelete.Date = iss.Date; isdelete.IsTransfer = iss.IsTransfer; isdelete.IssuedBy = iss.IssuedBy; isdelete.Remark = iss.Remark; isdelete.RefNo = iss.RefNo; isdelete.BatchNo = iss.BatchNo; isdelete.IsApproved = iss.IsApproved; isdelete.Cost = iss.Cost; isdelete.NoOfPack = iss.NoOfPack; isdelete.QtyPerPack = iss.QtyPerPack; isdelete.DUSOH = iss.DUSOH; isdelete.EurDate = iss.EurDate; isdelete.RecievDocID = iss.RecievDocID; isdelete.RecomendedQty = iss.RecomendedQty; isdelete.Save(); }
private void cboStores_EditValueChanged(object sender, EventArgs e) { if (cboStores.EditValue == null) { return; } var iss = new IssueDoc(); // var dtRec = iss.GetDistinctIssueDocments(Convert.ToInt32(cboStores.EditValue)); UserCommodityType ucs = new UserCommodityType(); DataTable dt = ucs.GetUserCommodityType(MainWindow.LoggedinId); int[] typeid = new int[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { typeid[i] = Convert.ToInt32(dt.Rows[i]["ID"]); } var typeids = string.Join(",", typeid); var dtRec = iss.GetDistinctIssueDocmentsUsers(Convert.ToInt32(cboStores.EditValue), typeids); lstTree.DataSource = dtRec; DateTime dt1 = EthiopianDate.EthiopianDate.Now.StartOfFiscalYear.ToGregorianDate(); DateTime dt2 = DateTime.Now; dtRec = iss.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2); lblIssDate.Text = @"Current Year"; gridIssues.DataSource = dtRec; }
/// <summary> /// Returns the Issue summary by item by supplier. /// </summary> /// <param name="dtFrom">The dt from.</param> /// <param name="dtTo">The dt to.</param> /// <param name="storeTypeID">The store type ID.</param> /// <returns></returns> public static DataTable GetIssueBreakdownBySupplier(DateTime dtFrom, DateTime dtTo, int storeTypeID) { var query = HCMIS.Repository.Queries.IssueDoc.SelectGetIssueBreakdownBySupplier(dtFrom, dtTo, storeTypeID); IssueDoc id = new IssueDoc(); id.LoadFromRawSql(query); return id.DataTable; }
private void RefreshActivity(int days) { chartActivity.Series["Requested"].DataSource = Order.GetWishListSummary(days); chartActivity.Series["Cancelled"].DataSource = Order.GetOrdersForReport(OrderStatus.Constant.CANCELED, days); chartActivity.Series["Issued"].DataSource = IssueDoc.GetIssueSummary(days); chartActivity.Series["Picklist"].DataSource = PickList.GetPickListSummary(days); }
private void cbYear_SelectedIndexChanged(object sender, EventArgs e) { if (listBoxControl1.SelectedItem.ToString().Equals("Issued Amount by Year")) { IssuedAmoutByYear issuedAmoutByYearReport = new IssuedAmoutByYear(CurrentContext.LoggedInUserName); issuedAmoutByYearReport.DataSource = IssueDoc.IssuedAmoutByYear(Convert.ToInt32(cbYear.SelectedItem), Convert.ToInt32(lkAccount.EditValue), Convert.ToBoolean(checbySellingPrice.Checked)); issuedAmoutByYearReport.xrMonth.Text = string.Format("{0}", cbYear.SelectedItem); printControl1.PrintingSystem = issuedAmoutByYearReport.PrintingSystem; report = issuedAmoutByYearReport; issuedAmoutByYearReport.CreateDocument(); } else if (listBoxControl1.SelectedItem.ToString().Equals("Received Amount by Year")) { ReceivedAmoutByYear receivedAmountReport = new ReceivedAmoutByYear(CurrentContext.LoggedInUserName); receivedAmountReport.DataSource = ReceiveDoc.ReceivedAmoutByYear(Convert.ToInt32(cbYear.SelectedItem), Convert.ToInt32(lkAccount.EditValue)); receivedAmountReport.xrMonth.Text = string.Format("{0}", cbYear.SelectedItem); printControl1.PrintingSystem = receivedAmountReport.PrintingSystem; report = receivedAmountReport; receivedAmountReport.CreateDocument(); } else if (lkMode.EditValue != null && lkCategories.EditValue != null && cbMonth.SelectedItem != null && cbYear.SelectedItem != null && cbToYear.SelectedItem != null && cbToMonth.SelectedItem != null && listBoxControl1.SelectedItem.ToString().Equals("Vital Report")) { LadVitalItemReport(); } else { cbMonth_SelectedIndexChanged(null, null); } }
public static DataView CostOfSales(int ethiopianMonth, int ethiopianYear, int modeID) { IssueDoc issueDoc = new IssueDoc(); string query = HCMIS.Repository.Queries.IssueDoc.SelectCostOfSales(ethiopianMonth, ethiopianYear, modeID); issueDoc.LoadFromRawSql(query); return issueDoc.DefaultView; }
private static void DeletedRelatedModel(IssueDoc iss) { Model22 md = new Model22(); md.Where.IssueDocID.Value = iss.ID; md.Query.Load(); md.DeleteAll(); md.Save(); }
public void PopulateItemListByDU(DataTable dtItem) { progressBar1.Visible = true; progressBar1.Minimum = 1; progressBar1.Value = 1; progressBar1.Maximum = dtItem.Rows.Count; GeneralInfo pipline = new GeneralInfo(); pipline.LoadAll(); int min = pipline.Min; int max = pipline.Max; int storeId = (cboStores.SelectedValue != null) ? Convert.ToInt32(cboStores.SelectedValue) : 1; int duId = Convert.ToInt32(cboIssuedTo.SelectedValue); lstItem.Items.Clear(); int col = 0; int count = 1; Balance bal = new Balance(); IssueDoc itmIssues = new IssueDoc(); foreach (DataRow dr in dtItem.Rows) { int itemId = Convert.ToInt32(dr["ID"]); string itemName = dr["ItemName"].ToString() + " - " + dr["DosageForm"].ToString() + " - " + dr["Strength"].ToString(); int year = Convert.ToInt32(cboYear.SelectedItem); Int64 SOH = bal.GetDUSOH(Convert.ToInt32(dr["ID"]), duId, dtCurrent.Month, year); int[] mon = { 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }; long[] cons = new long[12]; for (int i = 0; i < mon.Length; i++) { int yr = (mon[i] > 10) ? year - 1 : year; cons[i] = itmIssues.GetDUConsumptionByMonth(itemId, duId, mon[i], yr); } string[] str = { count.ToString(), itemName, ((SOH != 0) ? SOH.ToString("#,###") : "0"), ((cons[0] != 0) ? cons[0].ToString("#,###") : "0"), ((cons[1] != 0) ? cons[1].ToString("#,###") : "0"), ((cons[2] != 0) ? cons[2].ToString("#,###") : "0"), ((cons[3] != 0) ? cons[3].ToString("#,###") : "0"), ((cons[4] != 0) ? cons[4].ToString("#,###") : "0"), ((cons[5] != 0) ? cons[5].ToString("#,###") : "0"), ((cons[6] != 0) ? cons[6].ToString("#,###") : "0"), ((cons[7] != 0) ? cons[7].ToString("#,###") : "0"), ((cons[8] != 0) ? cons[8].ToString("#,###") : "0"), ((cons[9] != 0) ? cons[9].ToString("#,###") : "0"), ((cons[10] != 0) ? cons[10].ToString("#,###") : "0"), ((cons[11] != 0) ? cons[11].ToString("#,###") : "0") }; ListViewItem listItem = new ListViewItem(str); listItem.ToolTipText = itemName; listItem.Tag = dr["ID"]; if (col != 0) { listItem.BackColor = Color.FromArgb(233, 247, 248); col = 0; } else { col++; } lstItem.Items.Add(listItem); count++; progressBar1.PerformStep(); } progressBar1.Visible = false; }
private void EditIssue_Load(object sender, EventArgs e) { Stores str = new Stores(); str.LoadAll(); cboStores.DataSource = str.DefaultView; ReceivingUnits rUnit = new ReceivingUnits(); rUnit.GetActiveDispensaries(); cboReceivingUnit.DataSource = rUnit.DefaultView; if (_tranId != 0) { IssueDoc iss = new IssueDoc(); Items itm = new Items(); iss.LoadByPrimaryKey(_tranId); DataTable dtItm = itm.GetItemById(iss.ItemID); string itemName = dtItm.Rows[0]["ItemName"].ToString() + " - " + dtItm.Rows[0]["DosageForm"].ToString() + " - " + dtItm.Rows[0]["Strength"].ToString(); txtRefNo.Text = iss.RefNo; txtBatchNo.Text = iss.BatchNo; try { txtPack.Text = iss.NoOfPack.ToString(); txtQtyPack.Text = iss.QtyPerPack.ToString(); txtPrice.Text = (iss.Cost * iss.QtyPerPack).ToString(); } catch { txtPack.Text = "0"; txtQtyPack.Text = "0"; txtPrice.Text = (iss.Cost * 1).ToString(); } txtQuantity.Text = iss.Quantity.ToString(); DateTime dtDate = Convert.ToDateTime(iss.Date.ToString("MM/dd/yyyy")); txtDate.Text = dtDate.ToShortDateString(); //dtIssDate.Value = DateTime.Now; //dtIssDate.CustomFormat = "MM/dd/yyyy"; //DateTime dtCurrent = Convert.ToDateTime(dtIssDate.Text); //long tic = (DateTime.Now.Ticks - dtCurrent.Ticks); //DateTime dtIssG = dtDate.AddTicks(tic); //dtIssDate.Value = dtIssG; cboStores.SelectedValue = iss.StoreId; cboReceivingUnit.SelectedValue = iss.ReceivingUnitID; txtItemName.Text = itemName; txtReceivedBy.Text = iss.IssuedBy; txtRemark.Text = iss.Remark; } }
internal void VoidIssueBasesdOnSTVID() { BLL.IssueDoc issDoc = new IssueDoc(); issDoc.LoadBySTVID(_activeSTVID); while (!issDoc.EOF) { DeleteAnIssue(issDoc.ID); issDoc.MoveNext(); } }
private void btnSave_Click(object sender, EventArgs e) { string valid = ValidateFields(); if (valid == "true") { if (XtraMessageBox.Show("Are You Sure, You want to save this Transaction?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { IssueDoc iss = new IssueDoc(); ReceiveDoc rec = new ReceiveDoc(); iss.LoadByPrimaryKey(_tranId); string batchNo = iss.BatchNo; Int64 qty = iss.Quantity; rec.GetTransactionByBatch(iss.ItemID, iss.BatchNo, iss.StoreId); iss.RefNo = txtRefNo.Text; iss.BatchNo = txtBatchNo.Text; iss.NoOfPack = Convert.ToInt32(txtPack.Text); iss.QtyPerPack = Convert.ToInt32(txtQtyPack.Text); iss.Quantity = Convert.ToInt32(txtPack.Text) * Convert.ToInt32(txtQtyPack.Text); iss.StoreId = Convert.ToInt32(cboStores.SelectedValue); iss.ReceivingUnitID = Convert.ToInt32(cboReceivingUnit.SelectedValue); iss.Remark = txtRemark.Text; iss.IssuedBy = txtReceivedBy.Text; iss.Save(); Int64 newQty = 0; if (qty > iss.Quantity) { newQty = rec.QuantityLeft + (qty - iss.Quantity); } else { newQty = rec.QuantityLeft - (iss.Quantity - qty); } rec.QuantityLeft = newQty; if (rec.QuantityLeft > 0) { rec.Out = false; } rec.Save(); XtraMessageBox.Show("Transaction Succsfully Saved!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } else { XtraMessageBox.Show(valid, "Validation", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
public void PopulateItemList(DataTable dtItem) { progressBar1.Visible = true; progressBar1.Minimum = 1; progressBar1.Value = 1; progressBar1.Maximum = dtItem.Rows.Count; lstItem.Items.Clear(); int col = 0; int count = 1; int storeId = (cboStores.SelectedValue != null) ? Convert.ToInt32(cboStores.SelectedValue) : 1; dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCurrent = new DateTime(); dtCurrent = ConvertDate.DateConverter(dtDate.Text); IssueDoc issues = new IssueDoc(); foreach (DataRow dr in dtItem.Rows) { string itemName = dr["ItemName"].ToString() + " - " + dr["DosageForm"].ToString() + " - " + dr["Strength"].ToString(); Int64[] obj = new Int64[recId.Length]; int itemId = Convert.ToInt32(dr["ID"]); string[] str = new string[recId.Length + 2]; str[0] = count.ToString(); str[1] = itemName; for (int j = 0; j < recId.Length; j++) { obj[j] = issues.GetIssuedQuantityByReceivingUnit(itemId, storeId, recId[j], dtCurrent.Year); str[j + 2] = (obj[j] != 0)?obj[j].ToString("#,###"): "0"; } ListViewItem listItem = new ListViewItem(str); listItem.ToolTipText = itemName; listItem.Tag = dr["ID"]; if (col != 0) { listItem.BackColor = Color.FromArgb(233, 247, 248); col = 0; } else { col++; } lstItem.Items.Add(listItem); count++; progressBar1.PerformStep(); } progressBar1.Visible = false; }
public static bool CheckOutStandingIssues(int warehouseID = 0) { Warehouse warehouse = new Warehouse(); warehouse.LoadAll(); string query = HCMIS.Repository.Queries.IssueDoc.SelectCheckOutStandingIssues(warehouseID, warehouse.RowCount, OrderStatus.Constant.ORDER_APPROVED, OrderStatus.Constant.ISSUED); IssueDoc issueDoc = new IssueDoc(); issueDoc.LoadFromRawSql(query); return issueDoc.Getint("count") == 0; }
private void dtTo_ValueChanged(object sender, EventArgs e) { //CALENDAR: IssueDoc iss = new IssueDoc(); //dtFrom.CustomFormat = "MM/dd/yyyy"; //dtTo.CustomFormat = "MM/dd/yyyy"; //DateTime dteFrom = ConvertDate.DateConverter(dtFrom.Text); //DateTime dteTo = ConvertDate.DateConverter(dtTo.Text); // DataTable dtRec = dtFrom.Value < dtTo.Value ? iss.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dtFrom.Value, dtTo.Value) : iss.GetAllTransaction(Convert.ToInt32(cboStores.EditValue)); // gridIssues.DataSource = dtRec; }
/// <summary> /// Filters the STV log. /// </summary> private void FilterStvLog() { if (lkAccount.EditValue != null) { var iss = new IssueDoc(); gridReferences.DataSource = lkRoute.EditValue == null?iss.GetDistinctIssueDocmentsForAccount(Convert.ToInt32(lkAccount.EditValue), chkDeliveryNotes.Checked) : iss.GetDistinctIssueDocmentsForAccountAndRoute(Convert.ToInt32(lkAccount.EditValue), Convert.ToInt32(lkRoute.EditValue), chkDeliveryNotes.Checked); // apply the filter txtFilterFacilityName_EditValueChanged(null, null); // show details of the first entry in the table // gridViewReferences_FocusedRowChanged(null, null); } }
private void cboIssuedTo_EditValueChanged(object sender, EventArgs e) { if (cboIssuedTo.EditValue == null || cboStores.EditValue == null) { return; } IssueDoc iss = new IssueDoc(); DataTable dtRec = iss.GetTransactionByReceivingUnit(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(cboIssuedTo.EditValue)); gridIssues.DataSource = dtRec; }
private void EditIssueDocRefrenceNo_Load(object sender, EventArgs e) { dtRecDate.Value = DateTime.Now; dtRecDate.CustomFormat = "MM/dd/yyyy"; if (_refno != null) { var iss = new IssueDoc(); iss.GetTransactionByRefNo(_refno); DateTime dtDate = Convert.ToDateTime(iss.Date.ToString("MM/dd/yyyy")); txtDate.Text = dtDate.ToShortDateString(); txtRefNo.Text = iss.RefNo; } }
private void toolStripMenuItem2_Click(object sender, EventArgs e) { var us = new User(); var userID = MainWindow.LoggedinId; us.LoadByPrimaryKey(userID); var dr = grdLogReceive.GetFocusedDataRow(); if (dr == null) { return; } int tranId = Convert.ToInt32(dr["ID"]); var rec = new ReceiveDoc(); rec.LoadByPrimaryKey(tranId); var iss = new IssueDoc(); iss.GetIssueByBatchAndId(rec.ItemID, rec.BatchNo, rec.ID); _dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCurrent = ConvertDate.DateConverter(_dtDate.Text); if ((rec.Date.Year != dtCurrent.Year && rec.Date.Month < 11) || (iss.RowCount != 0)) { XtraMessageBox.Show("Unable to Delete, This Transaction has been processed. Try Loss and Adjustment.", "Unable to Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); } else { if ( XtraMessageBox.Show( "Are You Sure, You want to delete this Transaction? You will not be able to restore this data.", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //AddDeletedRecieveDoc(rec); rec.MarkAsDeleted(); rec.Save(); _dtDate.Value = DateTime.Now; _dtDate.CustomFormat = "MM/dd/yyyy"; dtCurrent = ConvertDate.DateConverter(_dtDate.Text); int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1); DateTime dt1 = new DateTime(yr, 11, 1); DateTime dt2 = new DateTime(dtCurrent.Year, dtCurrent.Month, dtCurrent.Day); DataTable dtRec = rec.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2); gridReceives.DataSource = dtRec; } } }
private void gridViewMissingOrders_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { // disable all the buttons. DataRow dataRow = gridViewMissingOrders.GetFocusedDataRow(); if (dataRow != null) { btnExport.Enabled = btnPrint.Enabled = btnReprint.Enabled = false; // now just show the details of the order IssueDoc issueDoc = new IssueDoc(); issueDoc.LoadMissingByOrderID(Convert.ToInt32(dataRow["ID"])); gridTransactions.DataSource = issueDoc.DefaultView; } }
private void cboStores_EditValueChanged(object sender, EventArgs e) { if (cboStores.EditValue == null) { return; } var iss = new IssueDoc(); var dtRec = iss.GetDistinctIssueDocments(Convert.ToInt32(cboStores.EditValue)); lstTree.DataSource = dtRec; DateTime dt1 = EthiopianDate.EthiopianDate.Now.StartOfFiscalYear.ToGregorianDate(); DateTime dt2 = DateTime.Now; dtRec = iss.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2); lblIssDate.Text = @"Current Year"; gridIssues.DataSource = dtRec; }
private void toolStripMenuItem1_Click(object sender, EventArgs e) { var us = new User(); var userID = MainWindow.LoggedinId; us.LoadByPrimaryKey(userID); var dr = grdLogReceive.GetFocusedDataRow(); if (dr == null) { return; } //if (us.UserName != "admin") //{ // XtraMessageBox.Show("You don't have the privilege to update reference number!", "Caution"); // return; //} int tranId = Convert.ToInt32(dr["ID"]); var rec = new ReceiveDoc(); var iss = new IssueDoc(); var dis = new Disposal(); rec.LoadByPrimaryKey(tranId); iss.GetIssueByBatchAndId(rec.ItemID, rec.BatchNo, rec.ID); _dtDate.Value = DateTime.Now; _dtDate.CustomFormat = "MM/dd/yyyy"; //if (iss.RowCount == 0) //{ if ((iss.RowCount != 0) && (iss.RecievDocID != null && iss.RecievDocID == rec.ID)) { var edRec = new EditReceive(tranId, true, Convert.ToBoolean(chkIntDrugCode.EditValue)); MainWindow.ShowForms(edRec); } //} else if (iss.RowCount == 0) { var edRec = new EditReceive(tranId, false, Convert.ToBoolean(chkIntDrugCode.EditValue)); MainWindow.ShowForms(edRec); } }
private void toolStripMenuItem1_Click(object sender, EventArgs e) { DataRow dr = grdLogIssue.GetFocusedDataRow(); if (dr == null) { return; } int tranId = Convert.ToInt32(dr["ID"]); EditIssue edRec = new EditIssue(tranId); MainWindow.ShowForms(edRec); IssueDoc iss = new IssueDoc(); DataTable dtRec = iss.GetAllTransaction(Convert.ToInt32(cboStores.EditValue)); /*PopulateTransaction(dtRec);*/ gridIssues.DataSource = dtRec; }
private void printModel_Click(object sender, EventArgs e) { var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode); if (dr == null) { return; } //lstTransactions.Items.Clear(); var iss = new IssueDoc(); DataTable dt = iss.GetModel22ByRefNo(dr["RefNo"].ToString(), Convert.ToDateTime(dr["Date"])); var issuedBy = ""; var receivedBy = ""; if (dt.Rows.Count > 0) { issuedBy = (dt.Rows[0]["ModelIssuedBy"] != null) ? dt.Rows[0]["ModelIssuedBy"].ToString() : ""; receivedBy = (dt.Rows[0]["RecipientName"] != null) ? dt.Rows[0]["RecipientName"].ToString() : ""; } var modelprint = new PharmInventory.Reports.Model22 { PrintedBy = { Text = _printedby }, xrStore = { Text = cboStores.Text }, xrIssuedBy = { Text = issuedBy }, xrReceivedBy = { Text = receivedBy } }; var tbl1 = dt; tbl1.TableName = "Model22"; var dtset = new DataSet(); dtset.Tables.Add(tbl1.Copy()); modelprint.DataSource = dtset; modelprint.Landscape = true; //var pagecount = modelprint.Pages.Count; //XtraMessageBox.Show(string.Format("You are about to print {0} pages!", pagecount), "Success", MessageBoxButtons.OK, // MessageBoxIcon.Information); modelprint.ShowPreviewDialog(); }
private void cbMonth_SelectedIndexChanged(object sender, EventArgs e) { if (cbMonth.SelectedItem != null && cbYear.SelectedItem != null && lkAccount.EditValue != null && listBoxControl1.SelectedItem.ToString().Equals("Issued Amount by Month")) { IssuedAmoutPerMonth issueAmountReport = new IssuedAmoutPerMonth(CurrentContext.LoggedInUserName); issueAmountReport.DataSource = IssueDoc.IssueAmountByPaymentType(Convert.ToInt32(cbMonth.SelectedIndex + 1), Convert.ToInt32(cbYear.SelectedItem), Convert.ToInt32(lkAccount.EditValue), Convert.ToBoolean(checbySellingPrice.Checked)); issueAmountReport.xrMonth.Text = string.Format("{0} {1}", cbMonth.SelectedItem, cbYear.SelectedItem); printControl1.PrintingSystem = issueAmountReport.PrintingSystem; report = issueAmountReport; issueAmountReport.CreateDocument(); } else if (cbMonth.SelectedItem != null && cbYear.SelectedItem != null && lkAccount.EditValue != null && listBoxControl1.SelectedItem.ToString().Equals("Received Amount by Month")) { ReceivedAmoutPerMonth receivedAmountReport = new ReceivedAmoutPerMonth(CurrentContext.LoggedInUserName); receivedAmountReport.DataSource = ReceiveDoc.ReceivedAmountByReason(Convert.ToInt32(cbMonth.SelectedIndex + 1), Convert.ToInt32(cbYear.SelectedItem), Convert.ToInt32(lkAccount.EditValue)); receivedAmountReport.xrMonth.Text = string.Format("{0} {1}", cbMonth.SelectedItem, cbYear.SelectedItem); printControl1.PrintingSystem = receivedAmountReport.PrintingSystem; report = receivedAmountReport; receivedAmountReport.CreateDocument(); } else if (cbMonth.SelectedItem != null && lkMode.EditValue != null && cbYear.SelectedItem != null && listBoxControl1.SelectedItem.ToString().Equals("Cost of Good Sold")) { CostOfGoodSold costOfGoodSold = new CostOfGoodSold(CurrentContext.LoggedInUserName); costOfGoodSold.DataSource = IssueDoc.CostOfSales(Convert.ToInt32(cbMonth.SelectedIndex + 1), Convert.ToInt32(cbYear.SelectedItem), Convert.ToInt32(lkMode.EditValue)); costOfGoodSold.xrMonth.Text = string.Format("{0} {1}", cbMonth.SelectedItem, cbYear.SelectedItem); printControl1.PrintingSystem = costOfGoodSold.PrintingSystem; report = costOfGoodSold; costOfGoodSold.CreateDocument(); } else if (lkMode.EditValue != null && lkCategories.EditValue != null && cbMonth.SelectedItem != null && cbYear.SelectedItem != null && cbToYear.SelectedItem != null && cbToMonth.SelectedItem != null && listBoxControl1.SelectedItem.ToString().Equals("Vital Report")) { LadVitalItemReport(); } }
private void cboStores_EditValueChanged(object sender, EventArgs e) { if (cboStores.EditValue != null) { IssueDoc iss = new IssueDoc(); //TODO: To be implemented // DataTable dtRec = iss.GetDistinctIssueDocments(Convert.ToInt32(cboStores.EditValue)); // /*PopulateDocument(dtRec);*/lstTree.DataSource = dtRec; // DateTime dt1 = new DateTime(); // DateTime dt2 = new DateTime(); // CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx(); // dtDate.Value = DateTime.Now; // dtDate.CustomFormat = "MM/dd/yyyy"; // DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text); // int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1); // dt1 = new DateTime(yr, 11, 1); // dt2 = new DateTime(dtCurrent.Year, dtCurrent.Month, dtCurrent.Day); // dtRec = iss.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2); // lblIssDate.Text = "Current Year"; //gridIssues.DataSource = dtRec; } }
private void unconfirmedMenuClicked_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { DataRow dataRow = gridUnconfirmedView.GetFocusedDataRow(); if (dataRow != null) { if (e.ClickedItem.Text == "Delete") { if (DialogResult.Yes == XtraMessageBox.Show("Are you sure you would like to delete this?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { DeleteIssueDoc(Convert.ToInt32(dataRow["ID"])); // Refresh it gridViewReferences_FocusedRowChanged(null, null); //XtraMessageBox.Show("Issue has been deleted"); } } else if (e.ClickedItem.Text == "Confirm") { IssueDoc doc = new IssueDoc(); doc.LoadByPrimaryKey(Convert.ToInt32(dataRow["ID"])); // do some validations if (doc.IsColumnNull("STVID")) { doc.STVID = _stvLogIdChosen.Value; doc.Save(); } // refresh XtraMessageBox.Show("You have confirmed the STV", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); gridViewReferences_FocusedRowChanged(null, null); } } }
private void BtnOutstandingTransactions_Click(object sender, EventArgs e) { var xreport = new OutstandingTransactions(CurrentContext.LoggedInUserName); var ds = new DataSet(); ds.Tables.Add(ReceiveDoc.GetOutstandingReceives()); ds.Tables[0].TableName = "OutstandingReceives"; ds.Tables.Add(IssueDoc.GetOutstandingIssues()); ds.Tables[1].TableName = "OutstandingIssues"; ds.Tables.Add(ReceiveDoc.GetOutstandingVoidRequestGRV()); ds.Tables[2].TableName = "OutstandingGRVVoidRequest"; ds.Tables.Add(IssueDoc.GetOutstandingRequestedVoidForInvoice()); ds.Tables[3].TableName = "OutstandingInvoiceVoidRequest"; ds.Tables.Add(IssueDoc.OutstandingIssuedDeliveryNote()); ds.Tables[4].TableName = "OutstandingIssuedDeliveryNote"; ds.Tables.Add(ReceiveDoc.GetOutstandingTransfer(ReceiptType.CONSTANTS.ACCOUNT_TO_ACCOUNT_TRANSFER)); ds.Tables[5].TableName = "OutstandingAccountToAccountTransfer"; ds.Tables.Add(ReceiveDoc.GetOutstandingTransfer(ReceiptType.CONSTANTS.STORE_TO_STORE_TRANSFER)); ds.Tables[6].TableName = "OutstandingStoreToStoreTransfer"; ds.Tables.Add(ReceiveDoc.GetOutstandingReceiveDeliveryNote()); ds.Tables[7].TableName = "OutstandingReceivedDeliveryNote"; xreport.DataSource = ds; xreport.ShowPreview(); }
private void btnUpdate_Click(object sender, EventArgs e) { var isd = new IssueDoc(); DataTable dtbl = isd.GetTransactionByRefNo(_refno); if (isd.RowCount > 0) { foreach (DataRow datarow in dtbl.Rows) { datarow["RefNo"] = txtRefNo.Text; datarow["Date"] = txtDate.Text; } isd.Save(); Close(); XtraMessageBox.Show("Refrence No and Date is successfully updated", "Success"); } else { XtraMessageBox.Show("There is no refrence no to edit"); return; } this.Close(); }
/// <summary> /// Tops the item receivers. /// </summary> /// <param name="itemID">The item ID.</param> /// <returns></returns> public static DataTable TopItemReceivers(int itemID) { IssueDoc issueDoc = new IssueDoc(); var query = HCMIS.Repository.Queries.IssueDoc.SelectTopItemReceivers(itemID); issueDoc.LoadFromRawSql(query); return issueDoc.DataTable; }
private void gridView4_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { DataRow dataRow = gridView4.GetFocusedDataRow(); if (dataRow != null) { // do the thing here. gridTopItemReceivingFacilities.DataSource = chartControl1.Series[0].DataSource = IssueDoc.TopItemReceivers(Convert.ToInt32(dataRow["ID"])); } }
public static DataView IssuedAmoutByYear(int ethiopianYear, int accountID, bool showBySellingPrice) { IssueDoc issueDoc = new IssueDoc(); string query; if (showBySellingPrice) { query = HCMIS.Repository.Queries.IssueDoc.SelectIssuedAmoutByYearShowBySellingPrice(ethiopianYear, accountID); } else { query = HCMIS.Repository.Queries.IssueDoc.SelectIssuedAmoutByYear(ethiopianYear, accountID); } issueDoc.LoadFromRawSql(query); return issueDoc.DefaultView; }
public static DataTable GetOutstandingRequestedVoidForInvoice(int warehouseID = 0) { string query = HCMIS.Repository.Queries.IssueDoc.SelectGetOutstandingRequestedVoidForInvoice(warehouseID, OrderStatus.Constant.ORDER_APPROVED, OrderStatus.Constant.ISSUED); IssueDoc issueDoc = new IssueDoc(); issueDoc.LoadFromRawSql(query); return issueDoc.DataTable; }
/// <summary> /// Returns issue summary Date against value /// </summary> /// <param name="days">For the past how many days (Enter -1 for all)</param> /// <returns></returns> public static object GetIssueSummary(int days) { //For use in the dashboard primarily string query; if (days == -1) query = HCMIS.Repository.Queries.IssueDoc.SelectGetIssueSummary(); else query = HCMIS.Repository.Queries.IssueDoc.SelectGetIssueSummary(days); IssueDoc iss = new IssueDoc(); iss.LoadFromRawSql(query); return iss.DefaultView; }
/// <summary> /// Returns IssueDoc history for a receiving unit /// Columns: ID,Date(Converted to Ethiopian),Quantity,FullItemName /// </summary> /// <param name="receivingUnitID">The receiving unit ID.</param> /// <param name="startDate">In European Calendar</param> /// <param name="endDate">In European Calendar</param> /// <returns></returns> public static object GetIssueHistoryForFacility(int receivingUnitID, DateTime startDate, DateTime endDate) { var query = HCMIS.Repository.Queries.IssueDoc.SelectGetIssueHistoryForFacility(receivingUnitID, startDate, endDate); IssueDoc issD = new IssueDoc(); issD.LoadFromRawSql(query); return DateTimeHelper.AddEthiopianDateField(issD).DefaultView; }
public static DataTable OutstandingIssuedDeliveryNote(int warehouseID = 0) { string query = HCMIS.Repository.Queries.IssueDoc.SelectOutstandingIssuedDeliveryNote(warehouseID, OrderStatus.Constant.ORDER_APPROVED, OrderStatus.Constant.ISSUED); IssueDoc issueDoc = new IssueDoc(); issueDoc.LoadFromRawSql(query); return issueDoc.DataTable; }
public static void RecordDiscrepancy(Dictionary<int, decimal> _discrepancyIssueDoc) { foreach(int issueDocID in _discrepancyIssueDoc.Keys) { BLL.IssueDoc issueDoc = new IssueDoc(); issueDoc.LoadByPrimaryKey(issueDocID); issueDoc.NoOfPackIssued = _discrepancyIssueDoc[issueDocID]; issueDoc.Save(); } }
/// <summary> /// Saves the whole transaction for /// </summary> /// <param name="orderID">The order ID.</param> /// <param name="dvOutstandingPickList">The dv outstanding pick list.</param> /// <param name="remark">The remark.</param> /// <param name="issuedBy">The issued by.</param> /// <param name="etCurrentDate">The et current date.</param> /// <returns></returns> /// <exception cref="System.Exception"></exception> public static Order SaveIssueTransaction(int orderID, ref DataView dvOutstandingPickList, string remark, string issuedBy, DateTime etCurrentDate) { // Add the IssueDocID field dvOutstandingPickList.Table.Columns.Add("IssueDocID"); PickList plst = new PickList(); IssueDoc issDoc = new IssueDoc(); ReceiveDoc recDoc = new ReceiveDoc(); BLL.Order ord = new BLL.Order(); ord.LoadByPrimaryKey(orderID); plst.LoadByOrderID(ord.ID); foreach (DataRowView drv in dvOutstandingPickList) { // Pseudo: // for each row in the picklist // undate the issue document // subtract the issued quantity from the receive doc // subtract the issued quantity from recieve pallet // subtract the issued the reserved quantity irregardless of the quantity issued. //Saving the new Issue issue if (Convert.ToDecimal(drv["BUPICKED"]) == 0) { continue; } if (Convert.ToDecimal(drv["SKUPicked"]) != Convert.ToDecimal(drv["SKUTOPICK"])) { drv["Cost"] = Convert.ToDecimal(drv["SKUPicked"]) * Convert.ToDecimal(drv["UnitPrice"]); } // Select the receive doc that is associated with this issue. recDoc.LoadByPrimaryKey(Convert.ToInt32(drv["ReceiveDocID"])); issDoc.AddNew(); issDoc.StoreId = Convert.ToInt32(drv["StoreID"]); issDoc.RefNo = ord.RefNo; if (!ord.IsColumnNull("RequestedBy")) issDoc.ReceivingUnitID = ord.RequestedBy; // TOFIX: // TODO: // Lord have mercy kind of hack to avoid the feb date problem // this needs to be fixed for pagume also issDoc.Date = etCurrentDate; issDoc.EurDate = DateTimeHelper.ServerDateTime; issDoc.RecievDocID = Convert.ToInt32(drv["ReceiveDocID"]); issDoc.IsApproved = true; issDoc.IsTransfer = false; issDoc.Remark = remark; issDoc.ItemID = Convert.ToInt32(drv["ItemID"]); issDoc.Quantity = Convert.ToDecimal(drv["BUPICKED"]); issDoc.NoOfPack = Convert.ToDecimal(drv["SKUPICKED"]); issDoc.QtyPerPack = Convert.ToInt32(drv["SKUBU"]); issDoc.BatchNo = drv["BatchNumber"].ToString(); issDoc.UnitID = recDoc.UnitID; issDoc.ManufacturerID = recDoc.ManufacturerId; if (drv["Cost"] != DBNull.Value) { issDoc.Cost = Convert.ToDouble(drv["Cost"]); issDoc.SellingPrice = Convert.ToDecimal(drv["UnitPrice"]); if (!recDoc.IsColumnNull("Cost")) { issDoc.UnitCost = Convert.ToDecimal(recDoc.Cost); } } issDoc.OrderID = orderID; issDoc.IssuedBy = issuedBy; // TODO: is this the right place where we need to pick the physical store ID from? // check it against the receipt pallet physical store. if (!recDoc.IsColumnNull("PhysicalStoreID")) { issDoc.PhysicalStoreID = recDoc.PhysicalStoreID; } if (!recDoc.IsColumnNull("InventoryPeriodID")) { //Todo: Remove for Inventory issDoc.InventoryPeriodID = recDoc.InventoryPeriodID; } if (!recDoc.IsColumnNull("Margin")) { issDoc.Margin = (decimal)recDoc.Margin; } //Replaced by issDoc.PLDetailID = Convert.ToInt32(drv["PLDetailID"]); BLL.Balance bal = new Balance(); BLL.ReceiveDoc rd = new ReceiveDoc(); rd.LoadByPrimaryKey(issDoc.RecievDocID); decimal currentBalance = bal.GetSoh(issDoc.ItemID, rd.UnitID, issDoc.StoreId, issDoc.Date.Month, issDoc.Date.Year); if (currentBalance < issDoc.NoOfPack) { throw new Exception(string.Format("The item {0} is not available in {1} Qty.", drv["FullItemName"].ToString(), issDoc.NoOfPack)); } // This is a field that is not applicable on the hub edition // It is about the dispensing unit quantity and there is no such thing as Dispensing unit // in the hub edition issDoc.DUSOH = 0; issDoc.RecomendedQty = 0;// ((recQty > 0) ? Convert.ToInt64(recQty) : 0); // End DU issDoc.DispatchConfirmed = false; issDoc.Save(); drv["IssueDocID"] = issDoc.ID; // updating the receiving doc //long prevQuantityLeft = recDoc.QuantityLeft; recDoc.QuantityLeft = recDoc.QuantityLeft - issDoc.Quantity; if (recDoc.QuantityLeft < 0) { //Possibly the wrong ReceiveDoc Entry chosen BLL.Item itm = new Item(); itm.LoadByPrimaryKey(recDoc.ItemID); throw new Exception(string.Format("Quantity problem detected for the item {0}", itm.FullItemName)); } //long recDoc.Out = (recDoc.QuantityLeft == 0) ? true : false; recDoc.Save(); ReceivePallet rp = new ReceivePallet(); int id = Convert.ToInt32(drv["ReceivePalletID"]); rp.LoadByPrimaryKey(id); if (rp.IsColumnNull("Balance")) { rp.Balance = rp.ReceivedQuantity; } rp.Balance -= issDoc.Quantity; if (rp.Balance < 0) { BLL.Item itm = new Item(); itm.LoadByPrimaryKey(recDoc.ItemID); throw new Exception(string.Format("Quantity problem detected for the item {0}", itm.FullItemName)); } decimal totReservedQty = Convert.ToDecimal(drv["QuantityInBU"]); if (rp.IsColumnNull("ReservedStock")) rp.ReservedStock = 0; rp.ReservedStock -= totReservedQty; if (rp.ReservedStock < 0) //If there has been a quantity problem somewhere rp.ReservedStock = 0; rp.Save(); } plst.IsConfirmed = true; ord.ChangeStatus(OrderStatus.Constant.ISSUED, CurrentContext.UserId); plst.Save(); ord.Save(); return ord; }
/// <summary> /// Gets the weekly transaction summary. /// </summary> /// <param name="days">-1 for all</param> /// <returns></returns> public static DataView GetWeeklyTransactionSummary(int days) { string query; if (days == -1) query = HCMIS.Repository.Queries.IssueDoc.SelectGetWeeklyTransactionSummary(); else query = HCMIS.Repository.Queries.IssueDoc.SelectGetWeeklyTransactionSummary(days); IssueDoc issueDoc = new IssueDoc(); issueDoc.LoadFromRawSql(query); return issueDoc.DefaultView; }
public IssueDoc CreateIssueFromPicklist(PickListDetail picklistDetail,Order order,DateTime convertedEthDate,Issue stvLog,User user) { ReceivePallet receivePallet = new ReceivePallet(); receivePallet.LoadByPrimaryKey(picklistDetail.ReceivePalletID); ReceiveDoc receiveDoc = new ReceiveDoc(); receiveDoc.LoadByPrimaryKey(receivePallet.ReceiveID); IssueDoc issueDoc = new IssueDoc(); issueDoc.AddNew(); issueDoc.BatchNo = picklistDetail.BatchNumber; if(!picklistDetail.IsColumnNull("Cost")) issueDoc.Cost = picklistDetail.Cost; issueDoc.Date = convertedEthDate; issueDoc.EurDate = DateTimeHelper.ServerDateTime; issueDoc.StoreId = picklistDetail.StoreID; issueDoc.STVID = stvLog.ID; issueDoc.IsTransfer = true; issueDoc.IssuedBy = user.FullName; issueDoc.ItemID = picklistDetail.ItemID; issueDoc.NoOfPack = picklistDetail.Packs; issueDoc.QtyPerPack = picklistDetail.QtyPerPack; issueDoc.Quantity = picklistDetail.QuantityInBU; issueDoc.OrderID = order.ID; issueDoc.UnitID = receiveDoc.UnitID; issueDoc.ManufacturerID = receiveDoc.ManufacturerId; issueDoc.SetColumn("UnitCost" ,receiveDoc.GetColumn("Cost")); issueDoc.SetColumn("SellingPrice" ,receiveDoc.GetColumn("SellingPrice")); issueDoc.SetColumn("Margin", receiveDoc.GetColumn("Margin")); issueDoc.SetColumn("PhysicalStoreID", receiveDoc.GetColumn("PhysicalStoreID")); issueDoc.PLDetailID = picklistDetail.ID; issueDoc.RecievDocID = picklistDetail.ReceiveDocID; issueDoc.SetColumn("InventoryPeriodID", receiveDoc.GetColumn("InventoryPeriodID")); // This is a deprecated field issueDoc.RecomendedQty = 0;// picklistDetail.Packs; issueDoc.RefNo = stvLog.IDPrinted.ToString(); issueDoc.DispatchConfirmed = false; issueDoc.Save(); //substract from QuantityLeft receiveDoc.QuantityLeft -= picklistDetail.QuantityInBU; if(receiveDoc.QuantityLeft < 0) { receiveDoc.QuantityLeft = 0; } receiveDoc.Save(); receivePallet.Balance -= picklistDetail.QuantityInBU; if(receivePallet.Balance < 0) { receivePallet.Balance=0; } receivePallet.ReservedStock -= picklistDetail.Packs; if(receivePallet.ReservedStock < 0) { receivePallet.ReservedStock = 0; } receivePallet.Save(); return issueDoc; }