public DataTable GetSubDepartment()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetSubDepartment");
return(dt_GNF);
}
public DataTable GetOpportunityProposal()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_Proposal");
return(dt_GD);
}
public DataTable GetAccount()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GA = objDBAcess.SP_Datatable("GetCustomerIdentification");
return(dt_GA);
}
public DataTable GetOpportunityBudgetary()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_BudgetaryOpportunity");
return(dt_GD);
}
public DataTable GetOpportunitySurveyEBU()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_Survey_EBU");
return(dt_GD);
}
public DataTable GetALLServices()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GAS = objDBAcess.SP_Datatable("GetServiceUnits");
return(dt_GAS);
}
public DataTable GetContactType()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_CCT = objDBAcess.SP_Datatable("sp_Sales_GetContactType");
return(dt_CCT);
}
public DataTable GetActivityStatus()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetActivityStatus");
return(dt_GNF);
}
public DataTable GetCloserRemarks()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetCloserRemarks");
return(dt_GNF);
}
public DataTable GetRegionforSysUsers()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetRegion");
return(dt_GNF);
}
public DataTable GetCustomerCode()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetCustomerCode");
return(dt_GNF);
}
public DataTable GetReportingManager()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetReportingManager");
return(dt_GNF);
}
public DataTable GetResourceRole()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetResourceRole");
return(dt_GNF);
}
public DataTable GetServiceUnitSysUser()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetServiceUnit");
return(dt_GNF);
}
public DataTable GetAllOppStatus()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("sp_OppStatus");
return(dt);
}
//---------------------------------------
public DataTable GetCompView()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("GetComplaintSD");
return(dt_GNF);
}
public DataTable GetDomain()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("sp_SelDomain");
return(dt_GD);
}
public DataTable GetPriority()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("OM_GetPriority");
return(dt_GNF);
}
public DataTable GetCurrency()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GOS = objDBAcess.SP_Datatable("sp_GetCurrency");
return(dt_GOS);
}
public DataTable GetTerritoryHead()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetTerritoryHead");
return(dt_GNF);
}
public DataTable GetContactReligion()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_CR = objDBAcess.SP_Datatable("sp_Sales_GetContactReligion");
return(dt_CR);
}
public DataTable GetALLBusinessType()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("GetBusinessType");
return(dt);
}
public DataTable GetOpportunityRequirementEBU()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_Requirement_EBU");
return(dt_GD);
}
public DataTable GetAllInfra()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("Get_LOB");
return(dt);
}
public DataTable GetOpportunityBusinessCaseEBU()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_BusinessCase_EBU");
return(dt_GD);
}
public DataTable GetAllAccounts()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("sp_CPM_GetMasterCustomer");
return(dt);
}
public DataTable GetALLBandWidth()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("GetBandwidthEnterprise");
return(dt);
}
public DataTable GetAllCurrencies()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt = objDBAcess.SP_Datatable("sp_Get_Currency");
return(dt);
}
public DataTable GetAllOpportunity()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GAO = objDBAcess.SP_Datatable("sp_Get_Opportunity");
return(dt_GAO);
}
public DataTable GetDesignation()
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNF = objDBAcess.SP_Datatable("RM_GetDesignation");
return(dt_GNF);
}
