public Boolean AnularDB(imp_catalogo_Info info) { try { using (EntitiesImportacion context = new EntitiesImportacion()) { var contact = context.imp_catalogo.FirstOrDefault(catalogo => catalogo.IdCatalogoImport == info.IdCatalogoImport && catalogo.IdCatalogoImport_tipo == info.IdCatalogoImport_tipo); if (contact != null) { contact.Estado = "I"; 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 llamar_formulario_catalogo(Cl_Enumeradores.eTipo_action Accion) { try { imp_catalogo_Info row = new imp_catalogo_Info(); row.IdCatalogo_tipo = listBoxControl_catalogo_tipo.SelectedValue == null ? 0 : Convert.ToInt32(listBoxControl_catalogo_tipo.SelectedValue); if (Accion != Cl_Enumeradores.eTipo_action.grabar) { row = (imp_catalogo_Info)gridView_catalogo.GetFocusedRow(); if (row == null) { MessageBox.Show("Seleccione un registro", param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (!row.estado) { MessageBox.Show("El registro seleccionado se encuentra anulado", param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } frmImp_catalogo_mant frm = new frmImp_catalogo_mant(); frm.set_accion(Accion); frm.set_info(row); frm.ShowDialog(); load_data_catalogo(); } catch (Exception ex) { Log_Error_bus.Log_Error(ex.ToString()); MessageBox.Show(ex.ToString(), param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool guardarDB(imp_catalogo_Info info) { try { using (Entities_importacion Context = new Entities_importacion()) { imp_catalogo Entity = new imp_catalogo(); Entity.IdCatalogo_tipo = info.IdCatalogo_tipo; Entity.IdCatalogo = info.IdCatalogo = get_id(); Entity.ca_descripcion = info.ca_descripcion; Entity.estado = info.estado = true; Context.imp_catalogo.Add(Entity); Context.SaveChanges(); } return(true); } catch (Exception ex) { string mensaje = ""; 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); mensaje = ex.ToString(); oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje); throw new Exception(ex.ToString()); } }
public bool anularDB(imp_catalogo_Info info) { try { using (Entities_importacion Context = new Entities_importacion()) { imp_catalogo Entity = Context.imp_catalogo.FirstOrDefault(q => q.IdCatalogo == info.IdCatalogo); if (Entity == null) { return(false); } Entity.estado = info.estado = false; Context.SaveChanges(); } return(true); } catch (Exception ex) { string mensaje = ""; 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); mensaje = ex.ToString(); oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje); throw new Exception(ex.ToString()); } }
public imp_catalogo_Info get_info(int IdCatalogo_tipo, int IdCatalogo) { try { imp_catalogo_Info info = new imp_catalogo_Info(); using (Entities_importacion Context = new Entities_importacion()) { imp_catalogo Entity = Context.imp_catalogo.FirstOrDefault(q => q.IdCatalogo_tipo == IdCatalogo_tipo && q.IdCatalogo == IdCatalogo); if (Entity == null) { return(null); } info = new imp_catalogo_Info { IdCatalogo = Entity.IdCatalogo, IdCatalogo_tipo = Entity.IdCatalogo_tipo, ca_descripcion = Entity.ca_descripcion, estado = Entity.estado }; } return(info); } catch (Exception) { throw; } }
public void setTipo(imp_catalogo_Info inf) { try { this.txtIdCat.Text = inf.IdCatalogoImport; this.txtCatTipo.Text = inf.IdCatalogoImport_tipo.ToString(); this.txtNombre.Text = inf.Nombre; this.txtAbreviatura.Text = inf.Abrebiatura; this.txtNombreIngles.Text = inf.NombreIngles; try { if (inf.Estado == "A") { this.chbEstado.Checked = true; } else { this.chbEstado.Checked = false; } } catch (Exception ex) { Log_Error_bus.Log_Error(ex.ToString()); } } catch (Exception ex) { Log_Error_bus.Log_Error(ex.ToString()); } info = inf; }
public ActionResult Modificar(imp_catalogo_Info model) { if (!bus_catalogo.modificarDB(model)) { ViewBag.IdCatalogo_tipo = model.IdCatalogo_tipo; cargar_combos(); return(View(model)); } return(RedirectToAction("Index", new { IdCatalogo_tipo = model.IdCatalogo_tipo })); }
public frmImp_catalogo_mant() { InitializeComponent(); info_catalogo = new imp_catalogo_Info(); bus_catalogo = new imp_catalogo_Bus(); bus_catalogo_tipo = new imp_catalogo_tipo_Bus(); lst_catalogo_tipo = new List <imp_catalogo_tipo_Info>(); param = cl_parametrosGenerales_Bus.Instance; Log_Error_bus = new tb_sis_Log_Error_Vzen_Bus(); }
public bool anularDB(imp_catalogo_Info info) { try { return(odata.anularDB(info)); } catch (Exception) { throw; } }
public ActionResult Nuevo(int IdCatalogo_tipo = 0) { imp_catalogo_Info model = new imp_catalogo_Info { IdCatalogo_tipo = IdCatalogo_tipo }; ViewBag.IdCatalogo_tipo = IdCatalogo_tipo; cargar_combos(); return(View(model)); }
private void gridViewCatalogo_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { try { infoCata = GetSelectedRow((DevExpress.XtraGrid.Views.Grid.GridView)sender); } catch (Exception ex) { Log_Error_bus.Log_Error(ex.ToString()); } }
public void set_info(imp_catalogo_Info _info) { try { info_catalogo = _info; } catch (Exception ex) { Log_Error_bus.Log_Error(ex.ToString()); MessageBox.Show(ex.ToString(), param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ActionResult Anular(int IdCatalogo_tipo = 0, int IdCatalogo = 0) { imp_catalogo_Info model = bus_catalogo.get_info(IdCatalogo_tipo, IdCatalogo_tipo); if (model == null) { return(RedirectToAction("Index", new { IdCatalogo_tipo = IdCatalogo_tipo })); } ViewBag.IdCatalogo_tipo = model.IdCatalogo_tipo; cargar_combos(); return(View(model)); }
public bool anularDB(imp_catalogo_Info info) { try { return(odata.anularDB(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("", "anularDB", ex.Message), ex) { EntityType = typeof(imp_catalogo_Bus) }; } }
public Boolean GrabarDB(imp_catalogo_Info inf, ref string Mensaje) { try { return(oDat.GrabarDB(inf, ref Mensaje)); } 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("", "Grabar", ex.Message), ex) { EntityType = typeof(imp_catalogo_Bus) }; } }
public Boolean GrabarDB(imp_catalogo_Info info, ref string Mensaje) { try { using (EntitiesImportacion context = new EntitiesImportacion()) { EntitiesImportacion EDB = new EntitiesImportacion(); var Q = (from per in EDB.imp_catalogo select per.Orden).Max() + 1; if ((from per in EDB.imp_catalogo where per.IdCatalogoImport == info.IdCatalogoImport select per).Count() != 0) { Mensaje = "El Codigo Ingresado Ya existe por favor ingrese uno distinto"; return(false); } var address = new imp_catalogo(); address.IdCatalogoImport = info.IdCatalogoImport; address.IdCatalogoImport_tipo = info.IdCatalogoImport_tipo; address.Nombre = info.Nombre; address.NombreIngles = info.NombreIngles; address.Abrebiatura = info.Abrebiatura; address.Orden = Q; address.Estado = "A"; context.imp_catalogo.Add(address); context.SaveChanges(); Mensaje = "Registro Ingresado Correctamente"; } 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; Mensaje = "Error al ingresar el registro "; throw new Exception(ex.ToString()); } }
private void gridView_catalogo_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e) { try { imp_catalogo_Info row = (imp_catalogo_Info)gridView_catalogo.GetRow(e.RowHandle); if (row == null) { return; } if (!row.estado) { e.Appearance.ForeColor = Color.Red; } } catch (Exception ex) { Log_Error_bus.Log_Error(ex.ToString()); MessageBox.Show(ex.ToString(), param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool anularDB(imp_catalogo_Info info) { try { using (Entities_importacion Context = new Entities_importacion()) { imp_catalogo Entity = Context.imp_catalogo.FirstOrDefault(q => q.IdCatalogo_tipo == info.IdCatalogo_tipo && q.IdCatalogo == info.IdCatalogo); if (Entity == null) { return(false); } Entity.estado = info.estado = false; Context.SaveChanges(); } return(true); } catch (Exception) { throw; } }
public List <imp_catalogo_Info> Get_List_catalogo() { List <imp_catalogo_Info> lista = new List <imp_catalogo_Info>(); EntitiesImportacion oEnt = new EntitiesImportacion(); try { var select = from q in oEnt.imp_catalogo select q; foreach (var item in select) { imp_catalogo_Info info = new imp_catalogo_Info(); info.IdCatalogoImport = item.IdCatalogoImport.Trim(); info.IdCatalogoImport_tipo = item.IdCatalogoImport_tipo; info.Nombre = item.Nombre.Trim(); info.NombreIngles = item.NombreIngles; info.Orden = item.Orden; info.Estado = item.Estado; info.Abrebiatura = item.Abrebiatura; lista.Add(info); } return(lista); } 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 bool guardarDB(imp_catalogo_Info info) { try { using (Entities_importacion Context = new Entities_importacion()) { imp_catalogo Entity = new imp_catalogo { IdCatalogo = info.IdCatalogo = get_id(), IdCatalogo_tipo = info.IdCatalogo_tipo, ca_descripcion = info.ca_descripcion, estado = info.estado = true }; Context.imp_catalogo.Add(Entity); Context.SaveChanges(); } return(true); } catch (Exception) { throw; } }