public StudiosModel Create(Studios studios)
{
return(new StudiosModel()
{
Id = studios.Id, StudioName = studios.StudioName
});
}
public string GetExecutable(string slnPath)
{
var lines = File.ReadAllLines(slnPath);
var formatVersionLine = lines.FirstOrDefault(p => p.StartsWith(VS_VERSION_INFOTEXT));
if (formatVersionLine == null)
{
throw new InvalidOperationException("Formatversion nicht gefunden.");
}
var versionLine = lines.FirstOrDefault(p => p.StartsWith(VS_VERSION));
if (versionLine == null)
{
throw new InvalidOperationException("Studioversion nicht gefunden.");
}
var formatVersion = formatVersionLine.Substring(VS_VERSION_INFOTEXT.Length);
var version = Regex.Match(versionLine, VS_VERSION + @"(Version ){0,1}(?<version>.*)").Groups["version"].Value;
var runner = Runners.FirstOrDefault(p => StringComparer.CurrentCultureIgnoreCase.Equals(p.FormatVersion, formatVersion) && StringComparer.CurrentCultureIgnoreCase.Equals(p.VisualStudioString, version));
if (runner == null)
{
throw new InvalidOperationException($"Version nicht konfiguriert: {formatVersion} / VS {version}.");
}
if (Studios.All(p => p.Ident != runner.Studio))
{
throw new InvalidOperationException($"Studio nicht konfiguriert: {runner.Studio}.");
}
return(Studios.First(p => p.Ident == runner.Studio).ExePath);
}
public async Task <IActionResult> UpdateStudioById(long id, Studios studio)
{
if (id != studio.Id)
{
return(BadRequest());
}
_context.Entry(studio).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Studios(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Studios> > PostStudios(Studios studio)
{
_context.Studio.Add(studio);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(GetAllStudios), new { id = studio.Id }, studio));
}
public void InitializeComponent()
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_Game"].ConnectionString))
{
if (Studios != null)
{
Studios.Clear();
}
Studios = new ObservableCollection <Studio>(db.Query <Studio>("SELECT * FROM [Studio]").ToList());
if (Styles != null)
{
Styles.Clear();
}
Styles = new ObservableCollection <Model.Base.Style>(db.Query <Model.Base.Style>("SELECT * FROM [Style]").ToList());
if (Mod_s != null)
{
Mod_s.Clear();
}
Mod_s = new ObservableCollection <Mod_Game>(db.Query <Mod_Game>("SELECT * FROM [Mod_Game]").ToList());
if (Games != null)
{
Games.Clear();
}
Games = new ObservableCollection <Game>(db.Query <Game>("SELECT * FROM [Game]").ToList());
Games.ToList().ForEach(i => i.Studio = Studios.ToList().Find(j => j.Id == i.Game_Studio_id));
Games.ToList().ForEach(i => i.Style = Styles.ToList().Find(j => j.Id == i.Game_Style_id));
Games.ToList().ForEach(i => i.Mod_Game = Mod_s.ToList().Find(j => j.Id == i.Game_Mod_id));
OnPropertyChanged("Games");
}
}
public ShikimoriClient(ILogger logger, ClientSettings settings)
{
Client = new ApiClient(logger, settings);
Achievements = new Achievements(Client);
Animes = new Animes(Client);
Bans = new Bans(Client);
Calendars = new Calendars(Client);
Characters = new Characters(Client);
Clubs = new Clubs(Client);
Comments = new Comments(Client);
Constants = new Constants(Client);
Dialogs = new Dialogs(Client);
Favorites = new Favorites(Client);
Forums = new Forums(Client);
Friends = new Friends(Client);
Genres = new Genres(Client);
Mangas = new Mangas(Client);
Messages = new Messages(Client);
People = new People(Client);
Publishers = new Publishers(Client);
Ranobe = new Ranobe(Client);
Stats = new Stats(Client);
Studios = new Studios(Client);
Styles = new Styles(Client);
TopicIgnores = new TopicIgnores(Client);
Topics = new Topics(Client);
UserImages = new UserImages(Client);
UserRates = new UserRates(Client);
Users = new Users(Client);
Videos = new Videos(Client);
}
public IEnumerable <RehearsalStudio> GetStudiosByOwner(int?ownerId)
{
if (ownerId == null)
{
return(Studios);
}
return(Studios.Where(l => l.UserId == ownerId));
}
public RehearsalStudio GetStudio(int?studioId)
{
if (studioId == null)
{
return(null);
}
return(Studios.FirstOrDefault(l => l.Id == studioId));
}
public ActionResult Edit(int?id)
{
Studios info = new Studios();
using (MyContext db = new MyContext())
{
info = db.Studios.Where(x => x.RoomID == id).FirstOrDefault();
}
return(View(info));
}
internal void ADD()
{
new Window_Add_New().ShowDialog();
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_Game"].ConnectionString))
{
Games = new ObservableCollection <Game>(db.Query <Game>("SELECT * FROM [Game]").ToList());
Games.ToList().ForEach(i => i.Studio = Studios.ToList().Find(j => j.Id == i.Game_Studio_id));
Games.ToList().ForEach(i => i.Style = Styles.ToList().Find(j => j.Id == i.Game_Style_id));
Games.ToList().ForEach(i => i.Mod_Game = Mod_s.ToList().Find(j => j.Id == i.Game_Mod_id));
OnPropertyChanged("Games");
}
}
public bool Add(Studios studios)
{
try
{
this.movieContext.Studios.Add(studios);
}
catch (Exception)
{
return(false);
}
return(true);
}
internal void Save() // сохранение изминений
{
if (MessageBox.Show("Сохранить изминения?", "Подтверждение", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
else
{
if (Games.ToList().Exists(i => i.Id == Curent_game.Id))
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_Game"].ConnectionString))
{
db.Open();
using (var transaction = db.BeginTransaction())
{
try
{
db.Execute("UPDATE [Game] SET Game_Name = @Game_Name," + "Game_Studio_id = @Game_Studio_id," +
"Game_Style_id = @Game_Style_id," + "Game_Year_Releas = @Game_Year_Releas," +
"Game_Mod_id = @Game_Mod_id," + "Game_Count_Sell = @Game_Count_Sell " +
"WHERE Id = @Id",
new
{
Id = Curent_game.Id,
Game_Name = Curent_game.Game_Name,
Game_Studio_id = Curent_game.Studio.Id,
Game_Style_id = Curent_game.Style.Id,
Game_Year_Releas = Curent_game.Game_Year_Releas,
Game_Mod_id = Curent_game.Mod_Game.Id,
Game_Count_Sell = Curent_game.Game_Count_Sell
}, transaction);
transaction.Commit();
}
catch (System.Exception ex)
{
transaction.Rollback();
throw ex;
}
}
Games = new ObservableCollection <Game>(db.Query <Game>("SELECT * FROM [Game]").ToList());
Games.ToList().ForEach(i => i.Studio = Studios.ToList().Find(j => j.Id == i.Game_Studio_id));
Games.ToList().ForEach(i => i.Style = Styles.ToList().Find(j => j.Id == i.Game_Style_id));
Games.ToList().ForEach(i => i.Mod_Game = Mod_s.ToList().Find(j => j.Id == i.Game_Mod_id));
OnPropertyChanged("Games");
}
}
else
{
MessageBox.Show("Что-то пошло нет так", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
// GET: /Studios/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Studios studios = await unitOfWork.StudiosRepository.GetByIDAsync(id);
if (studios == null)
{
return(HttpNotFound());
}
return(View(studios));
}
public ActionResult AddStudio(Studios info)
{
string result = "Fail";
using (MyContext db = new MyContext())
{
db.Studios.Add(info);
int r = db.SaveChanges();
if (r > 0)
{
result = "Success";
}
}
return(Content(result));
}
public ActionResult DelStudio(Studios info)
{
string result = "Fail";
using (MyContext db = new MyContext())
{
Studios uinfo = db.Studios.Where(x => x.RoomID == info.RoomID).FirstOrDefault();
db.Studios.Remove(uinfo);
int r = db.SaveChanges();
if (r > 0)
{
result = "Success";
}
}
return(Content(result));
}
/// <summary>
/// Adds a studio to the item
/// </summary>
/// <param name="name">The name.</param>
/// <exception cref="System.ArgumentNullException"></exception>
public void AddStudio(string name)
{
if (string.IsNullOrWhiteSpace(name))
{
throw new ArgumentNullException();
}
if (Studios == null)
{
Studios = new List <string>();
}
if (!Studios.Contains(name, StringComparer.OrdinalIgnoreCase))
{
Studios.Add(name);
}
}
public ActionResult EditStudios(Studios info)
{
string result = "Fail";
using (MyContext db = new MyContext())
{
Studios usinfo = db.Studios.Where(x => x.RoomID == info.RoomID).FirstOrDefault();
usinfo.RoomName = info.RoomName;
usinfo.Remake = info.Remake;
usinfo.State = info.State;
int r = db.SaveChanges();
if (r > 0)
{
result = "Success";
}
}
return(Content(result));
}
internal void Dell()
{
if (MessageBox.Show("Удалить игру?", "Подтверждение", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
else
{
if (Games.ToList().Exists(i => i.Id == Curent_game.Id))
{
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_Game"].ConnectionString))
{
db.Open();
using (var transaction = db.BeginTransaction())
{
try
{
db.Execute(" DELETE FROM [Game] WHERE Id = @Id",
new { Id = Curent_game.Id }, transaction);
transaction.Commit();
}
catch (System.Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
else
{
MessageBox.Show("Что-то пошло нет так", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_Game"].ConnectionString))
{
Games = new ObservableCollection <Game>(db.Query <Game>("SELECT * FROM [Game]").ToList());
Games.ToList().ForEach(i => i.Studio = Studios.ToList().Find(j => j.Id == i.Game_Studio_id));
Games.ToList().ForEach(i => i.Style = Styles.ToList().Find(j => j.Id == i.Game_Style_id));
Games.ToList().ForEach(i => i.Mod_Game = Mod_s.ToList().Find(j => j.Id == i.Game_Mod_id));
OnPropertyChanged("Games");
}
}
// GET: /Studios/Delete/5
public async Task <ActionResult> Delete(int?id, bool?saveChangesError = false)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (saveChangesError.GetValueOrDefault())
{
ViewBag.ErrorMessage = "Falha ao apagar Gênero. Tente novamente, e se o problema persistir contate o administrador do sistema.";
}
Studios studios = await unitOfWork.StudiosRepository.GetByIDAsync(id);
if (studios == null)
{
return(HttpNotFound());
}
return(View(studios));
}
public async Task <ActionResult> Create([Bind(Include = "Nome,Cidade")] Studios studios)
{
try
{
if (ModelState.IsValid)
{
unitOfWork.StudiosRepository.Insert(studios);
await unitOfWork.SaveAsync();
return(RedirectToAction("Index"));
}
}
catch (DataException /* dex */)
{
//Log the error (uncomment dex variable name and add a line here to write a log.
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(View(studios));
}
public Studios ParsePatch(StudiosModel model, int id)
{
try
{
Studios studio = this.movieRepository.GetSingleStudio(id);
if (model.StudioName != null)
{
studio.StudioName = model.StudioName;
}
studio.DateModified = DateTime.Now;
return(studio);
}
catch
{
return(null);
}
}
public Studios Parse(StudiosModel model)
{
try
{
var studio = new Studios();
if (model.StudioName == null)
{
return(null);
}
studio.StudioName = model.StudioName;
studio.DateAdded = DateTime.Now;
studio.DateModified = DateTime.Now;
return(studio);
}
catch
{
return(null);
}
}
public void Post([FromQuery] Studios value)
{
contextStudios.Update(value);
}
public GameAttributes SelectAllAttributes()
{
GameAttributes attributes = new GameAttributes();
string sqlConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection conn = new SqlConnection(sqlConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("dbo.Attributes_SelectAll", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Platforms plats = new Platforms();
int index = 0;
plats.Id = reader.GetInt32(index++);
plats.Platform = reader.GetString(index++);
attributes.Platforms.Add(plats);
}
reader.NextResult();
while (reader.Read())
{
Genres genres = new Genres();
int index = 0;
genres.Id = reader.GetInt32(index++);
genres.Genre = reader.GetString(index++);
attributes.Genres.Add(genres);
}
reader.NextResult();
while (reader.Read())
{
Studios studios = new Studios();
int index = 0;
studios.Id = reader.GetInt32(index++);
studios.Studio = reader.GetString(index++);
attributes.Studios.Add(studios);
}
reader.NextResult();
while (reader.Read())
{
Directors dirs = new Directors();
int index = 0;
dirs.Id = reader.GetInt32(index++);
dirs.Director = reader.GetString(index++);
attributes.Directors.Add(dirs);
}
}
conn.Close();
}
return(attributes);
}
public Studios Add(Studios studio)
{
_context.Studioses.Add(studio);
_context.SaveChanges();
return(studio);
}
public void Put(string name, [FromBody] Studios value)
{
contextStudios.Add(value);
}
