public ActionResult AlterarUsuario()
{
int Id = Convert.ToInt32(Session["mercadoID"]);
using (EconobuyEntities db = new EconobuyEntities())
{
var alter = (from mer in db.tb_mercado
join end in db.tb_endereco on
mer.end_in_codigo equals end.end_in_codigo
join merImg
in db.tb_mercado_img on mer.mer_in_codigo
equals merImg.mer_in_codigo
where mer.mer_in_codigo == Id
select new AlteraMercado
{
User = mer.mer_st_user,
Senha = mer.mer_st_senha,
Email = mer.mer_st_email,
Telefone_1 = end.end_st_tel1,
Telefone_2 = end.end_st_tel2,
EndID = end.end_in_codigo,
MerID = mer.mer_in_codigo,
ImgID = merImg.mer_img_in_codigo
});
if (alter != null)
{
AlteraMercado alt = alter.First();
return(View(alt));
}
else
{
return(View());
}
}
}
public ActionResult AlteraUsuario(AlteraMercado alt, HttpPostedFileBase imgMercado)
{
HttpPostedFileBase file = Request.Files["img"];
if (file.ContentLength > 0)
{
alt.imgMercado = ConvertToBytes(file);
}
using (EconobuyEntities db = new EconobuyEntities())
{
if (!ModelState.IsValid)
{
return(View("AlterarUsuario", alt));
}
else
{
tb_endereco end = db.tb_endereco.Find(alt.EndID);
tb_mercado mer = db.tb_mercado.Find(alt.MerID);
tb_mercado_img img = db.tb_mercado_img.Find(alt.ImgID);
if (alt != null)
{
mer.mer_st_user = alt.User;
mer.mer_st_senha = alt.Senha;
mer.mer_st_email = alt.Email;
end.end_st_tel1 = alt.Telefone_1;
end.end_st_tel2 = alt.Telefone_2;
if (alt.imgMercado != null)
{
img.mer_img = alt.imgMercado;
}
}
db.SaveChanges();
return(RedirectToAction("Home", "Mercado"));
}
}
}
