public void insertEventType(BALEventType obj)
    {
        SqlCommand cmd = new SqlCommand();

        cmd.Connection  = con;
        cmd.CommandText = "spInsertEventType";
        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.AddWithValue("@eventtypename", obj.EventTypeName);

        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
    }
 public IEnumerable <EventType> GetAllEventType()
 {
     balEventType = new BALEventType();
     return(balEventType.GetAllEventType());
 }