public static List <generic_AMatrix> getregioanlamtrix(string region_name)
{
PEIEntities7 Ganesh = new PEIEntities7();
List <generic_AMatrix> empList = null;
if (region_name.Substring(region_name.Length - 4) != "Rest")
{
var empQuery = from emp in Ganesh.spAlabama_AMatrix(region_name + "_AMatrix ").ToList()//Ganesh.Alabama_AMatrix
select new generic_AMatrix {
ID = emp.ID, VALUE = emp.VALUE
};
empList = empQuery.ToList();
}
if (region_name.Substring(region_name.Length - 4) == "Rest")//instead of name check last 4 letters rest
{
if (region_name == "AlabamaRest")
{
region_name = "Z_" + region_name; //special cas for labama
}
//region abalama rest table a bitterent name given
var empQuery = from emp in Ganesh.spz_AlabamaRest_AMatrix(region_name + "_AMatrix ").ToList() //Ganesh.z_AlabamaRest_AMatrix //z_AlabamaRest_AMatrix
select new generic_AMatrix {
ID = emp.ID, VALUE = emp.VALUE
};
empList = empQuery.ToList();
}
return(empList);
}
