//Added by Nag
public DataSet GetLoadExceptionReports(string reportType)
{
objclsDALReports = new clsDALReports();
DataSet pr = objclsDALReports.GetLoadExceptionReports(reportType);
return(pr);
}
public DataSet GetAllRecievedReports(string Quarter)
{
objclsDALReports = new clsDALReports();
DataSet ds = objclsDALReports.GetAllRecievedReports(Quarter);
return(ds);
}
public bool CheckIfDBReportSubmitted(int repID, string repType, string strQuarter)
{
objclsDALReports = new clsDALReports();
bool bln = objclsDALReports.CheckIfDBReportSubmitted(repID, repType, strQuarter);
return(bln);
}
//Added by Nag
public DataSet GetUnmappedSecGrpReport()
{
objclsDALReports = new clsDALReports();
DataSet pr = objclsDALReports.GetUnmappedSecGrpReport();
return(pr);
}
public DataSet SearchAllReport(string Type, string Quarter, int AppID, string SecurityGroup, string LastApproved, string AccountName, string signoffStatus, string Accountstatus, string LoggedInUser, string PreviousQuartertoSelected)
{
clsDALReports objclsDALReports = new clsDALReports();
DataSet ds = objclsDALReports.SearchAllReport(Type, Quarter, AppID, SecurityGroup, LastApproved, AccountName, signoffStatus, Accountstatus, LoggedInUser, PreviousQuartertoSelected);
return(ds);
}
public DataSet GetAllReport(int ApplicationID, string[] role, string Quarter)
{
clsDALReports objclsDALReports = new clsDALReports();
DataSet ds = objclsDALReports.GetAllReport(ApplicationID, role, Quarter);
return(ds);
}
public DataSet CheckIfUserExistsForCurrentQuarter(string strUserSID, string strGroupSID, string scope, int Appid, string strquarter)
{
clsDALReports objclsDALReports = new clsDALReports();
DataSet ds = objclsDALReports.CheckIfUserExistsForCurrentQuarter(strUserSID, strGroupSID, scope, Appid, strquarter);
return(ds);
}
public string LastStatus_DB(string strUserNm, string strCurrQuarter, string strDBRepType)
{
clsDALReports objclsDALReports = new clsDALReports();
string strLastStatus = objclsDALReports.LastStatus_DB(strUserNm, strCurrQuarter, strDBRepType);
return(strLastStatus);
}
//Added by Nag
public DataSet GetTicketReports(string strQuarter, string reportType)
{
objclsDALReports = new clsDALReports();
DataSet pr = objclsDALReports.GetTicketReports(strQuarter, reportType);
return(pr);
}
public DataSet CheckAllDBReports(int AppiD, string strCurrQuarter, string strRepType)
{
objclsDALReports = new clsDALReports();
DataSet ds = objclsDALReports.CheckAllDBReports(AppiD, strCurrQuarter, strRepType);
return(ds);
}
public bool CheckIfReportSubmitted(int repID)
{
objclsDALReports = new clsDALReports();
bool bln = objclsDALReports.CheckIfReportSubmitted(repID);
return(bln);
}
//Added by Nag
public DataSet GetPendingApprovalReports(string approverName, string reportType)
{
objclsDALReports = new clsDALReports();
DataSet pr = objclsDALReports.GetPendingApprovalUsers(approverName, reportType);
return(pr);
}
public string GetComment(Int32 ReportID, string SID, string GroupSID)
{
string comment = string.Empty;
clsDALReports objclsDALReports = new clsDALReports();
comment = objclsDALReports.GetComment(ReportID, SID, GroupSID);
return(comment);
}
public string GetDBComment(Int32 ReportID, string UserNm, string strRepType)
{
string comment = string.Empty;
clsDALReports objclsDALReports = new clsDALReports();
comment = objclsDALReports.GetDBComment(ReportID, UserNm, strRepType);
return(comment);
}
public string GetSecGrpComment(Int32 RowID)
{
string comment = string.Empty;
clsDALReports objclsDALReports = new clsDALReports();
comment = objclsDALReports.GetSecGrpComment(RowID);
return(comment);
}
public void UpdateComment(string comment, string scope, string strQuarter, int AppID, string ApproverSID, Int32 ReportID, string SID, string GroupSID)
{
try
{
clsDALReports objclsDALReports = new clsDALReports();
objclsDALReports.UpdateComment(comment, scope, strQuarter, AppID, ApproverSID, ReportID, SID, GroupSID);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateISAdmin(string usersid, Int32 ReportID, bool IsAdmin)
{
try
{
objclsDALReports = new clsDALReports();
objclsDALReports.UpdateISAdmin(usersid, ReportID, IsAdmin);
}
catch (Exception ex)
{
throw ex;
}
}
public void SubmitDBReport(Int32 ReportID, clsEALUser objApprover, string quarter, string strrepType)
{
try
{
objclsDALReports = new clsDALReports();
objclsDALReports.SubmitDBReport(ReportID, objApprover, quarter, strrepType);
}
catch (Exception ex)
{
throw ex;
}
}
public void SubmitReport(Int32 ReportID, clsEALUser objApprover)
{
try
{
objclsDALReports = new clsDALReports();
objclsDALReports.SubmitReport(ReportID, objApprover);
}
catch (Exception ex)
{
throw ex;
}
}
//public int SignOffDBUsersByOthers(string scope, Int32 ReportID, string strUserNm, string strDatabase, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, Int32 ApplicationID, string IsSA, string strRepType)
//{
// try
// {
// objclsDALReports = new clsDALReports();
// return objclsDALReports.SignOffDBUsersByOthers(scope, ReportID, strUserNm, strDatabase, signoffstatus, objclsEALApprover, Quarter, ApplicationID, IsSA, strRepType);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public int SignOffDBUsersByOthers(string scope, Int32 ReportID, string strUserNm, string strDatabase, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, Int32 ApplicationID, string IsSA, string strRepType, string strDBUser_ID)
{
try
{
objclsDALReports = new clsDALReports();
return(objclsDALReports.SignOffDBUsersByOthers(scope, ReportID, strUserNm, strDatabase, signoffstatus, objclsEALApprover, Quarter, ApplicationID, IsSA, strRepType, strDBUser_ID));
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByOthersAllAppScope(string scope, Int32 ReportID, string strUserSID, string strGroupSID, string signoffstatus, clsEALUser objclsEALApprover, string strCOSID, string Quarter, Int32 ApplicationID, bool IsAdminUpdate, bool IsAdmin)
{
try
{
objclsDALReports = new clsDALReports();
objclsDALReports.SignOffUsersByOthersAllAppScope(scope, ReportID, strUserSID, strGroupSID, signoffstatus, objclsEALApprover, strCOSID, Quarter, ApplicationID, IsAdminUpdate, IsAdmin);
}
catch (Exception ex)
{
throw ex;
}
}
public void SignOffUsersByGlobal(string usersid, string strgroupsid, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, bool IsAdminUpdate, bool IsAdmin)
{
try
{
objclsDALReports = new clsDALReports();
objclsDALReports.SignOffUsersByGlobal(usersid, strgroupsid, signoffstatus, objclsEALApprover, Quarter, IsAdminUpdate, IsAdmin);
}
catch (Exception ex)
{
throw ex;
}
}
//public void UpdateDBComment(string comment, string scope, string strQuarter, int AppID, string ApproverAdid, Int32 ReportID, string UserNm, string reportType, string strDBnm)
//{
// try
// {
// clsDALReports objclsDALReports = new clsDALReports();
// objclsDALReports.UpdateDBComment(comment, scope, strQuarter, AppID, ApproverAdid, ReportID, UserNm, reportType, strDBnm);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public void UpdateDBComment(string comment, string scope, string strQuarter, int AppID, string ApproverAdid, Int32 ReportID, string UserNm, string reportType, string strDBnm, string strDBUser_ID)
{
try
{
clsDALReports objclsDALReports = new clsDALReports();
objclsDALReports.UpdateDBComment(comment, scope, strQuarter, AppID, ApproverAdid, ReportID, UserNm, reportType, strDBnm, strDBUser_ID);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateSecGrpComment(string comment, string scope, string strQuarter, int AppID, string ApproverAdid, Int32 ServerID, string strUser_ID)
{
try
{
clsDALReports objclsDALReports = new clsDALReports();
objclsDALReports.UpdateSecGrpComment(comment, scope, strQuarter, AppID, ApproverAdid, ServerID, strUser_ID);
}
catch (Exception ex)
{
throw ex;
}
}
public int SignOffUsersByGlobalReport_Ora(string userNm, string strRole, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, int ReportID, string scope)
{
try
{
objclsDALReports = new clsDALReports();
return(objclsDALReports.SignOffUsersByGlobalReport_Ora(userNm, strRole, signoffstatus, objclsEALApprover, Quarter, ReportID, scope));
}
catch (Exception ex)
{
throw ex;
}
}
public int SignOffUsersByGlobalReport(string usersid, string strGroupsid, string signoffstatus, clsEALUser objclsEALApprover, string Quarter, bool IsAdminUpdate, bool IsAdmin, int ReportID, string scope)
{
try
{
objclsDALReports = new clsDALReports();
return(objclsDALReports.SignOffUsersByGlobalReport(usersid, strGroupsid, signoffstatus, objclsEALApprover, Quarter, IsAdminUpdate, IsAdmin, ReportID, scope));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetReportDetails(int ReportID, string strReportType, string SelectedQuarter)
{
try
{
clsDALReports objclsDALReports = new clsDALReports();
objds = objclsDALReports.GetReportDetails(ReportID, strReportType, SelectedQuarter);
return(objds);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetSearchDetails(int ReportID, string strRepType, string strQuarter, string PreviousQuarter, int ApplicationID, bool IsGlobalApprover, string LoggeInUser, string[] role, Int32 UserID)
{
try
{
clsDALReports objclsDALReports = new clsDALReports();
objds = objclsDALReports.GetSearchDetails(ReportID, strRepType, strQuarter, PreviousQuarter, ApplicationID, IsGlobalApprover, LoggeInUser, role, UserID);
return(objds);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetApplication(Int32 AppID)
{
try
{
objclsDALReports = new clsDALReports();
DataSet ds = objclsDALReports.GetApplication(AppID);
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetOracleReportsForUser(int AppID, string strUserNm, string strRole, string strquarter)
{
objclsDALReports = new clsDALReports();
return(objclsDALReports.GetDistinctOracleReportsForUser(AppID, strUserNm, strRole, strquarter));
}
