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()); } }