decimal getN(RainVariables rainVariables) //getting n method { decimal _getN = 0; using (projectappdbContext db = new projectappdbContext()){ string ChoosenRegion = Region.SelectionBoxItem as string; if (rainVariables.P >= 1) { var n = db.Pril2NPlessPaboveMrGamma.Where(el => el.Region == ChoosenRegion && rainVariables.P >= 1) .Select(el => el.NPless1) .FirstOrDefault(); _getN = n; } else { var n = db.Pril2NPlessPaboveMrGamma.Where(el => el.Region == ChoosenRegion && rainVariables.P < 1) .Select(el => el.NPabove1) .FirstOrDefault(); _getN = n; } } return(_getN); } //end of getting n method
static internal List <string> getRegionList() { List <string> RegionList; using (projectappdbContext db = new projectappdbContext()) { var Regions = db.Pril2NPlessPaboveMrGamma.Select(p => p.Region).ToList(); RegionList = Regions; } return(RegionList); }
static internal List <string> getPlaceList() { List <string> PlaceList; using (projectappdbContext db = new projectappdbContext()) { var Places = db.Pril11RegionIdHcpCvCs.Select(r => r.RegionName).ToList(); PlaceList = Places; } return(PlaceList); }
} //end of getting gamma method decimal getHc(RainVariables rainVariables) //getting gamma method { decimal _Hc = 0; using (projectappdbContext db = new projectappdbContext()){ int ClimateIdFromCombobox = 1; var Hc = db.Table12SloyTalikhVod.Where(el => el.ClimateId == ClimateIdFromCombobox).Select(el => el.P015).FirstOrDefault(); _Hc = Hc; } return(_Hc); } //end of getting gamma method
}//end of getting mr method decimal getGamma(RainVariables rainVariables) //getting gamma method { decimal _getGamma = 0; using (projectappdbContext db = new projectappdbContext()){ string ChoosenRegion = Region.SelectionBoxItem as string; var mr = db.Pril2NPlessPaboveMrGamma.Where(el => el.Region == ChoosenRegion).Select(el => el.Gamma).FirstOrDefault(); _getGamma = mr; } return(_getGamma); } //end of getting gamma method
//getting z_road and z_roof values decimal get_Z_roadAndRoof(RainVariables rainVariables) { bool getN = n_LESS065(rainVariables.n); int A_prev = (int)Math.Floor(rainVariables.A / 100) * 100; int A_next = (int)Math.Ceiling(rainVariables.A / 100) * 100; decimal z_A_prev = 0; //get this! by Linq. decimal z_A_next = 0; //get this! by Linq. //getting z_road and z_roof values from db for further interpolation using (projectappdbContext db = new projectappdbContext()){ if (getN == true) { var _z_A_prev = db.Table11ZiVodonepronitsaemie.Where(el => el.A == A_prev).Select(el => el.NAbove065).FirstOrDefault(); //last of default doesnt work, FIX == (step 100 and 200) var _z_A_next = db.Table11ZiVodonepronitsaemie.Where(el => el.A >= A_next).Select(el => el.NAbove065).FirstOrDefault(); z_A_prev = _z_A_prev; z_A_next = _z_A_next; } else { var _z_A_prev = db.Table11ZiVodonepronitsaemie.Where(el => el.A == A_prev).Select(el => el.NLess065).FirstOrDefault(); //last of default doesnt work, FIX == (step 100 and 200) var _z_A_next = db.Table11ZiVodonepronitsaemie.Where(el => el.A >= A_next).Select(el => el.NLess065).FirstOrDefault(); z_A_prev = _z_A_prev; z_A_next = _z_A_next; } } //end of getting z_road and z_roof values. decimal deltaMain = (z_A_next - z_A_prev) / (A_next - A_prev); //interpolation part decimal diff = rainVariables.A - A_prev; decimal InterpolationResult = z_A_prev + deltaMain * diff; return(InterpolationResult); //end of interpolation part. end of getting z_road and z_roof values }