public static ResponResultViewModel Update(TableViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
//Create
if (entity.id == 0)
{
Table table = new Table();
table.initial = entity.initial;
table.Seat = entity.Seat;
table.Desc = entity.Desc;
table.Active = entity.Active;
table.CreateBy = "Bloblo";
table.CreateDate = DateTime.Now;
db.Tables.Add(table);
db.SaveChanges();
result.Entity = table;
}
//Edit
else
{
Table table = db.Tables.Where(o => o.id == entity.id).FirstOrDefault();
if (table != null)
{
table.initial = entity.initial;
table.Seat = entity.Seat;
table.Desc = entity.Desc;
table.Active = entity.Active;
table.ModifyBy = "Booboo";
table.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "table not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel Update(CategoryViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
//Create
if (entity.id == 0)
{
Category category = new Category();
category.initial = entity.initial;
category.Name = entity.Name;
category.Active = entity.Active;
category.CreateBy = "Bloblo";
category.CreateDate = DateTime.Now;
db.Categories.Add(category);
db.SaveChanges();
result.Entity = category;
}
//Edit
else
{
Category category = db.Categories.Where(o => o.id == entity.id).FirstOrDefault();
if (category != null)
{
category.initial = entity.initial;
category.Name = entity.Name;
category.Active = entity.Active;
category.ModifyBy = "Booboo";
category.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Category not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public ActionResult Create([Bind(Include = "Id,Name")] Measure measure)
{
if (ModelState.IsValid)
{
db.Measuries.Add(measure);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(measure));
}
public ActionResult Create([Bind(Include = "Id,Name")] Author author)
{
if (ModelState.IsValid)
{
db.Authors.Add(author);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(author));
}
public ActionResult Create([Bind(Include = "Id,Name")] Category category)
{
if (ModelState.IsValid)
{
db.Categorys.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Create([Bind(Include = "Id,Name")] Ingredient ingredient)
{
if (ModelState.IsValid)
{
db.Ingredients.Add(ingredient);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ingredient));
}
public ActionResult Create([Bind(Include = "Id,Text,PhotoUrl,ReceipeId")] Step step)
{
if (ModelState.IsValid)
{
db.Steps.Add(step);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ReceipeId = new SelectList(db.Recipies, "Id", "Name", step.ReceipeId);
return(View(step));
}
public ActionResult Create([Bind(Include = "Id,Name,Preview,PhotoUrl,CookingTime,DateOfCreation,UserId")] Recipe recipe)
{
if (ModelState.IsValid)
{
db.Recipies.Add(recipe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.Users, "Id", "Login", recipe.UserId);
return(View(recipe));
}
public ActionResult Create([Bind(Include = "Id,Content,AuthorId")] Recipe recipe)
{
if (ModelState.IsValid)
{
db.Recipes.Add(recipe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AuthorId = new SelectList(db.Authors, "Id", "Name", recipe.AuthorId);
return(View(recipe));
}
public ActionResult Create([Bind(Include = "Id,Surname,Name,Gender,PhotoUrl,DateOfBirth")] UserProfile userProfile)
{
if (ModelState.IsValid)
{
db.UserProfilies.Add(userProfile);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(db.Users, "Id", "Login", userProfile.Id);
return(View(userProfile));
}
public ActionResult Create([Bind(Include = "Id,Name,CategoryId")] Tag tag)
{
if (ModelState.IsValid)
{
db.Tags.Add(tag);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.Categorys, "Id", "Name", tag.CategoryId);
return(View(tag));
}
public ActionResult Create([Bind(Include = "UserId,ReceipeId,Rating")] RecipeRating recipeRating)
{
if (ModelState.IsValid)
{
db.RecipeRatings.Add(recipeRating);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ReceipeId = new SelectList(db.Recipies, "Id", "Name", recipeRating.ReceipeId);
ViewBag.UserId = new SelectList(db.Users, "Id", "Login", recipeRating.UserId);
return(View(recipeRating));
}
public ActionResult Create([Bind(Include = "UserId,ReceipeId")] FavouriteRecipe favouriteRecipe)
{
if (ModelState.IsValid)
{
db.FavouriteRecipies.Add(favouriteRecipe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ReceipeId = new SelectList(db.Recipies, "Id", "Name", favouriteRecipe.ReceipeId);
ViewBag.UserId = new SelectList(db.Users, "Id", "Login", favouriteRecipe.UserId);
return(View(favouriteRecipe));
}
public ActionResult Create([Bind(Include = "Id,Login,Password,Email,DateOfRegistration,Locked,RoleId")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RoleId = new SelectList(db.Roles, "Id", "Name", user.RoleId);
ViewBag.Id = new SelectList(db.UserProfilies, "Id", "Surname", user.Id);
return(View(user));
}
public ActionResult Create([Bind(Include = "RecipeId,TagId")] TagRecipe tagRecipe)
{
if (ModelState.IsValid)
{
db.TagRecipies.Add(tagRecipe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RecipeId = new SelectList(db.Recipies, "Id", "Name", tagRecipe.RecipeId);
ViewBag.TagId = new SelectList(db.Tags, "Id", "Name", tagRecipe.TagId);
return(View(tagRecipe));
}
public ActionResult Create([Bind(Include = "Id,Text,ReceipeId,UserId")] Comment comment)
{
if (ModelState.IsValid)
{
comment.Date = DateTime.Now;
db.Comments.Add(comment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ReceipeId = new SelectList(db.Recipies, "Id", "Name", comment.ReceipeId);
ViewBag.UserId = new SelectList(db.Users, "Id", "Login", comment.UserId);
return(View(comment));
}
public ActionResult Create([Bind(Include = "IngredientId,ReceipeId,MeasureId,Amount")] RecipeIngredient recipeIngredient)
{
if (ModelState.IsValid)
{
db.RecipeIngredients.Add(recipeIngredient);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IngredientId = new SelectList(db.Ingredients, "Id", "Name", recipeIngredient.IngredientId);
ViewBag.MeasureId = new SelectList(db.Measuries, "Id", "Name", recipeIngredient.MeasureId);
ViewBag.ReceipeId = new SelectList(db.Recipies, "Id", "Name", recipeIngredient.RecipeId);
return(View(recipeIngredient));
}
public static ResponResultViewModel WorkFlow(OrderViewModel entity)
{
ResponResultViewModel res = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
if (entity.id == 0)
{
Order ord = new Order();
ord.reservid = entity.reservid;
ord.productid = entity.productid;
ord.quantity = entity.quantity;
ord.price = entity.price;
ord.status = entity.status + 1;
ord.Active = true;
ord.CreateBy = "OrderBlu";
ord.CreateDate = DateTime.Now;
db.Orders.Add(ord);
db.SaveChanges();
res.Entity = ord;
}
else
{
Order order = db.Orders.Where(o => o.id == entity.id).FirstOrDefault();
if (order == null)
{
res.Success = false;
res.Message = "Ord Not FOund";
}
else
{
order.status = order.status + 1;
db.SaveChanges();
res.Entity = entity;
}
}
}
}
catch (Exception e)
{
res.Success = false;
res.Message = e.Message;
}
return(res);
}
public void TestCategory()
{
using (var db = new KitchenContext())
{
Trace.WriteLine("--- Starting Category Testing ");
Category cat = new Category()
{
initial = "MC",
Name = "Main Course",
Active = true,
CreateBy = "Bloobloo",
CreateDate = DateTime.Now
};
db.Categories.Add(cat);
cat = new Category()
{
initial = "Dr",
Name = "Drink",
Active = true,
CreateBy = "Bloobloo",
CreateDate = DateTime.Now
};
db.Categories.Add(cat);
db.SaveChanges();
foreach (var category in db.Categories.ToList())
{
Trace.WriteLine(category.Name);
}
Trace.WriteLine("--- Ending Category Testing ");
}
}
public void UpdateQuantity(KitchenContext context, int ingredientId, int amount)
{
var ingredient = context.Ingredients.Find(ingredientId);
ingredient.Quantity = ingredient.Quantity + amount;
context.SaveChanges();
}
public static ResponResultViewModel Delete(int id)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
Product prod = db.Products.Where(x => x.id == id).FirstOrDefault();
if (prod != null)
{
result.Entity = prod;
db.Products.Remove(prod);
db.SaveChanges();
}
else
{
result.Success = false;
result.Message = "Products not found";
}
}
}
catch (Exception e)
{
result.Success = false;
result.Message = "Category memiliki Product, tidak dapat dihapus";
}
return(result);
}
public static ResponResultViewModel Delete(int id)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
Student st = db.Students.Where(x => x.id == id).FirstOrDefault();
if (st != null)
{
result.Entity = st;
db.Students.Remove(st);
db.SaveChanges();
}
else
{
result.Success = false;
result.Message = "Students not found";
}
}
}
catch (Exception e)
{
result.Success = false;
result.Message = e.Message;
}
return(result);
}
public void Save(KitchenContext context, Recipe currentOrder)
{
context.Omelettes.Add(new Omelette {
Recipe = currentOrder, DateCooked = DateTime.Today
});
context.SaveChanges();
}
public static ResponResultViewModel Update(ReservationVIewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
entity.reference = GerReff();
try
{
using (var db = new KitchenContext())
{
if (entity.id == 0)
{
Reservation reserv = new Reservation();
reserv.guest = entity.guest;
reserv.reference = entity.reference;
reserv.tableid = entity.tableid;
reserv.Paid = false;
reserv.CreateBy = "Floofloo";
reserv.CreateDate = DateTime.Now;
reserv.Active = true;
db.Reservations.Add(reserv);
db.SaveChanges();
result.Entity = entity;
}
else
{
Reservation reserv = db.Reservations.Where(r => r.id == entity.id).FirstOrDefault();
reserv.guest = entity.guest;
reserv.ModifyBy = "BlubluRese";
reserv.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ee)
{
result.Success = false;
result.Message = ee.Message;
}
return(result);
}
public override void CreateRole(string roleName)
{
Role newRole = new Role()
{
Name = roleName
};
KitchenContext db = new KitchenContext();
db.Roles.Add(newRole);
db.SaveChanges();
}
public KitchenControllerTest()
{
dbContextOptions = new DbContextOptionsBuilder <KitchenContext>()
.UseInMemoryDatabase(databaseName: "in-memory")
.Options;
using (var dbContext = new KitchenContext(dbContextOptions))
{
dbContext.AddRange(GetFakeData());
dbContext.SaveChanges();
}
logger = new Mock <ILogger <KitchenController> >().Object;
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
User user = null;
using (KitchenContext db = new KitchenContext())
{
user = db.Users.FirstOrDefault(u => u.Login == model.Login);
}
if (user == null)
{
// создаем нового пользователя
using (KitchenContext db = new KitchenContext())
{
user = new User {
Login = model.Login, Password = model.Password, DateOfRegistration = DateTime.Now, Role = db.Roles.Where(i => i.Name == "User").FirstOrDefault(), Email = model.Email
};
db.Users.Add(user);
var userProfile = new UserProfile()
{
DateOfBirth = DateTime.Now,
Gender = null,
Name = "",
Surname = "",
PhotoUrl = "",
User = user
};
db.UserProfilies.Add(userProfile);
db.SaveChanges();
user = db.Users.Where(u => u.Login == model.Login && u.Password == model.Password).FirstOrDefault();
}
// если пользователь удачно добавлен в бд
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Login, true);
return(RedirectToAction("Index", "Home"));
}
}
else
{
ModelState.AddModelError("", "Пользователь с таким логином уже существует");
}
}
return(View(model));
}
public static ResponResultViewModel Update(ProductViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
//Create
if (entity.id == 0)
{
Product product = new Product();
product.initial = entity.initial;
product.name = entity.name;
product.description = entity.description;
product.categoryid = entity.categoryid;
product.price = entity.price;
product.Active = entity.Active;
product.CreateBy = "Bloblo";
product.CreateDate = DateTime.Now;
db.Products.Add(product);
db.SaveChanges();
result.Entity = product;
}
//Edit
else
{
Product product = db.Products.Where(o => o.id == entity.id).FirstOrDefault();
if (product != null)
{
product.initial = entity.initial;
product.name = entity.name;
product.description = entity.description;
product.categoryid = entity.categoryid;
product.price = entity.price;
product.Active = entity.Active;
product.ModifyBy = "Bloblo";
product.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Prod not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel Update(StudentViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new KitchenContext())
{
//Create
if (entity.id == 0)
{
Student st = new Student();
st.firstname = entity.firstname;
st.lastname = entity.lastname;
st.gender = entity.gender;
st.dob = entity.dob;
st.pob = entity.pob;
st.Active = entity.Active;
st.CreateBy = "Blobloblo";
st.CreateDate = DateTime.Now;
db.Students.Add(st);
db.SaveChanges();
result.Entity = st;
}
//Edit
else
{
Student st = db.Students.Where(o => o.id == entity.id).FirstOrDefault();
if (st != null)
{
st.firstname = entity.firstname;
st.lastname = entity.lastname;
st.gender = entity.gender;
st.dob = entity.dob;
st.pob = entity.pob;
st.Active = entity.Active;
st.ModifyBy = "Booboo";
st.ModifyDate = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Student not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public ActionResult NewRecipe(string[] nameIngrediendRecipe, int[] countIngredienRecipe, int[] measureIdRecipe, string[] textStepRecipe, List <HttpPostedFileBase> fileInput, HttpPostedFileBase previewPhoto, string nameRecipe = "", string textRecipe = "", int hoursRecipe = 0, int minutesRecipe = 0, string tags = "")
{
DirectoryInfo Dir = new DirectoryInfo(Request.MapPath("~/Files/"));
if (Dir.EnumerateDirectories().FirstOrDefault(i => i.Name == User.Identity.Name) == null)
{
Dir.CreateSubdirectory(User.Identity.Name);
}
Dir = new DirectoryInfo(Request.MapPath("~/Files/" + User.Identity.Name));
if (Dir.EnumerateDirectories().FirstOrDefault(i => i.Name == nameRecipe) == null)
{
Dir.CreateSubdirectory(nameRecipe);
}
previewPhoto.SaveAs(Server.MapPath("~/Files/" + User.Identity.Name + "/" + nameRecipe + "/" + previewPhoto.FileName));
Recipe recipe = new Recipe()
{
Hours = hoursRecipe,
Minutes = minutesRecipe,
DateOfCreation = DateTime.Now,
Name = nameRecipe,
PhotoUrl = "../Files/" + User.Identity.Name + "/" + nameRecipe + "/" + previewPhoto.FileName,
Preview = textRecipe,
User = db.Users.FirstOrDefault(i => i.Login == User.Identity.Name),
};
db.Recipies.Add(recipe);
string[] arrayOfTags = tags.Split(',');
for (int j = 0; j < arrayOfTags.Length; j++)
{
arrayOfTags[j] = arrayOfTags[j].Trim();
}
arrayOfTags = arrayOfTags.Distinct().ToArray();
string result = "";
for (int j = 0; j < arrayOfTags.Length - 1; j++)
{
var tag = arrayOfTags[j];
result += tag;
var tagDb = db.Tags.FirstOrDefault(i => i.Name == tag);
if (tagDb == null)
{
db.Tags.Add(new Tag {
Name = tag, Category = db.Categorys.FirstOrDefault(i => i.Name == "Прочее")
});
}
TagRecipe tagRecpe = new TagRecipe()
{
Tag = tagDb,
Recipe = recipe
};
db.TagRecipies.Add(tagRecpe);
}
for (int j = 0; j < textStepRecipe.Length; j++)
{
fileInput[j].SaveAs(Server.MapPath("~/Files/" + User.Identity.Name + "/" + nameRecipe + "/" + fileInput[j].FileName));
var newStep = new Step()
{
PhotoUrl = "../Files/" + User.Identity.Name + "/" + nameRecipe + "/" + fileInput[j].FileName,
Receipe = recipe,
Text = textStepRecipe[j]
};
db.Steps.Add(newStep);
}
for (int j = 0; j < countIngredienRecipe.Length; j++)
{
string name = nameIngrediendRecipe[j];
var ingredient = db.Ingredients.FirstOrDefault(i => i.Name == name);
if (ingredient == null)
{
ingredient = new Ingredient()
{
Name = nameIngrediendRecipe[j],
Permission = 0
};
db.Ingredients.Add(ingredient);
}
;
var newIngredient = new RecipeIngredient();
newIngredient.Amount = countIngredienRecipe[j];
newIngredient.Ingredient = ingredient;
newIngredient.Recipe = recipe;
newIngredient.Measure = db.Measuries.Find(measureIdRecipe[j]);
db.RecipeIngredients.Add(newIngredient);
}
db.SaveChanges();
return(RedirectToAction("NewRecipe"));
}