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 HttpResponseMessage Get()
{
using (masterEntities1 db = new masterEntities1())
{
HttpResponseMessage Response;
Response = Request.CreateResponse("select*from[CurrentDateView]");
return(Response);
}
}
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 string getPecaById(string cod)
{
JavaScriptSerializer js = new JavaScriptSerializer();
using (masterEntities1 db = new masterEntities1())
{
db.Configuration.ProxyCreationEnabled = false;
Peca p = db.Peca.FirstOrDefault(x => x.cod.Equals(cod));
return(js.Serialize(p));
}
}
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 ActionResult Editar(int id)
{
TablaViewModel model = new TablaViewModel();
using (masterEntities1 db = new masterEntities1()) {
var oTabla = db.Tabla.Find(id);
model.Nombre = oTabla.nombre;
model.Correo = oTabla.correo;
model.Fecha = oTabla.fecha;
model.Id = oTabla.id;
}
return(View(model));
}
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));
}
}
}
// GET: Tabla
public ActionResult Index()
{
List <ListaTablaViewModel> lst;
using (masterEntities1 db = new masterEntities1())
{
lst = (from d in db.Tabla
select new ListaTablaViewModel
{
Id = d.id,
Nombre = d.nombre,
Correo = d.correo,
Fecha = d.fecha
}).ToList();
}
return(View(lst));
}
//public List<EmployeeDetails> ShowEmployeeDetails()
//{
// List<EmployeeDetails> details = new List<EmployeeDetails>();
// details.Add(new EmployeeDetails { eid = 101, ename = "zzz", salary = 25000.23m });
// details.Add(new EmployeeDetails { eid = 102, ename = "Yash", salary = 852563.23m });
// details.Add(new EmployeeDetails { eid = 103, ename = "Prash", salary = 12559.23m });
// return details;
//}
public List <EmployeeDetails> ShowEmployeeDetails()
{
List <EmployeeDetails> details = new List <EmployeeDetails>();
details.Add(new EmployeeDetails {
eid = 101, ename = "zzz", salary = 25000.23m
});
details.Add(new EmployeeDetails {
eid = 102, ename = "Yash", salary = 852563.23m
});
details.Add(new EmployeeDetails {
eid = 103, ename = "Prash", salary = 12559.23m
});
var context = new masterEntities1();
var selectResult = from s in context.Employees
select s.Eid;
Console.WriteLine(selectResult);
return(details);
}
public ProductModelMSSQLModelsAccess()
{
masterEntities = DbAccessHelper.MasterEntities;
}
public ModelsAccessSupplierModelMSSQL()
{
masterEntities = DbAccessHelper.MasterEntities;
}
