public ActionResult Product(int?id, string name, string email, int?rating, string comments)
{
// Initialize an object of ProductReview from the DB
ProductReview review = db.ProductReviews.Create();
//If any of the fields are null then we have to stop, collaborate and listen.
if (id == null || id.Equals("") || name == null || name.Equals("") || email == null || email.Equals("") || rating == null || rating.Equals("") || comments == null || comments.Equals(""))
{ //reloads the page
return(View(ProductDetails(id)));
}
// add all the attributes of a Product Review to add it to the db
review.Comments = comments;
review.EmailAddress = email;
review.ModifiedDate = DateTime.Now; // correct the date/time format
review.ProductID = (int)id;
review.Rating = (int)rating;
review.ReviewDate = DateTime.Now;
review.ReviewerName = name;
if (ModelState.IsValid) //error checking to make sure that everything was passed correctly and all the datatypes match
{
db.ProductReviews.Add(review); //add it to the database
db.SaveChanges(); //save the database
return(View(ProductDetails(id))); //reload the page
}
return(RedirectToAction("Index")); //if it fails reload the home page
}
public ActionResult Review(FormCollection form, int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
if (form.Get("user") == "" || form.Get("email") == "" || form.Get("comment") == "")
{
return(RedirectToAction("Review"));
}
var format = "MM-dd-yyyy HH:mm:ss:fff";
var stringDate = DateTime.Now.ToString(format);
var reviewDate = DateTime.ParseExact(stringDate, format, CultureInfo.InvariantCulture);
var modifiedDate = DateTime.ParseExact(stringDate, format, CultureInfo.InvariantCulture);
int rating = Convert.ToInt32(form.Get("rating"));
var review = new ProductReview
{
ProductID = id.Value,
ReviewerName = form.Get("user"),
ReviewDate = reviewDate,
EmailAddress = form.Get("email"),
Rating = rating,
Comments = form.Get("comment"),
ModifiedDate = modifiedDate
};
db.ProductReviews.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "ProductID,Name,ProductNumber,MakeFlag,FinishedGoodsFlag,Color,SafetyStockLevel,ReorderPoint,StandardCost,ListPrice,Size,SizeUnitMeasureCode,WeightUnitMeasureCode,Weight,DaysToManufacture,ProductLine,Class,Style,ProductSubcategoryID,ProductModelID,SellStartDate,SellEndDate,DiscontinuedDate,rowguid,ModifiedDate")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductID = new SelectList(db.ProductDocuments, "ProductID", "ProductID", product.ProductID);
ViewBag.ProductModelID = new SelectList(db.ProductModels, "ProductModelID", "Name", product.ProductModelID);
ViewBag.ProductSubcategoryID = new SelectList(db.ProductSubcategories, "ProductSubcategoryID", "Name", product.ProductSubcategoryID);
ViewBag.SizeUnitMeasureCode = new SelectList(db.UnitMeasures, "UnitMeasureCode", "Name", product.SizeUnitMeasureCode);
ViewBag.WeightUnitMeasureCode = new SelectList(db.UnitMeasures, "UnitMeasureCode", "Name", product.WeightUnitMeasureCode);
return(View(product));
}
public ActionResult Product(int?id, string name, string email, int?rating, string comments)
{
// create a new ProductReview object
ProductReview review = db.ProductReviews.Create();
if (id == null || id.Equals("") || name == null || name.Equals("") || email == null || email.Equals("") || rating == null || rating.Equals("") || comments == null || comments.Equals(""))
{
return(RedirectToAction("Failure"));
}
// add all the attributes of a Product Review to add it to the db
review.Comments = comments;
review.EmailAddress = email;
review.ModifiedDate = DateTime.Now; // correct date/time format
review.ProductID = (int)id;
review.Rating = (int)rating;
review.ReviewDate = DateTime.Now;
review.ReviewerName = name;
if (ModelState.IsValid)
{
db.ProductReviews.Add(review);
db.SaveChanges();
return(RedirectToAction("Success"));
}
return(RedirectToAction("Index"));
}
public IActionResult UpdatePerson(Person updatedPerson)
{
if (ModelState.IsValid)
{
Person person = db.Person.FirstOrDefault(p => p.BusinessEntityId == updatedPerson.BusinessEntityId);
person.FirstName = updatedPerson.FirstName;
person.MiddleName = updatedPerson.MiddleName;
person.LastName = updatedPerson.LastName;
person.Title = updatedPerson.Title;
db.Person.Update(person);
db.SaveChanges();
return(RedirectToAction("GetPerson", new { num = updatedPerson.BusinessEntityId }));
}
return(RedirectToAction("GetPerson", updatedPerson));
}
public Core.Models.Product InsertProduct(Core.Models.Product product)
{
var addProduct = Factory.CreateProductEntity(product);
AdventureWorksContext.Add(addProduct);
AdventureWorksContext.SaveChanges();
return(Factory.CreateProductDTO(addProduct));
}
public IActionResult Put([FromRoute] int id, [FromBody] Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.ProductId)
{
return(BadRequest());
}
_context.Entry(product).State = EntityState.Modified;
_context.SaveChanges();
return(Ok(product));
}
public IActionResult DeleteComment(int id)
{
var review = _context.ProductReviews.Find(id);
if (review == null)
{
return(NotFound());
}
if (User == null || !User.IsInRole("Admin"))
{
return(Forbid());
}
_context.ProductReviews.Remove(review);
_context.SaveChanges();
return(Redirect(Request.Headers["Referer"].ToString()));
}
public E Create(E entity)
{
try
{
E output = _context.Set <E>().Add(entity);
_context.SaveChanges();
return(output);
} catch (DbUpdateException e)
{
CheckDbConstraintValidations(e, entity);
throw e;
} catch (Exception e)
{
throw e;
}
}
private static void Main()
{
using (var db = new AdventureWorksContext())
{
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
foreach (var accountNumber in GetAccountNumbers(2000))
{
db.Add(new Customer {
AccountNumber = accountNumber,
});
}
db.SaveChanges();
}
// Warmup
using (var db = new AdventureWorksContext())
{
var customer = db.Customers.First();
}
RunTest(
accountNumbers =>
{
using (var db = new AdventureWorksContext())
{
foreach (var id in accountNumbers)
{
// Use a regular auto-compiled query
var customer = db.Customers.Single(c => c.AccountNumber == id);
}
}
},
name: "Regular");
RunTest(
accountNumbers =>
{
// Create an explicit compiled query
var query = EF.CompileQuery(
(AdventureWorksContext db, string id)
=> db.Customers.Single(c => c.AccountNumber == id));
using (var db = new AdventureWorksContext())
{
foreach (var id in accountNumbers)
{
// Invoke the compiled query
query(db, id);
}
}
},
name: "Compiled");
}
public void UploadImage(byte[] image, string mimeType, int empNo)
{
var employee = _ctx.Employees.Find(empNo);
if (employee != null)
{
employee.Photo = image;
_ctx.SaveChanges();
}
}
public ActionResult Review(ProductReview reviews)
{
if (ModelState.IsValid)
{
db.ProductReviews.Add(reviews);
db.SaveChanges();
return(RedirectToAction("Product", new { id = reviews.ProductID }));
}
reviews.Product = db.Products.Find(reviews.ProductID);
return(View(reviews));
}
public void GenerateData()
{
var bulkConfig = new BulkConfig {
SetOutputIdentity = true, BatchSize = 4000
};
//var fakeCustomers = new Faker<Customer>()
// .RuleFor(c => c.Title, f => f.Name.Prefix())
// .RuleFor(c => c.FirstName, f => f.Name.FirstName())
// .RuleFor(c => c.LastName, f => f.Name.LastName())
// .RuleFor(c => c.CompanyName, f => f.Company.CompanyName())
// .RuleFor(c => c.SalesPerson, f => f.Internet.Email())
// .RuleFor(c => c.EmailAddress, f => f.Internet.Email())
// .RuleFor(c => c.Phone, f => f.Phone.PhoneNumber())
// .RuleFor(c => c.PasswordHash, f => f.Random.Hash())
// .RuleFor(c => c.PasswordSalt, f => f.Random.AlphaNumeric(8))
// .RuleFor(c => c.Rowguid, f => Guid.NewGuid());
//var customerResult = fakeCustomers.Generate(3000);
//context.BulkInsert(customerResult, bulkConfig);
var customerDB = context.Customers.ToList();
//var fakeAddresses = new Faker<Address>()
// .RuleFor(c => c.AddressLine1, f => f.Address.StreetAddress())
// .RuleFor(c => c.City, f => f.Address.City())
// .RuleFor(c => c.StateProvince, f => "Washington")
// .RuleFor(c => c.CountryRegion, f => "United States")
// .RuleFor(c => c.Rowguid, f => Guid.NewGuid())
// .RuleFor(c => c.PostalCode, f => f.Address.ZipCode());
//var addressesResult = fakeAddresses.Generate(10000);
//context.BulkInsert(addressesResult, bulkConfig);
var addressDB = context.Addresses.ToList();
var fakeCustomerAddresses = new Faker <CustomerAddress>()
.RuleFor(c => c.Rowguid, f => Guid.NewGuid())
.RuleFor(c => c.AddressType, f => "Office")
.RuleFor(c => c.Address, f => f.PickRandom(addressDB))
.RuleFor(c => c.Customer, f => f.PickRandom(customerDB));
var customerAddressesResult = fakeCustomerAddresses.Generate(10000);
//context.BulkInsert(customerAddressesResult, bulkConfig);
foreach (var item in customerAddressesResult)
{
context.CustomerAddresses.Add(item);
context.SaveChanges();
}
}
private static AdventureWorksContext InitTestDB()
{
var options = new DbContextOptionsBuilder <AdventureWorksContext>()
.UseInMemoryDatabase(databaseName: "AWListDatabase" + DateTime.Now.ToFileTimeUtc())
.Options;
var context = new AdventureWorksContext(options);
context.Products.Add(new Product {
ProductId = 1, Name = "Prod1", Class = "Class1", ProductSubcategoryId = 1, ListPrice = 2, StandardCost = 3,
});
context.Products.Add(new Product {
ProductId = 2, Name = "Prod2", Class = "Class2", ProductSubcategoryId = 2, ListPrice = 4, StandardCost = 2,
});
context.Products.Add(new Product {
ProductId = 3, Name = "Prod3", Class = "Class3", ProductSubcategoryId = 3, ListPrice = 3, StandardCost = 1,
});
context.ProductCategories.Add(new ProductCategory {
Name = "Cat1", ProductCategoryId = 1,
});
context.ProductCategories.Add(new ProductCategory {
Name = "Cat2", ProductCategoryId = 2,
});
context.ProductCategories.Add(new ProductCategory {
Name = "Cat3", ProductCategoryId = 3,
});
context.ProductSubcategories.Add(new ProductSubcategory {
Name = "SubCat1", ProductSubcategoryId = 1, ProductCategoryId = 1
});
context.ProductSubcategories.Add(new ProductSubcategory {
Name = "SubCat2", ProductSubcategoryId = 2, ProductCategoryId = 2
});
context.ProductSubcategories.Add(new ProductSubcategory {
Name = "SubCat3", ProductSubcategoryId = 3, ProductCategoryId = 3
});
context.ProductPhotos.Add(new ProductPhoto {
ProductPhotoId = 1, ThumbNailPhoto = new byte[] { 1, 2, 3 }
});
context.ProductPhotos.Add(new ProductPhoto {
ProductPhotoId = 2, ThumbNailPhoto = new byte[] { 2, 3, 1 }
});
context.ProductPhotos.Add(new ProductPhoto {
ProductPhotoId = 3, ThumbNailPhoto = new byte[] { 3, 1, 2 }
});
context.SaveChanges();
return(context);
}
public static void AddRecordsAndSave()
{
using (var db = new AdventureWorksContext())
{
for (int i = 0; i < 1000; i++)
{
db.ProductCategories.Add(new ProductCategory {
Name = $"Test {Guid.NewGuid()}"
});
}
db.SaveChanges();
}
}
public ProductsController(AdventureWorksContext context)
{
_db = context;
if (context.Products.Count() == 0)
{
foreach (var p in adventureworksDataSource.GetProducts())
{
context.Products.Add(p);
}
context.SaveChanges();
}
}
public async Task <IActionResult> FormularioCrearAccionInmediata(AccionInmediataModels AI)
{
if (ModelState.IsValid)
{
AccionInmediata Accion = new AccionInmediata()
{
FechaRegistro = DateTime.Now,
Descripcion = AI.Descripcion,
Removed = false,
EventoId = AI.EventoId,
RutPersona = AI.RutPersona,
Efectivo = AI.Efectiva,
};
db.AccionInmediata.Add(Accion);
db.SaveChanges();
return(RedirectToAction("Index", "EventoSecuencia", new { EventoID = AI.EventoId }));
}
else
{
return(await FormularioCrearAccionInmediata(AI.EventoId.TrimEnd()));
}
}
public AdventureWorksContext BuildContext(params PurchaseOrderHeader[] purchaseOrders)
{
var context = new AdventureWorksContext(GenerateContextOptions());
if (purchaseOrders.Length == 0)
{
return(context);
}
context.PurchaseOrderHeader.AddRange(purchaseOrders);
context.SaveChanges();
return(context);
}
public void Test1()
{
using (var transaction = _context.Database.BeginTransaction())
{
var catCount = _context.ProductCategory.Count();
var subCatCount = _context.ProductSubcategory.Count();
//Category and SubCategory have Relations
var productCategory = new ProductCategory()
{
Name = "New ProductCategory",
ProductSubcategory = new List <ProductSubcategory>()
{
new ProductSubcategory()
{
Name = "New SubCategory 1"
},
new ProductSubcategory()
{
Name = "New SubCategory 2"
},
new ProductSubcategory()
{
Name = "New SubCategory 3"
}
}
};
_context.ProductCategory.Add(productCategory);
_context.SaveChanges();
Assert.Equal(catCount + 1, _context.ProductCategory.Count());
Assert.Equal(subCatCount + 3, _context.ProductSubcategory.Count());
_context.ProductSubcategory.RemoveRange(productCategory.ProductSubcategory);
_context.ProductCategory.Remove(productCategory);
_context.SaveChanges();
transaction.Rollback();
}
}
public OrderDetailsController(AdventureWorksContext context)
{
_db = context;
if (context.OrderDetails.Count() == 0)
{
foreach (var o in adventureworksDataSource.GetOrderDetails())
{
context.OrderDetails.Add(o);
}
context.SaveChanges();
}
}
public void ShouldDeleteEntityUsingState()
{
using (var transaction = _context.Database.BeginTransaction())
{
//Arrange the test
var product = TestHelpers.CreateProduct("1");
_context.Add(product);
_context.SaveChanges();
var productId = product.ProductId;
Assert.Equal(1, _context.Product.Count(p => p.ProductId == productId));
_context.Entry(product).State = EntityState.Detached;
//Act
_context.Entry(product).State = EntityState.Deleted;
_context.SaveChanges();
//Assert
Assert.Equal(0, _context.Product.Count(p => p.ProductId == productId));
transaction.Rollback();
}
}
public async Task <IActionResult> FormularioCrearPersona(CreatePersona model)
{
if (ModelState.IsValid)
{
string rut = model.rut.TrimEnd().Replace(".", "").ToUpper();
rut = rut.Replace(",", "");
rut = rut.Replace("-", "");
rut = rut.Replace("_", "");
if (db.Persona.FirstOrDefault(c => c.Rut.TrimEnd().Equals(rut)) != null)
{
ModelState.AddModelError("Error", "Ya existe una persona con ese rut, ingresar un rut distinto para continuar");
return(await FormularioCrearPersona());
}
Persona persona = new Persona()
{
Rut = rut,
Nombre = model.Nombre,
ApellidoPaterno = model.ApellidoPaterno,
ApellidoMaterno = model.ApellidoMaterno,
Sexo = model.Sexo,
RutSupervisor = model.RutSupervisor,
IdArea = model.IdArea,
IdSubArea = model.IdSubArea,
Removed = false,
Cargo = model.Cargo,
};
db.Persona.Add(persona);
db.SaveChanges();
return(RedirectToAction("CuentasPersonas"));
}
else
{
return(await FormularioCrearPersona());
}
}
// PUT: odata/PhoneNumberTypes(5)
public IHttpActionResult Put([FromODataUri] int key, Delta <PhoneNumberType> patch)
{
Validate(patch.GetInstance());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
PhoneNumberType phoneNumberType = _db.PhoneNumberTypes.Find(key);
if (phoneNumberType == null)
{
return(NotFound());
}
patch.Put(phoneNumberType);
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PhoneNumberTypeExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(phoneNumberType));
}
internal static void SeedData(AdventureWorksContext ctx)
{
try
{
if (!ctx.BusinessEntity.Any())
{
ctx.Shift.AddRange(SampleData.GetHumanResourceShifts());
ctx.Department.AddRange(SampleData.GetHRDepartments());
ctx.SaveChanges();
ctx.BusinessEntity.AddRange(SampleData.GetBusinessEntities());
ctx.SalesTerritory.AddRange(SampleData.GetSalesTerritories());
ctx.SaveChanges();
AddAddressesAndContactsToVendor(ctx);
AddAddressesToEmployees(ctx);
AddEmployeeDeptHistoryToDb(ctx);
}
}
catch (Exception ex)
{
Console.WriteLine($"*** SeedData() Error: {ex}");
}
}
// PUT: odata/CountryRegions(5)
public IHttpActionResult Put([FromODataUri] string key, Delta <CountryRegion> patch)
{
Validate(patch.GetInstance());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
CountryRegion countryRegion = _db.CountryRegions.Find(key);
if (countryRegion == null)
{
return(NotFound());
}
patch.Put(countryRegion);
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CountryRegionExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(countryRegion));
}
public IHttpActionResult PutProduct(int id, Product product)
{
Log.Information("Updating product by id={ID}", id);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.ProductID)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
Log.Error("Updating failed: product with id={Id} doesn't exist", id);
return(NotFound());
}
else
{
Log.Information("Updating failed for product by id={ID}", id);
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// PUT: odata/EmailAddresses(5)
public IHttpActionResult Put([FromODataUri] int key, Delta <EmailAddress> patch)
{
Validate(patch.GetInstance());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
EmailAddress emailAddress = _db.EmailAddresses.Find(key);
if (emailAddress == null)
{
return(NotFound());
}
patch.Put(emailAddress);
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmailAddressExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(emailAddress));
}
// PUT: odata/BusinessEntities(5)
public IHttpActionResult Put([FromODataUri] int key, Delta <BusinessEntity> patch)
{
Validate(patch.GetInstance());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
BusinessEntity businessEntity = _db.BusinessEntities.Find(key);
if (businessEntity == null)
{
return(NotFound());
}
patch.Put(businessEntity);
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BusinessEntityExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(businessEntity));
}
// PUT: odata/Currencies(5)
public IHttpActionResult Put([FromODataUri] int key, Delta <DimCurrency> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DimCurrency dimCurrency = db.DimCurrencies.Find(key);
if (dimCurrency == null)
{
return(NotFound());
}
patch.Put(dimCurrency);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DimCurrencyExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(dimCurrency));
}
public void Test1()
{
var count = _context.Product.Count();
var product1 = TestHelpers.CreateProduct("1");
_context.Product.Add(product1);
var product2 = new Product()
{
ProductId = 3
};
_context.Product.Add(product2);
try
{
_context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
Assert.Equal(count, _context.Product.Count());
}