private void submit_button_Click(object sender, EventArgs e) { using (var db = new Session5Entities()) { var getSkillid = (from s in db.Skills where s.skillName == skill_combo.SelectedItem.ToString() select s.skillId).First(); var getSession = int.Parse(session_combo.SelectedItem.ToString()); var competitions = (from c in db.Competitions where c.skillIdFK == getSkillid where c.sessionNo == getSession select c).First(); var user = name_combo.SelectedItem.ToString(); var getUserID = (from u in db.Competitors where u.competitorName == user select u.recordsId).First(); var r = new Result() { competitionIdFK = competitions.competitionId, recordsIdFK = getUserID, q1Marks = 0, q2Marks = 0, q3Marks = 0, q4Marks = 0, totalMarks = 00, }; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (i == 0) { r.q1Marks = double.Parse(dataGridView1.Rows[i].Cells[2].Value.ToString()); } else if (i == 1) { r.q2Marks = double.Parse(dataGridView1.Rows[i].Cells[2].Value.ToString()); } else if (i == 2) { r.q3Marks = double.Parse(dataGridView1.Rows[i].Cells[2].Value.ToString()); } if (i == 3) { r.q4Marks = double.Parse(dataGridView1.Rows[i].Cells[2].Value.ToString()); } } r.totalMarks = r.q1Marks + r.q2Marks + r.q3Marks + r.q4Marks; db.Results.Add(r); db.SaveChanges(); MessageBox.Show("Done"); } }
private void Confirm_Click(object sender, EventArgs e) { var skill = comboBox1.SelectedIndex + 1; foreach (DataGridViewRow row in dataGridView1.Rows) { foreach (DataGridViewCell dc in row.Cells) { if (string.IsNullOrEmpty(dc.Value.ToString()) == false) { var seatNo = dc.Value.ToString().Substring(0, 1); var ID = dc.Value.ToString().Substring(1).Trim(); using (var db = new Session5Entities()) { var q = db.Competitors.Where(x => x.skillIdFK == skill && x.competitorId == ID).FirstOrDefault(); try { q.assignedSeat = int.Parse(seatNo); try { db.SaveChanges(); MessageBox.Show("Success!"); } catch (Exception es) { MessageBox.Show(es.ToString()); } } catch { continue; } } } } } }
private void Sumbit_Click(object sender, EventArgs e) { using (var db = new Session5Entities()) { var name = sname.Text; var q = db.Results.Where(x => x.Competitor.competitorName == name).FirstOrDefault(); if (q != null) { foreach (DataGridViewRow dr in dataGridView1.Rows) { if (dr.Cells[1].Value.ToString().Contains("1")) { q.q1Marks = double.Parse(dr.Cells[3].Value.ToString()); } if (dr.Cells[1].Value.ToString().Contains("2")) { q.q2Marks = double.Parse(dr.Cells[3].Value.ToString()); } if (dr.Cells[1].Value.ToString().Contains("3")) { q.q3Marks = double.Parse(dr.Cells[3].Value.ToString()); } if (dr.Cells[1].Value.ToString().Contains("4")) { q.q4Marks = double.Parse(dr.Cells[3].Value.ToString()); } } try { q.totalMarks = double.Parse(Total.Text); } catch { MessageBox.Show("Invalid total marks!"); return; } try { db.SaveChanges(); MessageBox.Show("Successful!"); } catch (Exception es) { MessageBox.Show(es.ToString()); } } else { Result result = new Result(); var ID = skill.SelectedIndex + 1; var ses = session.SelectedIndex + 1; if (string.IsNullOrEmpty(name)) { MessageBox.Show("Invalid name!"); return; } if (string.IsNullOrEmpty(skill.Text)) { MessageBox.Show("Invalid skill!"); return; } if (string.IsNullOrEmpty(session.Text)) { MessageBox.Show("Invalid session!"); return; } var comps = db.Competitors.Where(x => x.competitorName == name).FirstOrDefault(); var comp = db.Competitions.Where(x => x.skillIdFK == ID && x.sessionNo == ses).FirstOrDefault(); result.recordsIdFK = comps.recordsId; result.competitionIdFK = comp.competitionId; result.q1Marks = 0; result.q2Marks = 0; result.q3Marks = 0; result.q4Marks = 0; foreach (DataGridViewRow dr in dataGridView1.Rows) { if (dr.Cells[1].Value.ToString().Contains("1")) { result.q1Marks = double.Parse(dr.Cells[3].Value.ToString()); } if (dr.Cells[1].Value.ToString().Contains("2")) { result.q2Marks = double.Parse(dr.Cells[3].Value.ToString()); } if (dr.Cells[1].Value.ToString().Contains("3")) { result.q3Marks = double.Parse(dr.Cells[3].Value.ToString()); } if (dr.Cells[1].Value.ToString().Contains("4")) { result.q4Marks = double.Parse(dr.Cells[3].Value.ToString()); } } try { result.totalMarks = double.Parse(Total.Text); } catch { MessageBox.Show("Invalid total marks!"); } try { db.Results.Add(result); db.SaveChanges(); MessageBox.Show("Successful!"); } catch (Exception es) { MessageBox.Show(es.ToString()); } } } }