private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Manage_Assessment m = new Manage_Assessment();
this.Close();
m.Show();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if ((textBox5.Text == "") || (dateTimePicker1.Value == null) || (textBox3.Text == "") || (textBox2.Text == ""))
{
MessageBox.Show("Submssion is not allowed with null values");
}
else
{
string constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
SqlConnection c = new SqlConnection(constr);
c.Open();
int f = dataGridView1.CurrentCell.RowIndex;
int id4 = (int)(dataGridView1.Rows[f].Cells["Id"].Value);
//MessageBox.Show("Updating this entry"
string s1 = string.Format("UPDATE Assessment SET Title=@Title, DateCreated=@DateCreated,TotalMarks=@TotalMarks,TotalWeightage=@TotalWeightage where Id=@Id");
//values('" + s.get_FirstName() + "', '" + s.get_LastName() + "','" + s.get_Contact() + "','" + s.get_Email() + "','" + s.get_Registration_No() + "','" + id + "')");
//string s1 = string.Format("INSERT INTO Student(FirstName,LastName,Contact,Email,RegistrationNumber,Status) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')", s.get_FirstName(), s.get_LastName(), s.get_Contact(), s.get_Email(), s.get_Registration_No(), id);
SqlCommand a2 = new SqlCommand(s1, c);
//GetExample(a2, p.ToArray());
a2.Parameters.Add(new SqlParameter("Id", id4));
a2.Parameters.Add(new SqlParameter("@Title", SqlDbType.VarChar));
a2.Parameters["@Title"].Value = textBox5.Text;
a2.Parameters.Add(new SqlParameter("@DateCreated", SqlDbType.DateTime));
a2.Parameters["@DateCreated"].Value = dateTimePicker1.Value;
a2.Parameters.Add(new SqlParameter("@TotalMarks", SqlDbType.VarChar));
a2.Parameters["@TotalMarks"].Value = textBox3.Text;
a2.Parameters.Add(new SqlParameter("@Totalweightage", SqlDbType.VarChar));
a2.Parameters["@TotalWeightage"].Value = textBox2.Text;
int rows = a2.ExecuteNonQuery();
if (rows != 0)
{
MessageBox.Show("Assesement Updated");
c.Close();
panel4.Hide();
this.Close();
Manage_Assessment j = new Manage_Assessment();
j.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Add_Assessment s = new Add_Assessment();
s.set_Title(TitleName.Text);
s.set_Date_Created(dateTimePicker1.Value);
s.set_Total_Marks(Marks.Text);
s.set_Total_Weightage(Weightage.Text);
if ((TitleName.Text == "") || (dateTimePicker1.Value == null) || (Marks.Text == "") || (Weightage.Text == ""))
{
MessageBox.Show("Submssion is not allowed with null values");
}
else if ((s.get_Title() == null) || (s.get_Date_Created() == null) || (s.get_Total_Marks() == 0) || (Convert.ToInt16(Weightage.Text) == 0))
{
MessageBox.Show("Invalid Data Entered!!");
}
else
{
string constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
SqlConnection c = new SqlConnection(constr);
c.Open();
string s1 = string.Format("INSERT INTO Assessment(Title,DateCreated,TotalMarks,TotalWeightage) values('" + s.get_Title() + "', '" + s.get_Date_Created() + "','" + s.get_Total_Marks() + "','" + s.get_Total_Weightage() + "')");
//string s1 = string.Format("INSERT INTO Student(FirstName,LastName,Contact,Email,RegistrationNumber,Status) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')", s.get_FirstName(), s.get_LastName(), s.get_Contact(), s.get_Email(), s.get_Registration_No(), id);
SqlCommand a2 = new SqlCommand(s1, c);
//int rows = DatabaseConnection.getInstance().exectuteQuery(s1);
int rows = a2.ExecuteNonQuery();
if (rows != 0)
{
MessageBox.Show("Added");
this.Close();
Manage_Assessment n = new Manage_Assessment();
n.Show();
}
c.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void linkLabel12_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Manage_Assessment t = new Manage_Assessment();
t.Show();
}
private void dataGridView1_CellContentClick_2(object sender, DataGridViewCellEventArgs e)
{
string constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
SqlConnection conn = new SqlConnection(constr);
conn.Open();
if (dataGridView1.Columns[e.ColumnIndex].Name == "Delete" && e.RowIndex >= 0)
{
try
{
MessageBox.Show("you are going to delete this row");
int Reg = (int)(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
string Id = string.Format("DELETE FROM Assessment WHERE Id=@Id");
SqlCommand p = new SqlCommand(Id, conn);
p.Parameters.AddWithValue("@Id", Reg);
int i = p.ExecuteNonQuery();
if (i != 0)
{
MessageBox.Show("Data deleted");
this.Hide();
Manage_Assessment m = new Manage_Assessment();
m.Show();
//StudentGrid d1 = new StudentGrid();
//d1.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
conn.Close();
}
else if (dataGridView1.Columns[e.ColumnIndex].Name == "Edit" && (e.RowIndex >= 0))
{
SqlConnection c = new SqlConnection(constr);
c.Open();
panel4.Show();
int f = dataGridView1.CurrentCell.RowIndex;
int id4 = (int)(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
//MessageBox.Show("Updating this entry");
string s2 = string.Format("SELECT Title,DateCreated,TotalMarks,TotalWeightage FROM Assessment Where Id=@Id");
SqlCommand d = new SqlCommand(s2, c);
d.Parameters.Add(new SqlParameter("@Id", id4));
SqlDataReader dr = d.ExecuteReader();
try
{
while (dr.Read())
{
textBox5.Text = dr.GetString(0);
dateTimePicker1.Value = (DateTime)dr.GetValue(1);
textBox3.Text = Convert.ToString(dr.GetValue(2));
textBox2.Text = Convert.ToString(dr.GetValue(3));
}
dr.Close();
panel4.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (dataGridView1.Columns[e.ColumnIndex].Name == "Column1" && (e.RowIndex >= 0))
{
SqlConnection c = new SqlConnection(constr);
c.Open();
//panel4.Show();
int f = dataGridView1.CurrentCell.RowIndex;
int id4 = (int)(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
//MessageBox.Show("Updating this entry");
string s2 = string.Format("SELECT DateCreated,TotalMarks FROM Assessment Where Id=@Id");
SqlCommand d = new SqlCommand(s2, c);
d.Parameters.Add(new SqlParameter("@Id", id4));
SqlDataReader dr = d.ExecuteReader();
try
{
while (dr.Read())
{
//textBox5.Text = dr.GetString(0);
dateTimePicker1.Value = (DateTime)dr.GetValue(0);
textBox1.Text = Convert.ToString(dr.GetValue(1));
//comboBox3.Text = Convert.ToString(dr.GetValue(2));
}
dr.Close();
SqlConnection b = new SqlConnection(constr);
b.Open();
SqlDataAdapter da = new SqlDataAdapter("select Id FROM Rubric", b);
DataTable t = new DataTable();
da.Fill(t);
comboBox2.DisplayMember = "Id";
comboBox2.DataSource = t;
panel1.Show();
b.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("No data Here");
}
}