public IHttpActionResult Putsecure(int id, secure secure)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != secure.secID)
{
return(BadRequest());
}
db.Entry(secure).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!secureExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Putvulnerability(int id, vulnerability vulnerability)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != vulnerability.vulID)
{
return(BadRequest());
}
db.Entry(vulnerability).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!vulnerabilityExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Delete(object obj)
{
using (var db = new projectContext(conn.ConnectionString))
{
if (obj is Person)
{
Person p = (Person)obj;
var person = db.Persons.FirstOrDefault(x => x.FirstName == p.FirstName);
db.Persons.Remove(person);
db.SaveChanges();
}
if (obj is Ration)
{
Ration r = (Ration)obj;
var ration = db.Rations.FirstOrDefault(x => x.RationId == r.RationId);
db.Rations.Remove(ration);
db.SaveChanges();
}
if (obj is Table)
{
Table t = (Table)obj;
var table = db.Tables.FirstOrDefault(x => x.TableId == t.TableId);
db.Tables.Remove(table);
db.SaveChanges();
}
}
}
public void Update(object obj)
{
using (var db = new projectContext(conn.ConnectionString))
{
if (obj is Person)
{
Person p = (Person)obj;
var person = db.Persons.FirstOrDefault(x => x.PersonId == p.PersonId);
if (person != null)
{
person.PersonId = p.PersonId;
person.FirstName = p.FirstName;
person.LastName = p.LastName;
person.Email = p.Email;
person.Password = p.Password;
person.PersonType = p.PersonType;
db.SaveChanges();
}
}
if (obj is Ration)
{
Ration r = (Ration)obj;
var ration = db.Rations.FirstOrDefault(x => x.RationId == r.RationId);
if (ration != null)
{
ration.RationId = r.RationId;
ration.Price = r.Price;
ration.Type = r.Type;
ration.Done = r.Done;
ration.TableId = r.TableId;
//if(r.Table != null)
// Update(r.Table);
db.SaveChanges();
}
}
if (obj is Table)
{
Table t = (Table)obj;
var table = db.Tables.FirstOrDefault(x => x.TableId == t.TableId);
if (table != null)
{
table.TableId = t.TableId;
table.Plasace = t.Plasace;
table.Notes = t.Notes;
foreach (var ration in t.RationList)
{
Update(ration);
}
db.SaveChanges();
}
}
}
}
public ActionResult Create([Bind(Include = "id,nombreProyecto,comentario")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "resID,Name,Date,Topic,Details")] resolution resolution)
{
if (ModelState.IsValid)
{
db.resolutions.Add(resolution);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(resolution));
}
public ActionResult Create([Bind(Include = "secID,Name,Date,Topic,Details")] secure secure)
{
if (ModelState.IsValid)
{
db.secures.Add(secure);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(secure));
}
public ActionResult Create([Bind(Include = "id,nombre")] Lenguajes lenguajes)
{
if (ModelState.IsValid)
{
db.Lenguajes.Add(lenguajes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(lenguajes));
}
public ActionResult Create([Bind(Include = "vulID,Name,Date,Topic,Details")] vulnerability vulnerability)
{
if (ModelState.IsValid)
{
db.vulnerabilities.Add(vulnerability);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vulnerability));
}
public void Insert(object obj)
{
using (var db = new projectContext(conn.ConnectionString))
{
if (obj is Person)
{
try
{
Open();
Person p = (Person)obj;
db.Persons.Add(p);
db.SaveChanges();
}
finally
{
Close();
}
}
if (obj is Ration)
{
try
{
Open();
Ration r = (Ration)obj;
db.Rations.Add(r);
db.SaveChanges();
}
finally
{
Close();
}
}
if (obj is Table)
{
try
{
Open();
Table t = (Table)obj;
db.Tables.Add(t);
db.SaveChanges();
}
finally
{
Close();
}
}
}
}
public void Post([FromBody] Tax value)
{
dc.Tax.Add(value);
dc.SaveChanges();
}
public void Post([FromBody] Orders value)
{
dc.Orders.Add(value);
dc.SaveChanges();
}
public void Post([FromBody] Brand value)
{
dc.Brand.Add(value);
dc.SaveChanges();
}
public void Post([FromBody] Product value)
{
dc.Product.Add(value);
dc.SaveChanges();
}
public void SaveChanges()
{
context.SaveChanges();
}
