public static List <generic_DefaultData> getdefaultrecords(String regionname)
{
PEIEntities7 Ganesh = new PEIEntities7();
List <generic_DefaultData> empList = null;
if (regionname.Substring(regionname.Length - 4) != "Rest")
{
var empQuery = from emp in Ganesh.spAlabama_DefaultData(regionname + "_DefaultData").ToList() //Ganesh.Alabama_DefaultData
orderby emp.RIO
select new generic_DefaultData
{
RIO = emp.RIO,
RIO_KEY = emp.RIO_KEY,
RIO_DESC = emp.RIO_DESC,
REGION_ID = emp.REGION_ID,
Inc = emp.Inc,
Emp = emp.Emp,
GDP = emp.GDP,
Wages = emp.Wages,
P = emp.P,
FederalGen = emp.FederalGen,
FederalIns = emp.FederalIns,
State = emp.State,
Local = emp.Local,
Supply = emp.Supply,
Demand = emp.Demand,
IncomeTotal = emp.IncomeTotal,
EmploymentTotal = emp.EmploymentTotal,
GDPTotal = emp.GDPTotal,
LocalTotal = emp.LocalTotal,
StateTotal = emp.StateTotal,
FederalGenTotal = emp.FederalGenTotal
};
empList = empQuery.ToList();
}
if (regionname.Substring(regionname.Length - 4) == "Rest")
{
var empQuery = from emp in Ganesh.spAlabamaRest_DefaultData(regionname + "_DefaultData").ToList()//Ganesh.AlabamaRest_DefaultData
orderby emp.RIO
select new generic_DefaultData
{
RIO = emp.RIO,
RIO_KEY = emp.RIO_KEY,
RIO_DESC = emp.RIO_DESC,
REGION_ID = emp.REGION_ID,
Inc = emp.Inc,
Emp = emp.Emp,
GDP = emp.GDP,
Wages = emp.Wages,
P = emp.P,
FederalGen = emp.FederalGen,
FederalIns = emp.FederalIns,
State = emp.State,
Local = emp.Local,
Supply = emp.Supply,
Demand = emp.Demand,
IncomeTotal = emp.IncomeTotal,
EmploymentTotal = emp.EmploymentTotal,
GDPTotal = emp.GDPTotal,
LocalTotal = emp.LocalTotal,
StateTotal = emp.StateTotal,
FederalGenTotal = emp.FederalGenTotal
};
empList = empQuery.ToList();
}
return(empList);
}
