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_;
}
