public List <tb_modulo_Info> Get_list_Modulo(Boolean Se_Cierra)
{
try
{
List <tb_modulo_Info> Lst = new List <tb_modulo_Info>();
EntitiesGeneral oEnti = new EntitiesGeneral();
var Query = from q in oEnti.tb_modulo
where q.Se_Cierra == Se_Cierra
select q;
foreach (var item in Query)
{
tb_modulo_Info Obj = new tb_modulo_Info();
Obj.CodModulo = item.CodModulo;
Obj.Descripcion = item.Descripcion;
Obj.Nom_Carpeta = item.Nom_Carpeta;
Obj.Se_Cierra = item.Se_Cierra;
Lst.Add(Obj);
}
return(Lst);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "",
"", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.ToString() + " " + ex.Message;
throw new Exception(ex.ToString());
}
}
public tb_modulo_Info Get_Info_Modulo(string CodModulo)
{
EntitiesGeneral oEnti = new EntitiesGeneral();
try
{
tb_modulo_Info Info = new tb_modulo_Info();
var Objeto = oEnti.tb_modulo.FirstOrDefault(var => var.CodModulo == CodModulo);
if (Objeto != null)
{
Info.CodModulo = Objeto.CodModulo;
Info.Descripcion = Objeto.Descripcion;
Info.Se_Cierra = Objeto.Se_Cierra;
}
return(Info);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "",
"", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.ToString() + " " + ex.Message;
throw new Exception(ex.ToString());
}
}
public Boolean ModificarDB(tb_modulo_Info info)
{
try
{
using (EntitiesGeneral context = new EntitiesGeneral())
{
var contact = context.tb_modulo.FirstOrDefault(minfo => minfo.CodModulo == info.CodModulo);
if (contact != null)
{
contact.Descripcion = info.Descripcion;
contact.Nom_Carpeta = info.Nom_Carpeta;
contact.Se_Cierra = info.Se_Cierra;
context.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "",
"", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.ToString() + " " + ex.Message;
throw new Exception(ex.ToString());
}
}
public tb_modulo_Info get_info(string CodModulo)
{
try
{
tb_modulo_Info info = new tb_modulo_Info();
using (Entities_general Context = new Entities_general())
{
tb_modulo Entity = Context.tb_modulo.FirstOrDefault(q => q.CodModulo == CodModulo);
if (Entity == null)
{
return(null);
}
info = new tb_modulo_Info
{
CodModulo = Entity.CodModulo,
Descripcion = Entity.Descripcion,
Nom_Carpeta = Entity.Nom_Carpeta,
Se_Cierra = Entity.Se_Cierra == null ? false : Convert.ToBoolean(Entity.Se_Cierra)
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public Boolean GuardarDB(tb_modulo_Info Info)
{
try
{
List <tb_modulo_Info> Lst = new List <tb_modulo_Info>();
using (EntitiesGeneral Context = new EntitiesGeneral())
{
var Address = new tb_modulo();
Address.CodModulo = Info.CodModulo;
Address.Descripcion = Info.Descripcion;
Address.Nom_Carpeta = Info.Nom_Carpeta;
Address.Se_Cierra = Info.Se_Cierra;
Context.tb_modulo.Add(Address);
Context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
string arreglo = ToString();
tb_sis_Log_Error_Vzen_Data oDataLog = new tb_sis_Log_Error_Vzen_Data();
tb_sis_Log_Error_Vzen_Info Log_Error_sis = new tb_sis_Log_Error_Vzen_Info(ex.ToString(), "", arreglo, "",
"", "", "", "", DateTime.Now);
oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
mensaje = ex.ToString() + " " + ex.Message;
throw new Exception(ex.ToString());
}
}
private void ucGe_Menu_event_btnconsultar_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
info_modulo = (tb_modulo_Info)gridViewmodulo.GetFocusedRow();
if (info_modulo != null)
{
frm = new FrmGE_ModuloMant();
frm.event_FrmGE_ModuloMant_FormClosing += frm_event_FrmGE_ModuloMant_FormClosing;
frm.Text = frm.Text + "***CONSULTAR REGISTRO***";
frm.info_mod = info_modulo;
frm.set_Modulo(info_modulo);
frm.set_Accion(Cl_Enumeradores.eTipo_action.consultar);
frm.ShowDialog();
}
else
{
MessageBox.Show("Seleccione un Registro ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return;
}
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool modificarDB(tb_modulo_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_modulo Entity = Context.tb_modulo.FirstOrDefault(q => q.CodModulo == info.CodModulo);
if (Entity == null)
{
return(false);
}
Entity.CodModulo = info.CodModulo;
Entity.Descripcion = info.Descripcion;
Entity.Nom_Carpeta = info.Nom_Carpeta;
Entity.Se_Cierra = info.Se_Cierra;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public ActionResult Modificar(tb_modulo_Info model)
{
if (!bus_modulo.modificarDB(model))
{
return(View(model));
}
return(RedirectToAction("Index"));
}
public ActionResult Modificar(string CodModulo = "")
{
tb_modulo_Info model = bus_modulo.get_info(CodModulo);
if (model == null)
{
return(RedirectToAction("Index"));
}
return(View(model));
}
public bool modificarDB(tb_modulo_Info info)
{
try
{
return(odata.modificarDB(info));
}
catch (Exception)
{
throw;
}
}
public ActionResult Nuevo(tb_modulo_Info model)
{
if (bus_modulo.validar_existe_CodModulo(model.CodModulo))
{
ViewBag.mensaje = "El código ya se encuentra registrado";
return(View(model));
}
if (!bus_modulo.guardarDB(model))
{
return(View(model));
}
return(RedirectToAction("Index"));
}
public Boolean ModificarDB(tb_modulo_Info info)
{
try
{
return(data.ModificarDB(info));
}
catch (Exception ex)
{
Core.Erp.Info.Log_Exception.LoggingManager.Logger.Log(Core.Erp.Info.Log_Exception.LoggingCategory.Error, ex.Message);
throw new Core.Erp.Info.Log_Exception.DalException(string.Format("", "ModificarDB", ex.Message), ex)
{
EntityType = typeof(tb_modulo_Bus)
};
}
}
public void set_Modulo(tb_modulo_Info info)
{
try
{
txtcodigo.Text = info.CodModulo;
txtdescripcion.Text = info.Descripcion;
txtcarpeta.Text = info.Nom_Carpeta;
chk_Se_cierra.Checked = info_mod.Se_Cierra == null ? false : (bool)info_mod.Se_Cierra;
info_mod = info;
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool guardarDB(tb_modulo_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_modulo Entity = new tb_modulo
{
CodModulo = info.CodModulo,
Descripcion = info.Descripcion,
Nom_Carpeta = info.Nom_Carpeta,
Se_Cierra = info.Se_Cierra
};
Context.tb_modulo.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
private void cmb_modulo_EditValueChanged(object sender, EventArgs e)
{
try
{
if (cmb_modulo.EditValue != null)
{
tb_modulo_Info items = lst_modulo.FirstOrDefault(q => q.CodModulo == cmb_modulo.EditValue.ToString());
if (Accion == Cl_Enumeradores.eTipo_action.grabar)
{
if (items != null)
{
string carpeta = items.Nom_Carpeta;
string codModulo = cmb_modulo.EditValue.ToString();
string num = bus_alerta.Get_Numero(codModulo);
txt_Id.Text = cmb_modulo.EditValue.ToString() + "_" + num;
txt_tabla.Text = "vw" + codModulo + "_Alerta_" + num;
txt_class_info.Text = carpeta + ".X" + codModulo + "_" + num + "_Info";
txt_class_bus.Text = carpeta + ".X" + codModulo + "_" + num + "_Bus";
txt_class_data.Text = carpeta + ".X" + codModulo + "_" + num + "_Data";
txt_class_rpt.Text = carpeta + ".X" + codModulo + "_" + num + "_Rpt";
txt_asembly.Text = "Core.Erp.Alertas";
txt_frm.Text = carpeta + ".X" + codModulo + "_" + num + "_frm";
//Nom_SP = "sp" + codModulo + "_Rpt" + num;
}
}
}
}
catch (Exception ex)
{
string NameMetodo = System.Reflection.MethodBase.GetCurrentMethod().Name;
NameMetodo = NameMetodo + " - " + ex.ToString();
Log_Error_bus.Log_Error(NameMetodo + " - " + ex.ToString());
MessageBox.Show(NameMetodo + " " + param.Get_Mensaje_sys(enum_Mensajes_sys.Error_comunicarse_con_sistemas)
, param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Nuevo()
{
tb_modulo_Info model = new tb_modulo_Info();
return(View());
}
