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);
}
}
