// when click on save button
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(conURL);
// connection opens
con.Open();
int ID = buffer;
if (ID < 0) // insertion
{
try
{
// here check whether boxes are empty for not
if (String.IsNullOrEmpty(textBoxName.Text) || String.IsNullOrEmpty(textBoxMarks.Text) || String.IsNullOrEmpty(textBoxWeghtage.Text))
{
MessageBox.Show("Fill all boxes must");
}
else
{
// if all validation are true then insert data
if (isalphaTest(textBoxName.Text) && Convert.ToInt32(textBoxWeghtage.Text) >= 0 && Convert.ToInt32(textBoxMarks.Text) >= 0)
{
// command store in string then execute it by passing into sqlcommand object
string cmdText = "INSERT INTO Evaluation (Name, TotalMarks, TotalWeightage) VALUES (@Name, @TotalMarks, @TotalWeightage)";
SqlCommand c = new SqlCommand(cmdText, con);
c.Parameters.Add(new SqlParameter("@Name", textBoxName.Text));
c.Parameters.Add(new SqlParameter("@TotalMarks", textBoxMarks.Text));
c.Parameters.Add(new SqlParameter("@TotalWeightage", textBoxWeghtage.Text));
//execute it
int result = c.ExecuteNonQuery();
if (result < 0)
{
MessageBox.Show("Error");
}
// show dialog box if added in table of database
MessageBox.Show("Successfully Added");
// connection closed
con.Close();
this.Hide();
Evaluation datap = new Evaluation();
datap.ShowDialog();
this.Close(); // close the form
}
else
{
throw new ArgumentNullException();
}
}
}
catch (Exception)
{
MessageBox.Show("Enter Name,Total marks, total weightage in correct Format!! marks and weightage can't be negative. No extra spaces in names");
}
}
else // updation
{
try
{
if (isalphaTest(textBoxName.Text) && Convert.ToInt32(textBoxWeghtage.Text) >= 0 && Convert.ToInt32(textBoxMarks.Text) >= 0)
{
string cmdText2 = "Update Evaluation SET Name = @Name, TotalMarks = @TotalMarks, TotalWeightage = @TotalWeightage WHERE Id = @Id";
SqlCommand c2 = new SqlCommand(cmdText2, con);
c2.Parameters.Add(new SqlParameter("@Id", ID));
c2.Parameters.Add(new SqlParameter("@Name", textBoxName.Text));
c2.Parameters.Add(new SqlParameter("@TotalMarks", textBoxMarks.Text));
c2.Parameters.Add(new SqlParameter("@TotalWeightage", textBoxWeghtage.Text));
c2.ExecuteNonQuery();
MessageBox.Show("Successfully Updated");
con.Close();
this.Hide();
Evaluation datap = new Evaluation();
datap.ShowDialog();
this.Close(); // close the form
}
else
{
throw new ArgumentNullException();
}
}
catch (Exception)
{
MessageBox.Show("Enter Name,Total marks, total weightage in correct Format!! marks and weightage can't be negative. No extra spaces in names");
}
}
}
// goes to manage evaluations form
private void MevalButton_Click(object sender, EventArgs e)
{
Evaluation st = new Evaluation();
st.ShowDialog();
}
