public FormularEditare(NoteClass pLC)
{
InitializeComponent();
workingNC = pLC;
labelID.Text = pLC.v_ID;
NumeTB.Text = pLC.v_Nume;
TIPCB.Text = pLC.v_Tip;
LansareDTP.Value = pLC.v_Lansare;
NotificareChB.Checked = pLC.v_Repetare;
NrNotTB.Text = pLC.v_NumarRepetari.ToString();
ModRepetareCB.Text = pLC.v_ModRepetare;
InteresCB.Text = pLC.v_Interes;
DescriereRTB.Text = pLC.v_Descriere;
if (NotificareChB.Checked)
{
ModRepetareCB.Enabled = true;
NrNotTB.Enabled = true;
}
else
{
ModRepetareCB.Enabled = false;
NrNotTB.Enabled = false;
}
}
public List<NoteClass> Select(string condition = "ID <> 0")
{
List<NoteClass> tempNC = new List<NoteClass>();
string sql = "select * from tableDATA WHERE " + condition ;
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
NoteClass tNC = new NoteClass();
tNC.v_ID = reader["ID"].ToString();
tNC.v_Tip = reader["TIP"].ToString();
tNC.v_Nume = reader["NUME"].ToString();
tNC.v_Lansare = DateTime.Parse(reader["LANSARE"].ToString());
tNC.v_Repetare = reader["REPETARE"].ToString().Equals("1");
tNC.v_ModRepetare = reader["MODREPETARE"].ToString();
tNC.v_NumarRepetari = Convert.ToInt16(reader["NUMARREPETARI"].ToString());
tNC.v_Interes = reader["INTERES"].ToString();
tNC.v_Descriere = reader["DESCRIERE"].ToString();
tNC.v_UltimaNotif = DateTime.Parse(reader["ULTIMANOTIF"].ToString());
tempNC.Add(tNC);
}
return tempNC;
}