public string LastApprovers_ADSec(string strUSerSID, string strCurrQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strLastApprover = objclsDALUsers.LastApprovedBy_ADSec(strUSerSID, strCurrQuarter);
return(strLastApprover);
}
public string GetAccountCommentLinux(string strUserID, string strRepType, string strQuarter, string strServer)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strComment = objclsDALUsers.GetAccountCommentLinux(strUserID, strRepType, strQuarter, strServer);
return(strComment);
}
public DataSet LastApprovers_ADSecDetails(string strUSerSID, string strCurrQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.LastApprovedBy_ADSecDetails(strUSerSID, strCurrQuarter);
return(ds);
}
public string GetPSIComment(string strUserNm, string strQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strComment = objclsDALUsers.GetPSIComment(strUserNm, strQuarter);
return(strComment);
}
public DataSet FetchReportData(string Type, string strPreviousQuarter, string strQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.FetchReportData(Type, strPreviousQuarter, strQuarter);
return(ds);
}
public string LastStatus(string strUserSID, string strCurrQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strLastStatus = objclsDALUsers.LastStatus(strUserSID, strCurrQuarter);
return(strLastStatus);
}
public string LastLinuxApprovers(string strUserSID, string strCurrQuarter, string strDBType, string loginstatus)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strLastApprover = objclsDALUsers.LastLinuxApprovedBy(strUserSID, strCurrQuarter, strDBType, loginstatus);
return(strLastApprover);
}
public string LastSQLApprovers(string strUserSID, string strCurrQuarter, string strDBType)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strLastApprover = objclsDALUsers.LastSQLApprovedBy(strUserSID, strCurrQuarter, strDBType);
return(strLastApprover);
}
public DataSet LastSQLApproversDetails(string strUserSID, string strCurrQuarter, string strDBType)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.LastSQLApprovedByDetails(strUserSID, strCurrQuarter, strDBType);
return(ds);
}
public DataSet FetchAssignedUser_PSI_DB(string strApproverAdid, int intAppID, string strQuarter, string strprevquarter, string strCOSID, string strScope, string strReportType)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.FetchAssignedUser_PSI_DB(strApproverAdid, intAppID, strQuarter, strprevquarter, strCOSID, strScope, strReportType);
return(ds);
}
public DataSet FetchPSIUser(string[] role, int intAppID, string strQuarter, string strPreviousQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.FetchPSIUser(role, intAppID, strQuarter, strPreviousQuarter);
return(ds);
}
public DataSet FetchAllUser(string[] role, int intAppID, string strQuarter, string strPreviousQuarter, string strLoggedInUserName)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.FetchAllUser(role, intAppID, strQuarter, strPreviousQuarter, strLoggedInUserName);
return(ds);
}
public string LastPSIApprovers(string strUserName, string strCurrQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strLastApprover = objclsDALUsers.LastPSIApprovedBy(strUserName, strCurrQuarter);
return(strLastApprover);
}
public DataSet FetchAllORACLEAccountUser(string strQuarter, string strPreviousQuarter, int intAppID, string[] role)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.FetchAllORACLEAccountUser(strQuarter, strPreviousQuarter, intAppID, role);
return(ds);
}
//GetUserDetails
public DataSet GetUserDetails()
{
objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.GetUserDetails();
return(ds);
}
public string GetAdminMailIDs()
{
objclsDALUsers = new clsDALUsers();
string strMailID = objclsDALUsers.GetAdminMailIDs();
return(strMailID);
}
public bool CheckRole(string strRole)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
bool blnExists = objclsDALUsers.CheckRole(strRole);
return(blnExists);
}
public DataSet GetRoles()
{
objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.GetRoles();
return(ds);
}
public string LastStatus_PSI(string LoggedInUserName, string strQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strLastStatus = objclsDALUsers.LastStatus_PSI(LoggedInUserName, strQuarter);
return(strLastStatus);
}
public DataSet GetNewUsers(string strCurrentQuarter, string strPreviousQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
DataSet ds = objclsDALUsers.GetNewUsers(strCurrentQuarter, strPreviousQuarter);
return(ds);
}
public string LastStatus_SecGrp(string strUserID, string strServer, string strCurrQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strLastStatus = objclsDALUsers.LastStatus_SecGrp(strUserID, strServer, strCurrQuarter);
return(strLastStatus);
}
public string LastStatus_SQL(string strUserSID, string strRole, string strDB, string strServer, string strCurrQuarter)
{
clsDALUsers objclsDALUsers = new clsDALUsers();
string strLastStatus = objclsDALUsers.LastStatus_SQL(strUserSID, strRole, strDB, strServer, strCurrQuarter);
return(strLastStatus);
}
public bool CheckIfCo(string loggedInUserSID)
{
objclsDALUsers = new clsDALUsers();
bool IsCO = objclsDALUsers.CheckIFCO(loggedInUserSID);
return(IsCO);
}
public bool SaveUserRole(clsEALUser objclsUser, string userRole, string StrUserADID)
{
objclsDALUsers = new clsDALUsers();
bool bln = objclsDALUsers.SaveUserRole(objclsUser, userRole, StrUserADID);
return(bln);
}
public void SignOffUsersByGlobal_SecGrp(string uID, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, string strServer)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffUsersByGlobal_SecGrp(uID, signoffstatus, objclsEALApprover, Quarter, strServer);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByOthersAllAcc_SQL_AllApp(string scope, Int32 ReportID, string strUserSID, string strUserName, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, Int32 ApplicationID, bool IsAdminUpdate, bool IsAdmin, string strDBType, string strCOSID, string strRole, string strDB, string strServer)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffUsersByOthersAllAcc_SQL_AllApp(scope, ReportID, strUserSID, strUserName, signoffstatus, objclsEALApprover, Quarter, ApplicationID, IsAdminUpdate, IsAdmin, strDBType, strCOSID, strRole, strDB, strServer);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByGlobal_SQL(string uName, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, bool IsAdminUpdate, bool IsAdmin, string strDBType, string strRole, string strDB, string strServer)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffUsersByGlobal_SQL(uName, signoffstatus, objclsEALApprover, Quarter, IsAdminUpdate, IsAdmin, strDBType, strRole, strDB, strServer);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffPSIUsers(string uName, string strStatus_PSI, clsEALUser objclsEALApprover, string strQuarter, string strUserID)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffPSIUsers(uName, strStatus_PSI, objclsEALApprover, strQuarter, strUserID);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByOthersAllAcc_SecGrp(string scope, Int32 Reportid, string strUserID, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, Int32 ApplicationID, string strServer)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffUsersByOthersAllAcc_SecGrp(scope, Reportid, strUserID, signoffstatus, objclsEALApprover, Quarter, ApplicationID, strServer);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByGlobal_Linux(string uID, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, string strServer, string loginstatus, string strgroup)
{
try
{
objclsDALUsers = new clsDALUsers();
objclsDALUsers.SignOffUsersByGlobal_Linux(uID, signoffstatus, objclsEALApprover, Quarter, strServer, loginstatus, strgroup);
}
catch (Exception ex)
{
throw ex;
}
}