public tb_sis_formulario_Info Get_Info_formulario(string IdFormulario)
{
EntitiesGeneral oEnti = new EntitiesGeneral();
try
{
tb_sis_formulario_Info Info = new tb_sis_formulario_Info();
var Objeto = oEnti.tb_sis_formulario.FirstOrDefault(var => var.IdFormulario == IdFormulario);
if (Objeto != null)
{
Info.IdFormulario = Objeto.IdFormulario;
Info.cod_Formulario = Objeto.cod_Formulario;
Info.nom_Formulario = Objeto.nom_Formulario;
Info.CodModulo = Objeto.CodModulo;
Info.Text = Objeto.Text;
Info.observacion = Objeto.observacion;
Info.estado = Objeto.estado;
Info.nom_Asembly = Objeto.nom_Asembly;
}
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_sis_formulario_Info info)
{
try
{
using (EntitiesGeneral context = new EntitiesGeneral())
{
var contact = context.tb_sis_formulario.FirstOrDefault(minfo => minfo.IdFormulario == info.IdFormulario);
if (contact != null)
{
contact.cod_Formulario = info.cod_Formulario;
contact.nom_Formulario = info.nom_Formulario;
contact.CodModulo = info.CodModulo;
contact.Text = info.Text;
contact.observacion = info.observacion;
contact.estado = info.estado;
contact.nom_Asembly = info.nom_Asembly;
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 cmb_formulario_EditValueChanged(object sender, EventArgs e)
{
try
{
tb_sis_formulario_Info InfoFormulario = ListInfo_Formulario_Combo_filtrado.FirstOrDefault(v => v.IdFormulario == Convert.ToString(cmb_formulario.EditValue));
txt_CodFormulario.Text = InfoFormulario.IdFormulario;
txt_texto.Text = InfoFormulario.Text;
}
catch (Exception ex)
{
}
}
private void Cargar_Combo_Formulario(string Nom_Asambly, string cod_modelo)
{
try
{
ListInfo_Formulario_Combo_filtrado = new List <tb_sis_formulario_Info>();
ListInfo_Formularios = new List <tb_sis_formulario_Info>();
string sNom_Asembly = txt_asembly.Text;
string sNom_Asembly_sin_extencion = sNom_Asembly.Replace(".exe", "");
sNom_Asembly_sin_extencion = sNom_Asembly_sin_extencion.Replace(".dll", "");
sNom_Asembly_sin_extencion = sNom_Asembly_sin_extencion + ".";
System.Reflection.Assembly Ensamblado;
Ensamblado = System.Reflection.Assembly.LoadFrom(Nom_Asambly);
foreach (Type type in Ensamblado.GetTypes())
{
tb_sis_formulario_Info InfoItem = new tb_sis_formulario_Info();
InfoItem.IdFormulario = type.FullName;
InfoItem.nom_Formulario = type.FullName.Replace(sNom_Asembly_sin_extencion, "");
InfoItem.nom_Asembly = sNom_Asembly;
try
{
InfoItem.CodModulo = InfoItem.nom_Formulario.Substring(0, InfoItem.nom_Formulario.IndexOf("."));
}
catch (Exception ex)
{
}
ListInfo_Formularios.Add(InfoItem);
}
ListInfo_Formulario_Combo_filtrado = ListInfo_Formularios.FindAll(v => v.CodModulo == cod_modelo);
cmb_formulario.Properties.DataSource = ListInfo_Formulario_Combo_filtrado;;
}
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);
}
}
private void gridViewFormulario_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
rpt_I = (tb_sis_formulario_Info)gridViewFormulario.GetFocusedRow();
}
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 void Set_Info(tb_sis_formulario_Info _info)
{
try
{
Info_Formulario = _info;
}
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 List <tb_sis_formulario_Info> Get_List_formulario_x_Modulo(List <tb_modulo_Info> lstModulo)
{
try
{
List <tb_sis_formulario_Info> Lst = new List <tb_sis_formulario_Info>();
var list = new List <string>();
foreach (var item in lstModulo)
{
list.Add(item.CodModulo);
}
EntitiesGeneral oEnti = new EntitiesGeneral();
var Query = from q in oEnti.tb_sis_formulario
where list.Contains(q.CodModulo)
select q;
foreach (var item in Query)
{
tb_sis_formulario_Info Obj = new tb_sis_formulario_Info();
Obj.IdFormulario = item.IdFormulario;
Obj.cod_Formulario = item.cod_Formulario;
Obj.nom_Formulario = item.nom_Formulario;
Obj.CodModulo = item.CodModulo;
Obj.Text = item.Text;
Obj.observacion = item.observacion;
Obj.estado = item.estado;
Obj.nom_Asembly = item.nom_Asembly;
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 Boolean GuardarDB(tb_sis_formulario_Info Info)
{
try
{
return(Odata.GuardarDB(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 tb_sis_formulario_Info Get_Info_formulario(string IdFormulario)
{
try
{
tb_sis_formulario_Info Info = new tb_sis_formulario_Info();
Info = Odata.Get_Info_formulario(IdFormulario);
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 GuardarDB(tb_sis_formulario_Info Info)
{
try
{
List <tb_sis_formulario_Info> Lst = new List <tb_sis_formulario_Info>();
using (EntitiesGeneral Context = new EntitiesGeneral())
{
var Address = new tb_sis_formulario();
Address.IdFormulario = Info.IdFormulario = "Frm" + Info.CodModulo + "_" + Get_Numero(Info.CodModulo);
Address.cod_Formulario = (Info.cod_Formulario == "" || Info.cod_Formulario == null) ? Address.IdFormulario : Info.cod_Formulario;
Address.nom_Formulario = Info.nom_Formulario;
Address.CodModulo = Info.CodModulo;
Address.Text = Info.Text;
Address.observacion = Info.observacion;
Address.estado = Info.estado;
Address.nom_Asembly = Info.nom_Asembly;
Context.tb_sis_formulario.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());
}
}
