public ActionResult Create([Bind(Include = "Title,Url,Platform,Score,Genre,Editors_choice,Release_year,ID")] Game game)
{
MyHub notification = new MyHub();
if (ModelState.IsValid)
{
db.Games.Add(game);
db.SaveChanges();
notification.Send();
return(RedirectToAction("Create"));
}
return(View(game));
}
public int AddModel(ProductModel t)
{
Product p = new Product()
{
ProductName = t.ProductName,
UnitPrice = t.UnitPrice,
Package = t.Package,
SupplierId = t.SupplierId,
IsDiscontinued = t.IsDiscontinued
};
masterEntities.Products.Add(p);
masterEntities.SaveChanges();
return(p.Id);
}
public HttpResponseMessage delete(int id)
{
try
{
var result = new HttpResponseMessage(HttpStatusCode.OK);
//result.Content = new StringContent(JsonConvert.SerializeObject(myDb.Testings.ToList()));
//result.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json");
myDb.Testings.Remove(myDb.Testings.Single(p => p.Id == id));
myDb.SaveChanges();
return(result);
}
catch
{
return(new HttpResponseMessage(HttpStatusCode.BadRequest));
}
}
public ActionResult Nuevo(TablaViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (masterEntities1 db = new masterEntities1())
{
var otabla = new Tabla();
otabla.id = model.Id;
otabla.correo = model.Correo;
otabla.fecha = model.Fecha;
otabla.nombre = model.Nombre;
db.Tabla.Add(otabla);
db.SaveChanges();
}
return(Redirect("/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Editar(TablaViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (masterEntities1 db = new masterEntities1())
{
var oTabla = db.tabla.Find(model.Id);
oTabla.correo = model.Correo;
oTabla.fecha_nacimiento = model.Fecha_Nacimiento;
oTabla.nombre = model.Nombre;
db.Entry(oTabla).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("~/Tabla/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Add(Deal obj)
{
try
{
if (ModelState.IsValid)
{
dbContext.Deals.Add(obj);
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
}
//return View("About",TempData["List"]);
return(RedirectToAction("About"));
}
public int AddModel(SupplierModel t)
{
Supplier s = new Supplier()
{
CompanyName = t.CompanyName,
ContactName = t.ContactName,
ContactTitle = t.ContactTitle,
City = t.City,
Country = t.Country,
Phone = t.Phone,
Fax = t.Fax
};
masterEntities.Suppliers.Add(s);
masterEntities.SaveChanges();
return(s.Id);
}
public ActionResult Eliminar(int id)
{
using (masterEntities1 db = new masterEntities1())
{
var oTabla = db.tabla.Find(id);
db.tabla.Remove(oTabla);
db.SaveChanges();
}
return(Redirect("~/Tabla/"));
}
public ActionResult Eliminar(int id)
{
TablaViewModel model = new TablaViewModel();
using (masterEntities1 db = new masterEntities1())
{
var oTabla = db.Tabla.Find(id);
db.Tabla.Remove(oTabla);
db.SaveChanges();
}
return(Redirect("/Tabla"));
}
public string setServico(
//Serviço
int clienteId, decimal valorTotal,
//Usuario
int usuarioId, string senha,
//Peca
int pecaId,
//Usinagem
double grande, double medio, double pequeno
)
{
JavaScriptSerializer js = new JavaScriptSerializer();
using (masterEntities1 db = new masterEntities1())
{
OrdemDeServico servico = new OrdemDeServico()
{
clienteId = clienteId,
Cliente = db.Cliente.First(x => x.id.Equals(clienteId)),
valorTotal = valorTotal,
Peca = db.Peca.First(x => x.id.Equals(pecaId)),
Usinagem = new Usinagem()
{
grande = grande,
medio = medio,
pequeno = pequeno,
},
pecaId = pecaId,
Usuario = db.Usuario.First(x => x.id.Equals(usuarioId)),
usuarioId = usuarioId
};
if (servico.Usuario.funcao.Trim().ToLower() != "atendente")
{
return(js.Serialize("Usuario não autorizado!"));
}
try
{
db.OrdemDeServico.Add(servico);
db.SaveChanges();
return(js.Serialize("Success"));
}
catch (Exception e)
{
return(js.Serialize("Erro" + e.InnerException));
}
}
}
