/// <summary>
/// Include is needed cause entities are not tracked in context.
/// </summary>
public void UseNoTracking1()
{
using var context = new AnimalContext();
var crows = context.Crows.Include(crow => crow.Grades).AsNoTracking().ToList();
crows = context.Crows.ToList();
Console.ForegroundColor = ConsoleColor.Magenta;
foreach (var crow in crows)
{
Console.WriteLine(crow);
if (crow.Grades != null)
{
foreach (var grade in crow.Grades)
{
Console.Write("\t");
Console.WriteLine(grade);
}
}
}
Console.ForegroundColor = ConsoleColor.White;
}
/// <summary>
/// Cast to derived type.
/// Include is needed.
/// </summary>
public void RSRP_481554_1()
{
using var context = new AnimalContext();
using var transaction = context.Database.BeginTransaction();
Console.ForegroundColor = ConsoleColor.Magenta;
foreach (var food in context.Food)
{
var normalFood = (NormalFood)food;
Console.WriteLine(normalFood);
if (normalFood.Drawbacks != null)
{
foreach (var drawback in normalFood.Drawbacks)
{
Console.Write("\t");
Console.WriteLine(drawback);
}
}
}
Console.ForegroundColor = ConsoleColor.White;
transaction.Commit();
}
public Repository(AnimalContext context)
{
Context = context;
}
public AnimalsController(AnimalContext context)
{
_context = context;
}
public UsersController(AnimalContext context)
{
_context = context;
}
public UserRepository(AnimalContext context) : base(context)
{
}
public feedFoodersController(AnimalContext context)
{
_context = context;
}
// private DbSet<T> dbEntity;
public Repository(AnimalContext Context)
{
db = Context;
//dbEntity = db.Set<T>();
}
public TestController(AnimalContext context)
{
_context = context;
}
public AnimalRepository(AnimalContext context)
{
_context = context ?? throw new ArgumentNullException(nameof(context));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// Verify user has completed the checkout process.
if ((string)Session["userCheckoutCompleted"] != "true")
{
Session["userCheckoutCompleted"] = string.Empty;
Response.Redirect("CheckoutError.aspx?" + "Desc=Unvalidated%20Checkout.");
}
NVPAPICaller payPalCaller = new NVPAPICaller();
string retMsg = "";
string token = "";
string finalPaymentAmount = "";
string PayerID = "";
NVPCodec decoder = new NVPCodec();
token = Session["token"].ToString();
PayerID = Session["payerId"].ToString();
finalPaymentAmount = Session["payment_amt"].ToString();
bool ret = payPalCaller.DoCheckoutPayment(finalPaymentAmount, token, PayerID, ref decoder, ref retMsg);
if (ret)
{
// Retrieve PayPal confirmation value.
string PaymentConfirmation = decoder["PAYMENTINFO_0_TRANSACTIONID"].ToString();
TransactionId.Text = PaymentConfirmation;
AnimalContext _db = new AnimalContext();
// Get the current order id.
int currentOrderId = -1;
if (Session["currentOrderId"] != string.Empty)
{
currentOrderId = Convert.ToInt32(Session["currentOrderID"]);
}
Order myCurrentOrder;
if (currentOrderId >= 0)
{
// Get the order based on order id.
myCurrentOrder = _db.Orders.Single(o => o.OrderId == currentOrderId);
// Update the order to reflect payment has been completed.
myCurrentOrder.PaymentTransactionId = PaymentConfirmation;
// Save to DB.
_db.SaveChanges();
}
// Clear shopping cart.
using (WebForms.Logic.ShoppingCartActions usersShoppingCart =
new WebForms.Logic.ShoppingCartActions())
{
usersShoppingCart.EmptyCart();
}
// Clear order id.
Session["currentOrderId"] = string.Empty;
}
else
{
Response.Redirect("CheckoutError.aspx?" + retMsg);
}
}
}
public HabitatEnrichmentsController(AnimalContext context)
{
_context = context;
}
public DBAnimal(AnimalContext context)
: base(context)
{
}
private static void SeedDb()
{
using var context = new AnimalContext();
context.Database.Delete();
context.Database.Create();
#region Seed TPT (Animal)
var beaver1 = new Beaver
{
Name = "SomeBeavers1",
Age = 27,
Fluffiness = FluffinessEnum.VeryFluffy,
Size = 15,
IpAddress = "127.0.0.1"
};
var beaver2 = new Beaver
{
Name = "SomeBeavers2",
Age = 26,
Fluffiness = FluffinessEnum.Fluffy,
Size = 14,
IpAddress = "127.0.0.1"
};
var beaver3 = new Beaver
{
Name = "SomeBeavers3",
Age = 25,
Fluffiness = FluffinessEnum.NotFluffy,
Size = 13,
IpAddress = "127.0.0.1"
};
var beaver4 = new Beaver
{
Name = "SomeBeavers4",
Age = 24,
Fluffiness = FluffinessEnum.Fluffy,
Size = 12,
IpAddress = "127.0.0.1"
};
var beaver5 = new Beaver
{
Name = "SomeBeavers5",
Age = 23,
Fluffiness = FluffinessEnum.VeryFluffy,
Size = 11,
IpAddress = "127.0.0.1"
};
var crow1 = new Crow
{
Name = "Crowly",
Age = 5,
Color = "black",
Size = 1,
IpAddress = "127.0.0.1"
};
var crow2 = new Crow
{
Name = "Crowly1",
Age = 5,
Color = "black",
Size = 1,
IpAddress = "127.0.0.1"
};
var crow3 = new Crow
{
Name = "Crowly2",
Age = 22,
Color = "black",
Size = 4,
IpAddress = "127.0.0.1"
};
var crow4 = new Crow
{
Name = "Crowly3",
Age = 50,
Color = "white",
Size = 10,
IpAddress = "127.0.0.1"
};
var crow5 = new Crow
{
Name = "Crowly4",
Age = 5,
Color = "pink",
Size = 1,
IpAddress = "127.0.0.1"
};
var deer1 = new Deer
{
Name = "Dasher",
Age = 1,
Horns = true,
IpAddress = "127.0.0.1"
};
var deer2 = new Deer
{
Name = "Dancer",
Age = 2,
Horns = true,
IpAddress = "127.0.0.1"
};
var deer3 = new Deer
{
Name = "Prancer",
Age = 1,
Horns = false,
IpAddress = "127.0.0.1"
};
var deer4 = new Deer
{
Name = "Vixen",
Age = 1,
Horns = true,
IpAddress = "127.0.0.1"
};
var deer5 = new Deer
{
Name = "Comet",
Age = 1,
Horns = true,
IpAddress = "127.0.0.1"
};
var deer6 = new Deer
{
Name = "Cupid",
Age = 1,
Horns = false,
IpAddress = "127.0.0.1"
};
var deer7 = new Deer
{
Name = "Donder ",
Age = 1,
Horns = true,
IpAddress = "127.0.0.1"
};
var deer8 = new Deer
{
Name = "Blitzen",
Age = 1,
Horns = true,
IpAddress = "127.0.0.1"
};
context.Beavers.Add(beaver1);
context.Beavers.Add(beaver2);
context.Beavers.Add(beaver3);
context.Beavers.Add(beaver4);
context.Beavers.Add(beaver5);
context.Crows.Add(crow1);
context.Crows.Add(crow2);
context.Crows.Add(crow3);
context.Crows.Add(crow4);
context.Crows.Add(crow5);
context.Deers.Add(deer1);
context.Deers.Add(deer2);
context.Deers.Add(deer3);
context.Deers.Add(deer4);
context.Deers.Add(deer5);
context.Deers.Add(deer6);
context.Deers.Add(deer7);
context.Deers.Add(deer8);
#endregion
#region Seed Many-to-many (Club)
var club1 = new Club
{
Title = "TreesWorshipers",
Animals = new List <Animal> {
beaver1, beaver2, beaver3, beaver4, beaver5, crow4
},
Locations = new List <Location>
{
new()
{
Address = "North America",
GeographicLocation = DbGeography.FromText("POINT(-122 47)")
},
new()
{
Address = "Canada",
GeographicLocation = DbGeography.FromText("POINT(122 40)")
},
new()
{
Address = "Russia",
GeographicLocation = DbGeography.FromText("POINT(1 1)")
}
}
};
var club2 = new Club
{
Title = "CornLovers",
Animals = new List <Animal> {
crow1, crow2, crow3, crow4, crow5
},
Locations = new List <Location>
{
new()
{
Address = "Westeros",
GeographicLocation = DbGeography.FromText("POINT(00 00)")
}
}
};
var club3 = new Club
{
Title = "ChristmasTeam",
Animals = new List <Animal>
{
beaver1, beaver2, beaver3, beaver4, beaver5,
crow1, crow2, crow3, crow4, crow5,
deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8
},
Locations = new List <Location>
{
new()
{
Address = "North Pole",
GeographicLocation = DbGeography.FromText("POINT(9 9)")
}
}
};
context.Clubs.Add(club1);
context.Clubs.Add(club2);
context.Clubs.Add(club3);
#endregion
#region Seed Grades
var grade1 = new Grade
{
TheGrade = 5,
Club = club1,
Animal = beaver1
};
var grade2 = new Grade
{
TheGrade = 4,
Club = club1,
Animal = beaver2
};
var grade3 = new Grade
{
TheGrade = 3,
Club = club1,
Animal = beaver3
};
var grade4 = new Grade
{
TheGrade = 3,
Club = club1,
Animal = beaver4
};
var grade5 = new Grade
{
TheGrade = 2,
Club = club1,
Animal = beaver5
};
var grade6 = new Grade
{
TheGrade = 1,
Club = club1,
Animal = crow4
};
var grade7 = new Grade
{
TheGrade = 5,
Club = club2,
Animal = crow1
};
var grade8 = new Grade
{
TheGrade = 4.5,
Club = club2,
Animal = crow2
};
var grade9 = new Grade
{
TheGrade = 2.1,
Club = club2,
Animal = crow3
};
var grade10 = new Grade
{
TheGrade = 4.3,
Club = club2,
Animal = crow4
};
var grade27 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver1
};
var grade26 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver2
};
var grade25 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver3
};
var grade24 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver4
};
var grade23 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver5
};
var grade22 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = crow1
};
var grade21 = new Grade
{
TheGrade = 3.5,
Club = club3,
Animal = crow2
};
var grade20 = new Grade
{
TheGrade = 2.5,
Club = club3,
Animal = crow3
};
var grade19 = new Grade
{
TheGrade = 1.5,
Club = club3,
Animal = crow4
};
var grade28 = new Grade
{
TheGrade = 4.9,
Club = club3,
Animal = crow5
};
var grade11 = new Grade
{
TheGrade = 4.8,
Club = club3,
Animal = deer1
};
var grade12 = new Grade
{
TheGrade = 4.7,
Club = club3,
Animal = deer2
};
var grade13 = new Grade
{
TheGrade = 4.6,
Club = club3,
Animal = deer3
};
var grade14 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = deer4
};
var grade15 = new Grade
{
TheGrade = 4.4,
Club = club3,
Animal = deer5
};
var grade16 = new Grade
{
TheGrade = 4.3,
Club = club3,
Animal = deer6
};
var grade17 = new Grade
{
TheGrade = 4.2,
Club = club3,
Animal = deer7
};
var grade18 = new Grade
{
TheGrade = 4.1,
Club = club3,
Animal = deer8
};
context.Grades.Add(grade1);
context.Grades.Add(grade2);
context.Grades.Add(grade3);
context.Grades.Add(grade4);
context.Grades.Add(grade5);
context.Grades.Add(grade6);
context.Grades.Add(grade7);
context.Grades.Add(grade8);
context.Grades.Add(grade9);
context.Grades.Add(grade10);
context.Grades.Add(grade11);
context.Grades.Add(grade12);
context.Grades.Add(grade13);
context.Grades.Add(grade14);
context.Grades.Add(grade15);
context.Grades.Add(grade16);
context.Grades.Add(grade17);
context.Grades.Add(grade18);
context.Grades.Add(grade19);
context.Grades.Add(grade20);
context.Grades.Add(grade21);
context.Grades.Add(grade22);
context.Grades.Add(grade23);
context.Grades.Add(grade24);
context.Grades.Add(grade25);
context.Grades.Add(grade26);
context.Grades.Add(grade27);
context.Grades.Add(grade28);
#endregion
#region Seed Jobs
var job1 = new Job
{
Title = "Builder",
Salary = 1,
Animals = new List <Animal>
{
beaver1, beaver2, beaver3, beaver4, beaver5
}
};
var job2 = new Job
{
Title = "Messenger",
Salary = 10,
Animals = new List <Animal>
{
crow1, crow2, crow3, crow4
}
};
var job3 = new Job
{
Title = "Delivery",
Salary = 100,
Animals = new List <Animal>
{
deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8
}
};
context.Jobs.Add(job1);
context.Jobs.Add(job2);
context.Jobs.Add(job3);
#endregion
#region Seed TPH (Food)
var food1 = new NormalFood
{
Title = "Elm",
Animal = beaver1,
Taste = Taste.Normal
};
var food2 = new VeganFood
{
Title = "Daphne laureola",
Animal = beaver2,
Calories = 100
};
var food3 = new VeganFood
{
Title = "Carpinus betulus",
Animal = beaver3,
Calories = 1001
};
var food4 = new VeganFood
{
Title = "Hornbeam",
Animal = beaver4,
Calories = 101
};
var food5 = new NormalFood
{
Title = "Pizza",
Animal = beaver5,
Taste = Taste.Excellent
};
var food6 = new NormalFood
{
Title = "Steak",
Animal = crow1,
Taste = Taste.Excellent
};
var food7 = new NormalFood
{
Title = "Meat",
Animal = crow2,
Taste = Taste.Good
};
var food8 = new NormalFood
{
Title = "Pizza",
Animal = crow3,
Taste = Taste.VeryGood
};
var food9 = new VeganFood
{
Title = "Corn",
Animal = crow4,
Calories = 1
};
var food10 = new NormalFood
{
Title = "Pizza",
Animal = crow5,
Taste = Taste.Normal
};
var food11 = new VeganFood
{
Title = "Pizza",
Animal = deer1,
Calories = 10
};
var food12 = new VeganFood
{
Title = "Pizza",
Animal = deer2,
Calories = 10
};
var food13 = new VeganFood
{
Title = "Pizza",
Animal = deer3,
Calories = 10
};
var food14 = new VeganFood
{
Title = "Pizza",
Animal = deer4,
Calories = 10
};
var food15 = new VeganFood
{
Title = "Pizza",
Animal = deer5,
Calories = 10
};
var food16 = new VeganFood
{
Title = "Pizza",
Animal = deer6,
Calories = 10
};
var food17 = new NormalFood
{
Title = "Elves",
Animal = deer7,
Taste = Taste.Excellent
};
var food18 = new VeganFood
{
Title = "Pizza",
Animal = deer8,
Calories = 10
};
context.Food.Add(food1);
context.Food.Add(food2);
context.Food.Add(food3);
context.Food.Add(food4);
context.Food.Add(food5);
context.Food.Add(food6);
context.Food.Add(food7);
context.Food.Add(food8);
context.Food.Add(food9);
context.Food.Add(food10);
context.Food.Add(food11);
context.Food.Add(food12);
context.Food.Add(food13);
context.Food.Add(food14);
context.Food.Add(food15);
context.Food.Add(food16);
context.Food.Add(food17);
context.Food.Add(food18);
#endregion
#region Seed Many-to-many old style (Drawback)
var drawback1 = new Drawback
{
Title = "Crowdy",
Foods = new List <Food>
{
food1, food2, food3, food4, /*food5,*/ food6, food7, food8, food9, food10, food11, food12, food13,
food14, food15, food16, food17, food18
},
Clubs = new List <Club>
{
club1, club2, club3
},
Consequence = new Consequence
{
Name = "Nervousness"
},
DrawbackDetail = new DrawbackDetails
{
DateCreated = DateTime.Now,
Description = "the quality or state of being nervous"
}
};
var drawback2 = new Drawback
{
Title = "Windy",
Foods = new List <Food>
{
food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13,
food14, food15, food16, food17, food18
},
Clubs = new List <Club>
{
club1, club2, club3
},
Consequence = new Consequence
{
Name = "Teleportation to Land of Oz"
},
DrawbackDetail = new DrawbackDetails
{
DateCreated = DateTime.Now,
Description = "hallucination"
}
};
var drawback3 = new Drawback
{
Title = "Soggy",
Foods = new List <Food>
{
food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13,
food14, food15, food16, food17, food18
},
Clubs = new List <Club>
{
club1, club2, club3
},
Consequence = new Consequence
{
Name = "Wet clothes"
},
DrawbackDetail = new DrawbackDetails
{
DateCreated = DateTime.Now,
Description = "cold"
}
};
var drawback4 = new Drawback
{
Title = "Hardy",
Foods = new List <Food>
{
food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13,
food14, food15, food16, food17, food18
},
Clubs = new List <Club>
{
club1, club2, club3
},
Consequence = new Consequence
{
Name = "Sadness"
},
DrawbackDetail = new DrawbackDetails
{
DateCreated = DateTime.Now,
Description = "the condition or quality of being sad"
}
};
context.Drawbacks.Add(drawback1);
context.Drawbacks.Add(drawback2);
context.Drawbacks.Add(drawback3);
context.Drawbacks.Add(drawback4);
var jobDrawback1 = new JobDrawback
{
Job = job1,
Drawback = drawback1
};
var jobDrawback2 = new JobDrawback
{
Job = job1,
Drawback = drawback2
};
var jobDrawback3 = new JobDrawback
{
Job = job1,
Drawback = drawback3
};
var jobDrawback4 = new JobDrawback
{
Job = job1,
Drawback = drawback4
};
var jobDrawback5 = new JobDrawback
{
Job = job2,
Drawback = drawback1
};
var jobDrawback6 = new JobDrawback
{
Job = job2,
Drawback = drawback2
};
var jobDrawback7 = new JobDrawback
{
Job = job3,
Drawback = drawback1
};
var jobDrawback8 = new JobDrawback
{
Job = job3,
Drawback = drawback2
};
context.JobDrawbacks.Add(jobDrawback1);
context.JobDrawbacks.Add(jobDrawback2);
context.JobDrawbacks.Add(jobDrawback3);
context.JobDrawbacks.Add(jobDrawback4);
context.JobDrawbacks.Add(jobDrawback5);
context.JobDrawbacks.Add(jobDrawback6);
context.JobDrawbacks.Add(jobDrawback7);
context.JobDrawbacks.Add(jobDrawback8);
#endregion
#region Seed Persons
var person1 = new Person
{
Name = "BeaverPerson",
AnimalsLoved = new List <Animal> {
beaver1, beaver2, beaver3, beaver4, beaver5
},
AnimalsHated = new List <Animal> {
deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8
}
};
context.Persons.Add(person1);
#endregion
context.SaveChanges();
}
public AvisDeRechercheDAL()
{
this.db = new AnimalContext();
}
private static void SeedDb()
{
using var context = new AnimalContext();
context.SavedChanges += (sender, args) =>
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(
$"Saved {args.EntitiesSavedCount} changes for {((DbContext) sender)?.Database.GetConnectionString()}");
Console.ForegroundColor = ConsoleColor.White;
};
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
#region Seed TPT (Animal)
var beaver1 = new Beaver
{
Name = "SomeBeavers1",
Age = 27,
Fluffiness = FluffinessEnum.VeryFluffy,
Size = 15,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var beaver2 = new Beaver
{
Name = "SomeBeavers2",
Age = 26,
Fluffiness = FluffinessEnum.Fluffy,
Size = 14,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var beaver3 = new Beaver
{
Name = "SomeBeavers3",
Age = 25,
Fluffiness = FluffinessEnum.NotFluffy,
Size = 13,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var beaver4 = new Beaver
{
Name = "SomeBeavers4",
Age = 24,
Fluffiness = FluffinessEnum.Fluffy,
Size = 12,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var beaver5 = new Beaver
{
Name = "SomeBeavers5",
Age = 23,
Fluffiness = FluffinessEnum.VeryFluffy,
Size = 11,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var crow1 = new Crow
{
Name = "Crowly",
Age = 5,
Color = "black",
Size = 1,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var crow2 = new Crow
{
Name = "Crowly1",
Age = 5,
Color = "black",
Size = 1,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var crow3 = new Crow
{
Name = "Crowly2",
Age = 22,
Color = "black",
Size = 4,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var crow4 = new Crow
{
Name = "Crowly3",
Age = 50,
Color = "white",
Size = 10,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var crow5 = new Crow
{
Name = "Crowly4",
Age = 5,
Color = "pink",
Size = 1,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var deer1 = new Deer
{
Name = "Dasher",
Age = 1,
Horns = true,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var deer2 = new Deer
{
Name = "Dancer",
Age = 2,
Horns = true,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var deer3 = new Deer
{
Name = "Prancer",
Age = 1,
Horns = false,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var deer4 = new Deer
{
Name = "Vixen",
Age = 1,
Horns = true,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var deer5 = new Deer
{
Name = "Comet",
Age = 1,
Horns = true,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var deer6 = new Deer
{
Name = "Cupid",
Age = 1,
Horns = false,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var deer7 = new Deer
{
Name = "Donder ",
Age = 1,
Horns = true,
IpAddress = IPAddress.Parse("127.0.0.1")
};
var deer8 = new Deer
{
Name = "Blitzen",
Age = 1,
Horns = true,
IpAddress = IPAddress.Parse("127.0.0.1")
};
context.Beavers.Add(beaver1);
context.Beavers.Add(beaver2);
context.Beavers.Add(beaver3);
context.Beavers.Add(beaver4);
context.Beavers.Add(beaver5);
context.Crows.Add(crow1);
context.Crows.Add(crow2);
context.Crows.Add(crow3);
context.Crows.Add(crow4);
context.Crows.Add(crow5);
context.Deers.Add(deer1);
context.Deers.Add(deer2);
context.Deers.Add(deer3);
context.Deers.Add(deer4);
context.Deers.Add(deer5);
context.Deers.Add(deer6);
context.Deers.Add(deer7);
context.Deers.Add(deer8);
#endregion
#region Seed Many-to-many (Club)
var club1 = new Club
{
Title = "TreesWorshipers",
Animals = new List <Animal> {
beaver1, beaver2, beaver3, beaver4, beaver5, crow4
},
Locations = new List <Location>
{
new()
{
Address = "North America"
},
new()
{
Address = "Canada"
},
new()
{
Address = "Russia"
}
}
};
var club2 = new Club
{
Title = "CornLovers",
Animals = new List <Animal> {
crow1, crow2, crow3, crow4, crow5
},
Locations = new List <Location>
{
new()
{
Address = "Westeros"
}
}
};
var club3 = new Club
{
Title = "ChristmasTeam",
Animals = new List <Animal>
{
beaver1, beaver2, beaver3, beaver4, beaver5,
crow1, crow2, crow3, crow4, crow5,
deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8
},
Locations = new List <Location>
{
new()
{
Address = "North Pole"
}
}
};
context.Clubs.Add(club1);
context.Clubs.Add(club2);
context.Clubs.Add(club3);
#endregion
#region Seed Grades
var grade1 = new Grade
{
TheGrade = 5,
Club = club1,
Animal = beaver1
};
var grade2 = new Grade
{
TheGrade = 4,
Club = club1,
Animal = beaver2
};
var grade3 = new Grade
{
TheGrade = 3,
Club = club1,
Animal = beaver3
};
var grade4 = new Grade
{
TheGrade = 3,
Club = club1,
Animal = beaver4
};
var grade5 = new Grade
{
TheGrade = 2,
Club = club1,
Animal = beaver5
};
var grade6 = new Grade
{
TheGrade = 1,
Club = club1,
Animal = crow4
};
var grade7 = new Grade
{
TheGrade = 5,
Club = club2,
Animal = crow1
};
var grade8 = new Grade
{
TheGrade = 4.5,
Club = club2,
Animal = crow2
};
var grade9 = new Grade
{
TheGrade = 2.1,
Club = club2,
Animal = crow3
};
var grade10 = new Grade
{
TheGrade = 4.3,
Club = club2,
Animal = crow4
};
var grade27 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver1
};
var grade26 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver2
};
var grade25 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver3
};
var grade24 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver4
};
var grade23 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = beaver5
};
var grade22 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = crow1
};
var grade21 = new Grade
{
TheGrade = 3.5,
Club = club3,
Animal = crow2
};
var grade20 = new Grade
{
TheGrade = 2.5,
Club = club3,
Animal = crow3
};
var grade19 = new Grade
{
TheGrade = 1.5,
Club = club3,
Animal = crow4
};
var grade28 = new Grade
{
TheGrade = 4.9,
Club = club3,
Animal = crow5
};
var grade11 = new Grade
{
TheGrade = 4.8,
Club = club3,
Animal = deer1
};
var grade12 = new Grade
{
TheGrade = 4.7,
Club = club3,
Animal = deer2
};
var grade13 = new Grade
{
TheGrade = 4.6,
Club = club3,
Animal = deer3
};
var grade14 = new Grade
{
TheGrade = 4.5,
Club = club3,
Animal = deer4
};
var grade15 = new Grade
{
TheGrade = 4.4,
Club = club3,
Animal = deer5
};
var grade16 = new Grade
{
TheGrade = 4.3,
Club = club3,
Animal = deer6
};
var grade17 = new Grade
{
TheGrade = 4.2,
Club = club3,
Animal = deer7
};
var grade18 = new Grade
{
TheGrade = 4.1,
Club = club3,
Animal = deer8
};
context.Grades.Add(grade1);
context.Grades.Add(grade2);
context.Grades.Add(grade3);
context.Grades.Add(grade4);
context.Grades.Add(grade5);
context.Grades.Add(grade6);
context.Grades.Add(grade7);
context.Grades.Add(grade8);
context.Grades.Add(grade9);
context.Grades.Add(grade10);
context.Grades.Add(grade11);
context.Grades.Add(grade12);
context.Grades.Add(grade13);
context.Grades.Add(grade14);
context.Grades.Add(grade15);
context.Grades.Add(grade16);
context.Grades.Add(grade17);
context.Grades.Add(grade18);
context.Grades.Add(grade19);
context.Grades.Add(grade20);
context.Grades.Add(grade21);
context.Grades.Add(grade22);
context.Grades.Add(grade23);
context.Grades.Add(grade24);
context.Grades.Add(grade25);
context.Grades.Add(grade26);
context.Grades.Add(grade27);
context.Grades.Add(grade28);
#endregion
#region Seed Jobs
var job1 = new Job
{
Title = "Builder",
Salary = 1,
Animals = new List <Animal>
{
beaver1, beaver2, beaver3, beaver4, beaver5
}
};
var job2 = new Job
{
Title = "Messenger",
Salary = 10,
Animals = new List <Animal>
{
crow1, crow2, crow3, crow4
}
};
var job3 = new Job
{
Title = "Delivery",
Salary = 100,
Animals = new List <Animal>
{
deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8
}
};
context.Jobs.Add(job1);
context.Jobs.Add(job2);
context.Jobs.Add(job3);
#endregion
#region Seed TPH (Food)
var food1 = new NormalFood
{
Title = "Elm",
Animal = beaver1,
Taste = Taste.Normal
};
var food2 = new VeganFood
{
Title = "Daphne laureola",
Animal = beaver2,
Calories = 100
};
var food3 = new VeganFood
{
Title = "Carpinus betulus",
Animal = beaver3,
Calories = 1001
};
var food4 = new VeganFood
{
Title = "Hornbeam",
Animal = beaver4,
Calories = 101
};
var food5 = new NormalFood
{
Title = "Pizza",
Animal = beaver5,
Taste = Taste.Excellent
};
var food6 = new NormalFood
{
Title = "Steak",
Animal = crow1,
Taste = Taste.Excellent
};
var food7 = new NormalFood
{
Title = "Meat",
Animal = crow2,
Taste = Taste.Good
};
var food8 = new NormalFood
{
Title = "Pizza",
Animal = crow3,
Taste = Taste.VeryGood
};
var food9 = new VeganFood
{
Title = "Corn",
Animal = crow4,
Calories = 1
};
var food10 = new NormalFood
{
Title = "Pizza",
Animal = crow5,
Taste = Taste.Normal
};
var food11 = new VeganFood
{
Title = "Pizza",
Animal = deer1,
Calories = 10
};
var food12 = new VeganFood
{
Title = "Pizza",
Animal = deer2,
Calories = 10
};
var food13 = new VeganFood
{
Title = "Pizza",
Animal = deer3,
Calories = 10
};
var food14 = new VeganFood
{
Title = "Pizza",
Animal = deer4,
Calories = 10
};
var food15 = new VeganFood
{
Title = "Pizza",
Animal = deer5,
Calories = 10
};
var food16 = new VeganFood
{
Title = "Pizza",
Animal = deer6,
Calories = 10
};
var food17 = new NormalFood
{
Title = "Elves",
Animal = deer7,
Taste = Taste.Excellent
};
var food18 = new VeganFood
{
Title = "Pizza",
Animal = deer8,
Calories = 10
};
context.Food.Add(food1);
context.Food.Add(food2);
context.Food.Add(food3);
context.Food.Add(food4);
context.Food.Add(food5);
context.Food.Add(food6);
context.Food.Add(food7);
context.Food.Add(food8);
context.Food.Add(food9);
context.Food.Add(food10);
context.Food.Add(food11);
context.Food.Add(food12);
context.Food.Add(food13);
context.Food.Add(food14);
context.Food.Add(food15);
context.Food.Add(food16);
context.Food.Add(food17);
context.Food.Add(food18);
#endregion
#region Seed Many-to-many old style (Drawback)
var drawback1 = new Drawback
{
Title = "Crowdy",
Foods = new List <Food>
{
food1, food2, food3, food4, /*food5,*/ food6, food7, food8, food9, food10, food11, food12, food13,
food14, food15, food16, food17, food18
},
Clubs = new List <Club>
{
club1, club2, club3
},
Consequence = new Consequence
{
Name = "Nervousness"
}
};
var drawback2 = new Drawback
{
Title = "Windy",
Foods = new List <Food>
{
food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13,
food14, food15, food16, food17, food18
},
Clubs = new List <Club>
{
club1, club2, club3
},
Consequence = new Consequence
{
Name = "Teleportation to Land of Oz"
}
};
var drawback3 = new Drawback
{
Title = "Soggy",
Foods = new List <Food>
{
food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13,
food14, food15, food16, food17, food18
},
Clubs = new List <Club>
{
club1, club2, club3
},
Consequence = new Consequence
{
Name = "Wet clothes"
}
};
var drawback4 = new Drawback
{
Title = "Hardy",
Foods = new List <Food>
{
food1, food2, food3, food4, food5, food6, food7, food8, food9, food10, food11, food12, food13,
food14, food15, food16, food17, food18
},
Clubs = new List <Club>
{
club1, club2, club3
},
Consequence = new Consequence
{
Name = "Sadness"
}
};
context.Drawbacks.Add(drawback1);
context.Drawbacks.Add(drawback2);
context.Drawbacks.Add(drawback3);
context.Drawbacks.Add(drawback4);
var jobDrawback1 = new JobDrawback
{
Job = job1,
Drawback = drawback1
};
var jobDrawback2 = new JobDrawback
{
Job = job1,
Drawback = drawback2
};
var jobDrawback3 = new JobDrawback
{
Job = job1,
Drawback = drawback3
};
var jobDrawback4 = new JobDrawback
{
Job = job1,
Drawback = drawback4
};
var jobDrawback5 = new JobDrawback
{
Job = job2,
Drawback = drawback1
};
var jobDrawback6 = new JobDrawback
{
Job = job2,
Drawback = drawback2
};
var jobDrawback7 = new JobDrawback
{
Job = job3,
Drawback = drawback1
};
var jobDrawback8 = new JobDrawback
{
Job = job3,
Drawback = drawback2
};
context.JobDrawbacks.Add(jobDrawback1);
context.JobDrawbacks.Add(jobDrawback2);
context.JobDrawbacks.Add(jobDrawback3);
context.JobDrawbacks.Add(jobDrawback4);
context.JobDrawbacks.Add(jobDrawback5);
context.JobDrawbacks.Add(jobDrawback6);
context.JobDrawbacks.Add(jobDrawback7);
context.JobDrawbacks.Add(jobDrawback8);
#endregion
context.SaveChanges();
#region Seed Property Bags (Category, Product)
var category1 = new Dictionary <string, object>
{
["Name"] = "Beverages",
["FoodId"] = food1.Id
};
context.Categories.Add(category1);
context.SaveChanges();
var product1 = new Dictionary <string, object>
{
["Name"] = "Product1",
["CategoryId"] = context.Categories.First()["Id"]
};
context.Products.Add(product1);
#endregion
#region Seed Persons
var person1 = new Person
{
Name = "BeaverPerson",
AnimalsLoved = new List <Animal> {
beaver1, beaver2, beaver3, beaver4, beaver5
},
AnimalsHated = new List <Animal> {
deer1, deer2, deer3, deer4, deer5, deer6, deer7, deer8
}
};
context.Persons.Add(person1);
#endregion
#region Seed Elves
var elf1 = new Elf
{
Name = "Alabaster Snowball",
Deer = deer1
};
var elf2 = new Elf
{
Name = "Bushy Evergreen",
Deer = deer1
};
var elf3 = new Elf
{
Name = "Pepper Minstix",
Deer = deer2
};
var elf4 = new Elf
{
Name = "Shinny Upatree",
Deer = deer3
};
var elf5 = new Elf
{
Name = "Sugarplum Mary",
Deer = deer4
};
var elf6 = new Elf
{
Name = "Wunorse Openslae",
Deer = deer5
};
var elf7 = new Elf
{
Name = "Grinch",
Deer = deer6
};
var elf8 = new Elf
{
Name = "Legolas",
Deer = deer7
};
var elf9 = new Elf
{
Name = "Iorveth",
Deer = deer8
};
context.Elves.Add(elf1);
context.Elves.Add(elf2);
context.Elves.Add(elf3);
context.Elves.Add(elf4);
context.Elves.Add(elf5);
context.Elves.Add(elf6);
context.Elves.Add(elf7);
context.Elves.Add(elf8);
context.Elves.Add(elf9);
#endregion
#region Seed AdditionaInfos
var additionalInfo1 = new AdditionalInfo()
{
Clubs = new List <Club>()
{
club1, club2, club3
},
Comment = "Best club ever"
};
var additionalInfo2 = new AdditionalInfo()
{
Clubs = new List <Club>()
{
club1, club2
},
Comment = "Evolution club"
};
var additionalInfo3 = new AdditionalInfo()
{
Clubs = new List <Club>()
{
club1
},
Comment = "Original club"
};
context.AdditionalInfos.Add(additionalInfo1);
context.AdditionalInfos.Add(additionalInfo2);
context.AdditionalInfos.Add(additionalInfo3);
#endregion
context.SaveChanges();
context.Database.ExecuteSqlRaw(File.ReadAllText(".\\BD\\CreateTVF.sql"));
}
public SiteController(AnimalContext context)
{
_context = context;
}
public HomeController(AnimalContext ctx)
{
context = ctx;
}
public AnimalController(AnimalContext context)
{
db = context;
}
public AnimalsController(IAppService appService, AnimalContext context)
{
_context = context;
this.appService = appService;
}
public AnimalsController(AnimalContext db)
{
_db = db;
}
public void PrintTest()
{
using var context = new AnimalContext();
var unused = context.Clubs;
try
{
var firstBeaver = context.Beavers
// includes
.Include(x => x.Clubs)
.Include(x => x.Grades)
.Include(x => x.Job)
.ThenInclude(j => j.JobDrawbacks)
.ThenInclude(jd => jd.Drawback)
.Include(x => x.Food)
.ThenInclude(x => x.Drawbacks)
// other
.OrderBy(x => x.Id)
.First();
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine(firstBeaver);
if (firstBeaver.Clubs != null)
{
foreach (var club in firstBeaver.Clubs)
{
Console.Write("\t");
Console.WriteLine(club);
foreach (var location in club.Locations)
{
Console.Write("\t");
Console.Write("\t");
Console.WriteLine(location);
}
}
}
if (firstBeaver.Grades != null)
{
foreach (var grade in firstBeaver.Grades)
{
Console.Write("\t");
Console.WriteLine(grade);
}
}
Console.Write("\t");
Console.WriteLine(firstBeaver.Job);
if (firstBeaver.Job.JobDrawbacks != null)
{
foreach (var drawback in firstBeaver.Job.JobDrawbacks)
{
Console.Write("\t");
Console.Write("\t");
Console.WriteLine(drawback.Drawback);
Console.Write("\t");
Console.Write("\t");
Console.Write("\t");
Console.WriteLine(drawback.Drawback.Consequence);
}
}
Console.Write("\t");
Console.WriteLine(firstBeaver.Food);
if (firstBeaver.Food.Drawbacks != null)
{
foreach (var drawback in firstBeaver.Food.Drawbacks)
{
Console.Write("\t");
Console.Write("\t");
Console.WriteLine(drawback);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
Console.ForegroundColor = ConsoleColor.White;
}
public AnimalsController(AnimalContext dataBase)
{
_dataBase = dataBase;
}
public AnimalController(AnimalContext context)
{
_context = context;
if (_context.Animals.Count() == 0)
{
_context.Animals.Add(new Animal()
{
Id = 1, User = "******", Location = "18835 Winnwood Ln. Santa Ana Ca 92705", Coordinates = Animal.GetCoordinates("18835 Winnwood Ln. Santa Ana Ca 92705"), Name = "Charlie", Type = "Dog", Breed = "Mini Australian Shepherd", Color = "Brown/White", Size = "Med", LostOrFound = "Lost", Date = "6/1/17", Image = "../images/CharliesPic.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 2, User = "******", Location = "1524 Maurine Place Fullerton CA 92831", Coordinates = Animal.GetCoordinates("1524 Maurine Place Fullerton CA 92831"), Name = "Chloe", Type = "Cat", Breed = "Persian", Color = "Grey/White", Size = "Sm", LostOrFound = "Found", Date = "3/2/17", Image = "../images/Persian1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 3, User = "******", Location = "1033 N Custer Street Santa Ana CA 92701", Coordinates = Animal.GetCoordinates("1033 N Custer Street Santa Ana CA 92701"), Name = "Ryder", Type = "Dog", Breed = "German Shepherd", Color = "Brown/Black", Size = "Lrg", LostOrFound = "Found", Date = "1/21/17", Image = "../images/GermanShepherd1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 4, User = "******", Location = "1801 E Chestnut Ave Santa Ana CA 92701", Coordinates = Animal.GetCoordinates("1801 E Chestnut Ave Santa Ana CA 92701"), Name = "Lilly", Type = "Cat", Breed = "Exotic Shorthair", Color = "Brown/Grey", Size = "Med", LostOrFound = "Lost", Date = "7/15/17", Image = "../images/ExoticShorthair1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 5, User = "******", Location = "2500 N Main St Santa Ana CA 92705", Coordinates = Animal.GetCoordinates("2500 N Main St Santa Ana CA 92705"), Name = "Gene", Type = "Dog", Breed = "Bulldog", Color = "Grey/White", Size = "Med", LostOrFound = "Lost", Date = "4/11/17", Image = "../images/BulldogGreyWhite1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 6, User = "******", Location = "1800 W Santa Clara Ave Santa Ana CA 92706", Coordinates = Animal.GetCoordinates("1800 W Santa Clara Ave Santa Ana CA 92706"), Name = "Tina", Type = "Cat", Breed = "Maine Coon", Color = "Black/White", Size = "Sm", LostOrFound = "Found", Date = "9/16/17", Image = "../images/MaineCoonBlackWhite1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 7, User = "******", Location = "2229 N Spruce St Santa Ana CA 92706", Coordinates = Animal.GetCoordinates("2229 N Spruce St Santa Ana CA 92706"), Name = "Louise", Type = "Cat", Breed = "Ragdoll", Color = "Orange/White", Size = "Med", LostOrFound = "Lost", Date = "6/13/17", Image = "../images/RagdollOrangeWhite1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 8, User = "******", Location = "1313 Disneyland Dr Anaheim CA 92802", Coordinates = Animal.GetCoordinates("1313 Disneyland Dr Anaheim CA 92802"), Name = "Mickey", Type = "Dog", Breed = "Beagle", Color = "Brown/White", Size = "Med", LostOrFound = "Found", Date = "10/1/16", Image = "../images/BeagleBrownWhite1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 9, User = "******", Location = "1000 S Harbor Blvd Fullerton CA 92832", Coordinates = Animal.GetCoordinates("1000 S Harbor Blvd Fullerton CA 92832"), Name = "Ace", Type = "Dog", Breed = "Poodle", Color = "Black/Grey", Size = "Lrg", LostOrFound = "Lost", Date = "7/1/17", Image = "../images/PoodleBlackGrey1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 10, User = "******", Location = "321 E Chapman Ave Fullerton CA 92832", Coordinates = Animal.GetCoordinates("321 E Chapman Ave Fullerton CA 92832"), Name = "Rocky", Type = "Cat", Breed = "British Shorthair", Color = "Tan", Size = "Sm", LostOrFound = "Found", Date = "1/1/16", Image = "../images/BritishShortHairTan1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 11, User = "******", Location = "800 N. State College Fullerton CA 92831", Coordinates = Animal.GetCoordinates("800 N. State College Fullerton CA 92831"), Name = "Milo", Type = "Dog", Breed = "Rottweiler", Color = "Tan/White", Size = "Lrg", LostOrFound = "Found", Date = "5/12/16", Image = "../images/Rottweiler1.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 12, User = "******", Location = "18001 Yorba Linda Blvd Yorba Linda CA 92886", Coordinates = Animal.GetCoordinates("18001 Yorba Linda Blvd Yorba Linda CA 92886"), Name = "Pretty Boy", Type = "Turtle", Breed = "Box Turtle", Color = "Green", Size = "Sm", LostOrFound = "Found", Date = "5/16/17", Image = "../images/boxturtle.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 13, User = "******", Location = "9392 Cloudhaven Dr. Huntington Beach Ca 92646", Coordinates = Animal.GetCoordinates("9392 Cloudhaven Dr. Huntington Beach Ca 92646"), Name = "Roxy", Type = "Dog", Breed = "Mini Australian Shepherd", Color = "Dark-Brown/White", Size = "Med", LostOrFound = "Found", Date = "5/22/17", Image = "../images/miniAussie2.jpg"
});
_context.Animals.Add(new Animal()
{
Id = 14, User = "******", Location = "26900 Peters Canyon Rd Tustin CA 92782", Coordinates = Animal.GetCoordinates("26900 Peters Canyon Rd Tustin CA 92782"), Name = "Stella", Type = "Dog", Breed = "Mini Australian Shepherd", Color = "Brown/Black/Grey/White", Size = "Med", LostOrFound = "Lost", Date = "5/13/17", Image = "../images/MiniAussie3.jpg"
});
_context.SaveChanges();
}
}
public AnimalRepository(AnimalContext context)
{
this.context = context;
}
protected BaseRepository(AnimalContext context)
{
_context = context;
}
public CatRepository(AnimalContext context) : base(context)
{
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
NVPAPICaller payPalCaller = new NVPAPICaller();
string retMsg = "";
string token = "";
string PayerID = "";
NVPCodec decoder = new NVPCodec();
token = Session["token"].ToString();
bool ret = payPalCaller.GetCheckoutDetails(token, ref PayerID, ref decoder, ref retMsg);
if (ret)
{
Session["payerId"] = PayerID;
var myOrder = new Order();
myOrder.OrderDate = Convert.ToDateTime(decoder["TIMESTAMP"].ToString());
myOrder.Username = User.Identity.Name;
myOrder.FirstName = decoder["FIRSTNAME"].ToString();
myOrder.LastName = decoder["LASTNAME"].ToString();
myOrder.Address = decoder["SHIPTOSTREET"].ToString();
myOrder.City = decoder["SHIPTOCITY"].ToString();
myOrder.State = decoder["SHIPTOSTATE"].ToString();
myOrder.PostalCode = decoder["SHIPTOZIP"].ToString();
myOrder.Country = decoder["SHIPTOCOUNTRYCODE"].ToString();
myOrder.Email = decoder["EMAIL"].ToString();
myOrder.Total = Convert.ToDecimal(decoder["AMT"].ToString());
// Verify total payment amount as set on CheckoutStart.aspx.
try
{
decimal paymentAmountOnCheckout = Convert.ToDecimal(Session["payment_amt"].ToString());
decimal paymentAmoutFromPayPal = Convert.ToDecimal(decoder["AMT"].ToString());
if (paymentAmountOnCheckout != paymentAmoutFromPayPal)
{
Response.Redirect("CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch.");
}
}
catch (Exception)
{
Response.Redirect("CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch.");
}
// Get DB context.
AnimalContext _db = new AnimalContext();
// Add order to DB.
_db.Orders.Add(myOrder);
_db.SaveChanges();
// Get the shopping cart items and process them.
using (WebForms.Logic.ShoppingCartActions usersShoppingCart = new WebForms.Logic.ShoppingCartActions())
{
List <CartItem> myOrderList = usersShoppingCart.GetCartItems();
// Add OrderDetail information to the DB for each product purchased.
for (int i = 0; i < myOrderList.Count; i++)
{
// Create a new OrderDetail object.
var myOrderDetail = new OrderDetail();
myOrderDetail.OrderId = myOrder.OrderId;
myOrderDetail.Username = User.Identity.Name;
myOrderDetail.AnimalId = myOrderList[i].AnimalId;
myOrderDetail.Quantity = myOrderList[i].Quantity;
myOrderDetail.TicketPrice = myOrderList[i].Animal.TicketPrice;
// Add OrderDetail to DB.
_db.OrderDetails.Add(myOrderDetail);
_db.SaveChanges();
}
// Set OrderId.
Session["currentOrderId"] = myOrder.OrderId;
// Display Order information.
List <Order> orderList = new List <Order>();
orderList.Add(myOrder);
ShipInfo.DataSource = orderList;
ShipInfo.DataBind();
// Display OrderDetails.
OrderItemList.DataSource = myOrderList;
OrderItemList.DataBind();
}
}
else
{
Response.Redirect("CheckoutError.aspx?" + retMsg);
}
}
}
public DbDogRepository(AnimalContext context)
{
this.context = context;
dbset = context.Set <Dog>();
}
public SpeciesController(AnimalContext context)
{
_context = context;
}
