//When the submit button is commeted should do the following
protected void buttonSubmit_Click(object sender, EventArgs e)
{
//Ensure the page is valid before you submit to the database
if (Page.IsValid)
{
//Create instance of compost db and load values to go into the db
EnergyConsumed ec = new EnergyConsumed
{
EnergyConsumer = Convert.ToString(consumer.SelectedItem.Text),
SourceOfEnergyUse = Convert.ToString(producer.SelectedItem.Text),
Date = Convert.ToDateTime(datepicker.Text),
kWPerHour = Convert.ToDouble(kw_h.Text),
CostkWPerHour = Convert.ToDecimal(cost_kw.Text),
Notes = Convert.ToString(Notes1.Text)
};
//Insert fw into db
db.EnergyConsumeds.InsertOnSubmit(ec);
//Submit the changes and go home page
//NOTE: Will not go to home page runnign in VS due to the way master pages work.
try
{
db.SubmitChanges();
}
//If not throw error
catch
{
Console.WriteLine(e);
db.SubmitChanges();
}
}
}
//When the submit button is commeted should do the following
protected void buttonSubmit_Click(object sender, EventArgs e)
{
//Ensure the page is valid before you submit to the database
if (Page.IsValid)
{
//Create instance of compost db and load values to go into the db
EnergyConsumed ec = new EnergyConsumed
{
EnergyConsumer = Convert.ToString(consumer.SelectedItem.Text),
SourceOfEnergyUse = Convert.ToString(producer.SelectedItem.Text),
Date = Convert.ToDateTime(datepicker.Text),
kWPerHour = Convert.ToDouble(kw_h.Text),
CostkWPerHour = Convert.ToDecimal(cost_kw.Text),
Notes = Convert.ToString(Notes1.Text)
};
//Insert fw into db
db.EnergyConsumeds.InsertOnSubmit(ec);
//Submit the changes and go home page
//NOTE: Will not go to home page runnign in VS due to the way master pages work.
try
{
db.SubmitChanges();
}
//If not throw error
catch
{
Console.WriteLine(e);
db.SubmitChanges();
}
}
}
partial void DeleteEnergyConsumed(EnergyConsumed instance);
partial void UpdateEnergyConsumed(EnergyConsumed instance);
partial void InsertEnergyConsumed(EnergyConsumed instance);
