//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)
{
}
}
