private void RRFForm_Load(object sender, EventArgs e) { btnAutoPushToPFSA.Enabled = false; btnSendEmergencyOrder.Enabled = false; var unitcolumn = ((GridView) gridItemsChoice.MainView).Columns[2]; var unitcolumn1 = ((GridView) gridItemsChoice.MainView).Columns[13]; layoutControlItem18.Visibility =LayoutVisibility.Never; switch (VisibilitySetting.HandleUnits) { case 3: unitcolumn.Visible = false; unitcolumn1.Visible = true; break; case 2: unitcolumn.Visible = false; unitcolumn1.Visible = true; break; default: unitcolumn.Visible = true; unitcolumn1.Visible = false; break; } var unit = new ItemUnit(); var units = unit.GetAllUnits(); unitsBindingSource.DataSource = units.DefaultView; var type = new BLL.Type(); var alltypes = type.GetAllCategory(); categorybindingSource.DataSource = alltypes.DefaultView; var program = new Programs(); var programs = program.GetSubPrograms(); cboProgram.Properties.DataSource = programs; cboProgram.Properties.DisplayMember = "Name"; cboProgram.Properties.ValueMember = "ID"; var orderstatus = new PharmInventory.HelperClasses.OrderStatus(); orderbindingSource.DataSource = orderstatus.GetRRFOrders(); lkorderstatus.Properties.DataSource = orderbindingSource; lkorderstatus.Properties.ValueMember = "RecordId"; lkorderstatus.Properties.DisplayMember = "Name"; PopulateTheMonthCombos(cboFromMonth); PopulateTheMonthCombos(cboToMonth); PopulateTheYearCombo(cboFromYear); PopulateTheYearCombo(cboToYear); var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; PopulateRRFs(); WindowVisibility(false); EnableDisableStatusCheck(); var prog = new Programs(); prog.GetSubPrograms(); cboProgram.Properties.DataSource = prog.DefaultView; cboProgram.EditValue = 1000; }
/// <summary> /// The save button should be active only when the date is Sene 30 or in the month of Hamle. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void YearEndProcess_Load(object sender, EventArgs e) { var ethDate = new EthiopianDate.EthiopianDate(); lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes(); lkCommodityTypes.ItemIndex = 0; btnSave.Enabled = false; var unit = new ItemUnit(); var allunits = unit.GetAllUnits(); unitBindingSource.DataSource = allunits.DefaultView; var unitcolumn = ((GridView)grdYearEnd.MainView).Columns[9]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } var str = new Stores(); str.GetActiveStores(); cboStores.Properties.DataSource = str.DefaultView; cboStores.ItemIndex = 0; dtDate.CustomFormat = "MMMM dd, yyyy"; }
private void ManageItems_Load(object sender, EventArgs e) { PopulateCatTree(SelectedType); lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes(); lkCommodityTypes.ItemIndex = 0; var itemunit = new ItemUnit(); var allunits = itemunit.GetAllUnits(); unitBindingSource.DataSource = allunits.DefaultView; var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; string[] arr = {"All", "Stock Out", "Below EOP", "Near EOP", "Normal", "Over Stocked"}; cboStatus.Properties.DataSource = arr; DataTable dtMonths = new DataTable(); dtMonths.Columns.Add("Value"); dtMonths.Columns.Add("Month"); dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; dtCur = ConvertDate.DateConverter(dtDate.Text); int currentMont = dtCur.Month; int year = ((currentMont < 11) ? dtCur.Year : dtCur.Year + 1); // this is just a try if (currentMont >= 11) { currentMont -= 11; } var dtyears = Items.AllYears(); cboYear.Properties.DataSource = dtyears; cboYear.EditValue = year; if (cboYear.Properties.Columns.Count > 0) cboYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near; var prog = new Programs(); var dtProg = new DataTable(); dtProg = prog.GetSubPrograms(); object[] objProg = { 0, "All Programs", "", 0, "" }; dtProg.Rows.Add(objProg); cboSubProgram.Properties.DataSource = dtProg; cboSubProgram.ItemIndex = -1; cboSubProgram.Text = "Select Program"; var rec = new ReceivingUnits(); var drRec = rec.GetAllApplicableDU(); cboIssuedTo.Properties.DataSource = drRec; cboIssuedTo.ItemIndex = -1; cboIssuedTo.Text = "Select Issue Location"; IsReady = true; var unitcolumn = ((GridView)gridItemsChoice.MainView).Columns[15]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } PopulateGrid(); }
/// <summary> /// Load the loookups /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ManageItems_Load(object sender, EventArgs e) { var unitcolumn = ((GridView) gridInventory.MainView).Columns[7]; unitcolumn.Visible = VisibilitySetting.HandleUnits != 1; var stor = new Stores(); var unit = new ItemUnit(); var allunit = unit.GetAllUnits(); unitbindingSource.DataSource = allunit.DefaultView; stor.GetActiveStores(); cboStores.DataSource = stor.DefaultView; }
/// <summary> /// Populate the lookups and item lists. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ReceiveingForm_Load(object sender, EventArgs e) { //gridRecieveView.Columns[4].Visible = VisibilitySetting.HandleUnits; var UnitColumn = ((GridView)receivingGrid.MainView).Columns[12]; var UnitColumn1 = ((GridView)receivingGrid.MainView).Columns[5]; var UnitColumn2 = ((GridView)gridItemsChoice.MainView).Columns[4]; var qtyperpack = ((GridView)receivingGrid.MainView).Columns[3]; var buqty = ((GridView)receivingGrid.MainView).Columns[4]; switch (VisibilitySetting.HandleUnits) { case 3: UnitColumn.Visible = true; UnitColumn1.Visible = false; UnitColumn2.Visible = false; qtyperpack.Visible = false; buqty.Visible = false; break; case 2: UnitColumn.Visible = true; UnitColumn1.Visible = false; UnitColumn2.Visible = false; qtyperpack.Visible = false; buqty.Visible = false; break; case 1: UnitColumn.Visible = false; UnitColumn1.Visible = true; qtyperpack.Visible = true; UnitColumn2.Visible = true; buqty.Visible = true; break; } var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; cboStores.ItemIndex = 0; Programs prog = new Programs(); DataTable dtProg = prog.GetSubPrograms(); cboProgram.Properties.DataSource = dtProg; cboProgram.Properties.DisplayMember = "Name"; cboProgram.Properties.ValueMember = "ID"; var unit = new ItemUnit(); var units = unit.GetAllUnits(); UnitsbindingSource.DataSource = units.DefaultView; Supplier sup = new Supplier(); DataTable dtSup = new DataTable(); sup.GetActiveSuppliers(); dtSup = sup.DefaultView.ToTable(); cboSuppliers.DataSource = dtSup; cboSupplier.Properties.DataSource = sup.DefaultView; cboSuppliers.Text = "Select Supplier"; cboSuppliers.ValueMember = "ID"; cboSuppliers.DisplayMember = "CompanyName"; // Bind the grid with only active items Items itm = new Items(); //DataTable dtItem = itm.GetAllItems(1); DataTable dtItem = BLL.Items.GetActiveItemsByCommodityType(0); lkCategories.Properties.DataSource = BLL.Type.GetAllTypes(); lkCategories.ItemIndex = 0; PopulateItemList(dtItem); selectedType = radioGroup1.EditValue.ToString(); PopulateCatTree(selectedType); int userID = MainWindow.LoggedinId; User us = new User(); us.LoadByPrimaryKey(userID); txtReceivedBy.Text = us.FullName; // bind the current date as the datetime field dtRecDate.Value = DateTime.Now; }
private void TransferForm_Load(object sender, EventArgs e) { var store = new Stores(); store.GetActiveStores(); lkFromStore.Properties.DataSource = store.DefaultView; lkCategories.Properties.DataSource = BLL.Type.GetAllTypes(); var units = new ItemUnit(); var allunits = units.GetAllUnits(); unitBindingSource.DataSource = allunits.DefaultView; lkToStore.Properties.DataSource = store.DefaultView; var unitcolumn0 = ((GridView)gridItemsChoice.MainView).Columns[7]; var unitcolumn1 = ((GridView)gridItemsChoice.MainView).Columns[2]; var unitcolumn2 = ((GridView)receivingGrid.MainView).Columns[4]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn0.Visible = false; unitcolumn1.Visible = true; unitcolumn2.Visible = false; break; case 2: unitcolumn0.Visible = true; unitcolumn1.Visible = false; unitcolumn2.Visible = true; break; default: unitcolumn0.Visible = true; unitcolumn1.Visible = false; unitcolumn2.Visible = true; break; } lkCategories.ItemIndex = 0; lkFromStore.ItemIndex = 0; var userID = MainWindow.LoggedinId; var us = new User(); us.LoadByPrimaryKey(userID); txtApprovedBy.Text = us.FullName; // bind the current date as the datetime field dtRecDate.Value = DateTime.Now; gridItemsView.ActiveFilterString = String.Format("[ExpiryDate] > #{0}# ", DateTime.Now); }
private void ManageItems_Load(object sender, EventArgs e) { PopulateCatTree(SelectedType); lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes(); lkCommodityTypes.ItemIndex = 0; var itemunit = new ItemUnit(); var allunits = itemunit.GetAllUnits(); unitBindingSource.DataSource = allunits.DefaultView; var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; DataTable dtMonths = new DataTable(); dtMonths.Columns.Add("Value"); dtMonths.Columns.Add("Month"); dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; dtCur = ConvertDate.DateConverter(dtDate.Text); int currentMont = dtCur.Month; int year = ((currentMont < 11) ? dtCur.Year : dtCur.Year + 1); // this is just a try if (currentMont >= 11) { currentMont -= 11; } var dtyears = Items.AllYears(); cboStores.ItemIndex = 0; cboYear.Properties.DataSource = dtyears; cboYear.EditValue = year; if (cboYear.Properties.Columns.Count > 0) cboYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near; IsReady = true; PopulateGrid(); }
private void ManageItems_Load(object sender, EventArgs e) { var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; cboStores.ItemIndex = 0; var sup = new Supplier(); var dtSup = sup.GetSuppliersWithTransaction(); cboSupplier.Properties.DataSource = dtSup; cboSupplier.ItemIndex = -1; cboSupplier.Text = "Select Supplier"; var itemunit = new ItemUnit(); var units = itemunit.GetAllUnits(); unitsbindingSource.DataSource = units.DefaultView; // bind the supplier lookup for the grid. lkEditSupplier.DataSource = dtSup; var unitcolumn = ((GridView)gridReceives.MainView).Columns[14]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } // bind the current dates try { var dr = (DataRowView) lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode); if (dr == null) return; var rec = new ReceiveDoc(); if (dr["ParentID"] == DBNull.Value) { // int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1); var dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1); var dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1); dtRec = rec.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2); lblRecDate.Text = dr["RefNo"].ToString(); } else { dtRec = rec.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue),dr["Date"].ToString()); lblRecDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy"); } gridReceives.DataSource = dtRec; } catch (Exception ex) { } }
/// <summary> /// Load all the stores and put them in the combo box /// Set the logged in user name in the issued by text box. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void IssuingForm_Load(object sender, EventArgs e) { var unitcolumn = ((GridView)gridItemsChoice.MainView).Columns[4]; var unitid = ((GridView)issueGrid.MainView).Columns[14]; var unitcolumn1 = ((GridView)issueGrid.MainView).Columns[2]; var duamc = ((GridView)issueGrid.MainView).Columns[8]; var mrdusoh = ((GridView)issueGrid.MainView).Columns[6]; var recommendedqty = ((GridView)issueGrid.MainView).Columns[9]; var requestedqty = ((GridView)issueGrid.MainView).Columns[12]; var qtyperpack = ((GridView)issueGrid.MainView).Columns[11]; var unitcolumn3 = ((GridView)gridItemsChoice.MainView).Columns[14]; switch (VisibilitySetting.HandleUnits) { case 3: unitcolumn.Visible = false; unitcolumn1.Visible = false; unitid.Visible = true; qtyperpack.Visible = true; mrdusoh.Visible = true; duamc.Visible = true; recommendedqty.Visible = true; duamc.Visible = true; requestedqty.Visible = false; unitcolumn3.Visible = true; break; case 2: unitcolumn.Visible = false; unitcolumn1.Visible = false; unitid.Visible = true; qtyperpack.Visible = true; mrdusoh.Visible = false; recommendedqty.Visible = false; duamc.Visible = false; requestedqty.Visible = false; unitcolumn3.Visible = true; break; default: unitcolumn.Visible = true; unitcolumn1.Visible = true; unitid.Visible = false; qtyperpack.Visible = true; duamc.Visible = true; unitcolumn3.Visible = false; break; } PopulateCatTree(_selectedType); var stor = new Stores(); stor.GetActiveStores(); storebindingSource.DataSource = stor.DefaultView; cboStores.Properties.DataSource = storebindingSource.DataSource; cboStores.ItemIndex = 0; cboStores.Properties.DisplayMember = "StoreName"; cboStores.Properties.ValueMember = "ID"; cboStoreConf.Properties.DataSource = stor.DefaultView; lkCategories.Properties.DataSource = BLL.Type.GetAllTypes(); lkCategories.ItemIndex = 0; var unit = new ItemUnit(); var xx = unit.GetAllUnits(); UnitsbindingSource.DataSource = xx.DefaultView; var userID = MainWindow.LoggedinId; var us = new User(); us.LoadByPrimaryKey(userID); txtIssuedBy.Text = us.FullName; if (!chkExcludeStockedOut.Checked) gridItemChoiceView.ActiveFilterString = String.Format("TypeID={0}", Convert.ToInt32(lkCategories.EditValue)); }
private void BinCardTransaction_Load(object sender, EventArgs e) { DataTable dtyears = Items.AllYears(); dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; _dtCurrent = ConvertDate.DateConverter(dtDate.Text); //CALENDAR: foreach (DataRow drYears in dtyears.Rows) { if (drYears["year"] != DBNull.Value) { int yr = Convert.ToInt32(drYears["year"]); cboYear.Items.Add(yr); } } bool added = true; for (int x = 0; x < cboYear.Items.Count; x++)//to check if the current year is included or not { if (Convert.ToInt64(cboYear.Items[x]) == _year) { added = false; break; } } if (added) { cboYear.Items.Add(_year); } cboYear.SelectedItem = _year; var itemunit = new ItemUnit(); var allunits = itemunit.GetAllUnits(); unitBindingSource.DataSource = allunits.DefaultView; var unitcolumn = ((GridView)gridItemsList.MainView).Columns[11]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } PopulateBinCardYearCombo(); cboFiscalYear.SelectedItem = _year; BLL.Items itm = new Items(); DataTable dtItm = itm.GetItemById(_itemId); string itemName = dtItm.Rows[0]["ItemName"].ToString() + " - " + dtItm.Rows[0]["DosageForm"].ToString() + " - " + dtItm.Rows[0]["Strength"].ToString(); txtItemName.Text = itemName; txtitmName.Text = itemName; toolTip1.SetToolTip(txtitmName, itemName); lblBUnit.Text = dtItm.Rows[0]["Unit"].ToString(); this.Text = itemName + " Detail Report"; ReceivingUnits dus = new ReceivingUnits(); DataTable dtDU = dus.GetApplicableDUs(_itemId, _storeId); Stores stor = new Stores(); stor.LoadByPrimaryKey(_storeId); object[] objS = { 0, stor.StoreName, "", "" }; dtDU.Rows.Add(objS); cboDU.DataSource = dtDU; cboDU.SelectedIndex = (cboDU.Items.Count - 1); cboDU.Text = "Select DU"; try { txtFreeItem.Text = (itm.IsFree) ? "Yes" : "No"; txtRefrigerated.Text = (itm.Refrigeratored) ? "Yes" : "No"; txtPediatric.Text = (itm.Pediatric) ? "Yes" : "No"; } catch { } int du = ((cboDU.SelectedValue != null) ? Convert.ToInt32(cboDU.SelectedValue) : 0); GenerateCharts(0); ItemStockStatus(); //GenerateBinCard(); GenerateBinCardNew(); PopulateTransaction(); tabControl1.SelectedTabPageIndex = _tabInd; _first = 1; lblItemID.Text = _itemId.ToString(); PopulateLogisticSummary(); }
private void LogTransfer_Load(object sender, EventArgs e) { var stor = new Stores(); stor.GetActiveStores(); // lkFromStore.ItemIndex = 0; storeBindingSource.DataSource = stor.DefaultView; var itemunit = new ItemUnit(); var units = itemunit.GetAllUnits(); unitBindingSource.DataSource = units.DefaultView; // bind the supplier lookup for the grid. var unitcolumn = ((GridView)gridControl1.MainView).Columns[4]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } lkToStore.Properties.DataSource = stor.DefaultView; lkToStore.ItemIndex = 0; // bind the current dates try { var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode); if (dr == null) return; var rec = new Transfer(); if (dr["ParentID"] == DBNull.Value) { // int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1); var dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1); var dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1); dtRec = rec.GetTransactionByDateRange(Convert.ToInt32(lkToStore.EditValue), dt1, dt2); lblTransferedDate.Text = dr["RefNo"].ToString(); } else { dtRec = rec.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(lkToStore.EditValue), dr["Date"].ToString()); lblTransferedDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy"); } gridControl1.DataSource = dtRec; } catch (Exception ex) { } }
/// <summary> /// Prepare all lookups /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ManageItems_Load(object sender, EventArgs e) { var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; cboStores.ItemIndex = 0; var rec = new DisposalReasons(); var dtDis = rec.GetAvailableReasons(); cboReasons.Properties.DataSource = dtDis.DefaultView; reasonBindingSource.DataSource = dtDis.DefaultView; // cboReasons.ItemIndex = 0; var itemunit = new ItemUnit(); var units = itemunit.GetAllUnits(); unitbindingSource.DataSource = units.DefaultView; var unitcolumn = ((GridView)gridAdjustments.MainView).Columns[10]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } try { //CALENDAR: var dtDate = new CalendarLib.DateTimePickerEx { CustomFormat = "MM/dd/yyyy", Value = DateTime.Now }; var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode); if (dr == null) return; var disp = new Disposal(); if (dr["ParentID"] == DBNull.Value) { var dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1); var dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1); dtRec = disp.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue),dt1,dt2); lblAdjDate.Text = dr["RefNo"].ToString(); } else { dtRec = disp.GetDocumentByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString()); lblAdjDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy"); } gridAdjustments.DataSource = dtRec; } catch (Exception ex) { } }
/// <summary> /// Populate the lookups /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ManageItems_Load(object sender, EventArgs e) { var rec = new ReceivingUnits(); DataTable drRec = rec.GetAllApplicableDU(); cboIssuedTo.Properties.DataSource = drRec; cboIssuedTo.ItemIndex = -1;//.SelectedIndex = -1; cboIssuedTo.Text = @"Select Issue Location"; var itemunit = new ItemUnit(); var units = itemunit.GetAllUnits(); unitbindingSource.DataSource = units.DefaultView; // populate the receiving unit's lookup edit var rus = new ReceivingUnits(); rus.GetActiveDispensaries(); lkEditReceivingUnis.DataSource = rus.DefaultView; var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; cboStores.ItemIndex = 0; var unitcolumn = ((GridView)gridIssues.MainView).Columns[12]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } try { DataRowView dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode); 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; } catch (Exception ex) { // do nothing } }
/// <summary> /// Load the lookups and the tree /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void LossesAdjustment_Load(object sender, EventArgs e) { var UnitColumn = ((GridView)AdjustmentGrid.MainView).Columns[10]; var UnitColumn1 = ((GridView)gridItemsChoice.MainView).Columns[4]; switch (VisibilitySetting.HandleUnits) { case 2: UnitColumn.Visible = true; UnitColumn1.Visible = false; break; case 1: UnitColumn.Visible = false; UnitColumn1.Visible = true; break; case 3: UnitColumn.Visible = true; UnitColumn1.Visible = false; break; } var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; lkCategories.Properties.DataSource = BLL.Type.GetAllTypes(); var unit = new ItemUnit(); var allunits = unit.GetAllUnits(); unitsbindingSource.DataSource = allunits.DefaultView; var disRes = new DisposalReasons(); var allreasons = disRes.GetAllReasons(); reasonBindingSource.DataSource = allreasons.DefaultView; lkCategories.ItemIndex = 0; cboStores.ItemIndex = 0; dtAdjustDate.Value = DateTime.Now; if (ckExpired.Checked) gridItemChoiceView.ActiveFilterString = String.Format("[ExpiryDate] < #{0}# and [TypeID]={1} and [QuantityLeft] > 0", DateTime.Now, (int)lkCategories.EditValue); }