protected void Button_GemTilbud_Click(object sender, EventArgs e)
{
if (TextBox_TilbudPct.Text == "")
{
Label_Error.Text = "Skriv en tilbuds procent";
}
else if (Convert.ToInt32(DropDownList_Vare.SelectedValue) == 0)
{
Label_Error.Text = "Vælg en vare";
}
else if (Calendar_Date.SelectedDate == null)
{
Label_Error.Text = "Vælg en dato";
}
else
{
Tilbud nytTilbud = new Tilbud
{
TildbudPct = Convert.ToInt32(TextBox_TilbudPct.Text),
Fk_VareId = Convert.ToInt32(DropDownList_Vare.SelectedValue),
SlutDato = Calendar_Date.SelectedDate,
StartDato = Calendar_Start.SelectedDate
};
db.Tilbuds.InsertOnSubmit(nytTilbud);
try
{
db.SubmitChanges();
Response.Redirect("~/Admin/TilbudAdmin.aspx");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
public Dagugetilbud()
{
_tilbudliste = new ObservableCollection <Tilbud>();
Tilbudliste.Add(new Tilbud(30, " Føtex", " Cookie", "../Assets/Chocolate_Chip_Cookies_-_kimberlykv.jpg"));
Tilbudliste.Add(new Tilbud(70, " Netto", " Bolig", "../Assets/download.jpg"));
Tilbudliste.Add(new Tilbud(130, " Føtex", " Kat", "../Assets/relaxing-cat.jpg"));
Tilbudliste.Add(new Tilbud(300, " Fakta", " Bedstemor", "../Assets/relaxing-cat.jpg"));
Tilbudliste.Add(new Tilbud(250, " Lidl", " Advokado", "../Assets/relaxing-cat.jpg"));
Tilbudliste.Add(new Tilbud(150, " Irma", " Enhjørning", "../Assets/relaxing-cat.jpg"));
_valgttilbud = new Tilbud();
}
public void Setup()
{
rute1 = new Rute(1);
Tilbud tilbud1 = new Tilbud("1", 1, 3, bydder1); // plads 3
Tilbud tilbud2 = new Tilbud("2", 1, 5, bydder2); // plads 4
Tilbud tilbud3 = new Tilbud("3", 1, 1, bydder3); // plads 0
Tilbud tilbud4 = new Tilbud("4", 1, 2, bydder4); // plads 2
Tilbud tilbud5 = new Tilbud("5", 1, 2, bydder5); // plads 1
Tilbud[] tilbud = new Tilbud[] { tilbud1, tilbud2, tilbud3, tilbud4, tilbud5 };
Byder[] bydder = new Byder[] { bydder1, bydder2, bydder3, bydder4, bydder5 };
rute1.Tilbud.AddRange(tilbud);
listRuter.Add(rute1);
listBydder.AddRange(bydder);
}
private void SletVare()
{
if (Request.QueryString["vare_id"] != null)
{
int id = int.Parse(Request.QueryString["vare_id"].ToString());
var query = db.Vares.Where(v => v.V_Id.Equals(id)).Single();
File.Delete(Server.MapPath("~/Billeder/Orginal/" + query.Billeder.Sti));
File.Delete(Server.MapPath("~/Billeder/Resized/" + query.Billeder.Sti));
Billeder billede = (from b in db.Billeders where b.B_Id == query.Fk_BilledeId select b).Single();
var erDerTilbud = (from x in db.Tilbuds where x.Fk_VareId == id select x).SingleOrDefault();
if (erDerTilbud != null)
{
Tilbud tilbud = (from t in db.Tilbuds where t.Fk_VareId == id select t).Single();
db.Tilbuds.DeleteOnSubmit(tilbud);
db.SubmitChanges();
db.Vares.DeleteOnSubmit(query);
db.SubmitChanges();
db.Billeders.DeleteOnSubmit(billede);
db.SubmitChanges();
}
else
{
db.Vares.DeleteOnSubmit(query);
db.SubmitChanges();
db.Billeders.DeleteOnSubmit(billede);
db.SubmitChanges();
}
Response.Redirect("~/Admin/VareAdmin.aspx");
//var query = from n in db._Nyheders where n.N_Id == id select n;
//var query2 = query.Single();
//if (query2.Fk_Billede_Id != null)
//{
// File.Delete(Server.MapPath("~/img/NyhedBilleder/Orginal/" + query2._Billeder.Billede));
// File.Delete(Server.MapPath("~/img/NyhedBilleder/Resized/" + query2._Billeder.Billede));
// _Billeder billede = (from b in db._Billeders where b.B_Id == query2.Fk_Billede_Id select b).Single();
// db._Nyheders.DeleteOnSubmit(query2);
// db.SubmitChanges();
// db._Billeders.DeleteOnSubmit(billede);
// db.SubmitChanges();
//}
//else
//{
// db._Nyheders.DeleteOnSubmit(query2);
// db.SubmitChanges();
//}
//Response.Redirect("NyhedsblogAdmin.aspx");
}
}
private void detach_Tilbuds(Tilbud entity)
{
this.SendPropertyChanging();
entity.Vare = null;
}
private void attach_Tilbuds(Tilbud entity)
{
this.SendPropertyChanging();
entity.Vare = this;
}
partial void DeleteTilbud(Tilbud instance);
partial void UpdateTilbud(Tilbud instance);
partial void InsertTilbud(Tilbud instance);
