public ActionResult DeleteConfirmed(int id)
{
using (var db = new ILABNew2Entities())
{
Billeder billeder = db.Billeder.Find(id);
db.Billeder.Remove(billeder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
// POST: Billeders/Edit/5
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see http://go.microsoft.com/fwlink/?LinkId=317598.
//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult Edit([Bind(Include = "BilledID,Journal,Billedindex,Numordning,Ordning,CDnr,Fotograf,Format,Materiale,Placering,Ophavsret,Klausul,Datering,Indlevering,Note,JournalID")] Billeder billeder)
//{
// using (var db = new ILABNew2Entities())
// {
// if (ModelState.IsValid)
// {
// db.Entry(billeder).State = EntityState.Modified;
// db.SaveChanges();
// return RedirectToAction("Index");
// }
// ViewBag.JournalID = new SelectList(db.Journaler, "JournalID", "JournalNb", billeder.JournalID);
// return View(billeder);
// }
//}
// GET: Billeders/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var db = new ILABNew2Entities())
{
Billeder billeder = db.Billeder.Find(id);
if (billeder == null)
{
return(HttpNotFound());
}
return(View(billeder));
}
}
// POST: Billeders/Create
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see http://go.microsoft.com/fwlink/?LinkId=317598.
//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult Create([Bind(Include = "BilledID,Journal,Billedindex,Numordning,Ordning,CDnr,Fotograf,Format,Materiale,Placering,Ophavsret,Klausul,Datering,Indlevering,Note,JournalID")] Billeder billeder)
//{
// if (ModelState.IsValid)
// {
// using (var db = new ILABNew2Entities())
// {
// db.Billeder.Add(billeder);
// db.SaveChanges();
// return RedirectToAction("Index");
// }
// }
// //ViewBag.JournalID = new SelectList(db.Journaler, "JournalID", "JournalNb", billeder.JournalID);
// return View(billeder);
//}
// GET: Billeders/Edit/5
public ActionResult Edit(int?id)
{
using (var db = new ILABNew2Entities())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Billeder billeder = db.Billeder.Find(id);
if (billeder == null)
{
return(HttpNotFound());
}
//ViewBag.JournalID = new SelectList(db.Journaler, "JournalID", "JournalNb", billeder.JournalID);
return(View(billeder));
}
}
private void SletMaerke()
{
if (Request.QueryString["maerke_id"] != null)
{
int id = int.Parse(Request.QueryString["maerke_id"].ToString());
var query = db.Maerkes.Where(v => v.M_Id.Equals(id)).Single();
var query22 = db.Vares.Where(v => v.Fk_MaerkeId.Equals(id));
if (query22.ToList().Count > 0)
{
var query2 = db.Vares.Where(v => v.Fk_MaerkeId.Equals(id)).Single();
Billeder billede = (from b in db.Billeders where b.B_Id == query2.Fk_BilledeId select b).Single();
File.Delete(Server.MapPath("~/Billeder/Orginal/" + query2.Billeder.Sti));
File.Delete(Server.MapPath("~/Billeder/Resized/" + query2.Billeder.Sti));
db.Vares.DeleteOnSubmit(query2);
db.SubmitChanges();
db.Billeders.DeleteOnSubmit(billede);
db.SubmitChanges();
}
File.Delete(Server.MapPath("~/Billeder/Orginal/" + query.Billede));
File.Delete(Server.MapPath("~/Billeder/Maerker/" + query.Billede));
db.Maerkes.DeleteOnSubmit(query);
db.SubmitChanges();
Response.Redirect("~/Admin/MaerkeAdmin.aspx");
}
}
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");
}
}
protected void Button_GemVare_Click(object sender, EventArgs e)
{
if (TextBox_Navn.Text == "")
{
Label_Error.Text = "skriv et navn";
}
else if (TextBox_Beskrivelse.Text == "")
{
Label_Error.Text = "Skriv en beskrivelse";
}
else if (TextBox_Pris.Text == "")
{
Label_Error.Text = "Skriv en pris";
}
else if (!FileUpload_Billede.HasFile)
{
Label_Error.Text = "Vælg et billede";
}
else if (Convert.ToInt32(DropDownList_Kategori.SelectedValue) == 0)
{
Label_Error.Text = "Vælg en kategori";
}
else if (Convert.ToInt32(DropDownList_Maerke.SelectedValue) == 0)
{
Label_Error.Text = "Vælg et mærke";
}
else
{
var myUniqueFileName = string.Format(@"{0}_", Guid.NewGuid());
FileUpload_Billede.SaveAs(Server.MapPath("~/Billeder/Orginal/") + myUniqueFileName + FileUpload_Billede.FileName);
Billeder nytBillede = new Billeder
{
Sti = myUniqueFileName + FileUpload_Billede.FileName
};
db.Billeders.InsertOnSubmit(nytBillede);
db.SubmitChanges();
// Kald Metoden MakeThumbs, som laver en Reisze af originalen til 120px i bredden og uploader den til Resized_original mappen
MakeThumb(myUniqueFileName + FileUpload_Billede.FileName, "/Billeder/Orginal/", 120, "/Billeder/Resized/");
Vare nyVare = new Vare
{
Navn = TextBox_Navn.Text,
Pris = Convert.ToInt32(TextBox_Pris.Text),
Beskrivelse = TextBox_Beskrivelse.Text,
Fk_BilledeId = nytBillede.B_Id,
Fk_KategoriId = Convert.ToInt32(DropDownList_Kategori.SelectedValue),
Fk_MaerkeId = Convert.ToInt32(DropDownList_Maerke.SelectedValue)
};
db.Vares.InsertOnSubmit(nyVare);
try
{
db.SubmitChanges();
Response.Redirect("~/Admin/VareAdmin.aspx");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
public async Task <ActionResult> Save(Billeder model)
{
if (!ModelState.IsValid)
{
return(Json(new
{
success = false,
message = ModelState.Keys.SelectMany(k => ModelState[k].Errors).First().ErrorMessage
}));
}
try
{
using (var db = new ILABNew2Entities())
{
var dbModel = new Billeder();
if (model.BilledID > 0)
{
dbModel = await db.Billeder.FirstOrDefaultAsync(x => x.BilledID == model.BilledID);
if (dbModel == null)
{
throw new Exception(string.Format("Billede med id {0} blev ikke fundet", model.BilledID));
}
}
dbModel.Datering = model.Datering;
dbModel.Billedindex = model.Billedindex;
dbModel.CDnr = model.CDnr;
dbModel.Format = model.Format;
dbModel.Fotograf = model.Fotograf;
dbModel.Journal = model.Journal;
dbModel.JournalID = model.JournalID;
dbModel.Klausul = model.Klausul;
dbModel.Materiale = model.Materiale;
dbModel.Note = model.Note;
dbModel.Numordning = model.Numordning;
dbModel.Ophavsret = model.Ophavsret;
dbModel.Ordning = model.Ordning;
dbModel.Placering = model.Placering;
if (model.BilledID > 0)
{
db.Entry(dbModel).State = EntityState.Modified;
}
else
{
db.Billeder.Add(dbModel);
}
await db.SaveChangesAsync();
return(Json(new { success = true, message = "" }));
}
}
catch (Exception ex)
{
//brug extensible funktion
string err_message = ex.Message;
if (ex.InnerException != null)
{
err_message = ex.InnerException.Message;
if (ex.InnerException.InnerException != null)
{
err_message = ex.InnerException.InnerException.Message;
}
}
return(Json(new
{
success = false,
message = err_message
}));
}
}
partial void DeleteBilleder(Billeder instance);
partial void UpdateBilleder(Billeder instance);
partial void InsertBilleder(Billeder instance);
