/// <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 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); }
/// <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> /// 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); } }
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(); gridItemChoiceView.Columns["InternalDrugCode"].Visible = Convert.ToBoolean(chkIntDrugCode.EditValue); }
/// <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 unit = new ItemUnit(); var units = unit.GetAllUnits(); UnitsbindingSource.DataSource = units.DefaultView; ((GridView)receivingGrid.MainView).Columns[13].Visible = false; PopulateStore(); PopulateSupplier(); 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); // Bind the grid with only active items Items itm = new Items(); //DataTable dtItem = itm.GetAllItems(1); // DataTable dtItem = BLL.Items.GetActiveItemsByCommodityType(0); DataTable dtItem = BLL.Items.GetActiveItemsByCommodityTypeids(typeids); // lkCategories.Properties.DataSource = BLL.Type.GetAllTypes(); lkCategories.Properties.DataSource = dt; 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; if (Common.IsInventoryPeriod()) { btnSave.Enabled = false; } else { btnSave.Enabled = true; } }
/// <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 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> /// Loads the form and loads the lookups and the grid /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ManageItems_Load(object sender, EventArgs e) { CALENDAR: PopulateCatTree(_selectedType); Stores stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes(); // lkCommodityTypes.ItemIndex = 0; string[] arr = new string[] { "All", "Stock Out", "Below EOP", "Near EOP", "Normal", "Over Stocked" }; cboStatus.Properties.DataSource = arr; var itemunit = new ItemUnit(); var allunits = itemunit.GetAllUnits(); unitBindingSource.DataSource = allunits.DefaultView; var 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); int year = _dtCur.Year; // this is just a try //if (currentMont >= 11) //{ // currentMont -= 11; //} var unitcolumn = ((GridView)gridItemsChoice.MainView).Columns[17]; switch (VisibilitySetting.HandleUnits) { case 1: unitcolumn.Visible = false; break; case 2: unitcolumn.Visible = true; break; default: unitcolumn.Visible = true; break; } DataTable dtyears = Items.AllYears(); //if (year == _dtCur.Year + 1) //{ // object[] objYear = { year }; // dtyears.Rows.Add(objYear); //} cboYear.Properties.DataSource = dtyears; cboYear.EditValue = year; if (cboYear.Properties.Columns.Count > 0) { cboYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near; } Programs prog = new Programs(); 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"; ReceivingUnits rec = new ReceivingUnits(); DataTable drRec = rec.GetAllApplicableDU(); cboIssuedTo.Properties.DataSource = drRec; cboIssuedTo.ItemIndex = -1; cboIssuedTo.Text = "Select Issue Location"; this._isReady = true; PopulateGrid(); }
private void ManageItems_Load(object sender, EventArgs e) { var usr = new User(); var userID = MainWindow.LoggedinId; usr.LoadByPrimaryKey(userID); if (usr.UserType == 1) { contextMenuStrip1.Enabled = false; } //var stor = new Stores(); //stor.GetActiveStores(); //cboStores.Properties.DataSource = stor.DefaultView; UserStore ucs = new UserStore(); DataTable dt = ucs.GetUserStore(MainWindow.LoggedinId); cboStores.Properties.DataSource = dt; 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 grdLogReceive.Columns["InternalDrugCode"].Visible = Convert.ToBoolean(chkIntDrugCode.EditValue); try { var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode); if (dr == null) { return; } var rec = new ReceiveDoc(); var supplier = new Supplier(); 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> /// 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 usr = new User(); var userID = MainWindow.LoggedinId; usr.LoadByPrimaryKey(userID); if (usr.UserType == 1) { contextMenuStrip1.Enabled = false; } GeneralInfo gn = new GeneralInfo(); gn.LoadAll(); _priceRate = gn.IsColumnNull("PriceRate") ? 0 : Convert.ToDouble(gn.PriceRate); _usesModel = gn.IsColumnNull("UsesModel") ? false : gn.UsesModel; _printedby = usr.FullName; layoutPrintModel.Visibility = _usesModel ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never; 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(); UserStore ucs = new UserStore(); DataTable dt = ucs.GetUserStore(MainWindow.LoggedinId); //cboStores.Properties.DataSource = stor.DefaultView; cboStores.Properties.DataSource = dt; 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; grdLogIssue.ActiveFilterString = String.Format("Quantity<>0"); } catch (Exception ex) { // do nothing } grdLogIssue.Columns["InternalDrugCode"].Visible = Convert.ToBoolean(chkIntDrugCode.EditValue); }
/// <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(); UserStore ust = new UserStore(); DataTable dtt = ust.GetUserStore(MainWindow.LoggedinId); cboStores.Properties.DataSource = dtt; // cboStores.Properties.DataSource = stor.DefaultView; //lkCategories.Properties.DataSource = BLL.Type.GetAllTypes(); UserCommodityType ucs = new UserCommodityType(); DataTable dt = ucs.GetUserCommodityType(MainWindow.LoggedinId); lkCategories.Properties.DataSource = dt; var unit = new ItemUnit(); var allunits = unit.GetAllUnits(); unitsbindingSource.DataSource = allunits.DefaultView; var disRes = new DisposalReasons(); var allreasons = disRes.GetAllReasons(); reasonBindingSource.DataSource = allreasons.DefaultView; lkReason.Properties.DataSource = allreasons; 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); } if (Common.IsInventoryPeriod()) { btnSave.Enabled = false; } else { btnSave.Enabled = true; } ((GridView)AdjustmentGrid.MainView).Columns[11].Visible = false; ((GridView)AdjustmentGrid.MainView).Columns[12].Visible = false; }
private void ManageItems_Load(object sender, EventArgs e) { PopulateCatTree(SelectedType); var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; cboStores.ItemIndex = 0; DataTable table = BLL.Type.GetAllTypes(); DataRow row = table.NewRow(); row["ID"] = "0"; row["Name"] = "All"; table.Rows.InsertAt(row, 0); lkCommodityTypes.Properties.DataSource = table; lkCommodityTypes.ItemIndex = 0; var itemunit = new ItemUnit(); var allunits = itemunit.GetAllUnits(); unitBindingSource.DataSource = allunits.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(); if (filter == "Stock Out") { ckExclude.Visible = true; } else if (filter == "Over Stocked") { gridItemChoiceView.Columns.RemoveAt(14);//remove DOS column ckExclude.Hide(); ckExclude.Enabled = false; } }