//called only in the beginning private void initVariables() { docID = Main.currentDocument; dtFromDate.Format = DateTimePickerFormat.Custom; dtFromDate.CustomFormat = "dd-MM-yyyy"; dtFromDate.Value = DateTime.Now.AddMonths(-1); dtToDate.Format = DateTimePickerFormat.Custom; grdLedger.ColumnHeadersDefaultCellStyle.BackColor = Color.LightBlue; grdLedger.EnableHeadersVisualStyles = false; dtToDate.CustomFormat = "dd-MM-yyyy"; dtToDate.Value = DateTime.Now; pnlUI.Controls.Add(pnlList); btnExportToExcel.Visible = false; chktransacted.Checked = true; btnCancel.Visible = false; lblSearch.Visible = false; TxtSearchNamr.Visible = false; //btnExportToPDF.Visible = false; closeAllPanels(); grdList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; FinancialYearDB.fillFYIDCombo(cmbFYID); pnlLedger.Visible = false; cmbFYID.SelectedIndex = cmbFYID.FindString(Main.currentFY); //userString = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + Main.delimiter2; //userCommentStatusString = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + "0" + Main.delimiter2; setButtonVisibility("init"); pnlList.Visible = true; }
private void initVariables() { try { ComboFIll.fillStaticCombos(); ////connString = Login.connString; ////userLoggedIn = Login.userLoggedIn; ////userLoggedInName = Login.userLoggedInName; ////empLoggedIn = Login.empLoggedIn; currentFY = FinancialYearDB.getCurrentFinancialYear(); documentDirectory = CatalogueValueDB.getParamValue("SysParam", "DocumentDirectory"); showTime(); lblEmployeeName.Text = Login.userLoggedInName; MenuPrivilegeDB mpDB = new MenuPrivilegeDB(); MenuItemDB dbrecord = new MenuItemDB(); menuhdritems = MenuItemDB.getMenuItemsHeader(); foreach (menuitem menu in menuhdritems) { dictMainHeader.Add(menu.menugrp, 0); } } catch (Exception) { MessageBox.Show("Main() : Error 2"); } }
private void initVariables() { docID = Main.currentDocument; pnlUI.Controls.Add(pnlList); FinancialYearDB.fillFYIDCombo(cmbFY); enableBottomButtons(); showControlsForAccessPrevelidge(); grdList.Visible = true; grdList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; }
private void initVariables() { try { FinancialYearDB.fillFYIDCombo(cmbFY); cmbFY.SelectedIndex = cmbFY.FindString(Main.currentFY); //RegionDB.fillRegionComboNew(cmbFY); } catch (Exception) { } }
private void btnLock_Click(object sender, EventArgs e) { DialogResult dialog = MessageBox.Show("You cannot modify the details after Locking. Are you sure to Lock the row ?", "Yes", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { FinancialYearDB fyDB = new FinancialYearDB(); if (fyDB.LockFinancialYear(txtFYID.Text)) { MessageBox.Show("Financial Year Locked"); closeAllPanels(); ListFinancialYear(); } } }
//called only in the beginning private void initVariables() { docID = Main.currentDocument; dtTrialBalanceDate.Format = DateTimePickerFormat.Custom; dtTrialBalanceDate.CustomFormat = "dd-MM-yyyy"; pnlUI.Controls.Add(pnlList); closeAllPanels(); grdTrialBalance.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; pnlsearch.Visible = false; //userString = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + Main.delimiter2; //userCommentStatusString = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + "0" + Main.delimiter2; FinancialYearDB.fillFYIDCombo(cmbFY); cmbFY.SelectedIndex = cmbFY.FindString(Main.currentFY); setButtonVisibility("init"); pnlList.Visible = true; }
private void initVariables() { if (getuserPrivilegeStatus() == 1) { //user is only a viewer listOption = 6; } docID = Main.currentDocument; dtDocDate.Format = DateTimePickerFormat.Custom; dtDocDate.CustomFormat = "dd-MM-yyyy"; dtDocDate.Enabled = false; FinancialYearDB.fillFYIDCombo(cmbFYID); StoreEmpMappingDB.fillLocationComboNew(cmbStoreLocation); ////dtSMRNHeaderDate.Enabled = true; pnlUI.Controls.Add(pnlAddEdit); closeAllPanels(); setButtonVisibility("init"); }
//called only in the beginning private void initVariables() { docID = Main.currentDocument; dtFromDate.Format = DateTimePickerFormat.Custom; dtFromDate.CustomFormat = "dd-MM-yyyy"; dtFromDate.Value = UpdateTable.getSQLDateTime().AddMonths(-1); dtToDate.Format = DateTimePickerFormat.Custom; dtToDate.CustomFormat = "dd-MM-yyyy"; pnlUI.Controls.Add(pnlList); closeAllPanels(); grdList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; FinancialYearDB.fillFYIDCombo(cmbFYID); cmbFYID.SelectedIndex = cmbFYID.FindString(Main.currentFY); //userString = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + Main.delimiter2; //userCommentStatusString = Login.userLoggedInName + Main.delimiter1 + Login.userLoggedIn + Main.delimiter1 + "0" + Main.delimiter2; setButtonVisibility("init"); pnlList.Visible = true; Cancl(); }
private void initVariables() { dtRecDate.Format = DateTimePickerFormat.Custom; dtRecDate.CustomFormat = "dd-MM-yyyy"; dtRecDate.Value = UpdateTable.getSQLDateTime(); pnlList.Visible = true; lblDate.Visible = true; dtRecDate.Visible = true; financialyear fyyr = FinancialYearDB.getFinancialYear().FirstOrDefault(fy => fy.fyID == Main.currentFY); if (fyyr != null) { FYStartTIme = fyyr.startDate; } //dtpDate.Format = DateTimePickerFormat.Custom; //dtpDate.CustomFormat = "dd-MM-yyyy"; //dtpDate.Enabled = true; //cmbFilterStock.SelectedIndex = 1; ///setdgvStyle(); }
private void ListFinancialYear() { try { grdList.Rows.Clear(); //FinancialYearDB fyDB = new FinancialYearDB(); List <financialyear> FYears = FinancialYearDB.getFinancialYear(); foreach (financialyear fyear in FYears) { grdList.Rows.Add(fyear.fyID, fyear.startDate, fyear.endDate, ComboFIll.getStatusString(fyear.status), getCurrentFYStatusString(fyear.IsCurrentFY), fyear.documentStatus); } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } enableBottomButtons(); pnlList.Visible = true; }
private void initVariables() { docID = Main.currentDocument; pnlUI.Controls.Add(pnlList); dtFromDate.Format = DateTimePickerFormat.Custom; dtFromDate.CustomFormat = "dd-MM-yyyy"; dtToDate.Format = DateTimePickerFormat.Custom; dtToDate.CustomFormat = "dd-MM-yyyy"; dtFromDate.Value = DateTime.Now.AddMonths(-1); dtToDate.Value = DateTime.Now; enableBottomButtons(); btnDocWiseExportToExcel.Visible = false; btnLevel2ExportToexcel.Visible = false; pnlShowTotal.Visible = false; FinancialYearDB.fillFYIDCombo(cmbFYID); cmbFYID.SelectedIndex = cmbFYID.FindString(Main.currentFY); grdDocumentWiseList.Visible = false; grdRadioSelectWiseList.Visible = false; btnClose1StGrid.Visible = false; btnClose2ndGrid.Visible = false; grdDocumentWiseList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; grdRadioSelectWiseList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; }
private void initVariables() { docID = Main.currentDocument; pnlUI.Controls.Add(pnlList); dtFromDate.Format = DateTimePickerFormat.Custom; dtFromDate.CustomFormat = "dd-MM-yyyy"; dtToDate.Format = DateTimePickerFormat.Custom; dtToDate.CustomFormat = "dd-MM-yyyy"; dtFromDate.Value = DateTime.Now.AddMonths(-1); dtToDate.Value = DateTime.Now; enableBottomButtons(); btnDocWiseExportToExcel.Visible = false; btnLevel2ExportToexcel.Visible = false; pnlShowTotal.Visible = false; FinancialYearDB.fillFYIDCombo(cmbFYID); cmbFYID.SelectedIndex = cmbFYID.FindString(Main.currentFY); grdDocumentWiseList.Visible = false; grdRadioSelectWiseList.Visible = false; btnClose1StGrid.Visible = false; btnClose2ndGrid.Visible = false; grdDocumentWiseList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; grdRadioSelectWiseList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; //--------- string[] str = cmbFYID.SelectedItem.ToString().Split(':'); string s = str[0]; string ss = str[1]; string sss = str[2]; DateTime FYstartDate = Convert.ToDateTime(ss.Trim()); DateTime FYEndDate = Convert.ToDateTime(sss.Trim()); if (dtFromDate.Value.Date < FYstartDate.Date) { dtFromDate.Value = FYstartDate.Date; } }
private void btnSave_Click(object sender, EventArgs e) { try { financialyear fyear = new financialyear(); FinancialYearDB fyDB = new FinancialYearDB(); fyear.fyID = txtFYID.Text; fyear.startDate = dtStart.Value; fyear.endDate = dtEnd.Value; fyear.status = ComboFIll.getStatusCode(cmbStatus.SelectedItem.ToString()); fyear.documentStatus = 99; System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btn.Text; if (fyDB.validateFinancialYear(fyear)) { if (btnText.Equals("Update")) { fyear.IsCurrentFY = getCurrentFYStatusCode(cmbIsCurrentFY.SelectedItem.ToString()); if (fyear.IsCurrentFY == 1) { if (!FinancialYearDB.verifyCurrentFYStatus(fyear.fyID)) { MessageBox.Show("Check Current Financial Year status. \nAlready Current Financial Year is there. \nNot allowed more Year."); return; } } if (fyear.IsCurrentFY == 1 && fyear.status == 2) { fyear.IsCurrentFY = 0; } if (fyDB.updateFinancialYear(fyear)) { MessageBox.Show("Financial Year data updated"); closeAllPanels(); ListFinancialYear(); } else { MessageBox.Show("Failed to update Financial Year Data"); } } else if (btnText.Equals("Save")) { if (fyDB.insertFinancialYear(fyear)) { MessageBox.Show("Financial Year data Added"); closeAllPanels(); ListFinancialYear(); } else { MessageBox.Show("Failed to Insert Financial Year Data"); } } } else { MessageBox.Show("Financial Year Data Validation Failed"); } } catch (Exception) { } }