private void ListUser()
{
try
{
grdList.Rows.Clear();
txtSearch.Text = "";
ERPUserDB dbrecord = new ERPUserDB();
List <user> Users = dbrecord.getUsers();
if (Users.Count == 0)
{
//
}
foreach (user usr in Users)
{
grdList.Rows.Add(usr.userID, usr.userEmpName,
ComboFIll.getUserTypeString(usr.userType),
ComboFIll.getStatusString(usr.userStatus));
//dbrecord.getEmpStatusString(emp.empStatus), emp.empPhoto);
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlUserList.Visible = true;
}
private void Listdet()
{
try
{
grdList.Rows.Clear();
CompanyDetailDB dbrecord = new CompanyDetailDB();
List <cmpnydetails> details = dbrecord.getdetails();
foreach (cmpnydetails det in details)
{
grdList.Rows.Add(det.companyID, det.companyname, det.companyAddress,
ComboFIll.getStatusString(det.status));
}
}
catch (Exception)
{
MessageBox.Show("Error in Region listing");
}
enableBottomButtons();
pnlRegionList.Visible = true;
}
private void ListTaxCode()
{
try
{
grdList.Rows.Clear();
TaxCodeDB taxcodedb = new TaxCodeDB();
List <taxcode> TaxCodes = taxcodedb.getTaxCode();
foreach (taxcode tc in TaxCodes)
{
grdList.Rows.Add(tc.TaxCode, tc.Description,
ComboFIll.getStatusString(tc.status));
}
}
catch (Exception)
{
MessageBox.Show("Error in Tax Code listing");
}
enableBottomButtons();
pnlList.Visible = true;
}
private void ListCatalogue()
{
try
{
grdList.Rows.Clear();
CatalogueDB dbrecord = new CatalogueDB();
List <catalogue> Catalogues = dbrecord.getCatalogues();
foreach (catalogue cat in Catalogues)
{
grdList.Rows.Add(cat.catalogueID, cat.description,
ComboFIll.getStatusString(cat.status));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlCatalogueList.Visible = true;
}
private void ListProductTestDesc()
{
try
{
grdList.Rows.Clear();
ProductTestDescriptionDB ptDescDB = new ProductTestDescriptionDB();
List <productTestDesc> PTDescList = ptDescDB.getProductTestDescriptionList();
foreach (productTestDesc ptdesc in PTDescList)
{
grdList.Rows.Add(ptdesc.TestDescriptionID, ptdesc.TestDescription,
ComboFIll.getStatusString(ptdesc.Status), ptdesc.CreateUser, ptdesc.CreateTime);
//dbrecord.getEmpStatusString(emp.empStatus), emp.empPhoto);
}
}
catch (Exception ex)
{
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
private void ListCurrency()
{
try
{
grdList.Rows.Clear();
CurrencyDB dbrecord = new CurrencyDB();
List <currency> Currencies = dbrecord.getCurrencies();
foreach (currency curr in Currencies)
{
grdList.Rows.Add(curr.CurrencyID, curr.name, curr.symbol,
ComboFIll.getStatusString(curr.status));
}
}
catch (Exception)
{
MessageBox.Show("Error in Currency listing");
}
enableBottomButtons();
pnlCurrencyList.Visible = true;
}
private void ListRegion()
{
try
{
grdList.Rows.Clear();
RegionDB dbrecord = new RegionDB();
List <region> Regions = dbrecord.getRegions();
foreach (region reg in Regions)
{
grdList.Rows.Add(reg.regionID, reg.name,
ComboFIll.getStatusString(reg.status));
}
}
catch (Exception)
{
MessageBox.Show("Error in Region listing");
}
enableBottomButtons();
pnlRegionList.Visible = true;
}
private void ListUser()
{
try
{
grdList.Rows.Clear();
txtSearch.Text = "";
MenuGroupDB dbrecord = new MenuGroupDB();
List <menugroup> mngrp = dbrecord.getMenuGroup();
foreach (menugroup mnr in mngrp)
{
grdList.Rows.Add(mnr.rowid, mnr.MenuGroup,
ComboFIll.getStatusString(mnr.status));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlUserList.Visible = true;
}
private void ListBankBranch()
{
try
{
grdList.Rows.Clear();
BankBranchDB bankbranchdb = new BankBranchDB();
List <bankbranch> BankBranches = bankbranchdb.getBankBranches();
foreach (bankbranch branch in BankBranches)
{
grdList.Rows.Add(branch.BankID, branch.BranchName, branch.Address1, branch.Address2,
branch.Address3, branch.IFSCCode, branch.SWIFTCode, branch.MICRCode, branch.BSRCode,
ComboFIll.getStatusString(branch.status), branch.BranchID);
}
}
catch (Exception)
{
MessageBox.Show("Error in Office listing");
}
enableBottomButtons();
pnlList.Visible = true;
}
private void ListStoreEmpMapping()
{
try
{
grdList.Rows.Clear();
StoreEmpMappingDB semDB = new StoreEmpMappingDB();
List <storeempmapping> SEMs = semDB.getStockEmpMapping();
foreach (storeempmapping sem in SEMs)
{
grdList.Rows.Add(sem.StoreLocationID, sem.Description,
sem.EmployeeID, sem.EmployeeName,
ComboFIll.getStatusString(sem.Status));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
private void ListDocCommentor()
{
try
{
grdList.Rows.Clear();
DocCommenterDB dcdb = new DocCommenterDB();
List <doccommenter> docCommList = dcdb.getDocCommList();
foreach (doccommenter doc in docCommList)
{
grdList.Rows.Add(doc.DocumentID, doc.DocumentName,
doc.EmployeeName + "-" + doc.EmployeeID,
ComboFIll.getStatusString(doc.DocumentStatus));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
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 ListOffice()
{
try
{
grdList.Rows.Clear();
OfficeDB dbrecord = new OfficeDB();
List <office> Offices = dbrecord.getOffices();
foreach (office off in Offices)
{
grdList.Rows.Add(off.OfficeID, off.name, off.RegionID + "-" + off.RegionName,
off.Address1, off.Address2, off.Address3, off.Address4,
ComboFIll.getStatusString(off.status));
}
}
catch (Exception)
{
MessageBox.Show("Error in Office listing");
}
enableBottomButtons();
pnlOfficeList.Visible = true;
}
private void ListTaxItem()
{
try
{
grdList.Rows.Clear();
TaxItemDB taxitemdb = new TaxItemDB();
List <taxitem> TaxItems = taxitemdb.getTaxItems();
foreach (taxitem ti in TaxItems)
{
grdList.Rows.Add(ti.TaxItemID, ti.Description, ti.AccountCodeIN, ti.AccountCodeOUT,
ComboFIll.getStatusString(ti.status));
}
}
catch (Exception)
{
MessageBox.Show("Error in Tax Item listing");
}
enableBottomButtons();
pnlList.Visible = true;
grdList.Visible = true;
}
private void ListEmpFinLimit()
{
try
{
grdList.Rows.Clear();
FinancialLimitDB fdb = new FinancialLimitDB();
List <financiallimit> finList = fdb.getEmpFinancialLimit();
foreach (financiallimit flim in finList)
{
grdList.Rows.Add(flim.DocumentID, flim.DocumentName,
flim.EmployeeName + "-" + flim.EmployeeID, flim.FinancialLimit,
ComboFIll.getStatusString(flim.DocumentStatus));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
private void ListEmpFinLimit(string sefid)
{
try
{
grdList.Rows.Clear();
SEFCheckListDB fdb = new SEFCheckListDB();
List <sefcheck> finList = fdb.getSEFCheckList(sefid);
foreach (sefcheck flim in finList)
{
grdList.Rows.Add(flim.rowid, flim.SEFID,
flim.Sequenceno, flim.description,
ComboFIll.getStatusString(flim.Status));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
////private void Form1_Load(object sender, EventArgs e)
////{
//// try
//// {
//// ListDocEmpMapping();
//// }
//// catch (Exception)
//// {
//// }
////}
private void ListDocEmpMapping()
{
try
{
grdList.Rows.Clear();
DocEmpMappingDB dbrecord = new DocEmpMappingDB();
List <docempmapping> DocEmpMappings = dbrecord.getDocEmpMapping();
foreach (docempmapping doc in DocEmpMappings)
{
grdList.Rows.Add(doc.DocumentID, doc.DocumentName,
doc.EmployeeName + "-" + doc.EmployeeID,
doc.SeniorEmployeeName + "-" + doc.SeniorEmployeeID,
ComboFIll.getStatusString(doc.DocumentStatus));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
private void Listdata()
{
try
{
grdList.Rows.Clear();
CompanyDataDB dbrecord = new CompanyDataDB();
int index = 0;
CatalogueValueDB ACDb = new CatalogueValueDB();
List <cataloguevalue> acList = ACDb.getCatalogueValues();
List <cmpnydata> data = dbrecord.getData(cmbcmpnysrch.SelectedItem.ToString().Trim().Substring(0, cmbcmpnysrch.SelectedItem.ToString().Trim().IndexOf('-')).Trim());
foreach (cataloguevalue cv in acList)
{
index = 0;
if (cv.catalogueID == "CompanyData")
{
foreach (cmpnydata dat in data)
{
if (cv.catalogueValueID.Equals(dat.DataID))
{
grdList.Rows.Add(dat.DataID, dat.DataValue,
ComboFIll.getStatusString(dat.status));
index = 1;
}
}
if (index == 0)
{
grdList.Rows.Add(cv.catalogueValueID, "", "");
}
}
}
grdList.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show("Error in CompanyData listing");
}
enableBottomButtons();
pnlRegionList.Visible = true;
}
////private void Form1_Load(object sender, EventArgs e)
////{
//// ListMenuItems();
////}
private void ListMenuItems()
{
try
{
grdList.Rows.Clear();
MenuItemDB dbrecord = new MenuItemDB();
List <menuitem> menuitems = dbrecord.getMenuItems();
foreach (menuitem menu in menuitems)
{
grdList.Rows.Add(menu.menuItemID, menu.description, menu.shortDescription,
dbrecord.getMenuItemTypeString(menu.menuitemType),
menu.documentID + "-" + menu.documentName,
menu.pageLink, menu.versionrequired,
menu.menugrp,
ComboFIll.getStatusString(menu.menuitemStatus));
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlMenuList.Visible = true;
}
private void ListCatalogueValues(string CatalogueID)
{
try
{
grdList.Rows.Clear();
CatalogueValueDB dbrecord = new CatalogueValueDB();
List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues();
foreach (cataloguevalue catval in CatalogueValues)
{
if (catval.catalogueID.Equals(CatalogueID))
{
grdList.Rows.Add(catval.catalogueValueID, catval.description,
ComboFIll.getStatusString(catval.status));
}
}
lblAddEditHeader.Text = CatalogueID;
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlCatalogueValueList.Visible = true;
}