private void ClodataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
CLOClass sc = new CLOClass();
ListofClasses lt = new ListofClasses();
int index = ClodataGridView.CurrentCell.RowIndex;
DataGridViewRow r = ClodataGridView.Rows[index];
int id = Convert.ToInt32(r.Cells[0].Value);
if (ClodataGridView.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))
{
sc.Delete(id);
MessageBox.Show("Data hes been deleted successfully");
Clo_Management_Load_1(sender, e);
}
else
{
return;
}
}
if (ClodataGridView.Columns[e.ColumnIndex].Name == "Edit")
{
CloName.Text = r.Cells[1].Value.ToString().Trim();
DateCreated.Value = Convert.ToDateTime(r.Cells[2].Value);
DateUpdated.Value = Convert.ToDateTime(r.Cells[3].Value);
globalindex2 = id;
if (Add.Visible)
{
Add.Visible = false;
}
}
}
private void Add_Click(object sender, EventArgs e)
{
if (CloName.Text == "")
{
MessageBox.Show("Must fill the Name attribute");
CloName_TextChanged(sender, e);
return;
}
if (DateCreated.Value == null)
{
MessageBox.Show("Must select the date for Datecreated");
DateCreated_ValueChanged(sender, e);
return;
}
if (DateUpdated.Value == null)
{
MessageBox.Show("Must select the date for DateUpdated");
DateUpdated_ValueChanged(sender, e);
return;
}
else
{
CLOClass clo1 = new CLOClass();
clo1.ADD_Clo(CloName.Text.Trim(), DateCreated.Value, DateUpdated.Value);
MessageBox.Show("Data has been added successfully");
CloName.Text = " ";
DateCreated.ResetText();
DateUpdated.ResetText();
Clo_Management_Load_1(sender, e);
}
}
/// <summary>
/// This function insert the CLO record in the CLORecordList
/// </summary>
/// <param name="query">Query to retrieve the data from database</param>
public void Show_CLoRecord(string query)
{
try
{
SqlCommand command = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader;
reader = command.ExecuteReader();
if (reader.HasRows)
{
ListofClasses Lt1 = new ListofClasses();
Lt1.CLOList.Clear();
while (reader.Read())
{
CLOClass Clo = new CLOClass();
Clo.Id1 = Convert.ToInt32(reader[0]);
Clo.Name = reader[1].ToString();
Clo.DateCreated = Convert.ToDateTime(reader[2]);
Clo.DateUpdated = Convert.ToDateTime(reader[3]);
Lt1.AddIntoCLoList(Clo);
}
}
}
catch (Exception ex)
{
throw (ex);
}
finally
{
conn.Close();
}
}
private void Clo_Management_Load_1(object sender, EventArgs e)
{
CLOClass clo = new CLOClass();
ListofClasses lt1 = new ListofClasses();
clo.CloRecord();
ClodataGridView.DataSource = null;
ClodataGridView.DataSource = lt1.CLOList;
}
private void Save_Click(object sender, EventArgs e)
{
CLOClass clo = new CLOClass();
if (CloName.Text == " ")
{
MessageBox.Show("Must fill the Name");
CloName_TextChanged(sender, e);
}
else
{
clo.Edit(globalindex2, CloName.Text, DateCreated.Value, DateUpdated.Value);
CloName.Text = " ";
DateCreated.ResetText();
DateUpdated.ResetText();
Clo_Management_Load_1(sender, e);
}
}
/// <summary>
/// this function used to add tne Clo from the CLO list
/// </summary>
/// <param name="cl">Clo of the CLOClass type</param>
public void AddIntoCLoList(CLOClass cl)
{
CLOList.Add(cl);
}