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);
}
}
