public IHttpActionResult PutSportsman(int id, Sportsman sportsman)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != sportsman.ID)
{
return(BadRequest());
}
db.Entry(sportsman).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SportsmanExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create(FormCollection collection)
{
try {
var Sportman = new Sportsman {
name = collection["name"],
lastname = collection["lastname"],
salary = int.Parse(collection["salary"]),
position = collection["position"],
futbolTeam = collection["futbolTeam"],
};
watch.Start();
if (Sportman.saveSportman(Storage.Instance.selectionList))
{
watch.Stop();
addOperation("New player", "A new player was added", watch.Elapsed.TotalMilliseconds.ToString());
return(RedirectToAction("Index"));
}
else
{
return(View(Sportman));
}
}
catch (Exception) {
return(View());
}
}
private void AddSportsmanCommandExecute(object obj)
{
var sportsman = new Sportsman(
NewSportsmanName,
NewSportsmanSurname,
NewSportsmanBirthday,
NewSportsmanCountry,
NewSportsmanSport);
if (!db.Sportsmen.ToList().Contains(sportsman))
{
db.Sportsmen.Add(sportsman);
db.SaveChanges();
FillSportsmen();
NewSportsmanName = string.Empty;
NewSportsmanSurname = string.Empty;
NewSportsmanBirthday = new DateTime(2000, 1, 1);
NewSportsmanCountry = null;
NewSportsmanSport = null;
systemClass.ShowMessageBox("Info", "Olympiad has been added!");
}
else
{
systemClass.ShowMessageBox("Error", "Olympiad exist");
}
}
public ActionResult Edit(int id, FormCollection collection)
{
try{
var Sportman = new Sportsman {
name = collection["name"],
lastname = collection["lastname"],
salary = int.Parse(collection["salary"]),
position = collection["position"],
futbolTeam = collection["futbolTeam"],
};
if (Storage.Instance.selectionList)
{
var sportman = Storage.Instance.listSportman.Where(c => c.sportsmanId == id).FirstOrDefault();
watch.Start();
Storage.Instance.listSportman.Find(sportman).Value = Sportman;
watch.Stop();
addOperation("Edit an object", "Edit an object in the LinkedList", watch.Elapsed.TotalMilliseconds.ToString());
return(RedirectToAction("Index"));
}
else
{
var sporstman = returnObject(id);
Storage.Instance.doublylistSportman.popInList(sporstman);
if (Sportman.saveSportman(Storage.Instance.selectionList))
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
}catch {
return(RedirectToAction("Index"));
}
}
public static void Start()
{
Sportsman[] sp = new Sportsman[10];
sp[0] = new Sportsman("Vasilev", 4, 2, 3);
sp[1] = new Sportsman("Petrov", 5, 5, 5);
sp[2] = new Sportsman("Dmitr", 4, 4, 5);
sp[3] = new Sportsman("Mishin", 5, 5, 5);
sp[4] = new Sportsman("Sashin", 5, 4, 4);
sp[5] = new Sportsman("Mashina", 2, 2, 2);
sp[6] = new Sportsman("Zhenin", 3, 3, 3);
sp[7] = new Sportsman("Olina", 3, 4, 4);
sp[8] = new Sportsman("Nastina", 5, 5, 5);
sp[9] = new Sportsman("Vsevol", 2, 3, 4);
for (int i = 0; i < 10; i++)
{
for (int j = i; j < 10; j++)
{
if (sp[i].best < sp[j].best)
{
Sportsman t;
t = sp[i];
sp[i] = sp[j];
sp[j] = t;
}
}
}
for (int i = 0; i < 10; i++)
{
WriteLine($"Фамилия\t{sp[i].surname}\tРезультат {sp[i].best:f2}");
}
}
// GET: Sportsman/Delete/5
public ActionResult Delete(int id)
{
var sportman = new Sportsman();
try {
if (Storage.Instance.selectionList)
{
if (sportman.deleteSportman(id, Storage.Instance.selectionList))
{
return(View(Storage.Instance.listSportman.Where(c => c.sportsmanId == id).FirstOrDefault()));
}
else
{
return(View());
}
}
else
{
var sportsman = returnObject(id);
return(View(sportsman));
}
}catch {
return(View(sportman));
}
}
public ActionResult Delete(int id, FormCollection collection)
{
var sportsman = new Sportsman();
try {
if (Storage.Instance.selectionList)
{
if (sportsman == null)
{
return(View("NotFound"));
}
watch.Start();
Storage.Instance.listSportman.Remove(Storage.Instance.listSportman.Where(c => c.sportsmanId == id).FirstOrDefault());
watch.Stop();
addOperation("Delete an object", "Delete an object in the LinkedList", watch.Elapsed.TotalMilliseconds.ToString());
return(RedirectToAction("Index"));
}
else
{
sportsman = returnObject(id);
watch.Start();
Storage.Instance.doublylistSportman.popInList(sportsman);
watch.Stop();
addOperation("Delete an object", "Delete an object in the Doubly List", watch.Elapsed.TotalMilliseconds.ToString());
return(RedirectToAction("Index"));
}
}catch {
return(View(sportsman));
}
}
public ActionResult DeleteConfirmed(string id)
{
Sportsman sportsman = db.Sportsmen.Find(id);
db.Sportsmen.Remove(sportsman);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SportsmanID,SurName,Name,BirthDay")] Sportsman sportsman)
{
if (ModelState.IsValid)
{
db.Entry(sportsman).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sportsman));
}
static void Main(string[] args)
{
var swimmer = new Sportsman(new Swimmer());
var runner = new Sportsman(new Runner());
swimmer.Wear();
runner.Wear();
swimmer.Move();
runner.Move();
}
public bool AddSportsmanToDatabase(Sportsman sportsman)
{
if (!db.Sportsmen.ToList().Contains(sportsman))
{
db.Sportsmen.Add(sportsman); // why always add new Country and Sport
SaveChanges();
return(true);
}
return(false);
}
public ActionResult Edit([Bind(Include = "Id,FirstName,LastName,TeamNumber")] Sportsman sportsman)
{
if (ModelState.IsValid)
{
db.Entry(sportsman).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sportsman));
}
public IHttpActionResult GetSportsman(int id)
{
Sportsman sportsman = db.Sportsmans.Find(id);
if (sportsman == null)
{
return(NotFound());
}
return(Ok(sportsman));
}
//Method for return object by Id
public Sportsman returnObject(int id)
{
var sportsman = new Sportsman();
DoublyLinkedList <Sportsman> sportmansCopy = Storage.Instance.doublylistSportman;
while (id != sportsman.sportsmanId)
{
sportsman = sportmansCopy.getObject();
}
return(sportsman);
}
public ActionResult Create([Bind(Include = "SportsmanID,SurName,Name,BirthDay")] Sportsman sportsman)
{
if (ModelState.IsValid)
{
db.Sportsmans.Add(sportsman);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sportsman));
}
public ActionResult Create([Bind(Include = "guid,formNumber,firstName,lastName")] Sportsman sportsman)
{
if (ModelState.IsValid)
{
sportsman.guid = Guid.NewGuid();
db.Sportsmen.Add(sportsman);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sportsman));
}
public IHttpActionResult PostSportsman(Sportsman sportsman)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Sportsmans.Add(sportsman);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = sportsman.ID }, sportsman));
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
Sportsman sportsman = new Sportsman()
{
LastName = TextBoxLastName.Text,
FirstName = TextBoxFirstName.Text,
Patronymic = TextBoxPatronymic.Text,
CodeGroup = TextBoxCodeGroup.Text
};
DataService.AddSportsman(sportsman);
Response.Redirect(Request.Url.AbsoluteUri);
}
public static void DeleteSportsman(Sportsman sportsman)
{
Sportsman deleted = null;
foreach (Sportsman current in sportsmen)
{
if (current.LastName == sportsman.LastName && current.FirstName == sportsman.FirstName && current.Patronymic == sportsman.Patronymic && current.CodeGroup == sportsman.CodeGroup)
{
deleted = current;
}
}
sportsmen.Remove(deleted);
}
// GET: Sportsmen/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Sportsman sportsman = db.Sportsmans.Find(id);
if (sportsman == null)
{
return(HttpNotFound());
}
return(View(sportsman));
}
public IHttpActionResult DeleteSportsman(int id)
{
Sportsman sportsman = db.Sportsmans.Find(id);
if (sportsman == null)
{
return(NotFound());
}
db.Sportsmans.Remove(sportsman);
db.SaveChanges();
return(Ok(sportsman));
}
// GET: Sportsmen/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Sportsman sportsman = db.Sportsmen.Find(id);
if (sportsman == null)
{
return(HttpNotFound());
}
return(View(sportsman));
}
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,TeamNumber")] Sportsman sportsman)
{
if (ModelState.IsValid)
{
if (sportsman.Id == null)
{
sportsman.Id = Guid.NewGuid().ToString();
}
db.Sportsmen.Add(sportsman);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sportsman));
}
public string CreateHeartRateValue(string SportsmanId, string FirstName, string LastName, string TeamNumber, string value)
{
Sportsman sportsman = new Sportsman();
bool firstConnect = false;
if (SportsmanId == null)
{
// Это первое обращение, сначала создадим Спортмена и запишем в базу
sportsman.FirstName = FirstName;
sportsman.LastName = LastName;
sportsman.TeamNumber = TeamNumber;
SportsmenController sportsmenController = new SportsmenController();
sportsmenController.Create(sportsman);
firstConnect = true;
}
else
{
sportsman = db.Sportsmen.Find(SportsmanId);
}
HeartRate heartRate = new HeartRate();
heartRate.Id = Guid.NewGuid().ToString();
heartRate.SportsmanId = sportsman.Id;
heartRate.FirstName = sportsman.FirstName;
heartRate.LastName = sportsman.LastName;
heartRate.HeartRateValue = value;
TimeZoneInfo moscowTimeZone = TimeZoneInfo.FindSystemTimeZoneById("Russian Standard Time");
DateTime moscowDateTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, moscowTimeZone);
heartRate.DateTime = moscowDateTime;
db.HeartRates.Add(heartRate);
db.SaveChanges();
if (firstConnect)
{
return(sportsman.Id);
}
return("Success");
}
public async Task ReadInfoAsync()
{
string sqlExpression = "SELECT * FROM SportsmanInfo (@idSportsman)";
using (SqlConnection connection = Connections.TrenerConnection.GetConnection())
{
await connection.OpenAsync();
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlParameter idsportsman = new SqlParameter
{
ParameterName = "@idSportsman",
Value = WorkClass.sportsman.sportsmanid
};
command.Parameters.Add(idsportsman);
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
while (reader.Read())
{
Sportsman sportsman = new Sportsman()
{
name = reader.GetValue(0).ToString(),
sname = reader.GetValue(1).ToString(),
phone = Convert.ToInt32(reader.GetValue(2)),
sex = Convert.ToChar(reader.GetValue(3)),
age = Convert.ToInt32(reader.GetValue(4))
};
Name.Text = sportsman.name;
Sname.Text = sportsman.sname;
Phone.Text = sportsman.phone.ToString();
Gender.Text = sportsman.sex.ToString();
Age.Text = sportsman.age.ToString();
}
connection.Close();
}
}
}
// GET: Sportsman
public ViewResult Index(Sportsman model, string sortOrder, string searchString)
{
try{
var sportsmanDoubly = from r in Storage.Instance.doublylistSportman
select r;
var find = from s in Storage.Instance.listSportman
select s;
watch.Start();
if (!String.IsNullOrEmpty(searchString))
{
if (Storage.Instance.selectionList)
{
find = find.Where(s => s.name.Contains(searchString) ||
s.lastname.Contains(searchString) ||
s.salary.ToString().Contains(searchString) || s.position.Contains(searchString) || s.futbolTeam.Contains(searchString));
watch.Stop();
addOperation("Find object", "Find object in the LinkedList.", watch.Elapsed.TotalMilliseconds.ToString());
}
else
{
sportsmanDoubly = sportsmanDoubly.Where(r => r.name.Contains(searchString) ||
r.lastname.Contains(searchString) ||
r.salary.ToString().Contains(searchString) || r.position.Contains(searchString) || r.futbolTeam.Contains(searchString));
watch.Stop();
addOperation("Find object", "Find object in the LinkedList.", watch.Elapsed.TotalMilliseconds.ToString());
}
}
if (Storage.Instance.selectionList)
{
return(View(find.ToList()));
}
else
{
return(View(sportsmanDoubly.ToList()));
}
}catch (Exception) {
return(View());
}
}
public ActionResult SelectionPage(Sportsman sportsman, string C_List, string DoublyList)
{
try {
var sportsmanS = Storage.Instance.listSportman;
if (!string.IsNullOrEmpty(C_List))
{
Storage.Instance.selectionList = true;
return(RedirectToAction("Index"));
}
else if (!string.IsNullOrEmpty(DoublyList))
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Index"));
}
}catch (Exception) {
return(View());
}
}
private void InfoChange(Sportsman item)
{
if (item == null)
{
FirstNameTxt.Text = "Фамилия: ";
LastNameTxt.Text = "Имя: ";
DateOfBirthTxt.Text = "Дата рождения: ";
EmailTxt.Text = "Email: ";
SportCategoryTxt.Text = "Спортивный разряд: ";
pictureBox.Image = null;
}
else
{
FirstNameTxt.Text = "Фамилия: " + item.FirstName;
LastNameTxt.Text = "Имя: " + item.LastName;
DateOfBirthTxt.Text = "Дата рождения: " + item.DateOfBirth.ToLongDateString();
EmailTxt.Text = "Email: " + item.Email;
SportCategoryTxt.Text = "Спортивный разряд: " + item.SportsCategory;
pictureBox.Image = ImageChange.ByteToImage(item.Photo);
}
}
private void ShowMostMedalsForSportExecute(object obj)
{
Sportsman sportsman = null;
int medalscount = 0;
foreach (var sprtmn in Sportsmen)
{
foreach (var item in db.Participants.ToList().Where(p => p.Event.Sport == MostMedalsSport).Select(p => p.Medals))
{
var tempCount = item.Where(m => m.Sportsman == sprtmn).ToList().Count();
if (tempCount > medalscount)
{
medalscount = tempCount;
sportsman = sprtmn;
}
}
}
MostMedalSportsman = sportsman;
MostMedalsCount = medalscount;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["sportsman"] != null)
{
string sportsman = Request.Params["sportsman"];
var arr = sportsman.Split(';');
Sportsman deleted = new Sportsman()
{
LastName = arr[0],
FirstName = arr[1],
Patronymic = arr[2],
CodeGroup = arr[3]
};
DataService.DeleteSportsman(deleted);
var newUri = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.IndexOf(Request.Url.Query, StringComparison.Ordinal));
Response.Redirect(newUri);
}
SportsmenRepeater.DataSource = DataService.GetAllSportsmen();
SportsmenRepeater.DataBind();
}
