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