// Busca pelo titulo
public Modulos Buscar(string txmodulo = "")
{
try
{
Modulos mods = new Modulos();
string qry = "";
qry += "SELECT * FROM modulos WHERE txmodulo LIKE '%" + txmodulo.Replace(" ", "%") + "%'";
Connection session = new Connection();
Query query = session.CreateQuery(qry);
IDataReader reader = query.ExecuteQuery();
if (reader.Read())
{
mods.idmodulo.value = Convert.ToInt32(reader["idmodulo"]);
mods.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
mods.txmodulo.value = Convert.ToString(reader["txmodulo"]);
mods.flinserir.value = Convert.ToInt32(reader["flinserir"]);
mods.flalterar.value = Convert.ToInt32(reader["flalterar"]);
mods.flexcluir.value = Convert.ToInt32(reader["flexcluir"]);
}
reader.Close();
session.Close();
return(mods);
}
catch (Exception error)
{
throw error;
}
}
// Gravar novo modulo
public int Gravar(Modulos rs)
{
try
{
int idmodulo = 0;
string qry = "";
qry += "INSERT INTO modulos (idaplicativo, txmodulo, flinserir, flalterar, flexcluir) output INSERTED.idmodulo ";
qry += "VALUES (" + rs.idaplicativo.value + ", '" + rs.txmodulo.value + "', " + rs.flinserir.value + ", " + rs.flalterar.value + ", " + rs.flexcluir.value + ")";
Connection session = new Connection();
Query query = session.CreateQuery(qry);
// Retorna o identificador
idmodulo = query.ExecuteScalar();
// Atualizar registro para registro de auditoria
rs.idmodulo.value = idmodulo;
session.Close();
// Auditoria
Audit.Check("Modulos", "I", idmodulo, rs);
return(idmodulo);
}
catch (Exception erro)
{
throw erro;
}
}
// Lista modulos
public List <Modulos> Listar()
{
try
{
List <Modulos> mods = new List <Modulos>();
string qry = "";
qry += "SELECT * FROM modulos ORDER BY txmodulo";
Connection session = new Connection();
Query query = session.CreateQuery(qry);
IDataReader reader = query.ExecuteQuery();
while (reader.Read())
{
Modulos temp = new Modulos();
temp.idmodulo.value = Convert.ToInt32(reader["idmodulo"]);
temp.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
temp.txmodulo.value = Convert.ToString(reader["txmodulo"]);
temp.flinserir.value = Convert.ToInt32(reader["flinserir"]);
temp.flalterar.value = Convert.ToInt32(reader["flalterar"]);
temp.flexcluir.value = Convert.ToInt32(reader["flexcluir"]);
mods.Add(temp);
}
reader.Close();
session.Close();
return(mods);
}
catch (Exception error)
{
throw error;
}
}
public async Task <int> Insert(Modulos value)
{
using (SqlConnection conn = new SqlConnection(_cnx))
{
using (SqlCommand cmd = new SqlCommand("Seg_Modulo_Insertar", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@IdModulo", Value = value.IdModulo, Direction = System.Data.ParameterDirection.Output
});
cmd.Parameters.Add(new SqlParameter("@IdAplicativo", value.IdAplicativo));
cmd.Parameters.Add(new SqlParameter("@NomModulo", value.NomModulo));
cmd.Parameters.Add(new SqlParameter("@IsModuloActivo", value.IsModuloActivo));
cmd.Parameters.Add(new SqlParameter("@RegCreateIdUsuario", value.RegCreateIdUsuario));
await conn.OpenAsync();
await cmd.ExecuteNonQueryAsync();
int id = (int)cmd.Parameters["@IdModulo"].Value;
return(id);
}
}
}
protected void Insert(Modulos modulos)
{
try
{
OpenConnection();
SqlCommand cmdSave = new SqlCommand("INSERT INTO modulos (desc_modulo,ejecuta)" +
"values(@desc_modulo,@ejecuta)" +
"select @@identity ", sqlConn);
cmdSave.Parameters.Add("@desc_modulo", SqlDbType.VarChar, 50).Value = modulos.desc_modulo;
cmdSave.Parameters.Add("@ejecuta", SqlDbType.VarChar, 50).Value = modulos.ejecuta;
modulos.ID = Decimal.ToInt32((decimal)cmdSave.ExecuteScalar());
//cmdSave.ExecuteNonQuery();
}
catch (Exception Ex)
{
Exception ExceptionManejada = new Exception("Erro al crear modulo", Ex);
throw ExceptionManejada;
}
finally
{
CloseConnection();
}
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtNombre.Text) || string.IsNullOrEmpty(txtRaiz.Text) || String.IsNullOrEmpty(txtHijo.Text))
{
throw new Exception(Mensajes.CamposVacios);
}
//if (item.Nombre == txtNombre.Text || item.Comando == txtComando.Text)
// throw new Exception(Mensajes.NingunCambio);
item = new Modulos()
{
IDModulo = (txtHijo.Text == "") ? 0 : Convert.ToInt32(txtHijo.Text),
Comando = txtRaiz.Text,
Nombre = txtNombre.Text,
Estado = chEstado.Checked,
};
if (!metodo.Grabar(item))
{
throw new Exception(metodo.Error);
}
XtraMessageBox.Show("Engraving done successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
Mostrar();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected void btnGravar_Click(object sender, EventArgs e)
{
DateTime dti = Convert.ToDateTime(tbDtinicial.Text), dtf = Convert.ToDateTime(tbDtFinal.Text);
DateTime dtiOc = Convert.ToDateTime(Session["dti"]), dtfOc = Convert.ToDateTime(Session["dtf"]);
if (dti < dtf && dti >= dtiOc && dtf <= dtfOc)
{
int codigo = 0;
if (hfCod.Value != "")
{
codigo = Convert.ToInt32(hfCod.Value);
}
OfertaCursoModulo ocm = new OfertaCursoModulo(codigo, Convert.ToDateTime(tbDtinicial.Text), Convert.ToDateTime(tbDtFinal.Text), Convert.ToInt32(hfCodMod.Value), Convert.ToInt32(hfOferta.Value));
if (ocm.GravarOCM())
{
ocm.GravarProfOCM(ocm.Cod, Convert.ToInt32(hfprof.Value));
Novo();
Modulos mod = new Modulos();
gvModulos.DataSource = mod.PesqModCurso(int.Parse(Request.QueryString["cur"]));
gvModulos.DataBind();
btnFinal.Visible = true;
btnGravar.Visible = false;
}
}
else
{
Utils u = new Utils();
u.MsgBox(this, "Verifique a Data inicial e a Data Final");
}
}
protected void RecuperarModulos()
{
Modulos mod = new Modulos();
gvModulos.DataSource = mod.PesqModCurso(Convert.ToInt32(hfCod.Value));
gvModulos.DataBind();
}
private void btnReturn_Click(object sender, EventArgs e)
{
this.Hide();
Modulos ventana = new Modulos();
ventana.Show();
}
/// <summary>
/// Validar si tiene permiso para ejecutar la accion, consulta bd.
/// </summary>
/// <param name="mod"></param>
/// <param name="accion"></param>
/// <param name="idUser"></param>
/// <returns></returns>
public static bool ValidarEjecutarAccion(Modulos mod, AccionCrud accion, int idUser)
{
var result = false;
var cu = new ControlUsuario();
if (idUser <= 0)
{
return(false);
}
var user = GetUsuarioEnSession();
if (user != null)
{
if (user.IdPerfil == 1)
{
return(true);
}
}
//numero del modulo
var idMod = (int)mod;
//var numAccion = (int)accion;
//buscamos si el modulo esta asignado al usuario
var reg = cu.GetModuloUsuarioById(idMod, idUser);
if (reg != null)
{
result = ValidarAccion(accion, reg.Acciones);
}
return(result);
}
public List <Modulos> ListarModulosUsuario(int filt, int IDUsuario, string jefatura)
{
List <Modulos> lista = new List <Modulos>();
Conexion con = new Conexion();
SqlCommand cmd = con.AbrirConexionIntranet();
if (cmd != null)
{
cmd.CommandText = "SP_Asignacion_Usuarios";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@filt", filt);
cmd.Parameters.AddWithValue("@idUsuario", IDUsuario);
cmd.Parameters.AddWithValue("@nombrejefatura", jefatura);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Modulos task = new Modulos();
task.IDModulo = Convert.ToInt32(reader["idModulo"].ToString());
task.Nombre_modulo = reader["Nombre_Mod"].ToString();
task.desc_modulo = reader["Url_Modulo"].ToString();
lista.Add(task);
}
}
con.CerrarConexion();
return(lista);
}
public IHttpActionResult PutModulos(int id, Modulos modulos)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != modulos.Id)
{
return(BadRequest());
}
db.Entry(modulos).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ModulosExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> PutModulos([FromRoute] int id, [FromBody] Modulos modulos)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != modulos.Id)
{
return(BadRequest());
}
_context.Entry(modulos).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ModulosExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult DeleteConfirmed(int id)
{
Modulos modulos = db.Modulos.Find(id);
db.Modulos.Remove(modulos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(Modulos modulos)
{
if (ModelState.IsValid)
{
db.Entry(modulos).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modulos));
}
public ActionResult Edit([Bind(Include = "Modulos_Id,Nombre_Modulos")] Modulos modulos)
{
if (ModelState.IsValid)
{
db.Entry(modulos).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modulos));
}
public IHttpActionResult GetOne(int id)
{
Modulos modulos = db.Modulos.Find(id);
if (modulos == null)
{
return(NotFound());
}
return(Ok(modulos));
}
public ActionResult Create([Bind(Include = "Modulos_Id,Nombre_Modulos")] Modulos modulos)
{
if (ModelState.IsValid)
{
db.Modulos.Add(modulos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modulos));
}
public ActionResult Edit([Bind(Include = "Id,Nome,Descricao,Hierarquia,CursosId")] Modulos modulos, Cursos cursos, string name)
{
if (ModelState.IsValid)
{
db.Entry(modulos).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CursosId = new SelectList(db.Cursos, "Id", "Nome", modulos.CursosId);
return(View(modulos));
}
public ActionResult Create(Modulos modulos)
{
if (ModelState.IsValid)
{
db.Modulos.Add(modulos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modulos));
}
public ActionResult Create([Bind(Include = "Id,Nome,Descricao,Hierarquia,CursosId")] Modulos modulos)
{
if (ModelState.IsValid)
{
db.Modulos.Add(modulos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CursosId = new SelectList(db.Cursos, "Id", "Nome", modulos.CursosId);
return(View(modulos));
}
public ActionResult Detail(int?id, Modulos model)
{
ModulRepository objmod = new ModulRepository(SessionCustom);
ModullanguageRepository modullang = new ModullanguageRepository(SessionCustom);
objmod.Entity = model.Modul;
try
{
SessionCustom.Begin();
if (id != null)
{
objmod.Entity.ModulId = id;
objmod.Update();
modullang.Entity.ModulId = id;
modullang.Entity.LanguageId = CurrentLanguage.LanguageId;
modullang.Load();
if (modullang.Entity.Name != null)
{
modullang.Entity.Name = model.Modul.Name;
modullang.Update();
}
else
{
modullang.Entity.Name = model.Modul.Name;
modullang.Insert();
}
this.InsertAudit("Update", this.Module.Name + " -> " + objmod.Entity.Name);
}
else
{
objmod.Entity.IsBasic = false;
int modulId = Convert.ToInt32(objmod.Insert());
modullang.Entity.ModulId = modulId;
modullang.Entity.LanguageId = CurrentLanguage.LanguageId;
modullang.Entity.Name = model.Modul.Name;
modullang.Insert();
this.InsertAudit("Insert", this.Module.Name + " -> " + objmod.Entity.Name);
}
this.SessionCustom.Commit();
}
catch (Exception ex)
{
this.SessionCustom.RollBack();
Utils.InsertLog(this.SessionCustom, "Error " + this.Module.Name, ex.ToString());
}
return(this.RedirectToAction("Index", "Modulos"));
}
public IHttpActionResult PostModulos(Modulos modulos)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Modulos.Add(modulos);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = modulos.Id }, modulos));
}
public async Task <IActionResult> PostModulos([FromBody] Modulos modulos)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Modulos.Add(modulos);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetModulos", new { id = modulos.Id }, modulos));
}
public async Task <IActionResult> Put([FromBody] Modulos value)
{
try
{
await _repository.Update(value);
}
catch (Exception ex)
{
// Guardar Excepción
return(BadRequest(ex.Message.ToString()));
}
return(Ok(value));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Modulos modulos = db.Modulos.Find(id);
if (modulos == null)
{
return(HttpNotFound());
}
return(View(modulos));
}
public IHttpActionResult DeleteModulos(int id)
{
Modulos modulos = db.Modulos.Find(id);
if (modulos == null)
{
return(NotFound());
}
db.Modulos.Remove(modulos);
db.SaveChanges();
return(Ok(modulos));
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int codMod = 0;
Modulos mod = new Modulos(tbNomeModulo.Text, Convert.ToDouble(tbValor.Text));
mod.GravarModulo();
codMod = mod.CodModulo;
Curso cur = new Curso();
cur.GravarCursoModulo(Convert.ToInt32(hfCod.Value), codMod);
tbNomeModulo.Text = "";
tbValor.Text = "";
RecuperarModulos();
}
public static bool AccesoAccionModulo(Modulos mod, AccionCrud accion, int idUser)
{
// var cu = new ControlUsuario();
if (idUser <= 0)
{
return(false);
}
//numero del enumerador
//var idMod = (int)mod;
//buscamos si el usuario tiene acceso al modulo y la accion
return(ValidarEjecutarAccion(mod, accion, idUser));
}
// GET: Turmas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Modulos modulos = db.Modulos.Find(id);
ViewBag.CursosId = new SelectList(db.Cursos.OrderBy(c => c.Nome), "Id", "Nome", modulos.CursosId);
if (modulos == null)
{
return(HttpNotFound());
}
return(View(modulos));
}
