private void ADD_Click(object sender, EventArgs e) { try { AssessmentClass Ass = new AssessmentClass(); if (Title.Text != "" && Totalweightage.Text != "" && TotalMarks.Text != "") { Ass.ADD_Asses(Title.Text, Convert.ToInt32(TotalMarks.Text), Convert.ToInt32(Totalweightage.Text), DateCreated.Value); MessageBox.Show("Data has been added successfully"); Title.Text = " "; TotalMarks.Text = " "; Totalweightage.Text = " "; DateCreated.ResetText(); AssessmentRecord.DataSource = null; Assessment_Load(sender, e); } else { MessageBox.Show("Must fill all the fields in order to proceed"); } } catch (Exception ex) { MessageBox.Show("Fail to add the data please try again with valid values"); return; } }
/// <summary> /// This function used to insert the Aseseement record in Assessment List /// </summary> /// <param name="query">Query to retrieve the data from database</param> public void ShowASSRecord(string query) { try { SqlCommand command = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader; reader = command.ExecuteReader(); if (reader.HasRows) { ListofClasses Lt1 = new ListofClasses(); Lt1.RemoveFromASS(); while (reader.Read()) { AssessmentClass ASS = new AssessmentClass(); ASS.Id1 = Convert.ToInt32(reader[0]); ASS.Title1 = reader[1].ToString(); ASS.DateCreated1 = Convert.ToDateTime(reader[2]); ASS.TotalMarks1 = Convert.ToInt32(reader[3]); ASS.TotalWeightage1 = Convert.ToInt32(reader[4]); Lt1.AddASSList(ASS); } } } catch (Exception ex) { throw (ex); } finally { conn.Close(); } }
private void Assessment_Load(object sender, EventArgs e) { AssessmentClass ASS = new AssessmentClass(); ListofClasses lt1 = new ListofClasses(); ASS.ASSRecord(); AssessmentRecord.DataSource = lt1.ASSC1; }
private void Save_Click(object sender, EventArgs e) { AssessmentClass ASS = new AssessmentClass(); ASS.Edit(globalindex, Title.Text, Convert.ToInt32(TotalMarks.Text), Convert.ToInt32(Totalweightage.Text), DateCreated.Value); AssessmentRecord.DataSource = null; Title.Text = " "; TotalMarks.Text = " "; Totalweightage.Text = " "; DateCreated.ResetText(); Assessment_Load(sender, e); ADD.Visible = true; }
private void AssessmentRecord_CellContentClick(object sender, DataGridViewCellEventArgs e) { AssessmentClass ASS = new AssessmentClass(); ListofClasses lt = new ListofClasses(); int index = AssessmentRecord.CurrentCell.RowIndex; DataGridViewRow r = AssessmentRecord.Rows[index]; int id = Convert.ToInt32(r.Cells[0].Value); if (AssessmentRecord.Columns[e.ColumnIndex].Name == "Delete") { DialogResult result = MessageBox.Show("Do You Want to delete?" + id, "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result.Equals(DialogResult.OK)) { ASS.Delete(id); MessageBox.Show("Data has deen Deleted successfully"); AssessmentRecord.DataSource = null; Assessment_Load(sender, e); if (ADD.Visible == false) { ADD.Visible = true; } } else { return; } } if (AssessmentRecord.Columns[e.ColumnIndex].Name == "Edit") { Title.Text = r.Cells[1].Value.ToString(); TotalMarks.Text = r.Cells[3].Value.ToString(); Totalweightage.Text = r.Cells[4].Value.ToString(); DateCreated.Value = Convert.ToDateTime(r.Cells[2].Value); globalindex = id; ADD.Visible = false; } }
/// <summary> /// This function used to ADD tne Assessment in the AssessmentList /// </summary> /// <param name="rl"></param> public void AddASSList(AssessmentClass rl) { ASSC.Add(rl); }