public string GetCurrentQuarter()
{
objclsDALCommon = new clsDALCommon();
string strCurrQuarter = objclsDALCommon.GetCurrentQuarter();
return(strCurrQuarter);
}
public DataSet CheckIfUserExistsForCurrentQuarter_DB(string strUserSID, string scope, int Appid, string strquarter, string strDBType)
{
objclsDALCommon = new clsDALCommon();
DataSet ds = objclsDALCommon.CheckIfUserExistsForCurrentQuarter_DB(strUserSID, scope, Appid, strquarter, strDBType);
return(ds);
}
public DataSet GetAppScope(int AppId, string strApproverADID)
{
objclsDALCommon = new clsDALCommon();
DataSet ds = objclsDALCommon.GetAppScope(AppId, strApproverADID);
return(ds);
}
public DataSet GetControlOwnersEmailIDS()
{
objclsDALCommon = new clsDALCommon();
DataSet ds = objclsDALCommon.GetControlOwnersEmailIDs();
return(ds);
}
public string GetHomepageText()
{
objclsDALCommon = new clsDALCommon();
string strText = objclsDALCommon.GetHomepageText();
return(strText);
}
//Added by Nag
public DataTable GetAllApprovers(string ReportType)
{
objclsDALCommon = new clsDALCommon();
DataTable dtstatus = objclsDALCommon.GetAllApprovers(ReportType);
return(dtstatus);
}
public DataTable GetAvailableQuarters()
{
objclsDALCommon = new clsDALCommon();
DataTable dtQuarter = objclsDALCommon.GetAvailableQuarters();
return(dtQuarter);
}
public DataTable GetAccountStatusPSI()
{
objclsDALCommon = new clsDALCommon();
DataTable dtstatus = objclsDALCommon.GetAccountStatusPSI();
return(dtstatus);
}
public DataTable GetCurrentManagers(string quarter)
{
objclsDALCommon = new clsDALCommon();
DataTable dtstatus = objclsDALCommon.GetCurrentManagers(quarter);
return(dtstatus);
}
public DataSet GetAppControlOwnerInfo(int intAppID)
{
objclsDALCommon = new clsDALCommon();
DataSet ds = objclsDALCommon.GetAppControlOwnerInfo(intAppID);
return(ds);
}
public DataTable GetSignOffStatus()
{
objclsDALCommon = new clsDALCommon();
DataTable dtstatus = objclsDALCommon.GetSignOffStatus();
return(dtstatus);
}
public DataSet GetSOXScope(int AppId)
{
objclsDALCommon = new clsDALCommon();
DataSet ds = objclsDALCommon.GetSOXScope(AppId);
return(ds);
}
public bool CheckIfNextQuarterReportExists(string strCurrQuarter)
{
objclsDALCommon = new clsDALCommon();
bool blnNextQuarterReportExists = objclsDALCommon.CheckIfNextQuarterReportExists(strCurrQuarter);
return(blnNextQuarterReportExists);
}
public string GetNextQuarter(string strcurrQuarter)
{
objclsDALCommon = new clsDALCommon();
string strNextQuarter = objclsDALCommon.GetNextQuarter(strcurrQuarter);
return(strNextQuarter);
}
public string GetLatestQuarter_DB(string strDBType)
{
objclsDALCommon = new clsDALCommon();
string strCurrQuarter = objclsDALCommon.GetLatestQuarter_DB(strDBType);
return(strCurrQuarter);
}
public void DeleteSelectiveApproval(string strloggedInUserSID, string strApproverSID,
string strCurrQuarter, int intAppId, string strScope, string sReportType)
{
objclsDALCommon = new clsDALCommon();
objclsDALCommon.DeleteSelectiveApproval(strloggedInUserSID, strApproverSID, strCurrQuarter, intAppId, strScope, sReportType);
}
public void UpdateSelectiveQuarter_DB(string strLoggedInUserName, string strloggedInUserSID, string strApproverSID, string strApproverName, string strApproverEmail, string strFetchedQuarter, string strCurrQuarter, int intAppId, bool IsGlobal, string strScope, string strDBType)
{
objclsDALCommon = new clsDALCommon();
objclsDALCommon.UpdateSelectiveQuarter_DB(strLoggedInUserName, strloggedInUserSID, strApproverSID, strApproverName, strApproverEmail, strFetchedQuarter, strCurrQuarter, intAppId, IsGlobal, strScope, strDBType);
//return blnSave;
}
public DataSet FetchApproval_DB(string strLoggedInSID, string strDBType)
{
objclsDALCommon = new clsDALCommon();
return(objclsDALCommon.FetchApproval_DB(strLoggedInSID, strDBType));
}
public void ModifyReportAdminRight(string strUserSID, string strGroupSID, int AppID, int RepID, string scope, string strLoggedInUserSID, string strSelectedQuarter)
{
objclsDALCommon = new clsDALCommon();
objclsDALCommon.ModifyReportAdminRights(strUserSID, strGroupSID, AppID, RepID, scope, strLoggedInUserSID, strSelectedQuarter);
}
public void CheckIFUserExistsInCurrentQuarter(string strUserSID, string strCurrQuarter, string PreviousQuartertoSelected, int intAppId, string role)
{
objclsDALCommon = new clsDALCommon();
objclsDALCommon.CheckIFUserExistsInCurrentQuarter(strUserSID, strCurrQuarter, PreviousQuartertoSelected, intAppId, role);
}
//code added by Suman
public DataTable GetCommonFields(string Field)
{
objclsDALCommon = new clsDALCommon();
return(objclsDALCommon.GetCommonFields(Field));
}
public bool SetHomepageText(string strText)
{
objclsDALCommon = new clsDALCommon();
objclsDALCommon.SetHomepageText(strText);
return(true);
}
public void SaveSelectiveApproval_linux(string strLoggedInUserName, string strloggedInUserSID, string strApproverSID, string strApproverName, string strApproverEmail, string strUserSID, string strServerName, string strUserName, string strDataBaseName, string strCurrQuarter, int intAppId, bool IsGlobal, string strScope, string strDBType, string strSignOffStatus, string strRole)
{
objclsDALCommon = new clsDALCommon();
objclsDALCommon.SaveSelectiveApproval_linux(strLoggedInUserName, strloggedInUserSID, strApproverSID, strApproverName, strApproverEmail, strUserSID, strServerName, strUserName, strDataBaseName, strCurrQuarter, intAppId, IsGlobal, strScope, strDBType, strSignOffStatus, strRole);
//return blnSave;
}
public void ModifyAdminRight_SQL(string strUserSID, int intAppID, string scope, string strLoggedInUserSID, string strSelectedQuarter, string strDBType)
{
objclsDALCommon = new clsDALCommon();
objclsDALCommon.ModifyAdminRights_SQL(strUserSID, intAppID, scope, strLoggedInUserSID, strSelectedQuarter, strDBType);
}
public DataTable GetRoleWiseUser(int roleID)
{
objclsDALCommon = new clsDALCommon();
return(objclsDALCommon.GetRoleWiseUser(roleID));
}
public DataSet FetchApproval_PSI(string strLoggedInSID)
{
objclsDALCommon = new clsDALCommon();
return(objclsDALCommon.FetchApproval_PSI(strLoggedInSID));
}
public void UpdateSelectiveQuarter(string strLoggedInUserName, string strloggedInUserSID, string strApproverSID, string strApproverName, string strApproverEmail, string strUserSID, string strgroupSID, string strCurrQuarter, int intAppId, bool IsGlobal, string strScope, string strusernm, string strGroupNm)
{
objclsDALCommon = new clsDALCommon();
objclsDALCommon.UpdateSelectiveQuarter(strLoggedInUserName, strloggedInUserSID, strApproverSID, strApproverName, strApproverEmail, strUserSID, strgroupSID, strCurrQuarter, intAppId, IsGlobal, strScope, strusernm, strGroupNm);
//return blnSave;
}