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;
}
