private void prcLoadList() { clsConnection clsCon = new clsConnection(); dsList = new DataSet(); try { string sqlQuery = "Exec [prcGetSubject] " + clsMain.intComId + ",0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "List"; dsList.Tables[1].TableName = "tblDept"; gridList.DataSource = null; gridList.DataSource = dsList.Tables["List"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlquary = "Exec [rptGradeSheet] " + Common.Classes.clsMain.intComId + ", '','0','0','',0"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "ProssType"; dsList.Tables[1].TableName = "Section"; dsList.Tables[2].TableName = "Employee"; dsList.Tables[3].TableName = "Band"; gridProssType.DataSource = dsList.Tables["ProssType"]; gridSec.DataSource = dsList.Tables["Section"]; gridEmployee.DataSource = dsList.Tables["Employee"]; gridBand.DataSource = dsList.Tables["Band"]; } catch (Exception ex) { throw (ex); } }
private void btnLoad_Click(object sender, EventArgs e) { clsConnection clsCon = new clsConnection(); string sqlQuery = ""; dsList = new DataSet(); string Band = ""; string EmpId = "0", ProssType = ""; ProssType = gridProssType.ActiveRow.Cells["ProssType"].Value.ToString(); EmpId = gridEmp.ActiveRow.Cells["EmpID"].Value.ToString(); try { sqlQuery = "Exec PrcProcessPFManual " + Common.Classes.clsMain.intComId + ",'" + ProssType + "'," + EmpId + ",2"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tblGrid"; gridDetails.DataSource = null; gridDetails.DataSource = dsList.Tables["tblGrid"]; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { clsCon = null; } }
private void prcGetDate() { clsConnection clsCon = new clsConnection(); string sqlQuery = ""; dsDetails = new DataSet(); try { sqlQuery = "Exec prcGetIpAddressGTR 2," + Common.Classes.clsMain.intComId + ""; clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "DeviceDate"; gridInfo.DataSource = null; gridInfo.DataSource = dsDetails.Tables["DeviceDate"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clsCon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec prcGetDesig 0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "Desig"; dsList.Tables[1].TableName = "tblGrade"; gridUnit.DataSource = null; gridUnit.DataSource = dsList.Tables["Desig"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlquary = "Exec [rptSalaryDriver] " + Common.Classes.clsMain.intComId + ", '','0','0',0,''"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "ProssType"; dsList.Tables[1].TableName = "Unit"; dsList.Tables[2].TableName = "Employee"; dsList.Tables[3].TableName = "ReportCategory"; gridProssType.DataSource = dsList.Tables["ProssType"]; gridUnit.DataSource = dsList.Tables["Unit"]; gridEmployee.DataSource = dsList.Tables["Employee"]; gridReportCategory.DataSource = dsList.Tables["ReportCategory"]; } catch (Exception ex) { throw (ex); } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { String sqlquary = "Exec [rptFestAdvanceSheet] " + Common.Classes.clsMain.intComId + ", '1','1', '1','1','1','1','1',6"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "ProssType"; dsList.Tables[1].TableName = "tblSect"; dsList.Tables[2].TableName = "tblBand"; dsList.Tables[3].TableName = "tblGrid"; gridProssType.DataSource = null; gridProssType.DataSource = dsList.Tables["ProssType"]; gridSec.DataSource = null; gridSec.DataSource = dsList.Tables["tblSect"]; gridBand.DataSource = null; gridBand.DataSource = dsList.Tables["tblBand"]; gridDetails.DataSource = null; gridDetails.DataSource = dsList.Tables["tblGrid"]; } catch (Exception ex) { throw (ex); } }
private void prcLoadList() { clsConnection clsCon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec [prcGetEmployeeCasual] " + Common.Classes.clsMain.intComId + ", 0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tblgrid"; dsList.Tables[1].TableName = "tblEmpType"; dsList.Tables[2].TableName = "tblDesig"; dsList.Tables[3].TableName = "tblSection"; dsList.Tables[4].TableName = "tblshift"; dsList.Tables[5].TableName = "tblShitCat"; dsList.Tables[6].TableName = "tblReligion"; dsList.Tables[7].TableName = "tblsex"; dsList.Tables[8].TableName = "tblCSComp"; gridList.DataSource = null; gridList.DataSource = dsList.Tables["tblGrid"]; } catch (Exception ex) { throw ex; } finally { clsCon = null; } }
public void prcLoadList() { clsConnection clsCon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec prcGetDesigCapacity " + Common.Classes.clsMain.intComId + ",0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tblDesigCapacity"; dsList.Tables[1].TableName = "tblDept"; dsList.Tables[2].TableName = "tblSection"; dsList.Tables[3].TableName = "tblDesig"; gridList.DataSource = null; gridList.DataSource = dsList.Tables["tblDesigCapacity"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadListAfterSave() { clsConnection clsCon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec [prcGetAttFixIndividual] " + Common.Classes.clsMain.intComId + ",1, 0,'" + dtInputDate.Value.ToString() + "' "; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tblgrid"; dsList.Tables[1].TableName = "tblCompany"; dsList.Tables[2].TableName = "tblEmployee"; gridList.DataSource = null; gridList.DataSource = dsList.Tables["tblGrid"]; } catch (Exception ex) { throw ex; } finally { clsCon = null; } }
public void prcDisplayDetails(string strParam) { clsConnection clsCon = new clsConnection(); dsDetail = new System.Data.DataSet(); try { string SqlQuery = "Exec prcGetCorporateBusiness " + Int32.Parse(strParam) + ",'Corporate'"; clsCon.GTRFillDatasetWithSQLCommand(ref dsDetail, SqlQuery); dsDetail.Tables[0].TableName = "details"; DataRow dr; if (dsDetail.Tables["details"].Rows.Count > 0) { dr = dsDetail.Tables["details"].Rows[0]; txtId.Text = dr["CPId"].ToString(); txtName.Text = dr["CPName"].ToString(); // txtNameB.Text = dr["DesigNameB"].ToString(); btnSave.Text = "&Update"; btnDelete.Enabled = true; } } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void btnLoad_Click(object sender, EventArgs e) { clsConnection clsCon = new clsConnection(); dsList = new System.Data.DataSet(); DateTime lastDay = new DateTime(dtInputDate.DateTime.Year, dtInputDate.DateTime.Month, 1); lastDay = lastDay.AddMonths(1); lastDay = lastDay.AddDays(-(lastDay.Day)); dtInputDate.Value = lastDay; try { string sqlQuery = "Exec [prcGetAttFixIndividual] " + Common.Classes.clsMain.intComId + ",1, 0,'" + dtInputDate.Value.ToString() + "' "; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tblGrid"; gridList.DataSource = null; gridList.DataSource = dsList.Tables["tblGrid"]; } catch (Exception ex) { throw ex; } finally { clsCon = null; } }
private void prcIdInfoLoad(string strParam) { dsDetails = new System.Data.DataSet(); clsConnection clsCon = new clsConnection(); try { string sqlQuery = "Exec prcGetAttFixIndividual " + Common.Classes.clsMain.intComId + ",2," + Int32.Parse(strParam) + ",'" + clsProc.GTRDate(dtInputDate.Value.ToString()) + "'"; clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "Details"; DataRow dr; if (dsDetails.Tables["Details"].Rows.Count > 0) { dr = dsDetails.Tables["Details"].Rows[0]; this.cboCode.Value = dr["empid"].ToString(); this.txtId.Text = dr["EmpId"].ToString(); this.cboCom.Value = dr["ComName"].ToString(); this.txtName.Text = dr["EmpName"].ToString(); this.txtDesig.Text = dr["DesigName"].ToString(); this.txtSec.Text = dr["SectName"].ToString(); this.btnSave.Text = "&Save"; this.btnDelete.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { clsCon = null; } }
private void prcShowReport() { dsDetails = new DataSet(); ArrayList arQuery = new ArrayList(); clsConnection clsCon = new clsConnection(); try { DataSourceName = "DataSet1"; FormCaption = "Report :: Night Allowance..."; string ProssType = "", SectId = "0", Band = ""; ProssType = gridProssType.ActiveRow.Cells["ProssType"].Value.ToString(); SectId = gridSec.ActiveRow.Cells["SectId"].Value.ToString(); Band = gridBand.ActiveRow.Cells["varName"].Value.ToString(); rptQuery = "Exec rptNightAllowance " + Common.Classes.clsMain.intComId + ",'" + ProssType + "'," + SectId + ",'" + Band + "','" + clsProc.GTRDate(dtDateFrom.Value.ToString()) + "', '" + clsProc.GTRDate(dtDateTo.Value.ToString()) + "',2"; clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, rptQuery); //SQLQuery = "Exec rptSalaryCasual 3,'10-Nov-13','16-Nov-2013', 0, 0, 'Casual Worker'"; if (dsDetails.Tables[0].Rows.Count == 0) { MessageBox.Show("Data Not Found"); return; } clsReport.strReportPathMain = ReportPath; clsReport.dsReport = dsDetails; clsReport.strDSNMain = DataSourceName; Common.Classes.clsMain.strExtension = optFormat.Value.ToString(); Common.Classes.clsMain.strFormat = optFormat.Text.ToString(); FM.prcShowReport(FormCaption); //clsReport.strReportPathMain = ReportPath; //clsReport.strQueryMain = rptQuery; //clsReport.strDSNMain = DataSourceName; //clsReport.dsReport = dsDetails; //FM.prcShowReport(FormCaption); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { rptQuery = null; DataSourceName = null; DataSourceName = null; ReportPath = null; dsDetails = null; } }
private void prcLoadList() { clsConnection clsCon = new clsConnection(); string sqlQuery = ""; dsList = new DataSet(); try { sqlQuery = "Exec prcGetTransport " + Common.Classes.clsMain.intComId + ", 0, 0,'','','" + clsProc.GTRDate(dtFrom.Value.ToString()) + "','" + clsProc.GTRDate(dtDate.Value.ToString()) + "'"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "Grid"; dsList.Tables[1].TableName = "tblSect"; dsList.Tables[2].TableName = "tblBand"; dsList.Tables[3].TableName = "tblEmp"; gridDetails.DataSource = null; gridDetails.DataSource = dsList.Tables["Grid"]; this.dtFrom.Value = DateTime.Now; this.dtDate.Value = DateTime.Now; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clsCon = new clsConnection(); string sqlQuery = ""; dsList = new DataSet(); try { sqlQuery = "Exec prcGetIncAll " + Common.Classes.clsMain.intComId + ", 0, 0,'','','" + clsProc.GTRDate(dtFrom.Value.ToString()) + "'"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "Grid"; dsList.Tables[1].TableName = "tblSect"; dsList.Tables[2].TableName = "tblBand"; dsList.Tables[3].TableName = "tblEmp"; dsList.Tables[4].TableName = "tblIncType"; gridDetails.DataSource = null; gridDetails.DataSource = dsList.Tables["Grid"]; var DaysInMonth = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month); var firstDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtFrom.Value = firstDay; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clsCon = new clsConnection(); string sqlQuery = ""; dsList = new DataSet(); try { sqlQuery = "Exec prcGetIncenManaulEntry " + Common.Classes.clsMain.intComId + ", 0, 0,'','',''"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "Grid"; dsList.Tables[1].TableName = "tblSect"; dsList.Tables[2].TableName = "tblBand"; dsList.Tables[3].TableName = "tblEmp"; dsList.Tables[4].TableName = "tblGrade"; dsList.Tables[5].TableName = "tblProssType"; //dsList.Tables[4].TableName = "tblIncenBand"; //dsList.Tables[5].TableName = "tblIncenSubBand"; gridDetails.DataSource = null; gridDetails.DataSource = dsList.Tables["Grid"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { String sqlquary = "Exec [rptOTOfficer] " + Common.Classes.clsMain.intComId + ", '0',0, 0,0"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "ProssType"; dsList.Tables[1].TableName = "tblSect"; dsList.Tables[2].TableName = "tblEmp"; gridProssType.DataSource = null; gridProssType.DataSource = dsList.Tables["ProssType"]; gridSec.DataSource = null; gridSec.DataSource = dsList.Tables["tblSect"]; gridEmp.DataSource = null; gridEmp.DataSource = dsList.Tables["tblEmp"]; } catch (Exception ex) { throw (ex); } }
public void prcDisplayDetails(string strParam) { clsConnection clsCon = new clsConnection(); dsDetail = new System.Data.DataSet(); try { string SqlQuery = "Exec prcGetDistrict " + Int32.Parse(strParam); clsCon.GTRFillDatasetWithSQLCommand(ref dsDetail, SqlQuery); dsDetail.Tables[0].TableName = "District"; DataRow dr; if (dsDetail.Tables["District"].Rows.Count > 0) { dr = dsDetail.Tables["District"].Rows[0]; //txtId.Text = dr["DistId"].ToString(); //cboShiftType.Text = dr["ShiftType"].ToString(); btnSave.Text = " &Update"; btnDelete.Enabled = true; } } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clsCon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec [prcGetLoan] " + Common.Classes.clsMain.intComId + ", 0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tblgrid"; dsList.Tables[1].TableName = "tblEmployee"; dsList.Tables[2].TableName = "tblgridAdd"; gridList.DataSource = null; gridList.DataSource = dsList.Tables["tblGrid"]; gridData.DataSource = null; gridData.DataSource = dsList.Tables["tblgridAdd"]; DateTime firstDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtFrom.Value = firstDay; } catch (Exception ex) { throw ex; } finally { clsCon = null; } }
public void prcLoadList() { clsConnection clsCon = new clsConnection(); dsList = new System.Data.DataSet(); try { String SqlQuery = "select EmpId from tblLogin_User where LUserId = " + Common.Classes.clsMain.intUserId + " "; Int32 Id = 604; //clsCon.GTRCountingData(SqlQuery); SqlQuery = "Exec prcGetNotification " + Common.Classes.clsMain.intComId + ", " + Id + ", '" + clsProc.GTRDate(System.DateTime.Today.Date.ToString()) + "' "; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, SqlQuery); dsList.Tables[0].TableName = "Attendent"; gridAtt.DataSource = null; gridAtt.DataSource = dsList.Tables["Attendent"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcGetBasedLoad() { clsConnection clsCon = new clsConnection(); string sqlQuery = ""; dsList = new DataSet(); string Band = ""; string SectId = "0", EmpId = "0"; //Collecting Parameter Value if (optCriteria.Value.ToString().ToUpper() == "All".ToUpper()) { } try { sqlQuery = "Exec prcGetIncAll " + Common.Classes.clsMain.intComId + ", " + EmpId + "," + SectId + ",'" + Band + "','" + optCriteria.Value.ToString() + "','" + clsProc.GTRDate(dtJoinFrom.Value.ToString()) + "'"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "Grid"; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlquary = "Exec prcrptDailyCasual " + Common.Classes.clsMain.intComId; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "Section"; dsList.Tables[1].TableName = "Type"; dsList.Tables[2].TableName = "Employee"; gridSection.DataSource = null; gridSection.DataSource = dsList.Tables["Section"]; gridType.DataSource = null; gridType.DataSource = dsList.Tables["Type"]; gridEmployeeID.DataSource = null; gridEmployeeID.DataSource = dsList.Tables["Employee"]; } catch (Exception ex) { throw (ex); } }
private void prcLoadList() { clsConnection clsCon = new clsConnection(); string sqlQuery = ""; dsList = new DataSet(); try { sqlQuery = "Exec prcGetIncYearly " + Common.Classes.clsMain.intComId + ",0,0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tblEmp"; int year = DateTime.Now.Year; DateTime YearfirstDay = new DateTime(year, 1, 1); dtInc.Value = YearfirstDay; dtJoinFrom.Value = "1-Jan-1950"; dtJoinTo.Value = DateTime.Now; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcDisplayDetails(string strParam) { string sqlQuery = "Exec prcGetDesig " + Int32.Parse(strParam); dsDetails = new System.Data.DataSet(); clsConnection clsCon = new clsConnection(); clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "Details"; DataRow dr; if (dsDetails.Tables["Details"].Rows.Count > 0) { dr = dsDetails.Tables["Details"].Rows[0]; this.txtUnitId.Text = dr["DesigId"].ToString(); this.txtName.Text = dr["DesigName"].ToString(); this.txtNameB.Text = dr["DesigNameB"].ToString(); this.txtBonus.Text = dr["AttBonus"].ToString(); this.cboGrade.Text = dr["Grade"].ToString(); this.btnSave.Text = "&Update"; this.btnDelete.Enabled = true; } }
public void prcLoadList() { clsConnection clsCon = new clsConnection(); dsList = new System.Data.DataSet(); try { string SqlQuery = "Exec prcGetCadreUnit " + Common.Classes.clsMain.intComId + ",'" + this.Tag.ToString() + "'"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, SqlQuery); dsList.Tables[0].TableName = "Varible"; dsList.Tables[1].TableName = "MPosition"; gridList.DataSource = null; gridList.DataSource = dsList.Tables["Varible"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlquary = "Exec prcrptGradeIns " + Common.Classes.clsMain.intComId; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "Criteria"; dsList.Tables[1].TableName = "IncType"; dsList.Tables[2].TableName = "EmpStatus"; dsList.Tables[3].TableName = "EmpType"; dsList.Tables[4].TableName = "Section"; dsList.Tables[5].TableName = "Employee"; dsList.Tables[6].TableName = "tblGrade"; gridCriteria.DataSource = dsList.Tables["Criteria"]; gridEmpStatus.DataSource = dsList.Tables["EmpStatus"]; gridEmpType.DataSource = dsList.Tables["EmpType"]; gridArea.DataSource = dsList.Tables["Section"]; gridEmp.DataSource = dsList.Tables["Employee"]; gridBand.DataSource = dsList.Tables["tblGrade"]; } catch (Exception ex) { throw (ex); } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlquary = "Exec prcrptDaily " + Common.Classes.clsMain.intComId; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "Section"; dsList.Tables[3].TableName = "Employee"; gridSection.DataSource = dsList.Tables["Section"]; gridEmployeeID.DataSource = dsList.Tables["Employee"]; DateTime firstDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtDateFrom.Value = firstDay; DateTime lastDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); lastDay = lastDay.AddMonths(1); lastDay = lastDay.AddDays(-(lastDay.Day)); dtDateTo.Value = lastDay; } catch (Exception ex) { throw (ex); } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlquary = "Exec prcrptSalarySheet " + Common.Classes.clsMain.intComId + ", 'Admin'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "ProssType"; dsList.Tables[2].TableName = "Section"; dsList.Tables[4].TableName = "PayMode"; dsList.Tables[6].TableName = "EmpType"; dsList.Tables[7].TableName = "EmpStatus"; dsList.Tables[8].TableName = "Band"; gridProssType.DataSource = dsList.Tables["ProssType"]; gridSec.DataSource = dsList.Tables["Section"]; gridBand.DataSource = dsList.Tables["Band"]; } catch (Exception ex) { throw (ex); } }
private void prcLoadList() { clsConnection clscon = new clsConnection(); dsList = new System.Data.DataSet(); try { string sqlquary = "Exec prcrptEarnLeave " + Common.Classes.clsMain.intComId + ", 'Admin'"; clscon.GTRFillDatasetWithSQLCommand(ref dsList, sqlquary); dsList.Tables[0].TableName = "ProssType"; dsList.Tables[2].TableName = "Section"; dsList.Tables[3].TableName = "Employee"; dsList.Tables[4].TableName = "PayMode"; dsList.Tables[6].TableName = "EmpType"; dsList.Tables[7].TableName = "EmpStatus"; dsList.Tables[8].TableName = "ReportCategory"; gridProssType.DataSource = dsList.Tables["ProssType"]; gridSec.DataSource = dsList.Tables["Section"]; gridEmployee.DataSource = dsList.Tables["Employee"]; gridReportCategory.DataSource = dsList.Tables["ReportCategory"]; dtFirst.Value = DateTime.Now; dtLast.Value = DateTime.Now; } catch (Exception ex) { throw (ex); } }