private void importTemps(int parkId) { temps = new List<CommonTools.Temp>(); String[] fields = { "Description", "Charge", "DateAssigned" }; List<Object[]> opts = DatabaseControl.getMultipleRecord(fields, DatabaseControl.tempChargeTable, "ParkID=@value0 AND DateAssigned>=@value1", new Object[] { parkId, DateTime.Now.Date.AddDays(-7) }); foreach (Object[] opt in opts) { CommonTools.Temp newTemp = new CommonTools.Temp(opt[0].ToString(), (DateTime)opt[2]); newTemp.charge = (decimal)opt[1]; temps.Add(newTemp); } refreshTempList(); }
private void insertTemp_Click(object sender, EventArgs e) { CommonTools.Temp opt = new CommonTools.Temp(tempDescription.Text, dateAssigned.Value.Date); try { opt.charge = Convert.ToDecimal(tempCharge.Text); } catch { MessageBox.Show("Invalid value for temporary charge."); return; } temps.Add(opt); tempList.Items.Add(new CommonTools.Item(0, tempDescription.Text)); refreshTempList(); }