public Boolean AddCart(Cart model)
{
var availableStock = db.Products.Where(x => x.Product_Id == model.Product_Id).FirstOrDefault();
int StockInHand = availableStock.Product_Quantity;
if (StockInHand > model.Quantity)
{
var Authorize = db.carts.Where(x => x.Product_Id == model.Product_Id && x.userId == model.userId).FirstOrDefault();
if (Authorize == null)
{
db.carts.Add(model);
db.SaveChanges();
var query = db.carts.Where(x => x.Cart_Id == model.Cart_Id).FirstOrDefault();
var query1 = db.Products.Where(p => p.Product_Id == model.Product_Id).FirstOrDefault();
double price = query1.Product_Price;
query.Price = price;
query.Total = (query.Quantity * price);
db.SaveChanges();
return(true);
}
else
{
Authorize.Quantity = Authorize.Quantity + model.Quantity;
Authorize.Total = Authorize.Total + (model.Quantity * Authorize.Price);
db.SaveChanges();
return(true);
}
}
else
{
return(false);
}
}
public T Add(T entity)
{
var newEntity = _entities.Add(entity);
_dbContext.SaveChanges();
return(newEntity);
}
public ActionResult Create([Bind(Include = "ID,FileNumber,Secret,Reminder,Title,FirstName,Surname,IdNumber,BirthDate,EmailAddress,ContactNumber,CellNumber,Address1,Address2,Address3,Address4,ConsultationFee,CurrentBalance")] Patient patient)
{
if (ModelState.IsValid)
{
db.Patients.Add(patient);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(patient));
}
public bool UpdateUser(string userID, string pass, string cName, string phone, string tel, string gender, string birth)
{
try
{
// Query the database for the row to be updated.
var query =
(from mem in _context.Member
where mem.Account == userID
select mem).ToList();
// Execute the query, and change the column values
// you want to change.
foreach (Member mem in query)
{
mem.Password = pass;
mem.Name = cName;
mem.Phone = phone;
mem.Tel = tel;
mem.Gender = gender;
mem.Birthday = DateTime.Parse(birth);
}
_context.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
var entityError = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
return(false);
}
}
public int AddConsumer([FromBody] Consumer consumer)
{
try
{
_context.Consumer.Add(consumer);
int numberEntriesSaved = _context.SaveChanges();
return(numberEntriesSaved);
}
catch
{
throw;
}
//if (ModelState.IsValid)
// _dataLayer.AddConsumer(consumer);
}
public static void OrderMock(PracticeContext context)
{
if (context.Order.Any())
{
return;
}
context.Order.AddRange(Enumerable.Range(1, 5).Select(c => CreateOrder(c, context)));
context.SaveChanges();
}
public bool AddCart(Cart model)
{
var availableStock = db.Products.Where(x => x.PId == model.PId).FirstOrDefault();
int StockInHand = model.Quantity;
if (StockInHand >= model.Quantity)
{
var Authorize = db.Carts.Where(x => x.PId == model.PId && x.UId == model.UId).FirstOrDefault();
if (Authorize == null)
{
Product product = db.Products.Find(model.PId);
int total = product.Quantity * product.PPrice;
Cart cart = new Cart();
cart.PId = model.PId;
cart.Item = product.PImage;
cart.Description = product.PName;
cart.Quantity = product.Quantity;
cart.Price = product.PPrice;
cart.UId = model.UId;
cart.Total = total;
db.Carts.Add(cart);
db.SaveChanges();
return(true);
}
else
{
db.Carts.Add(model);
db.SaveChanges();
Authorize.Quantity = Authorize.Quantity + model.Quantity;
Authorize.Total = Authorize.Total + (model.Quantity * Authorize.Price);
db.SaveChanges();
return(true);
}
}
else
{
return(false);
}
}
public static void CreateUser(PracticeContext context)
{
var user = new User()
{
Username = "******",
Password = "",
SecurityToken = "",
Name = "Ball",
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
};
context.Add(user);
context.SaveChanges();
}
public IActionResult Create(User NewUser)
{
User newUser = new User {
FirstName = NewUser.FirstName,
LastName = NewUser.LastName,
Email = NewUser.Email,
Password = NewUser.Password
};
// We can take the User object created from a form submission
// And pass this object to the .Add() method
dbContext.Add(newUser);
// OR dbContext.Users.Add(newUser);
dbContext.SaveChanges();
// Other code
return(RedirectToAction("Index"));
}
public static void SupplierMock(PracticeContext context)
{
if (context.Suppliers.Any())
{
return;
}
context.Suppliers.AddRange(Enumerable.Range(1, 5).Select(c => new Supplier
{
Name = "Supplier_" + c,
Address = "Thailand",
PhoneNo = "084-874" + c,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
}));
context.SaveChanges();
}
public static void ActionStateMock(PracticeContext context)
{
if (context.ActionStates.Any())
{
return;
}
var user = context.Users.FirstOrDefault();
var action = new ActionState()
{
By = user.Id,
On = DateTime.Now.Ticks
};
context.ActionStates.Add(action);
context.SaveChanges();
}
public static void ItemsStateMock(PracticeContext context)
{
if (context.ItemStates.Any())
{
return;
}
var item = context.Items.ToArray().Select(c => new ItemState
{
ItemId = c.Id,
Type = StateType.Get,
ActionStateId = context.ActionStates.Select(x => x.Id).FirstOrDefault(),
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
});
context.ItemStates.AddRange(item);
context.SaveChanges();
}
public static void OrdersStateMock(PracticeContext context)
{
if (context.OrderStates.Any())
{
return;
}
var order = context.Order.ToArray().Select(c => new OrderState
{
OrderId = c.Id,
Type = StateType.Get,
ActionStateId = context.ActionStates.Select(x => x.Id).FirstOrDefault(),
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
});
context.OrderStates.AddRange(order);
context.SaveChanges();
}
private static void AddTopics(PracticeContext context)
{
var topicList = new List <Topic>
{
new Topic {
TopicId = "TAdd", TopicDesc = "Addition"
},
new Topic {
TopicId = "TSub", TopicDesc = "Subtraction"
},
new Topic {
TopicId = "TMul", TopicDesc = "Multiplication"
},
new Topic {
TopicId = "TDiv", TopicDesc = "Division"
},
new Topic {
TopicId = "TAlg", TopicDesc = "Algebra"
},
new Topic {
TopicId = "TDec", TopicDesc = "Decimal"
},
new Topic {
TopicId = "TFra", TopicDesc = "Fraction"
},
new Topic {
TopicId = "TNum", TopicDesc = "Number Sense"
},
new Topic {
TopicId = "TInt", TopicDesc = "Integers"
},
};
topicList.ForEach(s => context.Topics.Add(s));
context.SaveChanges();
Console.WriteLine("updated topics");
}
public void UpdateContext(PracticeContext context)
{
//Membership.CreateUser(“testuser”, “test123″);
//Roles.CreateRole(“Administrator”);
//Roles.AddUsersToRole(new[] {“testuser”}, “Administrator”);
var topicList = new List <Topic>
{
new Topic {
TopicId = "TAdd", TopicDesc = "Adddition"
},
new Topic {
TopicId = "TSub", TopicDesc = "Subtraction"
},
new Topic {
TopicId = "TMul", TopicDesc = "Multipication"
},
new Topic {
TopicId = "TDiv", TopicDesc = "Division"
},
new Topic {
TopicId = "TAlg", TopicDesc = "Algebra"
},
new Topic {
TopicId = "TCom", TopicDesc = "Compare"
},
new Topic {
TopicId = "TFra", TopicDesc = "Fraction"
},
new Topic {
TopicId = "TDec", TopicDesc = "Decimal"
},
new Topic {
TopicId = "TPAl", TopicDesc = "Pre-Algebra"
},
new Topic {
TopicId = "TWor", TopicDesc = "WordProblem"
},
};
topicList.ForEach(s => context.Topics.Add(s));
context.SaveChanges();
var subTopicList = new List <SubTopic>
{
//Add
new SubTopic {
SubTopicId = "1001", SubTopicDesc = "Additions 1 to 9", TopicId = "TAdd"
},
new SubTopic {
SubTopicId = "1002", SubTopicDesc = "Additions 1 to 100", TopicId = "TAdd"
},
new SubTopic {
SubTopicId = "1003", SubTopicDesc = "Two Digit Additions 11-20 with 11-20", TopicId = "TAdd"
},
new SubTopic {
SubTopicId = "1004", SubTopicDesc = "Two Digit Additions with Regrouping", TopicId = "TAdd"
},
//Sub
new SubTopic {
SubTopicId = "1101", SubTopicDesc = "Subtraction 1 to 9", TopicId = "TSub"
},
new SubTopic {
SubTopicId = "1102", SubTopicDesc = "Subtraction 1 to 100", TopicId = "TSub"
},
new SubTopic {
SubTopicId = "1103", SubTopicDesc = "Two Digit Subtraction 11-20 with 11-20", TopicId = "TSub"
},
new SubTopic {
SubTopicId = "1104", SubTopicDesc = "Two Digit Subtraction with Regrouping", TopicId = "TSub"
},
//Mul
new SubTopic {
SubTopicId = "1201", SubTopicDesc = "Multiplication by 1", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1202", SubTopicDesc = "Multiplication by 2", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1203", SubTopicDesc = "Multiplication by 3", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1204", SubTopicDesc = "Multiplication by 4", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1205", SubTopicDesc = "Multiplication by 5", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1206", SubTopicDesc = "Multiplication by 6", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1207", SubTopicDesc = "Multiplication by 7", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1208", SubTopicDesc = "Multiplication by 8", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1209", SubTopicDesc = "Multiplication by 9", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1210", SubTopicDesc = "Multiplication by 10", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1211", SubTopicDesc = "Multiplication by 11", TopicId = "TMul"
},
new SubTopic {
SubTopicId = "1212", SubTopicDesc = "Multiplication by 12", TopicId = "TMul"
},
//new SubTopic { SubTopicId="1213", SubTopicDesc ="Multiplication by 8", TopicId="TMul" },
//Division
new SubTopic {
SubTopicId = "1301", SubTopicDesc = "Division 1 to 9", TopicId = "TDiv"
},
new SubTopic {
SubTopicId = "1302", SubTopicDesc = "Division 1 to 100", TopicId = "TDiv"
},
new SubTopic {
SubTopicId = "1303", SubTopicDesc = "Two Digit Division 11-20 with 11-20", TopicId = "TDiv"
},
new SubTopic {
SubTopicId = "1304", SubTopicDesc = "Two Digit Division with Regrouping", TopicId = "TDiv"
},
//Algebra
new SubTopic {
SubTopicId = "2001", SubTopicDesc = "Algebra for Addition", TopicId = "TAlg"
},
new SubTopic {
SubTopicId = "2101", SubTopicDesc = "Algebra for Subraction", TopicId = "TAlg"
},
new SubTopic {
SubTopicId = "2201", SubTopicDesc = "Algebra involving Mulitplication", TopicId = "TAlg"
},
new SubTopic {
SubTopicId = "2301", SubTopicDesc = "Algebra involving Division", TopicId = "TAlg"
},
};
subTopicList.ForEach(s => context.SubTopics.Add(s));
context.SaveChanges();
//add the Grades Table
// var gradeList = GradeList ?? SimpleInit.GetHardCodedGrades();
var gradeList = new List <Grade>
{
//Add
new Grade {
GradeId = "-1", GradeDesc = "Pre-K", GradeDesc2 = "PreSchool"
},
new Grade {
GradeId = "0", GradeDesc = "KinderGarten", GradeDesc2 = "KinderGarten"
},
new Grade {
GradeId = "1", GradeDesc = "Grade1", GradeDesc2 = "Grade1"
},
new Grade {
GradeId = "2", GradeDesc = "Grade2", GradeDesc2 = "Grade2"
},
new Grade {
GradeId = "3", GradeDesc = "Grade3", GradeDesc2 = "Grade3"
},
new Grade {
GradeId = "4", GradeDesc = "Grade4", GradeDesc2 = "Grade4"
},
new Grade {
GradeId = "5", GradeDesc = "Grade5", GradeDesc2 = "Grade5"
},
new Grade {
GradeId = "6", GradeDesc = "Grade6", GradeDesc2 = "Grade6"
},
new Grade {
GradeId = "7", GradeDesc = "Grade7", GradeDesc2 = "Grade7"
},
new Grade {
GradeId = "8", GradeDesc = "Grade8", GradeDesc2 = "Grade8"
},
};
gradeList.ForEach(s => context.Grades.Add(s));
context.SaveChanges();
//var gradeSubTopicList = GradeSubTopicList ?? SimpleInit.GetHardCodedGrade_Subtopic();
var gradeSubTopicList = new List <GradeSubTopic>
{
new GradeSubTopic {
GradeId = "-1", SubTopicId = "1001"
},
new GradeSubTopic {
GradeId = "-1", SubTopicId = "1002"
},
new GradeSubTopic {
GradeId = "0", SubTopicId = "1001"
},
new GradeSubTopic {
GradeId = "0", SubTopicId = "1002"
},
new GradeSubTopic {
GradeId = "0", SubTopicId = "1101"
},
new GradeSubTopic {
GradeId = "0", SubTopicId = "1102"
},
new GradeSubTopic {
GradeId = "1", SubTopicId = "1001"
},
new GradeSubTopic {
GradeId = "1", SubTopicId = "1002"
},
new GradeSubTopic {
GradeId = "1", SubTopicId = "1101"
},
new GradeSubTopic {
GradeId = "1", SubTopicId = "1102"
},
new GradeSubTopic {
GradeId = "1", SubTopicId = "1003"
},
new GradeSubTopic {
GradeId = "1", SubTopicId = "1004"
},
new GradeSubTopic {
GradeId = "1", SubTopicId = "1103"
},
new GradeSubTopic {
GradeId = "1", SubTopicId = "1104"
},
new GradeSubTopic {
GradeId = "2", SubTopicId = "1001"
},
new GradeSubTopic {
GradeId = "2", SubTopicId = "1002"
},
new GradeSubTopic {
GradeId = "2", SubTopicId = "1101"
},
new GradeSubTopic {
GradeId = "2", SubTopicId = "1102"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1201"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1202"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1203"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1204"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1205"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1206"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1207"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1208"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1209"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1210"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1211"
},
new GradeSubTopic {
GradeId = "3", SubTopicId = "1212"
},
new GradeSubTopic {
GradeId = "4", SubTopicId = "1201"
},
new GradeSubTopic {
GradeId = "4", SubTopicId = "1202"
},
new GradeSubTopic {
GradeId = "4", SubTopicId = "1203"
},
new GradeSubTopic {
GradeId = "4", SubTopicId = "1204"
},
new GradeSubTopic {
GradeId = "4", SubTopicId = "1205"
},
new GradeSubTopic {
GradeId = "5", SubTopicId = "1201"
},
new GradeSubTopic {
GradeId = "5", SubTopicId = "1202"
},
new GradeSubTopic {
GradeId = "5", SubTopicId = "1203"
},
new GradeSubTopic {
GradeId = "5", SubTopicId = "1204"
},
new GradeSubTopic {
GradeId = "5", SubTopicId = "1205"
},
new GradeSubTopic {
GradeId = "6", SubTopicId = "1201"
},
new GradeSubTopic {
GradeId = "6", SubTopicId = "1202"
},
new GradeSubTopic {
GradeId = "6", SubTopicId = "1203"
},
new GradeSubTopic {
GradeId = "6", SubTopicId = "1204"
},
new GradeSubTopic {
GradeId = "6", SubTopicId = "1205"
},
new GradeSubTopic {
GradeId = "7", SubTopicId = "1201"
},
new GradeSubTopic {
GradeId = "7", SubTopicId = "1202"
},
new GradeSubTopic {
GradeId = "7", SubTopicId = "1203"
},
new GradeSubTopic {
GradeId = "7", SubTopicId = "1204"
},
new GradeSubTopic {
GradeId = "7", SubTopicId = "1205"
},
new GradeSubTopic {
GradeId = "8", SubTopicId = "1201"
},
new GradeSubTopic {
GradeId = "8", SubTopicId = "1202"
},
new GradeSubTopic {
GradeId = "8", SubTopicId = "1203"
},
new GradeSubTopic {
GradeId = "8", SubTopicId = "1204"
},
new GradeSubTopic {
GradeId = "8", SubTopicId = "1205"
},
};
gradeSubTopicList.ForEach(s => context.GradeSubTopics.Add(s));
context.SaveChanges();
var questionList = QuestionList ?? SimpleInit.GetHardCodedQuestions();
questionList.ForEach(s => context.Questions.Add(s));
context.SaveChanges();
var answerOptionsList = AnswerOptionList ?? SimpleInit.GetHardCodedAnsweOptions();
answerOptionsList.ForEach(s => context.AnswerOptions.Add(s));
context.SaveChanges();
var questionDetailList = QuestionDetailList ?? SimpleInit.GetHardCodedQuestionDetails();
questionDetailList.ForEach(s => context.QuestionDetails.Add(s));
context.SaveChanges();
//add the Sheet Tables
var sheetList = SheetList ?? SimpleInit.GenerateSheetList();
sheetList.ForEach(s => context.Sheet.Add(s));
context.SaveChanges();
//add the Question Sheet details
var questionSheetList = QuestionSheetList ?? SimpleInit.GenerateQuestionSheetList();
questionSheetList.ForEach(s => context.QuestionSheet.Add(s));
context.SaveChanges();
}
public IActionResult Post([FromBody] Game game)
{
_context.Games.Add(game);
_context.SaveChanges();
return(Created("", game));
}