public ActionResult Modificar(in_Catalogo_Info model)
{
if (!bus_catalogo.modificarDB(model))
{
ViewBag.IdCatalogo_tipo = model.IdCatalogo_tipo;
return(View(model));
}
return(RedirectToAction("Index", new { IdCatalogo_tipo = model.IdCatalogo_tipo }));
}
public ActionResult Nuevo(int IdCatalogo_tipo = 0)
{
in_Catalogo_Info model = new in_Catalogo_Info
{
IdCatalogo_tipo = IdCatalogo_tipo
};
ViewBag.IdCatalogo_tipo = IdCatalogo_tipo;
cargar_combos();
return(View(model));
}
public bool anularDB(in_Catalogo_Info info)
{
try
{
return(odata.anularDB(info));
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(in_Catalogo_Info info)
{
try
{
return(odata.modificarDB(info));
}
catch (Exception)
{
throw;
}
}
public ActionResult Modificar(string IdCatalogo = "", int IdCatalogo_tipo = 0)
{
in_Catalogo_Info model = bus_catalogo.get_info(IdCatalogo);
if (model == null)
{
return(RedirectToAction("Index", new { IdCatalogo_tipo = IdCatalogo_tipo }));
}
ViewBag.IdCatalogo_tipo = model.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());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Boolean ModificarDB(in_Catalogo_Info info)
{
try
{
return(oData.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(in_Catalogo_Bus)
};
}
}
public in_Catalogo_Info Get_CatalogosInfo()
{
try
{
InfoCatalogo = listCatalogo.FirstOrDefault(v => v.IdCatalogo == Convert.ToString(cmbCatalogo.EditValue));
return(InfoCatalogo);
}
catch (Exception ex)
{
string NameMetodo = System.Reflection.MethodBase.GetCurrentMethod().Name;
MessageBox.Show(NameMetodo + " - " + ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Log_Error_bus.Log_Error(NameMetodo + " - " + ex.ToString());
return(null);
}
}
void LimpiarDatos()
{
try
{
txtIdCatalogo_tipo.Text = "";
txt_IdCatalogo.Text = "";
txt_abreviatura.Text = "";
txt_nombre.Text = "";
Info = new in_Catalogo_Info();
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Nuevo(in_Catalogo_Info model)
{
if (bus_catalogo.validar_existe_IdCatalogo(model.IdCatalogo))
{
ViewBag.mensaje = "El código ya se encuentra registrado";
ViewBag.IdCatalogo_tipo = model.IdCatalogo_tipo;
return(View(model));
}
if (!bus_catalogo.guardarDB(model))
{
ViewBag.IdCatalogo_tipo = model.IdCatalogo_tipo;
return(View(model));
}
return(RedirectToAction("Index", new { IdCatalogo_tipo = model.IdCatalogo_tipo }));
}
public Boolean GuardarDB(in_Catalogo_Info info, ref string Mensaje)
{
try
{
using (EntitiesInventario oEnti = new EntitiesInventario())
{
var Q = (from per in oEnti.in_Catalogo
select per.Orden).Max() + 1;
if ((from per in oEnti.in_Catalogo where per.IdCatalogo == info.IdCatalogo select per).Count() != 0)
{
Mensaje = "El Codigo Ingresado Ya existe por favor ingrese uno distinto";
return(false);
}
var registo = new in_Catalogo();
registo.IdCatalogo = info.IdCatalogo;
registo.IdCatalogo_tipo = info.IdCatalogo_tipo;
registo.Nombre = info.Nombre;
registo.NombreIngles = info.NombreIngles;
registo.Abrebiatura = info.Abrebiatura;
registo.Orden = Q;
registo.Estado = "A";
oEnti.in_Catalogo.Add(registo);
oEnti.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());
}
}
public ActionResult Nuevo(int IdCatalogo_tipo = 0)
{
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "Inventario", "CatalogoTipoInventario", "Index");
if (!info.Nuevo)
{
return(RedirectToAction("Index"));
}
#endregion
in_Catalogo_Info model = new in_Catalogo_Info
{
IdCatalogo_tipo = IdCatalogo_tipo
};
ViewBag.IdCatalogo_tipo = IdCatalogo_tipo;
cargar_combos();
return(View(model));
}
public ActionResult Anular(string IdCatalogo = "", int IdCatalogo_tipo = 0)
{
#region Permisos
seg_Menu_x_Empresa_x_Usuario_Info info = bus_permisos.get_list_menu_accion(Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.IdUsuario, "Inventario", "CatalogoTipoInventario", "Index");
if (!info.Anular)
{
return(RedirectToAction("Index"));
}
#endregion
in_Catalogo_Info model = bus_catalogo.get_info(IdCatalogo);
if (model == null)
{
return(RedirectToAction("Index", new { IdTipoCatalogo = IdCatalogo_tipo }));
}
ViewBag.IdCatalogo_tipo = model.IdCatalogo_tipo;
cargar_combos();
return(View(model));
}
public List <in_Catalogo_Info> Get_List_Catalogo(int IdTIpoCatalogo)
{
List <in_Catalogo_Info> lista = new List <in_Catalogo_Info>();
EntitiesInventario oEnt = new EntitiesInventario();
try
{
var select = from q in oEnt.in_Catalogo
where q.IdCatalogo_tipo == IdTIpoCatalogo
select q;
foreach (var item in select)
{
in_Catalogo_Info info = new in_Catalogo_Info();
info.IdCatalogo = item.IdCatalogo.Trim();
info.IdCatalogo_tipo = item.IdCatalogo_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 anularDB(in_Catalogo_Info info)
{
try
{
using (Entities_inventario Context = new Entities_inventario())
{
in_Catalogo Entity = Context.in_Catalogo.FirstOrDefault(q => q.IdCatalogo == info.IdCatalogo);
if (Entity == null)
{
return(false);
}
Entity.Estado = info.Estado = "I";
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(in_Catalogo_Info info)
{
try
{
using (Entities_inventario Context = new Entities_inventario())
{
in_Catalogo Entity = Context.in_Catalogo.FirstOrDefault(q => q.IdCatalogo == info.IdCatalogo);
if (Entity == null)
{
return(false);
}
Entity.Nombre = info.Nombre;
Entity.Abrebiatura = info.Abrebiatura;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool guardarDB(in_Catalogo_Info info)
{
try
{
using (Entities_inventario Context = new Entities_inventario())
{
in_Catalogo Entity = new in_Catalogo
{
IdCatalogo_tipo = info.IdCatalogo_tipo,
IdCatalogo = info.IdCatalogo,
Nombre = info.Nombre,
Estado = info.Estado = "A",
Orden = info.Orden
};
Context.in_Catalogo.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
