public static DataSet ExecuteDataset(string Username, string Password)
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
SqlParameter[] param = new SqlParameter[2];
SqlParameter p1 = new SqlParameter(PARAM1NAME,Username);
SqlParameter p2 = new SqlParameter(PARAM2NAME,Password);
param[0] = p1;
param[1] = p2;
return _sqlHelper.ExecuteDataset(PROCEDURE_NAME, param);
}
public static DataSet ExecuteDataset(string Username, string Password)
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
SqlParameter[] param = new SqlParameter[2];
SqlParameter p1 = new SqlParameter(PARAM1NAME, Username);
SqlParameter p2 = new SqlParameter(PARAM2NAME, Password);
param[0] = p1;
param[1] = p2;
return(_sqlHelper.ExecuteDataset(PROCEDURE_NAME, param));
}
private spGetLeaveByEmployeeID()
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
}
private spCheckLogin()
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
}
private spCheckLogin()
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
}
private spGetLeaveByEmployeeID()
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
}
private spGetEmployeeDetails()
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
}
private spGetEmployeeDetailsByID()
{
_sqlHelper = new IISQLHelper(InsideInningDB.InsideInning_CONNECTIONSTRING);
}