public ActionResult SaveJson(Supplier e)
{
var resposta = new RespostaHtml {
success = true
};
try
{
if (e.SupplierID == 0)
{
db.Suppliers.Add(e);
}
else
{
db.Suppliers.Attach(e);
db.Entry(e).State = EntityState.Modified;
}
db.SaveChanges();
resposta.Data = e;
}
catch (Exception ex)
{
ex = ErrorException(ex);
resposta.success = false;
resposta.message = ex.Message;
}
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
public ActionResult DeleteJson(Supplier e)
{
var resposta = new RespostaHtml {
success = true
};
var Supplier = (from emp in db.Suppliers
where emp.SupplierID == e.SupplierID
select emp).FirstOrDefault();
if (Supplier == null)
{
resposta.success = false;
resposta.message = "Registro não Encontrado";
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
try
{
db.Suppliers.Remove(Supplier);
db.SaveChanges();
resposta.Data = Supplier;
}
catch (Exception ex)
{
ex = ErrorException(ex);
resposta.success = false;
resposta.message = ex.Message;
}
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
public ActionResult SaveJson(Supplier s)
{
var resposta = new RespostaHtml {
success = true
};
try
{
if (s.SupplierID == 0)
{
//Como eu salvo um registro no Banco de Dados?
db.Suppliers.Add(s);
}
else
{
db.Suppliers.Attach(s);
db.Entry(s).State = EntityState.Modified;
}
db.SaveChanges();
resposta.Data = s;
}
catch (Exception ex)
{
ex = ErrorException(ex);
resposta.success = false;
resposta.message = ex.Message;
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
public ActionResult SaveJson(Employee e)
{
var resposta = new RespostaHtml {
success = false
};
try
{
if (string.IsNullOrWhiteSpace(e.LastName))
{
resposta.message += "LastName Obrigatorio!";
}
if (string.IsNullOrWhiteSpace(e.FirstName))
{
resposta.message += "FistName Obrigatorio!";
}
if (resposta.message != null)
{
throw new Exception(resposta.message);
}
e.Adventista = e.Adventista == null ? false : true;
if (e.EmployeeID == 0)
{
db.Employees.Add(e);
}
else
{
db.Employees.Attach(e);
}
db.Entry(e).State = EntityState.Modified;
db.SaveChanges();
resposta.Data = e;
resposta.success = true;
}
catch (Exception ex)
{
ex = ErrorException(ex);
resposta.success = false;
resposta.message = ex.Message;
}
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
public ActionResult DeleteJson(Employee e)
{
var resposta = new RespostaHtml {
success = true
};
try
{
BusinessEmployee.Delete(e.EmployeeID);
resposta.message = "Excluido com sucesso!";
}
catch (Exception ex)
{
resposta.success = false;
ex = ErrorException(ex);
resposta.message = ex.Message;
}
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
public ActionResult SaveJson(Employee e)
{
var resposta = new RespostaHtml {
success = false
};
try
{
// Usar nossa classe de banco de dados
e.Adventista = e.Adventista == null ? false : true;
BusinessEmployee.Save(e);
resposta.Data = e;
resposta.success = true;
}
catch (Exception ex)
{
ex = ErrorException(ex);
resposta.message = ex.Message;
}
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
public ActionResult SaveJson(Employee e)
{
var resposta = new RespostaHtml {
success = true
};
try
{
//Usar nossa classe de banco de dados.
//Instanciando a base.
var db = new NorthWind();
if (e.Adventista == null)
{
e.Adventista = false;
}
//ou e.Adventista = e.Adventista == null ? false : true;
if (e.EmployeeID == 0)
{
//Como eu salvo um registro no Banco de Dados?
db.Employees.Add(e);
}
else
{
db.Employees.Attach(e);
db.Entry(e).State = EntityState.Modified;
}
db.SaveChanges();
resposta.Data = e;
}
catch (Exception ex)
{
ex = ErrorException(ex);
resposta.success = false;
resposta.message = ex.Message;
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
public ActionResult DeleteJson(int EmployeeID)
{
var resposta = new RespostaHtml {
success = true
};
var db = new NorthWind();
var employee = (from emp in db.Employees
where emp.EmployeeID == EmployeeID
select emp).FirstOrDefault();
if (employee == null)
{
var ex = new Exception("Registro não encontrado");
resposta.success = false;
resposta.message = ex.Message;
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
else
{
db.Employees.Remove(employee);
try
{
db.SaveChanges();
resposta.Data = employee;
}
catch (Exception ex)
{
ex = ErrorException(ex);
resposta.success = false;
resposta.message = ex.Message;
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
}
var empregados = (from emp in db.Employees
select emp).ToList();
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
public ActionResult DeleteJson(int SupplierID)
{
var resposta = new RespostaHtml {
success = true
};
var supplier = (from s in db.Suppliers
where s.SupplierID == SupplierID
select s).FirstOrDefault();
if (supplier == null)
{
var ex = new Exception("Registro não encontrado");
resposta.success = false;
resposta.message = ex.Message;
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
else
{
db.Suppliers.Remove(supplier);
try
{
db.SaveChanges();
resposta.Data = supplier;
}
catch (Exception ex)
{
ex = ErrorException(ex);
resposta.success = false;
resposta.message = ex.Message;
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
}
var fornecedores = (from s in db.Suppliers
select s).ToList();
return(Json(resposta, JsonRequestBehavior.DenyGet));
}
