private void My_Own_Load() { RubricsClass Rub = new RubricsClass(); ListofClasses lt1 = new ListofClasses(); Rub.RubricRecord(); RubricsDetail.DataSource = lt1.RubList; comoboxvalues(); }
private void Save_Click(object sender, EventArgs e) { RubricsClass Rub = new RubricsClass(); Rub.Edit(globalindex, Details.Text.Trim(), Closelection.Text); RubricsDetail.DataSource = null; My_Own_Load(); Details.Text = " "; Closelection.Text = " "; Add.Visible = true; }
public void comoboxvalues() { RubricsClass Rub = new RubricsClass(); ListofClasses lt1 = new ListofClasses(); Rub.addCLOname(); int length = lt1.Cloname.Count(); Closelection.Items.Clear(); for (int i = 0; i < length; i++) { Closelection.Items.Add(lt1.Cloname.ElementAt(i)); } }
private void RubricsDetail_CellContentClick(object sender, DataGridViewCellEventArgs e) { RubricsClass Rub = new RubricsClass(); ListofClasses lt = new ListofClasses(); int index = RubricsDetail.CurrentCell.RowIndex; datagridviewindex = index; DataGridViewRow r = RubricsDetail.Rows[index]; int id = Convert.ToInt32(r.Cells[0].Value); if (RubricsDetail.Columns[e.ColumnIndex].Name == "Delete") { DialogResult result = MessageBox.Show("Do You Want to delete data against the id ?" + id, "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result.Equals(DialogResult.OK)) { Rub.Delete(id); MessageBox.Show("Data has been deleted successfylly"); RubricsDetail.DataSource = null; Details.Text = " "; Closelection.SelectedText = " "; My_Own_Load(); if (Add.Visible == false) { Add.Visible = true; } } else { return; } } if (RubricsDetail.Columns[e.ColumnIndex].Name == "Edit") { comoboxvalues(); Details.Text = r.Cells[2].Value.ToString(); CLO = r.Cells[1].Value.ToString(); Closelection.SelectedText = CLO; globalindex = id; if (Add.Visible) { Add.Visible = false; } } }
private void Add_Click(object sender, EventArgs e) { RubricsClass rub = new RubricsClass(); if (Details.Text == " ") { MessageBox.Show("please fill the detail box first"); Details_TextChanged(sender, e); } else { string clo = Closelection.Text.Trim(); rub.ADD_Rubric(Details.Text.Trim(), clo); MessageBox.Show("Data has deen added successfully"); RubricsDetail.DataSource = null; Details.Text = " "; Closelection.Text = " "; My_Own_Load(); } }
/// <summary> /// This function used to insert the Rubric record in Rubric List /// </summary> /// <param name="query">Query to retrieve the data from database</param> public void RubricRecord(string query) { try { SqlCommand command = new SqlCommand(query, conn); if (conn.State != System.Data.ConnectionState.Open) { conn.Open(); } SqlDataReader reader; reader = command.ExecuteReader(); if (reader.HasRows) { ListofClasses Lt1 = new ListofClasses(); Lt1.RemoveFromRubrics(); while (reader.Read()) { RubricsClass Rub = new RubricsClass(); Rub.Id = Convert.ToInt32(reader[0]); Rub.Details1 = reader[1].ToString(); int id = Convert.ToInt32(reader[2]); string myquery = "select Name FROM Clo where Id = '" + id + "'"; Rub.Cloname = Cloname(myquery); Lt1.AddIntoRubricList(Rub); } } } catch (Exception ex) { throw (ex); } finally { conn.Close(); } }
/// <summary> /// this function used to Add tne Rubric in the RubricList /// </summary> /// <param name="cl">Indicate the object of Rubric type</param> public void AddIntoRubricList(RubricsClass cl) { rubList.Add(cl); }