/// <summary> /// Open the detailed information for an item when the user double clicks on the grid. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridItemsChoice_DoubleClick(object sender, EventArgs e) { DataRow dr = gridItemChoiceView.GetFocusedDataRow(); if (dr == null) { return; } int itemId = Convert.ToInt32(dr["ID"]); dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; _dtCur = ConvertDate.DateConverter(dtDate.Text); int month = _dtCur.Month; //int year = (month < 11) ? Convert.ToInt32(cboYear.EditValue) : Convert.ToInt32(cboYear.EditValue); int year = Convert.ToInt32(cboYear.EditValue); EthiopianDate.EthiopianDate ethioDate = new EthiopianDate.EthiopianDate(year, month, 30); //ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0); ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0);//ethioDate.FiscalYear con.ShowDialog(); }
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 lstTree_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { var dtDate = new CalendarLib.DateTimePickerEx { CustomFormat = "MM/dd/yyyy", Value = DateTime.Now }; DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text); var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode); if (dr == null) { return; } var rec = new Transfer(); DataTable dtRec; if (dr["ParentID"] == DBNull.Value) { int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1); DateTime dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1); DateTime 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; }
private void gridItemListView_DoubleClick(object sender, EventArgs e) { GridView view = sender as GridView; if (view == null) { return; } DataRow dr = view.GetFocusedDataRow(); if (dr == null) { return; } dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCur = ConvertDate.DateConverter(dtDate.Text); int month = dtCur.Month; int year = (month < 11) ? dtCur.Year : dtCur.Year + 1; int itemId = Convert.ToInt32(dr["ID"]); //ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0); //con.ShowDialog(); }
private void GeneralReport_Load(object sender, EventArgs e) { Stores stor = new Stores(); DataTable dtStor = stor.GetActiveStores(); DataRow rowStore = dtStor.NewRow(); rowStore["ID"] = "0"; rowStore["StoreName"] = "All Stores"; dtStor.Rows.InsertAt(rowStore, 0); cboStores.Properties.DataSource = dtStor; cboStores.ItemIndex = 0; dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; dtCurrent = ConvertDate.DateConverter(dtDate.Text); DataView dv = Items.AllFiscalYears().DefaultView; dv.Sort = "year desc"; DataTable sortedDT = dv.ToTable(); cboYear.Properties.DataSource = sortedDT; // cboYear.Properties.DataSource = Items.AllYears(); // cboYear.EditValue = dtCurrent.Year; cboYear.ItemIndex = 0; GeneratCostChartForAllStores(); }
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 void LstTreeFocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { DateTime dt1 = new DateTime(); DateTime dt2 = new DateTime(); CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx(); dtDate.CustomFormat = "MM/dd/yyyy"; dtDate.Value = DateTimeHelper.ServerDateTime; DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text); DataRowView dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode); if (dr != null) { LossAndAdjustment disp = new LossAndAdjustment(); DataTable dtRec = new DataTable(); if (dr["ParentID"] == DBNull.Value) { int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1); dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1); dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1); dtRec = disp.GetTransactionByDateRange(Convert.ToInt32(lkActivity.EditValue), dt1, dt2); string dateString = dr["RefNo"].ToString(); lblAdjDate.Text = dateString; } else { dtRec = disp.GetDocumentByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(lkActivity.EditValue), dr["Date"].ToString()); lblAdjDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy"); } gridAdjustments.DataSource = dtRec; } }
private void GeneralReport_Load(object sender, EventArgs e) { Activity stor = new Activity(); stor.LoadAll(); DataTable dtStor = stor.DefaultView.ToTable(); object[] obj = { 0, 1, "All" }; //if(stor.RowCount > 1) //dtStor.Rows.Add(obj); cboStores.DataSource = dtStor; //if (stor.RowCount > 1) // cboStores.SelectedValue = 0; dtDate.Value = DateTimeHelper.ServerDateTime; dtDate.CustomFormat = "MM/dd/yyyy"; dtCurrent = ConvertDate.DateConverter(dtDate.Text); curMont = dtCurrent.Month; curYear = dtCurrent.Year; Item itm = new Item(); DataTable dtyears = itm.AllYears(); foreach (DataRow drYears in dtyears.Rows) { int yr = Convert.ToInt32(drYears["year"]); cboYear.Items.Add(yr); } cboYear.SelectedItem = dtCurrent.Year; }
/// <summary> /// Gets the balance of all items /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bw_DoWork(object sender, DoWorkEventArgs e) { var bal = new Balance(); int[] arr = (int[])e.Argument; int storeId = arr[0], month = arr[1]; // year = arr[2], quarter = arr[3]; dtFrom.CustomFormat = "MM/dd/yyyy"; DateTime dt1 = ConvertDate.DateConverter(dtFrom.Text); dtTo.CustomFormat = "MM/dd/yyyy"; DateTime dt2 = ConvertDate.DateConverter(dtTo.Text); //string dRange = "From " + dtFrom.Text + " to " + dtTo.Text; //layoutControlGroup3.Text = "Cost Report " + dRange; if (dt1 == dt2) { dt1 = ((dt1.Month == 11 || dt1.Month == 12)? new DateTime(dt1.Year, 11, 1) : new DateTime(dt1.Year - 1, 11, 1)); //dRange = "For Year " + dt1.Year.ToString(); } var dtBal = bal.TransactionReport(storeId, dt1, dt2, _selectedType, bw); selecteddate = dt1; e.Result = dtBal; //txtFromDate.Text = dt1.ToShortDateString(); }
private void ManageSaveButton() { dtDate.Value = DateTime.Now; DateTime dtCurent; dtDate.CustomFormat = "MM/dd/yyyy"; dtCurent = ConvertDate.DateConverter(dtDate.Text); if ((dtCurent.Month == 10 && dtCurent.Day == 30) || dtCurent.Month == 11) { if (grdYearEnd.DataSource != null) { DataTable yearEndTable = (DataTable)grdYearEnd.DataSource; if (yearEndTable.Rows.Count > 0) { btnSave.Enabled = true; } else { btnSave.Enabled = false; } } else { btnSave.Enabled = false; } } else { btnSave.Enabled = false; } }
private void dtTo_ValueChanged(object sender, EventArgs e) { if (_isReady) { ReceiveDoc rec = new ReceiveDoc(); dtFrom.CustomFormat = "MM/dd/yyyy"; dtTo.CustomFormat = "MM/dd/yyyy"; DateTime dteFrom = new DateTime(); DateTime dteTo = new DateTime(); dteFrom = ConvertDate.DateConverter(dtFrom.Text); dteTo = ConvertDate.DateConverter(dtTo.Text); DataTable dtRec = new DataTable(); if (dteFrom < dteTo) { dtRec = rec.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dteFrom, dteTo); } else { dtRec = rec.GetAllTransaction(Convert.ToInt32(cboStores.EditValue)); } PopulateTransactions(dtRec); } }
private void ManageItems_Load(object sender, EventArgs e) { lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes(); lkCommodityTypes.ItemIndex = 0; PopulateCatTree(); Stores stor = new Stores(); stor.GetActiveStores(); cboStores.DataSource = stor.DefaultView; dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; dtCurrent = ConvertDate.DateConverter(dtDate.Text); Programs prog = new Programs(); DataTable dtProg = new DataTable(); dtProg = prog.GetSubPrograms(); object[] objProg = { 0, "All Programs", "", 0, "" }; dtProg.Rows.Add(objProg); cboSubProgram.DataSource = dtProg; cboSubProgram.SelectedIndex = -1; cboSubProgram.Text = "Select Program"; ReceivingUnits rec = new ReceivingUnits(); DataTable drRec = rec.GetAllApplicableDU(); cboIssuedTo.DataSource = drRec; cboIssuedTo.SelectedIndex = -1; cboIssuedTo.Text = "Select Issue Location"; int month = dtCurrent.Month; int year = ((dtCurrent.Month < 11) ? dtCurrent.Year : dtCurrent.Year + 1); DataTable dtyears = Items.AllYears(); foreach (DataRow drYears in dtyears.Rows) { 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; }
private void LoadInventoryItems() { dtDate.Value = DateTime.Now; DateTime dtCurent; dtDate.CustomFormat = "MM/dd/yyyy"; dtCurent = ConvertDate.DateConverter(dtDate.Text); int year = dtCurent.Year; var itm = new Items(); DataTable dtItm; switch (VisibilitySetting.HandleUnits) { case 1: if (ckExclude != null && (ckExclude.Checked)) { dtItm = itm.ExcludeNeverReceivedItems(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkCommodityTypes.EditValue)); } else { dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue)); } PopulateItemList(dtItm, year); dtDate.CustomFormat = "MMMM dd, yyyy"; break; case 2: if (ckExclude == null || (!ckExclude.Checked)) { dtItm = itm.ExcludeNeverReceivedItemsForHandlingUnit(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkCommodityTypes.EditValue)); } else { dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue)); } PopulateItemList(dtItm, year); dtDate.CustomFormat = "MMMM dd, yyyy"; break; case 3: if (ckExclude == null || (!ckExclude.Checked)) { dtItm = itm.ExcludeNeverReceivedItemsForHandlingUnit(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkCommodityTypes.EditValue)); } else { dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue)); } PopulateItemList(dtItm, year); dtDate.CustomFormat = "MMMM dd, yyyy"; break; } }
/// <summary> /// Validates user input and returns "true" when valid and the error message when invalid. /// </summary> /// <returns></returns> private string ValidateFields() { //dtRecDate.Value = DateTime.Now; DateTime dtCurent = new DateTime(); dtRecDate.CustomFormat = "MM/dd/yyyy"; dtCurent = ConvertDate.DateConverter(dtRecDate.Text); string valid = "true"; if (Convert.ToDateTime(dtRecDate.Value) > DateTime.Now) { valid = "You cannot pick a Date in a future!"; return(valid); } if (!dxValidationProvider1.Validate()) { valid = "Please correct the highlighted filed!"; } Items itm = new Items(); for (int i = 0; i < gridRecieveView.DataRowCount; i++) { DataRow dr = gridRecieveView.GetDataRow(i); dr.ClearErrors(); if (dr["Pack Qty"] == null || dr["Pack Qty"].ToString() == "" || Convert.ToInt64(dr["Pack Qty"]) == 0) { dr.SetColumnError("Pack Qty", "This field cannot be left blank."); valid = "Please fill the requested feild!"; } itm.LoadByPrimaryKey(Convert.ToInt32(dtRecGrid.Rows[i]["ID"])); if (!itm.IsColumnNull("NeedExpiryBatch")) { if (itm.NeedExpiryBatch) { if (dr["Expiry Date"].ToString() == "") { dr.SetColumnError("Expiry Date", "This field cannot be left blank."); valid = "Please fill the requested feild!"; } if (dr["Batch No"].ToString() == "") { dr.SetColumnError("Batch No", "This field cannot be left blank."); valid = "Please fill the requested feild!"; } } } } return(valid); }
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; }
private void GeneralReport_Load(object sender, EventArgs e) { Activity stor = new Activity(); stor.LoadAll(); DataTable dtStor = stor.DefaultView.ToTable(); cboStores.DataSource = dtStor; dtDate.Value = DateTimeHelper.ServerDateTime; dtDate.CustomFormat = "MM/dd/yyyy"; ConvertDate.DateConverter(dtDate.Text); }
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 GeneralReport_Load(object sender, EventArgs e) { Stores stor = new Stores(); stor.GetActiveStores(); DataTable dtStor = stor.DefaultView.ToTable(); DataRow rowStore = dtStor.NewRow(); rowStore["ID"] = "0"; rowStore["StoreName"] = "All Stores"; dtStor.Rows.InsertAt(rowStore, 0); cboStores.Properties.DataSource = dtStor; if (stor.RowCount > 1) { cboStores.ItemIndex = 0; } var type = new BLL.Type(); DataTable alltypes = type.GetAllCategory(); DataRow row = alltypes.NewRow(); row["ID"] = "0"; row["Name"] = "All Categories"; alltypes.Rows.InsertAt(row, 0); lkCategory.Properties.DataSource = alltypes; lkCategory.Properties.DisplayMember = "Name"; lkCategory.Properties.ValueMember = "ID"; lkCategory.ItemIndex = 0; dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; dtCurrent = ConvertDate.DateConverter(dtDate.Text); curMont = dtCurrent.Month; curYear = dtCurrent.Year; //cboYear.Properties.DataSource = Items.AllYears(); //cboYear.EditValue = dtCurrent.Year; DataView dv = Items.AllFiscalYears().DefaultView; dv.Sort = "year desc"; DataTable sortedDT = dv.ToTable(); cboYear.Properties.DataSource = sortedDT; cboYear.ItemIndex = 0; if (cboYear.Properties.Columns.Count > 0) { cboYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near; } }
private string ValidateFields() { dtRecDate.Value = DateTime.Now; DateTime dtCurent = new DateTime(); dtRecDate.CustomFormat = "MM/dd/yyyy"; dtCurent = ConvertDate.DateConverter(dtRecDate.Text); string valid = "true"; if (Convert.ToDateTime(dtRecDate.Value) > DateTime.Now) { valid = "You cannot pick a Date in a future!"; return(valid); } if (lkFromStore != null && Convert.ToInt32(lkFromStore.EditValue) == Convert.ToInt32(lkToStore.EditValue)) { valid = "You cannot transfer an item to the same store."; return(valid); } if (!dxValidationProvider1.Validate()) { valid = "Please correct the highlighted filed!"; } var itm = new Items(); for (int i = 0; i < gridRecieveView.DataRowCount; i++) { DataRow dr = gridRecieveView.GetDataRow(i); dr.ClearErrors(); if (dr["Qty To Transfer"] == null || dr["Qty To Transfer"].ToString() == "" || Convert.ToInt64(dr["Qty To Transfer"]) == 0) { dr.SetColumnError("Qty To Transfer", "This field cannot be left blank."); valid = "Please fill the requested feild!"; } if (Convert.ToInt32(dr["Qty To Transfer"]) > Convert.ToInt32(dr["BU Qty"])) { dr.SetColumnError("Qty To Transfer", "Qty To Transfer should be less than BU Qty(Remaining)."); valid = "Qty To Transfer should be less than BU Qty(Remaining)"; } itm.LoadByPrimaryKey(Convert.ToInt32(_dtRecGrid.Rows[i]["ID"])); } return(valid); }
private void cboYear_SelectedValueChanged(object sender, EventArgs e) { 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 currentYear = dtCur.Year; if (currentMont >= 11) { currentYear++; currentMont -= 10; } else { currentMont += 2; } int[] val = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 }; string[] mon = { "Hamle", "Nehase", "Meskerem", "Tikemt", "Hedar", "Tahsas", "Tir", "Yekatit", "Megabit", "Miziya", "Genbot", "Sene" }; int i = 0; //currentMont; if (Convert.ToInt32(cboYear.EditValue) == currentYear) { for (i = 0; i < val.Length; i++) { if (val[i] == currentMont) { break; } } } else { i = val.Length - 1; } for (int j = i; j >= 0; j--) { object[] obj = { val[j], mon[j] }; dtMonths.Rows.Add(obj); } cboMonth.Properties.DataSource = dtMonths; cboMonth.ItemIndex = 0; //cboMonth_SelectedValueChanged(null, null); PopulateGrid(); }
/// <summary> /// Load the dropdowns and the category tree /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ManageItems_Load(object sender, EventArgs e) { PopulateCatTree(_selectedType); var type = new BLL.Type(); var alltypes = type.GetAllCategory(); DataRow row = alltypes.NewRow(); row["ID"] = "0"; row["Name"] = "All"; alltypes.Rows.InsertAt(row, 0); lkCategory.Properties.DataSource = alltypes; lkCategory.Properties.DisplayMember = "Name"; lkCategory.Properties.ValueMember = "ID"; lkCategory.ItemIndex = 0; var stor = new Stores(); stor.GetActiveStores(); cboStores.DataSource = stor.DefaultView; dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; _dtCur = ConvertDate.DateConverter(dtDate.Text); dtTo.Value = DateTime.Now; // int yearFrom = ((_dtCur.Month == 11 && _dtCur.Month == 12) ? _dtCur.Year : _dtCur.Year - 1 ); int currYear = (EthiopianDate.EthiopianDate.Now.Month < 11) ? EthiopianDate.EthiopianDate.Now.Year - 1 : EthiopianDate.EthiopianDate.Now.Year; dtFrom.Value = EthiopianDate.EthiopianDate.EthiopianToGregorian(String.Format("{0}/{1}/{2}", 1, 11, currYear)); dtFrom.CustomFormat = "MM/dd/yyyy"; DateTime dt1 = ConvertDate.DateConverter(dtFrom.Text); dtTo.CustomFormat = "MM/dd/yyyy"; DateTime dt2 = ConvertDate.DateConverter(dtTo.Text); //string dRange = "From " + dtFrom.Text + " to " + dtTo.Text; //layoutControlGroup3.Text = "Cost Report " + dRange; if (dt1 == dt2) { dt1 = ((dt1.Month == 11 || dt1.Month == 12) ? new DateTime(dt1.Year, 11, 1) : new DateTime(dt1.Year - 1, 11, 1)); //dRange = "For Year " + dt1.Year.ToString(); } this._isReady = true; txtFromDate.Text = dt1.ToShortDateString(); PopulateItemList(); }
/// <summary> /// Populates the list of items in the gridItemsList /// </summary> private void PopulateItemList() { Balance bal = new Balance(); int storeId = (cboStores.SelectedValue != null) ? Convert.ToInt32(cboStores.SelectedValue) : 1; dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text); gridItemsList.DataSource = bal.BalanceAllItems(storeId, dtCurrent.Year, dtCurrent.Month, _selectedType); if (ckExclude.Checked) { gridItemListView.ActiveFilterString = "[Received] != '0'"; } }
private void lstItem_MouseDoubleClick(object sender, MouseEventArgs e) { if (lstItem.SelectedItems[0].Tag != null) { dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCur = ConvertDate.DateConverter(dtDate.Text); int month = dtCur.Month; int year = (cboYear.SelectedItem != null) ? Convert.ToInt32(cboYear.SelectedItem) : dtCur.Year; int itemId = Convert.ToInt32(lstItem.SelectedItems[0].Tag); ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.SelectedValue), year, 2); con.ShowDialog(); } }
private void dtTo_ValueChanged(object sender, EventArgs e) { //CALENDAR: Disposal adj = new Disposal(); DataTable dtRec; dtFrom.CustomFormat = "MM/dd/yyyy"; dtTo.CustomFormat = "MM/dd/yyyy"; DateTime dteFrom = ConvertDate.DateConverter(dtFrom.Text); DateTime dteTo = ConvertDate.DateConverter(dtTo.Text); dtRec = dteFrom < dteTo?adj.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dteFrom, dteTo) : adj.GetAllTransaction(Convert.ToInt32(cboStores.EditValue)); gridAdjustments.DataSource = dtRec; }
/// <summary> /// Loads the lookups and the category tree /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ManageItems_Load(object sender, EventArgs e) { PopulateCatTree(_selectedType); var rec = new DisposalReasons(); var dtDis = rec.GetAvailableReasons(); //object[] objRec = { 0, "All Reasons", "" }; //dtDis.Rows.Add(objRec); cboReasons.Properties.DataSource = dtDis; cboReasons.Properties.DisplayMember = "Reason"; cboReasons.Properties.ValueMember = "ID"; // cboReasons.ItemIndex = 0; //cboStores.ItemIndex = 0; dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCur = ConvertDate.DateConverter(dtDate.Text); int month = dtCur.Month; int year; if (month < 11) { year = dtCur.Year; } else { year = dtCur.Year + 1; } DataTable dtyears = Items.AllYears(); cmbYear.Properties.DataSource = dtyears; cmbYear.EditValue = year; if (cmbYear.Properties.Columns.Count > 0) { cmbYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near; } //cmbYear.EditValue var stor = new Stores(); stor.GetActiveStores(); cboStores.Properties.DataSource = stor.DefaultView; cboStores.ItemIndex = 0; lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes(); lkCommodityTypes.ItemIndex = 0; }
/// <summary> /// Opens the detailed item report for the chosen item /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridItemListView_DoubleClick(object sender, EventArgs e) { var view = sender as GridView; DataRow dr = view.GetFocusedDataRow(); if (view != null && VisibilitySetting.HandleUnits == 1) { if (dr != null) { dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCur = ConvertDate.DateConverter(dtDate.Text); var month = dtCur.Month; var year = (month < 11) ? dtCur.Year : dtCur.Year + 1; var itemId = Convert.ToInt32(dr["ID"]); var con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.SelectedValue), year, 0); con.ShowDialog(); } } else if (view != null && VisibilitySetting.HandleUnits == 2) { if (dr != null) { dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCur = ConvertDate.DateConverter(dtDate.Text); var month = dtCur.Month; var year = (month < 11) ? dtCur.Year : dtCur.Year + 1; var itemId = Convert.ToInt32(dr["ID"]); var con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.SelectedValue), year, 0, Convert.ToInt32(dr["ID"])); con.ShowDialog(); } } else if (view != null && VisibilitySetting.HandleUnits == 3) { if (dr != null) { dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCur = ConvertDate.DateConverter(dtDate.Text); var month = dtCur.Month; var year = (month < 11) ? dtCur.Year : dtCur.Year + 1; var itemId = Convert.ToInt32(dr["ID"]); var con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.SelectedValue), year, 0, Convert.ToInt32(dr["ID"])); con.ShowDialog(); } } }
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> /// Open the detailed information for an item when the user double clicks on the grid. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridItemsChoice_DoubleClick(object sender, EventArgs e) { DataRow dr = gridItemChoiceView.GetFocusedDataRow(); if (dr == null) { return; } int itemId = Convert.ToInt32(dr["ID"]); dtDate.Value = DateTime.Now; dtDate.CustomFormat = "MM/dd/yyyy"; _dtCur = ConvertDate.DateConverter(dtDate.Text); int month = Convert.ToInt32(cboMonth.EditValue); //int year = (month < 11) ? Convert.ToInt32(cboYear.EditValue) : Convert.ToInt32(cboYear.EditValue); int year = Convert.ToInt32(cboYear.EditValue); var ethioDate = new EthiopianDate.EthiopianDate(year, month, 30); switch (VisibilitySetting.HandleUnits) { case 2: { unitID = Convert.ToInt32(dr["UnitID"]); var con1 = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0, unitID); //ethioDate.FiscalYear con1.ShowDialog(); } break; case 3: { unitID = Convert.ToInt32(dr["UnitID"]); var con1 = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0, unitID); //ethioDate.FiscalYear con1.ShowDialog(); } break; default: { //ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0); ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0); //ethioDate.FiscalYear con.ShowDialog(); } break; } }
private void detailToolStripMenuItem_Click(object sender, EventArgs e) { GridView view = sender as GridView; DataRow dr = view.GetFocusedDataRow(); if (dr != null) { dtRecDate.Value = DateTime.Now; dtRecDate.CustomFormat = "MM/dd/yyyy"; DateTime dtCur = ConvertDate.DateConverter(dtRecDate.Text); int year = ((dtCur.Month < 11) ? dtCur.Year : dtCur.Year + 1); dtRecDate.CustomFormat = "MMM dd,yyyy"; int itemId = Convert.ToInt32(dr["ID"]); ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0); con.ShowDialog(); } }
private void dtFrom_ValueChanged(object sender, EventArgs e) { if (cboStores.SelectedValue != null)//&& cboYear.SelectedValue != null) { dtFrom.CustomFormat = "MM/dd/yyyy"; DateTime dt1 = ConvertDate.DateConverter(dtFrom.Text); PopulateItemList(); if (dt1.Year >= 2010) { SetColumnIndex(true); } else { SetColumnIndex(false); } } }