public DataSet getAllUserInfo(Int32 PageNumber, Int32 RowsPerPage, DataTable dtParams)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(3);
dbManager.AddParameters(0, "@PageNumber", PageNumber, ParameterDirection.Input);
dbManager.AddParameters(1, "@RowsPerPage", RowsPerPage, ParameterDirection.Input);
dbManager.AddParameters(2, "@filterParams", dtParams, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("getAllUserInfo");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "getAllUserInfo");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
public DataSet getDashBDtls(string UserCode, string AppType)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(2);
dbManager.AddParameters(0, "UserCode", UserCode, ParameterDirection.Input);
if (AppType != null && AppType != "")
{
dbManager.AddParameters(1, "AppType", AppType, ParameterDirection.Input);
}
else
{
dbManager.AddParameters(1, "AppType", DBNull.Value, ParameterDirection.Input);
}
string spCall = dbManager.GetSPCall("dbo.GTKSSODashBDtls");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "dbo.GTKSSODashBDtls");
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbManager.Dispose();
}
}
public DataSet saveChangePassword(string Usercode, string Oldpassword, string NewPassword)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(3);
dbManager.AddParameters(0, "@Usercode", Usercode, ParameterDirection.Input);
dbManager.AddParameters(1, "@Oldpassword", Oldpassword, ParameterDirection.Input);
dbManager.AddParameters(2, "@NewPassword", NewPassword, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("saveChangePassword");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "saveChangePassword");
return(ds);
}
catch (Exception)
{
throw;
}
finally
{
dbManager.Dispose();
}
}
public DataSet saveUserAction(DataTable dtParams, string usercode, string AxnCD)
{
GTKDBConnection dbManager = CommonConnection.GetGTKConnection();
try
{
dbManager.Open();
dbManager.CreateParameters(3);
dbManager.AddParameters(0, "@UserAxnParams", dtParams, ParameterDirection.Input);
dbManager.AddParameters(1, "@loginusercode", usercode, ParameterDirection.Input);
dbManager.AddParameters(2, "@AxnCD", AxnCD, ParameterDirection.Input);
string spCall = dbManager.GetSPCall("saveUserAction");
DataSet ds = dbManager.ExecuteDataSet(CommandType.StoredProcedure, "saveUserAction");
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();
}
}
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 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();
}
}