public void Initialize() { dao = null; dao = new ProviderDAO(); conn = null; conn = SQLiteConnectionFactory.GetPrimaryDBConnection(); }
private void button_save_Click(object sender, EventArgs e) { log.Debug("Save button clicked"); SQLiteConnection conn = SQLiteConnectionFactory.GetPrimaryDBConnection(); ProviderDAO dao = new ProviderDAO(); Provider provider = new Provider(); try { label_message.ForeColor = Color.Blue; provider.ProviderName = textBox_providerName.Text; if (isUpdate) { provider.ProviderId = Convert.ToInt32(label_providerId.Text); log.Debug("Attempting to update provider " + provider.ProviderId + ": " + provider.ProviderName); dao.Update(provider, conn); label_message.Text = "Updated Provider " + provider.ProviderName; log.Debug("Update provider successful"); } else { log.Debug("Attempting to save new provider: " + provider.ProviderName); dao.Create(provider, conn); label_message.Text = "Saved new Provider " + provider.ProviderName; log.Debug("Create new provider successful"); this.Close(); } } catch (Exception ex) { log.Error("Error saving/updating provider", ex); label_message.ForeColor = Color.Red; label_message.Text = ex.Message; } }
private Provider InsertTestProvider(SQLiteConnection conn, int i) { ProviderDAO providerDAO = new ProviderDAO(); string name = GetRandomName() + i; Provider p = new Provider() { ProviderName = name }; providerDAO.Create(p, conn); p.ProviderId = providerDAO.Read("SELECT * FROM providers WHERE provider_id = (SELECT max(provider_id) FROM providers)", conn)[0].ProviderId; return p; }
private DataTable FormatRawData(List<Hunt> hunts, SQLiteConnection conn) { log.Debug("Formatting results to display"); DataTable outDT = new DataTable(); ProviderDAO providerDAO = new ProviderDAO(); outDT.Columns.Add(Constants.friendly_column_huntId); outDT.Columns.Add(Constants.friendly_column_providerName); outDT.Columns.Add(Constants.friendly_column_habitatName); outDT.Columns.Add(Constants.friendly_column_groupName); outDT.Columns.Add(Constants.friendly_column_guideName); outDT.Columns.Add(Constants.friendly_column_numberOfGuns); outDT.Columns.Add(Constants.friendly_column_huntDate); outDT.Columns.Add(Constants.friendly_column_pheasantHarvest); outDT.Columns.Add(Constants.friendly_column_grouseHarvest); outDT.Columns.Add(Constants.friendly_column_partrdigeHarvest); outDT.Columns.Add(Constants.friendly_column_birdsSeen); outDT.Columns.Add(Constants.friendly_column_birdsMissed); outDT.Columns.Add(Constants.friendly_column_crop); outDT.Columns.Add(Constants.friendly_column_cropHarvested); for (int i = 0; i < hunts.Count; i++) { List<Guide> guides = guideDAO.ReadByHuntId(hunts[i].HuntId, conn); string guideConcat = ""; for (int j = 0; j < guides.Count; j++) { guideConcat += guides[j].GuideName; if (j < guides.Count - 1) { guideConcat += ", "; } } var row = outDT.NewRow(); row[Constants.friendly_column_huntId] = hunts[i].HuntId; string providerName = providerDAO.ReadById(hunts[i].Habitat.ProviderId, conn).ProviderName; row[Constants.friendly_column_providerName] = providerName; row[Constants.friendly_column_habitatName] = hunts[i].Habitat.HabitatName; row[Constants.friendly_column_groupName] = hunts[i].Group.GroupName; row[Constants.friendly_column_guideName] = guideConcat; row[Constants.friendly_column_huntDate] = hunts[i].HuntDate.ToShortDateString(); row[Constants.friendly_column_pheasantHarvest] = hunts[i].Harvest.Pheasant; row[Constants.friendly_column_grouseHarvest] = hunts[i].Harvest.Grouse; row[Constants.friendly_column_partrdigeHarvest] = hunts[i].Harvest.Partridge; row[Constants.friendly_column_birdsSeen] = hunts[i].Harvest.BirdsSeen; row[Constants.friendly_column_birdsMissed] = hunts[i].Harvest.BirdsMissed; row[Constants.friendly_column_crop] = hunts[i].Harvest.Crop; row[Constants.friendly_column_cropHarvested] = hunts[i].Harvest.CropHarvested; row[Constants.friendly_column_numberOfGuns] = hunts[i].NumberOfGuns; outDT.Rows.Add(row); } return outDT; }
private Provider InsertTestProvider(SQLiteConnection conn) { ProviderDAO providerDAO = new ProviderDAO(); Provider p = new Provider() { ProviderName = "HuntTestProvider" }; providerDAO.Create(p, conn); p.ProviderId = providerDAO.Read("SELECT * FROM providers WHERE provider_name = 'HuntTestProvider'", conn)[0].ProviderId; return p; }