public override string[] GetRolesForUser(string username) { using (UIAEntities db = new UIAEntities()) { string spiltUsername = username.Split('|')[0].ToString(); string data = db.Users.Where(x => x.Username == spiltUsername).FirstOrDefault().Role; string[] result = { data }; return(result); } }
public decimal GetTotalPrice(string[] DOBList, string[] seats, Guid flightID) { List <decimal> ticketsPrices = new List <decimal>(); string flightClass = null; using (UIAEntities db = new UIAEntities()) { var flightDetail = (from f in db.Pricings where f.FlightID == flightID select f).ToList(); for (int i = 0; i < DOBList.Length; i++) { if (Convert.ToInt16(seats[i]) <= 18 && Convert.ToInt16(seats[i]) >= 1) { flightClass = "First"; } else if (Convert.ToInt16(seats[i]) <= 60 && Convert.ToInt16(seats[i]) >= 19) { flightClass = "Business"; } else if (Convert.ToInt16(seats[i]) <= 180 && Convert.ToInt16(seats[i]) >= 61) { flightClass = "Economy"; } string ageCategory = GetAgeCategory(DOBList[i]); var price = (from f in flightDetail where f.AgeCategory == ageCategory && f.ClassCategory == flightClass select f.Price).First(); ticketsPrices.Add(price); } decimal totalPrice = ticketsPrices.Sum(); return(totalPrice); } }