public ActionResult Create([Bind(Include = "ID,Chargenumber,Hours,Date")] Timecard timecard)
{
ViewBag.WeekStart = weekstart.ToString("yyyy-MM-dd");
ViewBag.WeekEnd = weekend.ToString("yyyy-MM-dd");
var ChargeNumList = new List <string>();
var ChargeNumQry = from d in db.ChargeNumbers
orderby d.ID
select d.chargenumber;
ChargeNumList.AddRange(ChargeNumQry.Distinct());
ViewBag.ChargeNumList = new SelectList(ChargeNumList);
List <string> datelist = new List <string>();
for (int i = 0; i < 7; i++)
{
datelist.Add(weekstart.AddDays(i).ToString("yyyy-MM-dd"));
}
ViewBag.DateList = new SelectList(datelist);
timecard.EmployeeName = User.Identity.Name;
timecard.StartDate = weekstart;
timecard.EndDate = weekend;
timecard.SubmitDate = DateTime.Now;
if (ModelState.IsValid)
{
db.Timecards.Add(timecard);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(timecard));
}
public ActionResult Create([Bind(Include = "ID,Title,ReleaseDate,Genre,Price")] Movie movie)
{
if (ModelState.IsValid)
{
string key = movie.Title.Replace(" ", "");
if (!ms.mClient.KeyExists(key))
{
string value = movie.ReleaseDate + movie.Genre + movie.Price;
bool ret = ms.mClient.Set(key, value);
//string value2 = ms.mClient.Get(key) as string;
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.errmsg = movie.Title + " 同名电影已经存在，请改名";
}
// db.Movies.Add(movie);
// db.SaveChanges();
// return RedirectToAction("Index");
}
return(View(movie));
}
public IHttpActionResult PutStudio(int id, Studio studio)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != studio.Id)
{
return(BadRequest());
}
db.Entry(studio).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!StudioExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IActionResult CreateRating(RatingModel ratingmodel)
{
_dbContext.RatingModels.Add(ratingmodel);
_dbContext.SaveChanges();
ViewData["MovieID"] = new SelectList(_dbContext.MovieModels, "MovieID", "MovieName");
return(View());
}
private void objectListView1_ButtonClick(object sender, BrightIdeasSoftware.CellClickEventArgs e)
{
if (e.Column == actionsCol)
{
var selectedUser = (User)e.Item.RowObject;
switch (selectedUser.StatusActionText)
{
case "Delete":
_db.Users.Remove(selectedUser);
_db.SaveChanges();
Users = _db.Users.ToList();
break;
case "Approve":
var dbUser = _db.Users.Find(selectedUser.Id);
dbUser.UserStatus = UserStatus.FirstLogin;
_db.SaveChanges();
Users = _db.Users.ToList();
break;
default:
break;
}
}
}
public ActionResult Create([Bind(Include = "ID,Title,ReleaseDate,Genre,Price,Rating,LogoFileName")] Movie movie, HttpPostedFileBase upload)
{
var toDb = false;
if (ModelState.IsValid)
{
if (upload != null && upload.ContentLength > 0)
{
if (toDb)
{
// Store image into database
var avatarFileContent = FileUpload.StoreIntoDatabase(upload);
movie.Files = new List <File> {
avatarFileContent
};
}
else
{
// Store image on disk
var avatarFilePath = FileUpload.StoreOnServer(upload);
movie.FilePaths = new List <FilePath> {
avatarFilePath
};
}
}
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
public ActionResult AddToMyMovies(int id, string returnUrl)
{
Movie movie = db.Movies.Find(id);
var userid = User.Identity.GetUserId();
var m = movie.AddedToMyMovies + userid;
movie.AddedToMyMovies = m;
;
var myMovie = new MyMovie
{
Genres = movie.Genres,
IdImdb = movie.IdImdb,
ImdbRating = movie.ImdbRating,
ReleaseYear = movie.ReleaseYear,
Title = movie.Title,
Votes = movie.Votes,
Note = "",
Watched = "no",
UserID = User.Identity.GetUserId(),
MyRating = ""
};
db.MyMovies.Add(myMovie);
db.SaveChanges();
return(Redirect(returnUrl));
}
public IActionResult AddToFavorites(int id, string routedQuery)
{
var claimsIdentity = (ClaimsIdentity)this.User.Identity;
var claim = claimsIdentity.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier);
var userId = claim.Value;
var favorites = _movieContext.Favorites.Where(x => x.UserId == userId).ToList();
Favorites favorite = new Favorites()
{
UserId = userId,
MovieId = id
};
if (ModelState.IsValid)
{
_movieContext.Favorites.Add(favorite);
_movieContext.SaveChanges();
return(RedirectToAction("Result", new { query = routedQuery }));
}
else
{
TempData["Error"] = "Could not add to favorites list.";
return(RedirectToAction("Result"));
}
}
public ActionResult SendMovies(IQueryable <Movie> movies, TMDbLib.Objects.Movies.Movie movie, TMDbClient client)
{
int id;
CultureInfo[] cultures = CultureInfo.GetCultures(CultureTypes.AllCultures);
for (id = 0; id <= 30; id++)
{
try
{
movie = client.GetMovieAsync(id).Result;
}
catch (NullReferenceException ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
if (movie != null)
{
if (movie.Adult == false)
{
Movie objMovie = movies.FirstOrDefault(x => x.RemoteId.Equals(movie.Id));
if (objMovie != null) //achei no banco local
{
objMovie.Original_title = movie.OriginalTitle;
objMovie.Release_date = movie.ReleaseDate;
objMovie.Original_Language = new CultureInfo(movie.OriginalLanguage).DisplayName;
objMovie.Description = movie.Overview;
objMovie.Budget = movie.Budget;
objMovie.Vote_average = movie.VoteAverage;
}
else //não achei esse movie no banco local
{
objMovie = new Movie
{
RemoteId = movie.Id,
Original_title = movie.OriginalTitle,
Release_date = movie.ReleaseDate,
Description = movie.Overview,
Original_Language = new CultureInfo(movie.OriginalLanguage).DisplayName,
Budget = movie.Budget,
Vote_average = movie.VoteAverage
};
//depois de atribuir tudo
db.Movies.Add(objMovie);
db.SaveChanges();
}
}
}
}
return(View(movies));
}
public ActionResult Create(Movie m)
{
if (ModelState.IsValid)
{
db.Movies.Add(m);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(m));
}
public IActionResult Entry(Movie movie = null, string type = "", int movieId = -1)
{
//this only takes us the success screen if the information is entered correctly. this protects from people using something like postman to enter in values we don't want
if (type == "remove")
{
movie = _context.Movies.FirstOrDefault(m => m.MovieID == movieId);
if (movie != null)
{
_context.Remove(movie);
_context.SaveChanges();
return(View("Confirmation", movie));
}
else
{
return(View("Error"));
}
}
else if (!ModelState.IsValid)
{
return(View());
}
else
{
Movie searchedMovie = _context.Movies.FirstOrDefault(m => m.MovieID == movieId);
if (searchedMovie != null)
{
//the movie already exists so it's an edit
//_context.Remove(searchedMovie);
//_context.SaveChanges();
//_context.Movies.Add(movie);
_context.Movies.FirstOrDefault(m => m.MovieID == movieId).Rating = movie.Rating;
_context.Movies.FirstOrDefault(m => m.MovieID == movieId).Director = movie.Director;
_context.Movies.FirstOrDefault(m => m.MovieID == movieId).Edited = movie.Edited;
_context.Movies.FirstOrDefault(m => m.MovieID == movieId).Year = movie.Year;
_context.Movies.FirstOrDefault(m => m.MovieID == movieId).Title = movie.Title;
_context.Movies.FirstOrDefault(m => m.MovieID == movieId).LentTo = movie.LentTo;
_context.Movies.FirstOrDefault(m => m.MovieID == movieId).Notes = movie.Notes;
_context.Movies.FirstOrDefault(m => m.MovieID == movieId).Category = movie.Category;
_context.SaveChanges();
return(View("Confirmation", movie));
}
else
{
//commenting out old way
//Storage.AddMovie(movie);
//the movie is a n
_context.Movies.Add(movie);
_context.SaveChanges();
return(View("Confirmation", movie));
}
}
}
public ActionResult Create([Bind(Include = "ID,CustomerName,Email,Residence,SalesPerson,ItemBought,MonthBought,Price,Qty,Sales")] excel excel)
{
if (ModelState.IsValid)
{
db.excel.Add(excel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(excel));
}
public ActionResult Create([Bind(Include = "ID,Email,Name,Position,MailAddress,SSN,Deduction,Phone,HourRate,Salary,CommisonRate,HourLimit,PaymentMethod,Vacation")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Details", new { id = employee.ID }));
}
return(View(employee));
}
public ActionResult Create([Bind(Include = "ID_SPOTKANIA,ID_DRUZYNY,ID_MIASTA,DRU_ID_DRUZYNY,BRAMKI_D1,BRAMKI_D2,DATA_SPOTKANIA")] Spotkania spotkania)
{
if (ModelState.IsValid)
{
db.SPOTKANIA.Add(spotkania);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(spotkania));
}
public ActionResult Create([Bind(Include = "ID_DRUZYNY,ID_MIASTA,NAZWA_DRUZYNY,PUNKTY,BRAMKI,ILOSC_SPOTKAN")] Druzyny druzyny)
{
if (ModelState.IsValid)
{
db.DRUZYNY.Add(druzyny);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(druzyny));
}
public ActionResult Create([Bind(Include = "ID,RatingName,LastModified,LastModifiedBy")] Rating rating)
{
if (ModelState.IsValid)
{
db.Ratings.Add(rating);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rating));
}
public ActionResult Create([Bind(Include = "ClientId,FirstName,LastName,Address,City,State,Zip,Phone,DoB,Email")] Client client)
{
if (ModelState.IsValid)
{
db.Clients.Add(client);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(client));
}
public ActionResult Create([Bind(Include = "Id,Title,ReleaseDate,Price,Rating,TmdbId,VoteCount,VoteAverage,Overview,PosterPath")] Movie movie)
{
if (ModelState.IsValid)
{
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
public ActionResult Create([Bind(Include = "ID,OwnerID,Title,Genre,Year,Length,Format,OnLoan,LoanedToID,LoanedDate")] Movie movie)
{
if (ModelState.IsValid)
{
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index", "Collection"));
}
return(View(movie));
}
public ActionResult Create([Bind(Include = "id,name,img,pubdate,desc")] Movie movie)
{
if (ModelState.IsValid)
{
db.movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
public ActionResult Create([Bind(Include = "ID,Title,Stocks,Description,ReleaseDate")] Movie movie)
{
if (ModelState.IsValid)
{
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
public ActionResult Create([Bind(Include = "ID,Title,ReleaseDate,Genre,Rating,Description,Picture,Video")] Movie movie)
{
if (ModelState.IsValid)
{
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MoviesGenre = MoviesGenre.get();
return(View(movie));
}
public ActionResult Create([Bind(Include = "ID,CreatedBy,EquipmentName,ReleaseDate,TypeofAssets,Barcode,Location,RoomName")] excel excel)
{
if (ModelState.IsValid)
{
db.excel.Add(excel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(excel));
}
public ActionResult Create([Bind(Include = "ID,Name,ReleaseDate,Location,Barcode,Type,CreatedBy,roomName")] Asset asset)
{
if (ModelState.IsValid)
{
db.Assets.Add(asset);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(asset));
}
public ActionResult Create([Bind(Include = "ID,EmployeeName,Salary,PayDate")] PayRoll payRoll)
{
if (ModelState.IsValid)
{
db.PayRolls.Add(payRoll);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(payRoll));
}
public ActionResult Create([Bind(Include = "ID_PILKARZA,ID_DRUZYNY,IMIE_PILKARZA,NAZWISKO_PILKARZA,WIEK_PILKARZA,POZYCJA,NARODOWOSC_PILKARZA")] Pilkarze pilkarze)
{
if (ModelState.IsValid)
{
db.PILKARZE.Add(pilkarze);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pilkarze));
}
public ActionResult Create([Bind(Include = "ID,Title,ReleaseDate,Genre,Price,Rating")] Movie movie)
{
if (ModelState.IsValid)
{
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movie));
}
public ActionResult Create(Car car)
{
if (ModelState.IsValid)
{
db.Cars.Add(car);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(car));
}
public ActionResult Create([Bind(Include = "ID_SEDZI,IMIE_SEDZI,NAZWISKO_SEDZI")] Sedziowie sedziowie)
{
if (ModelState.IsValid)
{
db.SEDZIOWIE.Add(sedziowie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sedziowie));
}
public ActionResult Create([Bind(Include = "ID_SPOTKANIA,ID_DRUZYNY,ID_PILKARZA,MINUTA_WYNIKU")] Wynik wynik)
{
if (ModelState.IsValid)
{
db.WYNIK.Add(wynik);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(wynik));
}
public void AlterTableTest()
{
ReInitDb();
MovieDBContext db = new MovieDBContext();
db.Database.Initialize(true);
var l = db.MovieFormats.ToList();
foreach (var i in l)
{
}
MovieFormat m = new MovieFormat();
m.Format = 8.0f;
db.MovieFormats.Add(m);
db.SaveChanges();
}
public void AddingEmptyRow()
{
using (MovieDBContext ctx = new MovieDBContext())
{
ctx.Database.Initialize(true);
ctx.EntitySingleColumns.Add(new EntitySingleColumn());
ctx.SaveChanges();
}
using (MovieDBContext ctx2 = new MovieDBContext())
{
var q = from esc in ctx2.EntitySingleColumns where esc.Id == 1 select esc;
Assert.AreEqual(1, q.Count());
}
}
public void ConcurrencyCheck()
{
using (MovieDBContext db = new MovieDBContext())
{
db.Database.ExecuteSqlCommand(
@"DROP TABLE IF EXISTS `test3`.`MovieReleases`");
db.Database.ExecuteSqlCommand(
@"CREATE TABLE `MovieReleases` (
`Id` int(11) NOT NULL,
`Name` varbinary(45) NOT NULL,
`Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary");
MySqlTrace.Listeners.Clear();
MySqlTrace.Switch.Level = SourceLevels.All;
GenericListener listener = new GenericListener();
MySqlTrace.Listeners.Add(listener);
try
{
MovieRelease mr = db.MovieReleases.Create();
mr.Id = 1;
mr.Name = "Commercial";
db.MovieReleases.Add(mr);
db.SaveChanges();
mr.Name = "Director's Cut";
db.SaveChanges();
}
finally
{
db.Database.ExecuteSqlCommand(@"DROP TABLE IF EXISTS `MovieReleases`");
}
// Check sql
Regex rx = new Regex(@"Query Opened: (?<item>UPDATE .*)", RegexOptions.Compiled | RegexOptions.Singleline);
foreach (string s in listener.Strings)
{
Match m = rx.Match(s);
if (m.Success)
{
CheckSql(m.Groups["item"].Value, SQLSyntax.UpdateWithSelect);
Assert.Pass();
}
}
Assert.Fail();
}
}
