public ActionResult DeleteConfirmed(int id)
{
ADRESS aDRESS = db.ADRESS.Find(id);
db.ADRESS.Remove(aDRESS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Street,Post,City,Email,Cel,Tel,CountryID")] ADRESS aDRESS)
{
if (ModelState.IsValid)
{
db.Entry(aDRESS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CountryID = new SelectList(db.COUNTRY, "Id", "continent", aDRESS.CountryID);
return(View(aDRESS));
}
// GET: ADRESSes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ADRESS aDRESS = db.ADRESS.Find(id);
if (aDRESS == null)
{
return(HttpNotFound());
}
return(View(aDRESS));
}
// GET: ADRESSes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ADRESS aDRESS = db.ADRESS.Find(id);
if (aDRESS == null)
{
return(HttpNotFound());
}
ViewBag.CountryID = new SelectList(db.COUNTRY, "Id", "continent", aDRESS.CountryID);
return(View(aDRESS));
}
public bool UpdateAdress(ADRESS Entity)
{
using (KARYABDBEntities db = new KARYABDBEntities())
{
try
{
// var Skill = db.SKILLS.FirstOrDefault(q => q.ID == SkillID);
db.ADRESSES.Attach(Entity);
var Entry = db.Entry(Entity);
Entry.State = EntityState.Modified;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public long SetAdress(ADRESS Adress, long HumanID)
{
using (KARYABDBEntities db = new KARYABDBEntities())
{
try
{
db.Configuration.ProxyCreationEnabled = false;
db.ADRESSES.Add(Adress);
db.SaveChanges();
OWNERSADRES owenersAdress = new OWNERSADRES();
owenersAdress.ADRESSID = Adress.ID;
owenersAdress.ADRESSOWNERID = HumanID;
db.OWNERSADRESES.Add(owenersAdress);
db.SaveChanges();
return(Adress.ID);
}
catch
{
return(0);
}
}
}
public bool DeleteAdress(ADRESS Entity)
{
using (KARYABDBEntities db = new KARYABDBEntities())
{
try
{
db.Configuration.ProxyCreationEnabled = false;
ADRESS entity = db.ADRESSES.FirstOrDefault(q => q.ID == Entity.ID);
OWNERSADRES Owner = db.OWNERSADRESES.FirstOrDefault(q => q.ADRESSID == Entity.ID);
db.OWNERSADRESES.Attach(Owner);
db.OWNERSADRESES.Remove(Owner);
db.SaveChanges();
db.ADRESSES.Attach(entity);
db.ADRESSES.Remove(entity);
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
