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