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