private void back1_Click(object sender, EventArgs e)
{
evaluations s = new evaluations();
this.Hide();
s.Show();
}
private void evllist_Click(object sender, EventArgs e)
{
evaluations ev = new evaluations();
this.Hide();
ev.Show();
}
private void saveupadd_Click(object sender, EventArgs e)
{
Evaluation evl = new Evaluation();
Regexp(@"^[a-zA-Z]{1,100}", nametext, addnme, "name");
Regexp(@"^[0-9]{1,20}", tmrkstxt, tmeks, "Total Marks");
Regexp(@"^[0-9]{1,20}", twttxt, twt, "Total Weightage");
evl.Name = nametext.Text;
evl.totalmarks = Convert.ToInt32(tmrkstxt.Text);
evl.weightage = Convert.ToInt32(twttxt.Text);
if (Convert.ToInt32(obttext.Text) > Convert.ToInt32(tmrkstxt.Text))
{
MessageBox.Show("Obtain marks should be less than or equal to Total Marks");
obttext.Clear();
}
else
{
String cmd = String.Format("UPDATE Evaluation SET Name = '{0}' , TotalMarks = '{1}',TotalWeightage='{2}' WHERE Id ='{3}' ", evl.Name, evl.totalmarks, evl.weightage, ide);
DatabaseConnection.getInstance().exectuteQuery(cmd);
cmd = String.Format("SELECT GroupProject.GroupId FROM Project JOIN GroupProject On (Project.Id = GroupProject.ProjectId) WHERE (title = '{0}')", procombo.Text);
SqlCommand a = new SqlCommand(cmd, DatabaseConnection.getInstance().getConnection());
int id;
id = (Int32)a.ExecuteScalar();
cmd = String.Format("UPDATE GroupEvaluation SET ObtainedMarks = '{0}',EvaluationDate = GetDate() WHERE EvaluationId = '{1}' AND GroupId= '{2}')", obttext.Text, ide, id);
DatabaseConnection.getInstance().exectuteQuery(cmd);
evaluations s = new evaluations();
this.Hide();
s.Show();
}
}
private void delstu_Click(object sender, EventArgs e)
{
if (dataGridstudent.SelectedCells.Count != 0)
{
int rw = dataGridstudent.SelectedCells[0].RowIndex;
String cmd = String.Format("Select Id from Evaluation Where Name = '{0}'", dataGridstudent.Rows[rw].Cells["Evaluation Name"].Value.ToString());
SqlCommand del = new SqlCommand(cmd, DatabaseConnection.getInstance().getConnection());
int idp;
idp = (Int32)del.ExecuteScalar();
cmd = String.Format("delete from GroupEvaluation Where Evaluation.EvaluationId = '{0}'", idp);
del = new SqlCommand(cmd, DatabaseConnection.getInstance().getConnection());
int count = del.ExecuteNonQuery();
evaluations p = new evaluations();
this.Hide();
p.Show();
}
}
private void createbtn_Click(object sender, EventArgs e)
{
Evaluation evl = new Evaluation();
Regexp(@"^[a-zA-Z]{1,100}", nametext, addnme, "name");
Regexp(@"^[0-9]{1,20}", tmrkstxt, tmeks, "Contact");
Regexp(@"^[0-9]{1,20}", obttext, obt, "Contact");
Regexp(@"^[0-9]{1,20}", twttxt, twt, "Contact");
if (Convert.ToInt32(obttext.Text) > Convert.ToInt32(tmrkstxt.Text))
{
MessageBox.Show("Obtain marks should be less than or equal to Total Marks");
obttext.Clear();
}
else
{
evl.Name = nametext.Text;
evl.totalmarks = Convert.ToInt32(tmrkstxt.Text);
evl.weightage = Convert.ToInt32(twttxt.Text);
String cmd = String.Format("INSERT INTO Evaluation(Name,TotalMarks,TotalWeightage) values('{0}','{1}','{2}' )", evl.Name, evl.totalmarks, evl.weightage);
DatabaseConnection.getInstance().exectuteQuery(cmd);
cmd = String.Format("SELECT GroupProject.GroupId FROM Project JOIN GroupProject On (Project.Id = GroupProject.ProjectId) WHERE (title = '{0}')", procombo.Text);
SqlCommand a = new SqlCommand(cmd, DatabaseConnection.getInstance().getConnection());
int id;
id = (Int32)a.ExecuteScalar();
cmd = String.Format("SELECT Max(Id) FROM Evaluation");
a = new SqlCommand(cmd, DatabaseConnection.getInstance().getConnection());
int ide;
ide = (Int32)a.ExecuteScalar();
cmd = String.Format("INSERT INTO GroupEvaluation(GroupId,EvaluationId,ObtainedMarks,EvaluationDate) values('{0}','{1}','{2}',GetDate() )", id, ide, obttext.Text);
DatabaseConnection.getInstance().exectuteQuery(cmd);
evaluations s = new evaluations();
this.Hide();
s.Show();
}
}