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> /// 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(); UserCommodityType ucs = new UserCommodityType(); DataTable dt = ucs.GetUserCommodityType(MainWindow.LoggedinId); lkCommodityTypes.Properties.DataSource = dt; 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(); UserStore us = new UserStore(); DataTable dtt = us.GetUserStore(MainWindow.LoggedinId); //cboStores.Properties.DataSource = str.DefaultView; cboStores.Properties.DataSource = dtt; cboStores.ItemIndex = 0; dtDate.CustomFormat = "MMMM dd, yyyy"; }
private void cboStores_EditValueChanged(object sender, EventArgs e) { if (cboStores.EditValue == null) { return; } var rec = new ReceiveDoc(); // dtRec = rec.GetDistinctRecDocments(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); dtRec = rec.GetDistinctRecDocmentbyUsers(Convert.ToInt32(cboStores.EditValue), typeids); PopulateDocuments(dtRec); }
/// <summary> /// Update the form based on the selected user /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void lstUsers_SelectedIndexChanged(object sender, EventArgs e) { if (lstUsers.SelectedItems.Count > 0) { int selected = Convert.ToInt32(lstUsers.SelectedItems[0].Tag); User us = new User(); us.LoadByPrimaryKey(selected); txtFullName.Text = us.FullName; txtAddress.Text = us.Address; txtMobile.Text = us.Mobile; ckActive.Checked = us.Active; cboUserType.SelectedValue = us.UserType.ToString(); _userId = us.ID; grpLoginInfo.Enabled = false; BLL.Type ucType = new BLL.Type(); ucType.LoadAll(); UserCommodityType usc = new UserCommodityType(); DataTable comUser = usc.GetUserCommodityType(_userId); cbCommodity.Properties.DataSource = ucType.DefaultView.ToTable(); cbCommodity.Properties.DisplayMember = "Name"; cbCommodity.Properties.ValueMember = "ID"; string[] arr = new string[comUser.DefaultView.ToTable().Rows.Count]; int index = 0; foreach (DataRow dr in comUser.DefaultView.ToTable().Rows) { arr[index] = Convert.ToString(dr["ID"]); index++; } char separator = cbCommodity.Properties.SeparatorChar; string result = string.Empty; foreach (var element in arr) { result += element + separator; } cbCommodity.SetEditValue(result); UserStore ust = new UserStore(); DataTable storeUser = ust.GetUserStore(_userId); Stores stuser = new Stores(); stuser.LoadAll(); cbStore.Properties.DataSource = stuser.DefaultView; cbStore.Properties.DisplayMember = "StoreName"; cbStore.Properties.ValueMember = "ID"; string[] arrst = new string[storeUser.DefaultView.ToTable().Rows.Count]; int rowindex = 0; foreach (DataRow drs in storeUser.DefaultView.ToTable().Rows) { arrst[rowindex] = Convert.ToString(drs["ID"]); rowindex++; } char separatorst = cbStore.Properties.SeparatorChar; string resultst = string.Empty; foreach (var element in arrst) { resultst += element + separatorst; } cbStore.SetEditValue(resultst); } }
/// <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; } }
private void TransferForm_Load(object sender, EventArgs e) { var store = new Stores(); // store.GetActiveStores(); //lkFromStore.Properties.DataSource = store.DefaultView; UserStore ust = new UserStore(); DataTable dtt = ust.GetUserStore(MainWindow.LoggedinId); lkFromStore.Properties.DataSource = dtt; UserCommodityType ucs = new UserCommodityType(); DataTable dt = ucs.GetUserCommodityType(MainWindow.LoggedinId); lkCategories.Properties.DataSource = dt; // lkCategories.Properties.DataSource = BLL.Type.GetAllTypes(); var units = new ItemUnit(); var allunits = units.GetAllUnits(); unitBindingSource.DataSource = allunits.DefaultView; lkToStore.Properties.DataSource = dtt; 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; } if (Common.IsInventoryPeriod()) { btnSave.Enabled = false; } else { btnSave.Enabled = true; } 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); if (Common.IsInventoryPeriod()) { btnSave.Enabled = false; } else { btnSave.Enabled = true; } }
/// <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; 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; } }