public IHttpActionResult PutPurchaseCategory(int id, PurchaseCategory purchaseCategory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != purchaseCategory.ID)
{
return(BadRequest());
}
db.Entry(purchaseCategory).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseCategoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> Edit(int id, [Bind("ID,Name")] PurchaseCategory purchaseCategory)
{
if (id != purchaseCategory.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(purchaseCategory);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PurchaseCategoryExists(purchaseCategory.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(purchaseCategory));
}
public ActionResult DeleteConfirmed(int id)
{
PurchaseCategory purchaseCategory = db.PurchaseCategories.Find(id);
db.PurchaseCategories.Remove(purchaseCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Name,Description")] PurchaseCategory purchaseCategory)
{
if (ModelState.IsValid)
{
db.Entry(purchaseCategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(purchaseCategory));
}
public async Task <IActionResult> Create([Bind("ID,Name")] PurchaseCategory purchaseCategory)
{
if (ModelState.IsValid)
{
_context.Add(purchaseCategory);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(purchaseCategory));
}
public ActionResult Create([Bind(Include = "ID,Name,Description")] PurchaseCategory purchaseCategory)
{
if (ModelState.IsValid)
{
db.PurchaseCategories.Add(purchaseCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(purchaseCategory));
}
public IHttpActionResult GetPurchaseCategory(int id)
{
PurchaseCategory purchaseCategory = db.PurchaseCategories.Find(id);
if (purchaseCategory == null)
{
return(NotFound());
}
return(Ok(purchaseCategory));
}
public void CreateAllCategory()
{
foreach (PurchaseCategoryEnum name in Enum.GetValues(typeof(PurchaseCategoryEnum)))
{
GameObject category = Instantiate(PurchaseCategoryPrefab, Vector3.zero, Quaternion.identity);
PurchaseCategory purchaseCategory = category.GetComponent <PurchaseCategory>();
purchaseCategory.CategoryName = name.Translate();
categories.Add(name, purchaseCategory);
category.transform.SetParent(PurchaseCategoryContent.transform);
category.GetComponent <RectTransform>().localScale = new Vector3(1, 1, 1);
}
}
public IHttpActionResult PostPurchaseCategory(PurchaseCategory purchaseCategory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.PurchaseCategories.Add(purchaseCategory);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = purchaseCategory.ID }, purchaseCategory));
}
// GET: PurchaseCategories/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PurchaseCategory purchaseCategory = db.PurchaseCategories.Find(id);
if (purchaseCategory == null)
{
return(HttpNotFound());
}
return(View(purchaseCategory));
}
public IHttpActionResult DeletePurchaseCategory(int id)
{
PurchaseCategory purchaseCategory = db.PurchaseCategories.Find(id);
if (purchaseCategory == null)
{
return(NotFound());
}
db.PurchaseCategories.Remove(purchaseCategory);
db.SaveChanges();
return(Ok(purchaseCategory));
}
void DrawCategories(Rect area)
{
string[] categories = Enum.GetNames(typeof(PurchaseCategory));
float buttonWidth = (area.width / categories.Length) - 16;
for (int i = 0; i < categories.Length; i++)
{
string s = categories[i];
if (GUI.Button(new Rect(area.x + (buttonWidth * i) + (16 * i), area.y, buttonWidth, area.height), s, GameHandler.instance.GetStyle("MenuDefault_Button")))
{
selectedCategory = (PurchaseCategory)Enum.Parse(typeof(PurchaseCategory), s);
buyableIndex = 0;
}
}
}
static IEnumerable <Buyer> GetBuyersByCategories(this Dictionary <Buyer, List <PurchaseCategory> > dict, PurchaseCategory category)
{
return(dict.Where(x => x.Value.Where(y => y == category).Any()).Select(x => x.Key));
}
public static void Initialize(FamilyFinancesContext context)
{
//context.Database.EnsureCreated();
// Look for any students.
if (context.PurchaseCategories.Any())
{
return; // DB has been seeded
}
// PurchaseCategory
var purchaseCategories = new PurchaseCategory[]
{
new PurchaseCategory {
Name = "Продукты"
},
new PurchaseCategory {
Name = "Коммунальные"
},
new PurchaseCategory {
Name = "Здоровье"
},
new PurchaseCategory {
Name = "Заправки"
},
new PurchaseCategory {
Name = "Дача"
}
};
foreach (PurchaseCategory pc in purchaseCategories)
{
context.PurchaseCategories.Add(pc);
}
context.SaveChanges();
// Pay Source Types
var paySources = new PaySource[]
{
new PaySource {
Name = "ДК", FullName = "XXXX XXXX XXXX 0256", ValidThru = "08/22"
},
new PaySource {
Name = "КК", FullName = "XXXX XXXX XXXX 3348", ValidThru = "11/20"
},
new PaySource {
Name = "Счет", FullName = "Мастер счет в рублях"
},
new PaySource {
Name = "Наличные"
},
};
foreach (PaySource ps in paySources)
{
context.PaySources.Add(ps);
}
context.SaveChanges();
// Expences
var expences = new Expense[]
{
new Expense {
TimeStamp = DateTime.Parse("2020-07-03"), Sum = Decimal.Parse("569.70"),
Purchase = "Дикси", PaySource = paySources.Single(x => x.Name == "ДК"), Category = purchaseCategories.Single(x => x.Name == "Продукты")
},
new Expense {
TimeStamp = DateTime.Parse("2020-07-03"), Sum = Decimal.Parse("110.00"),
Purchase = "Колобок", PaySource = paySources.Single(x => x.Name == "ДК"), Category = purchaseCategories.Single(x => x.Name == "Продукты")
},
new Expense {
TimeStamp = DateTime.Parse("2020-07-06"), Sum = Decimal.Parse("100.00"),
Purchase = "На даче", PaySource = paySources.Single(x => x.Name == "Наличные"), Category = purchaseCategories.Single(x => x.Name == "Продукты")
},
new Expense {
TimeStamp = DateTime.Parse("2020-07-06"), Sum = Decimal.Parse("164.00"),
Purchase = "Колобок", PaySource = paySources.Single(x => x.Name == "КК"), Category = purchaseCategories.Single(x => x.Name == "Продукты")
}
};
foreach (Expense e in expences)
{
context.Expenses.Add(e);
}
context.SaveChanges();
/*
* var instructors = new Instructor[]
* {
* new Instructor { FirstMidName = "Kim", LastName = "Abercrombie",
* HireDate = DateTime.Parse("1995-03-11") },
* new Instructor { FirstMidName = "Fadi", LastName = "Fakhouri",
* HireDate = DateTime.Parse("2002-07-06") },
* new Instructor { FirstMidName = "Roger", LastName = "Harui",
* HireDate = DateTime.Parse("1998-07-01") },
* new Instructor { FirstMidName = "Candace", LastName = "Kapoor",
* HireDate = DateTime.Parse("2001-01-15") },
* new Instructor { FirstMidName = "Roger", LastName = "Zheng",
* HireDate = DateTime.Parse("2004-02-12") }
* };
*
* foreach (Instructor i in instructors)
* {
* context.Instructors.Add(i);
* }
* context.SaveChanges();
*
* var departments = new Department[]
* {
* new Department { Name = "English", Budget = 350000,
* StartDate = DateTime.Parse("2007-09-01"),
* InstructorID = instructors.Single( i => i.LastName == "Abercrombie").ID },
* new Department { Name = "Mathematics", Budget = 100000,
* StartDate = DateTime.Parse("2007-09-01"),
* InstructorID = instructors.Single( i => i.LastName == "Fakhouri").ID },
* new Department { Name = "Engineering", Budget = 350000,
* StartDate = DateTime.Parse("2007-09-01"),
* InstructorID = instructors.Single( i => i.LastName == "Harui").ID },
* new Department { Name = "Economics", Budget = 100000,
* StartDate = DateTime.Parse("2007-09-01"),
* InstructorID = instructors.Single( i => i.LastName == "Kapoor").ID }
* };
*
* foreach (Department d in departments)
* {
* context.Departments.Add(d);
* }
* context.SaveChanges();
*
* var courses = new Course[]
* {
* new Course {CourseID = 1050, Title = "Chemistry", Credits = 3,
* DepartmentID = departments.Single( s => s.Name == "Engineering").DepartmentID
* },
* new Course {CourseID = 4022, Title = "Microeconomics", Credits = 3,
* DepartmentID = departments.Single( s => s.Name == "Economics").DepartmentID
* },
* new Course {CourseID = 4041, Title = "Macroeconomics", Credits = 3,
* DepartmentID = departments.Single( s => s.Name == "Economics").DepartmentID
* },
* new Course {CourseID = 1045, Title = "Calculus", Credits = 4,
* DepartmentID = departments.Single( s => s.Name == "Mathematics").DepartmentID
* },
* new Course {CourseID = 3141, Title = "Trigonometry", Credits = 4,
* DepartmentID = departments.Single( s => s.Name == "Mathematics").DepartmentID
* },
* new Course {CourseID = 2021, Title = "Composition", Credits = 3,
* DepartmentID = departments.Single( s => s.Name == "English").DepartmentID
* },
* new Course {CourseID = 2042, Title = "Literature", Credits = 4,
* DepartmentID = departments.Single( s => s.Name == "English").DepartmentID
* },
* };
*
* foreach (Course c in courses)
* {
* context.Courses.Add(c);
* }
* context.SaveChanges();
*
* var officeAssignments = new OfficeAssignment[]
* {
* new OfficeAssignment {
* InstructorID = instructors.Single( i => i.LastName == "Fakhouri").ID,
* Location = "Smith 17" },
* new OfficeAssignment {
* InstructorID = instructors.Single( i => i.LastName == "Harui").ID,
* Location = "Gowan 27" },
* new OfficeAssignment {
* InstructorID = instructors.Single( i => i.LastName == "Kapoor").ID,
* Location = "Thompson 304" },
* };
*
* foreach (OfficeAssignment o in officeAssignments)
* {
* context.OfficeAssignments.Add(o);
* }
* context.SaveChanges();
*
* var courseInstructors = new CourseAssignment[]
* {
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Kapoor").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Harui").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Microeconomics" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Zheng").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Macroeconomics" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Zheng").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Calculus" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Fakhouri").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Trigonometry" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Harui").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Composition" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
* },
* new CourseAssignment {
* CourseID = courses.Single(c => c.Title == "Literature" ).CourseID,
* InstructorID = instructors.Single(i => i.LastName == "Abercrombie").ID
* },
* };
*
* foreach (CourseAssignment ci in courseInstructors)
* {
* context.CourseAssignments.Add(ci);
* }
* context.SaveChanges();
*
* var enrollments = new Enrollment[]
* {
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alexander").ID,
* CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID,
* Grade = Grade.A
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alexander").ID,
* CourseID = courses.Single(c => c.Title == "Microeconomics" ).CourseID,
* Grade = Grade.C
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alexander").ID,
* CourseID = courses.Single(c => c.Title == "Macroeconomics" ).CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alonso").ID,
* CourseID = courses.Single(c => c.Title == "Calculus" ).CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alonso").ID,
* CourseID = courses.Single(c => c.Title == "Trigonometry" ).CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Alonso").ID,
* CourseID = courses.Single(c => c.Title == "Composition" ).CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Anand").ID,
* CourseID = courses.Single(c => c.Title == "Chemistry" ).CourseID
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Anand").ID,
* CourseID = courses.Single(c => c.Title == "Microeconomics").CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Barzdukas").ID,
* CourseID = courses.Single(c => c.Title == "Chemistry").CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Li").ID,
* CourseID = courses.Single(c => c.Title == "Composition").CourseID,
* Grade = Grade.B
* },
* new Enrollment {
* StudentID = students.Single(s => s.LastName == "Justice").ID,
* CourseID = courses.Single(c => c.Title == "Literature").CourseID,
* Grade = Grade.B
* }
* };
*
* foreach (Enrollment e in enrollments)
* {
* var enrollmentInDataBase = context.Enrollments.Where(
* s =>
* s.Student.ID == e.StudentID &&
* s.Course.CourseID == e.CourseID).SingleOrDefault();
* if (enrollmentInDataBase == null)
* {
* context.Enrollments.Add(e);
* }
* }
* context.SaveChanges();
*/
}
