public DataSet getMenuDetails(string UserCode)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(1);
dbManager.AddParameters(0, "UserCode", UserCode, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("dbo.GTKSSOMenuDtls");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "dbo.GTKSSOMenuDtls");
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
public DataSet getGTKSSOUserAxn(int Menuid)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(1);
dbManager.AddParameters(0, "@Menuid", Menuid, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("getGTKSSOUserAxn");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "getGTKSSOUserAxn");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
public DataSet getLoginInfo(string UserCode, string Password)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(2);
dbManager.AddParameters(0, "LoginUserCode", UserCode, ParameterDirection.Input);
dbManager.AddParameters(1, "UserPassword", Password, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("getLoginInfo");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "getLoginInfo");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
