public ActionResult Post(bool IsNew, SexoModel varSexo) { try { //if (ModelState.IsValid) //{ if (!_tokenManager.GenerateToken()) { return(Json(null, JsonRequestBehavior.AllowGet)); } _ISexoApiConsumer.SetAuthHeader(_tokenManager.Token); var result = ""; var SexoInfo = new Sexo { Clave = varSexo.Clave , Descripcion = varSexo.Descripcion }; result = !IsNew? _ISexoApiConsumer.Update(SexoInfo, null, null).Resource.ToString() : _ISexoApiConsumer.Insert(SexoInfo, null, null).Resource.ToString(); Session["KeyValueInserted"] = result; return(Json(result, JsonRequestBehavior.AllowGet)); //} //return Json(false, JsonRequestBehavior.AllowGet); } catch (ServiceException ex) { return(Json(false, JsonRequestBehavior.AllowGet)); } }
public async Task <IActionResult> Consulta(SexoTransfer sexoTransfer) { SexoModel sexoModel; SexoTransfer sexoLista; try { sexoModel = new SexoModel(httpContext); sexoLista = await sexoModel.Consultar(sexoTransfer); } catch (Exception ex) { sexoLista = new SexoTransfer(); sexoLista.Validacao = false; sexoLista.Erro = true; sexoLista.IncluirMensagem("Erro em SexoController Consulta [" + ex.Message + "]"); } finally { sexoModel = null; } ViewData["Usuario"] = UsuarioNome; if (sexoLista.Erro || !sexoLista.Validacao) { return(View("Filtro", sexoLista)); } else { return(View("Lista", sexoLista)); } }
public async Task <IActionResult> Exclusao(int id) { SexoModel sexoModel; SexoTransfer sexo; try { sexoModel = new SexoModel(httpContext); sexo = await sexoModel.Excluir(id); } catch (Exception ex) { sexo = new SexoTransfer(); sexo.Validacao = false; sexo.Erro = true; sexo.IncluirMensagem("Erro em SexoController Exclusao [" + ex.Message + "]"); } finally { sexoModel = null; } ViewData["Usuario"] = UsuarioNome; if (sexo.Erro || !sexo.Validacao) { return(View("Form", sexo)); } else { return(RedirectToAction("Lista")); } }
public async Task <IActionResult> Form(int id) { SexoModel sexoModel; SexoTransfer sexo; try { sexoModel = new SexoModel(httpContext); if (id > 0) { sexo = await sexoModel.ConsultarPorId(id); } else { sexo = null; } } catch { sexo = new SexoTransfer(); sexo.Validacao = false; sexo.Erro = true; sexo.IncluirMensagem("Erro em SexoController Form"); } finally { sexoModel = null; } ViewData["Usuario"] = UsuarioNome; return(View(sexo)); }
public SexoModel RecuperarPeloId(int id) { SexoModel ret = null; Connection(); using (SqlCommand command = new SqlCommand("SELECT * FROM Sexo WHERE Id = @id", con)) { con.Open(); command.Parameters.AddWithValue("@id", SqlDbType.Int).Value = id; var reader = command.ExecuteReader(); if (reader.Read()) { ret = new SexoModel() { Id = (int)reader["Id"], Nome = (string)reader["Nome"], Sigla = (string)reader["Sigla"], Ativo = (bool)reader["Ativo"] }; } } return(ret); }
public IActionResult Listar() { SexoModel sexoModel; SexoTransfer sexoLista; try { sexoModel = new SexoModel(); sexoLista = sexoModel.Consultar(new SexoTransfer()); } catch (Exception ex) { sexoLista = new SexoTransfer(); sexoLista.Validacao = false; sexoLista.Erro = true; sexoLista.IncluirMensagem("Erro em SexoController Listar [" + ex.Message + "]"); } finally { sexoModel = null; } sexoLista.TratarLinks(); if (sexoLista.Erro || !sexoLista.Validacao) { return BadRequest(sexoLista); } else { return Ok(sexoLista); } }
public IActionResult ConsultarPorId(int id) { SexoModel sexoModel; SexoTransfer sexo; try { sexoModel = new SexoModel(); if (id > 0) { sexo = sexoModel.ConsultarPorId(id); } else { sexo = null; } } catch (Exception ex) { sexo = new SexoTransfer(); sexo.Validacao = false; sexo.Erro = true; sexo.IncluirMensagem("Erro em SexoController ConsultarPorId [" + ex.Message + "]"); } finally { sexoModel = null; } sexo.TratarLinks(); if (sexo.Erro || !sexo.Validacao) { return BadRequest(sexo); } else { return Ok(sexo); } }
public IActionResult Incluir(SexoTransfer sexoTransfer) { SexoModel sexoModel; SexoTransfer sexo; try { sexoModel = new SexoModel(); sexo = sexoModel.Incluir(sexoTransfer); } catch (Exception ex) { sexo = new SexoTransfer(); sexo.Validacao = false; sexo.Erro = true; sexo.IncluirMensagem("Erro em SexoController Incluir [" + ex.Message + "]"); } finally { sexoModel = null; } sexo.TratarLinks(); if (sexo.Erro || !sexo.Validacao) { return BadRequest(sexo); } else { string uri = Url.Action("ConsultarPorId", new { id = sexo.Sexo.Id }); return Created(uri, sexo); } }
public int Salvar(SexoModel sexoModel) { var ret = 0; var model = RecuperarPeloId(sexoModel.Id); if (model == null) { Connection(); using (SqlCommand command = new SqlCommand(" INSERT INTO Sexo ( Nome, " + " Sigla, " + " Ativo " + " ) " + " VALUES ( @Nome, " + " @Sigla, " + " @Ativo " + " ); " + " select convert( int, scope_identity() " + " )", con)) { con.Open(); command.Parameters.AddWithValue("@Nome", SqlDbType.VarChar).Value = sexoModel.Nome; command.Parameters.AddWithValue("@Sigla", SqlDbType.VarChar).Value = sexoModel.Sigla; command.Parameters.AddWithValue("@Ativo", SqlDbType.Int).Value = sexoModel.Ativo; ret = (int)command.ExecuteScalar(); } } else { Connection(); using (SqlCommand command = new SqlCommand(" UPDATE Sexo" + " SET Nome=@Nome," + " Sigla=@Sigla," + " Ativo=@Ativo" + " WHERE Id=@Id", con)) { con.Open(); command.Parameters.AddWithValue("@Nome", SqlDbType.VarChar).Value = sexoModel.Nome; command.Parameters.AddWithValue("@Sigla", SqlDbType.VarChar).Value = sexoModel.Sigla; command.Parameters.AddWithValue("@Ativo", SqlDbType.Int).Value = sexoModel.Ativo; command.Parameters.AddWithValue("@Id", SqlDbType.Int).Value = sexoModel.Id; if (command.ExecuteNonQuery() > 0) { ret = sexoModel.Id; } } } return(ret); }
public ActionResult AddSexo(int rowIndex = 0, int functionMode = 0, string id = "0") { int ModuleId = (Session["CurrentModuleId"] != null) ? Convert.ToInt32(Session["CurrentModuleId"]) : 0; ViewBag.currentRowIndex = rowIndex; ViewBag.functionMode = functionMode; ViewBag.Consult = false; var permission = PermissionHelper.GetRoleObjectPermission(SessionHelper.Role, 43966); ViewBag.Permission = permission; if (!_tokenManager.GenerateToken()) { return(null); } _ISexoApiConsumer.SetAuthHeader(_tokenManager.Token); SexoModel varSexo = new SexoModel(); if (id.ToString() != "0") { var SexosData = _ISexoApiConsumer.ListaSelAll(0, 1000, "Sexo.Clave=" + id, "").Resource.Sexos; if (SexosData != null && SexosData.Count > 0) { var SexoData = SexosData.First(); varSexo = new SexoModel { Clave = SexoData.Clave , Descripcion = SexoData.Descripcion }; } } if (!_tokenManager.GenerateToken()) { return(Json(null, JsonRequestBehavior.AllowGet)); } return(PartialView("AddSexo", varSexo)); }
public JsonResult SalvarSexo(SexoModel sexoModel) { var resultado = "OK"; var mensagens = new List <string>(); var idSalvo = string.Empty; if (!ModelState.IsValid) { resultado = "AVISO"; mensagens = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList(); } else { try { sexoRepositorio = new SexoRepositorio(); var id = sexoRepositorio.Salvar(sexoModel); if (id > 0) { idSalvo = id.ToString(); } else { resultado = "ERRO"; } }catch (Exception ex) { resultado = "ERRO"; throw new Exception(ex.Source); } } return(Json(new { Resultado = resultado, Mensagens = mensagens, IdSalvo = idSalvo })); }
public ActionResult Create(int Id = 0, int consult = 0, int ModuleId = 0) { if (ModuleId == 0) { ModuleId = (Session["CurrentModuleId"] != null) ? Convert.ToInt32(Session["CurrentModuleId"]) : 0; } else { Session["CurrentModuleId"] = ModuleId; } var permission = PermissionHelper.GetRoleObjectPermission(SessionHelper.Role, 43966, ModuleId); if ((!permission.New && Id.ToString() == "0") || (!permission.Edit && Id.ToString() != "0" && (!permission.Consult && consult == 1))) { Response.Redirect("~/"); } ViewBag.Permission = permission; var varSexo = new SexoModel(); varSexo.Clave = Id; ViewBag.ObjectId = "43966"; ViewBag.Operation = "New"; ViewBag.IsNew = true; if ((Id.GetType() == typeof(string) && Id.ToString() != "") || ((Id.GetType() == typeof(int) || Id.GetType() == typeof(Int16) || Id.GetType() == typeof(Int32) || Id.GetType() == typeof(Int64) || Id.GetType() == typeof(short)) && Id.ToString() != "0")) { ViewBag.IsNew = false; ViewBag.Operation = "Update"; _tokenManager.GenerateToken(); _ISpartane_FileApiConsumer.SetAuthHeader(_tokenManager.Token); _ISexoApiConsumer.SetAuthHeader(_tokenManager.Token); var SexosData = _ISexoApiConsumer.ListaSelAll(0, 1000, "Sexo.Clave=" + Id, "").Resource.Sexos; if (SexosData != null && SexosData.Count > 0) { var SexoData = SexosData.First(); varSexo = new SexoModel { Clave = SexoData.Clave , Descripcion = SexoData.Descripcion }; } } if (!_tokenManager.GenerateToken()) { return(Json(null, JsonRequestBehavior.AllowGet)); } ViewBag.Consult = consult == 1; if (consult == 1) { ViewBag.Operation = "Consult"; } var viewInEframe = false; var isPartial = false; var isMR = false; var nameMR = string.Empty; var nameAttribute = string.Empty; if (Request.QueryString["isPartial"] != null) { isPartial = Convert.ToBoolean(Request.QueryString["isPartial"]); } if (Request.QueryString["isMR"] != null) { isMR = Convert.ToBoolean(Request.QueryString["isMR"]); } if (Request.QueryString["nameMR"] != null) { nameMR = Request.QueryString["nameMR"].ToString(); } if (Request.QueryString["nameAttribute"] != null) { nameAttribute = Request.QueryString["nameAttribute"].ToString(); } if (Request.QueryString["viewInEframe"] != null) { viewInEframe = Convert.ToBoolean(Request.QueryString["viewInEframe"]); } ViewBag.isPartial = isPartial; ViewBag.isMR = isMR; ViewBag.nameMR = nameMR; ViewBag.nameAttribute = nameAttribute; ViewBag.viewInEframe = viewInEframe; return(View(varSexo)); }
// Quem for dar um NEW passa dados que vão vir da tela e serão validados e cadastrados public SexoBusiness(SexoModel modelo_) { this._modelo = modelo_; }