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());
}
}
}
}
