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