public virtual void Delete(TEntity entityToDelete)
{
if (Context.Entry(entityToDelete).State == EntityState.Detached)
{
DbSet.Attach(entityToDelete);
}
DbSet.Remove(entityToDelete);
}
private void UpdateBook(int id, string payment, string transactionId)
{
using (AppDb db = new AppDb())
{
var book = new Book()
{
Id = id, payment = payment, TransactionId = transactionId
};
db.Books.Attach(book);
db.Entry(book).Property(x => x.payment).IsModified = true;
db.Entry(book).Property(x => x.TransactionId).IsModified = true;
db.SaveChanges();
}
}
public async Task <IActionResult> PutDetail(int id, Detail detail)
{
if (id != detail.Id)
{
return(BadRequest());
}
_context.Entry(detail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IHttpActionResult> PutSurvey(int id, Survey survey)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != survey.Id)
{
return(BadRequest());
}
AppDb.Entry(survey).State = EntityState.Modified;
try
{
await AppDb.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SurveyExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> PutSuspect(int id, Suspect suspect)
{
if (id != suspect.Id)
{
return(BadRequest());
}
_context.Entry(suspect).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SuspectExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IHttpActionResult PutEmployee(int id, Employee employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employee.EmployeeID)
{
return(BadRequest());
}
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutCloseCoachingProgram(int id)
{
var currentUser = AppUserManager.FindById(User.Identity.GetUserId());
var coachingProgram = GetCoachingPrograms(currentUser)
.FirstOrDefault(i => i.Id == id);
if (coachingProgram == null || coachingProgram.IsClosed)
{
return(BadRequest("Program Not Found"));
}
coachingProgram.IsClosed = true;
AppDb.Entry(coachingProgram).Property(i => i.IsClosed).IsModified = true;
coachingProgram.UpdatedAt = DateTime.Now;
AppDb.Entry(coachingProgram).Property(i => i.UpdatedAt).IsModified = true;
try
{
AppDb.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CoachingProgramExists(id, currentUser))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutDepartment(int id, Department department)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != department.DepartID)
{
return(BadRequest());
}
db.Entry(department).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DepartmentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutProgramMedia(int id, ProgramMedia item)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != item.Id)
{
return(BadRequest());
}
var currentUser = AppUserManager.FindById(User.Identity.GetUserId());
var programMedia = GetProgramMediaList(currentUser)
.FirstOrDefault(i => i.Id == item.Id);
if (id != item.Id)
{
return(NotFound());
}
if (programMedia.MediaType == MediaType.Resource && !(AppUserManager.IsInRole(currentUser.Id, "Coach") || AppUserManager.IsInRole(currentUser.Id, "Admin")))
{
return(BadRequest("Only Coaches can upload Resources"));
}
var isLink = !String.IsNullOrEmpty(programMedia.Link);
if (isLink && String.IsNullOrEmpty(item.Link))
{
return(BadRequest("Links cannot be empty"));
}
if (!isLink && !String.IsNullOrEmpty(item.Link))
{
return(BadRequest("Non Links do not have a Link Property"));
}
AppDb.Entry(programMedia).State = EntityState.Modified;
programMedia.Name = item.Name;
programMedia.BodyText = item.BodyText;
programMedia.Link = item.Link;
programMedia.UpdatedAt = DateTime.Now;
try
{
AppDb.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProgramMediaExists(id, currentUser))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Edit([Bind(Include = "ShipperId,CompanyName,Phone")] Shipper shipper)
{
if (ModelState.IsValid)
{
db.Entry(shipper).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(shipper));
}
public ActionResult Edit([Bind(Include = "Id,DriverSerial,Name,Mobile,Address")] Driver driver)
{
if (ModelState.IsValid)
{
db.Entry(driver).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(driver));
}
public ActionResult Edit([Bind(Include = "CustomerId,CompanyName,ContactName,ContactTitle,Address,City,PostalCode,Country,Phone")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "ID,ParentID,Name,IsActive,CreateDate,CreateUserID,UpdateDate,UpdateUserID")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit([Bind(Include = "Id,Title,Fare,Distance")] Route route)
{
if (ModelState.IsValid)
{
db.Entry(route).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(route));
}
public ActionResult Edit([Bind(Include = "ID,Name,LastName,Email,Telephone,Password,TCKN,IsActive,IsAdmin,CreateDate,CreateUserID,UpdateDate,UpdateUserID")] User user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Edit([Bind(Include = "EmployeeId,FirstName,LastName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,PostalCode,Country,HomePhone,Extension,Note,ReportsTo")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Edit([Bind(Include = "SupplierId,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phon,Fax,HomePage")] Supplier supplier)
{
if (ModelState.IsValid)
{
db.Entry(supplier).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(supplier));
}
public ActionResult Edit([Bind(Include = "CategoryId,CategoryName,Description")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit([Bind(Include = "DepartID,DepartName")] Department department)
{
if (ModelState.IsValid)
{
db.Entry(department).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(department));
}
public ActionResult Edit([Bind(Include = "Id,SerialNo,Brand,Model")] Bus bus)
{
if (ModelState.IsValid)
{
db.Entry(bus).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bus));
}
public ActionResult Edit([Bind(Include = "CartId,ProductId,UnitPrice,Quantity,Discount")] Cart cart)
{
if (ModelState.IsValid)
{
db.Entry(cart).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "ProductName", cart.ProductId);
return(View(cart));
}
public ActionResult Edit([Bind(Include = "EmployeeID,FirstName,LastName,Email,DepartRefID")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartRefID = new SelectList(db.Departments, "DepartID", "DepartName", employee.DepartRefID);
return(View(employee));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName")] User user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Edit([Bind(Include = "ID,Name,CategoryID,Brand,Model,ImageUrl,Description,Price,Tax,Discount,Stock,IsActive,CreateDate,CreateUserID,UpdateDate,UpdateUserID")] Product product)
{
if (ModelState.IsValid)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryID = new SelectList(db.Categories, "ID", "Name", product.CategoryID);
return(View(product));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name")] RecipeTag recipeTag)
{
if (ModelState.IsValid)
{
db.Entry(recipeTag).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(recipeTag));
}
public int SaveChanges()
{
foreach (var p in db.Products.Local)
{
if (db.Entry(p).State == EntityState.Modified)
{
p.UpdatedDate = DateTime.Now;
p.UpdatedBy = "";
}
}
return(db.SaveChanges());
}
public async Task <IActionResult> Index()
{
//var items = db.Products.Include(x => x.Pictures).ToList();
var items = db.Products.ToList();
foreach (var item in items)
{
await db.Entry(item).Collection(x => x.Pictures).LoadAsync();
}
return(View(items));
}
public ActionResult Edit([Bind(Include = "ProductId,ProductName,SupplierId,CategoryId,QuantityPerUnit,UnitPrice,InStock,OnOrder,ReOrderLevel,discontinued")] Product product)
{
if (ModelState.IsValid)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "CategoryName", product.CategoryId);
ViewBag.SupplierId = new SelectList(db.Suppliers, "SupplierID", "CompanyName", product.SupplierId);
return(View(product));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,ParentId")] RecipeCategory recipeCategory)
{
if (ModelState.IsValid)
{
db.Entry(recipeCategory).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.ParentId = new SelectList(db.RecipeCategories, "Id", "Name", recipeCategory.ParentId);
return(View(recipeCategory));
}
public async Task <IActionResult> GetAsync(int id)
{
var model = await _db.Authors.FindAsync(id);
await _db.Entry(model).Collection(m => m.Posts).Query().OrderByDescending(m => m.Id).ToListAsync();
if (model != null)
{
return(new OkObjectResult(model));
}
return(NotFound());
}
