コード例 #1
0
        public Boolean EliminarDB(ro_tabla_Impu_Renta_Info info)
        {
            try
            {
                using (EntitiesRoles rol = new EntitiesRoles())
                {
                    var Quer = (from q in rol.ro_tabla_Impu_Renta
                                where q.Secuencia == info.Secuencia
                                select q);

                    if (Quer.Count() > 0)
                    {
                        ro_tabla_Impu_Renta dato = rol.ro_tabla_Impu_Renta.First(v => v.Secuencia == info.Secuencia);
                        rol.ro_tabla_Impu_Renta.Remove(dato);
                        rol.SaveChanges();
                    }
                }
                return(true);
            }
            catch (Exception ex)
            {
                string array = 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(), "", array, "", "", "", "", "", DateTime.Now);
                oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
                mensaje = ex.InnerException + " " + ex.Message;
                throw new Exception(ex.InnerException.ToString());
            }
        }
コード例 #2
0
 public ActionResult Modificar(ro_tabla_Impu_Renta_Info info)
 {
     try
     {
         if (ModelState.IsValid)
         {
             if (!bus_imp_renta.modificarDB(info))
             {
                 return(View(info));
             }
             else
             {
                 return(RedirectToAction("Index"));
             }
         }
         else
         {
             return(View(info));
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #3
0
        public ro_tabla_Impu_Renta_Info Get_Info_FraccionBasica(int anio, ref string msg)
        {
            ro_tabla_Impu_Renta_Info info = new ro_tabla_Impu_Renta_Info();

            try
            {
                using (EntitiesRoles db = new EntitiesRoles())
                {
                    var consultar = from q in db.ro_tabla_Impu_Renta
                                    where q.AnioFiscal == anio && q.FraccionBasica == 0 &&
                                    q.ImpFraccionBasica == 0 && q.Por_ImpFraccion_Exce == 0
                                    select q;
                    foreach (var item in consultar)
                    {
                        info.AnioFiscal           = item.AnioFiscal;
                        info.Secuencia            = item.Secuencia;
                        info.FraccionBasica       = Convert.ToDouble(item.FraccionBasica);
                        info.ExcesoHasta          = Convert.ToDouble(item.ExcesoHasta);
                        info.ImpFraccionBasica    = Convert.ToDouble(item.ImpFraccionBasica);
                        info.Por_ImpFraccion_Exce = Convert.ToDouble(item.Por_ImpFraccion_Exce);
                    }
                }
                return(info);
            }
            catch (Exception ex)
            {
                string array = 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(), "", array, "", "", "", "", "", DateTime.Now);
                oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
                mensaje = ex.InnerException + " " + ex.Message;
                throw new Exception(ex.InnerException.ToString());
            }
        }
コード例 #4
0
 public ActionResult Nuevo(ro_tabla_Impu_Renta_Info info)
 {
     try
     {
         if (ModelState.IsValid)
         {
             int IdEmpresa = Convert.ToInt32(SessionFixed.IdEmpresa);
             if (!bus_imp_renta.guardarDB(info))
             {
                 return(View(info));
             }
             else
             {
                 return(RedirectToAction("Index"));
             }
         }
         else
         {
             return(View(info));
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #5
0
        public Boolean GrabarDB(ro_tabla_Impu_Renta_Info info)
        {
            try
            {
                EliminarDB(info);
                using (EntitiesRoles rol = new EntitiesRoles())
                {
                    ro_tabla_Impu_Renta db = new ro_tabla_Impu_Renta();
                    db.AnioFiscal           = info.AnioFiscal;
                    db.Secuencia            = info.Secuencia;
                    db.FraccionBasica       = info.FraccionBasica;
                    db.ExcesoHasta          = info.ExcesoHasta;
                    db.ImpFraccionBasica    = info.ImpFraccionBasica;
                    db.Por_ImpFraccion_Exce = info.Por_ImpFraccion_Exce;

                    rol.ro_tabla_Impu_Renta.Add(db);
                    rol.SaveChanges();
                }
                return(true);
            }
            catch (Exception ex)
            {
                string array = 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(), "", array, "", "", "", "", "", DateTime.Now);
                oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
                mensaje = ex.InnerException + " " + ex.Message;
                throw new Exception(ex.InnerException.ToString());
            }
        }
コード例 #6
0
        public List <ro_tabla_Impu_Renta_Info> Get_List_tabla_Impu_Renta()
        {
            List <ro_tabla_Impu_Renta_Info> Lst = new List <ro_tabla_Impu_Renta_Info>();

            try
            {
                using (EntitiesRoles rol = new EntitiesRoles())
                {
                    var consultar = from q in rol.ro_tabla_Impu_Renta
                                    orderby q.Secuencia
                                    select q;
                    foreach (var item in consultar)
                    {
                        ro_tabla_Impu_Renta_Info info = new ro_tabla_Impu_Renta_Info();
                        info.AnioFiscal           = item.AnioFiscal;
                        info.Secuencia            = item.Secuencia;
                        info.FraccionBasica       = Convert.ToDouble(item.FraccionBasica);
                        info.ExcesoHasta          = Convert.ToDouble(item.ExcesoHasta);
                        info.ImpFraccionBasica    = Convert.ToDouble(item.ImpFraccionBasica);
                        info.Por_ImpFraccion_Exce = Convert.ToDouble(item.Por_ImpFraccion_Exce);
                        Lst.Add(info);
                    }
                }
                return(Lst);
            }
            catch (Exception ex)
            {
                string array = 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(), "", array, "", "", "", "", "", DateTime.Now);
                oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
                mensaje = ex.InnerException + " " + ex.Message;
                throw new Exception(ex.InnerException.ToString());
            }
        }
コード例 #7
0
        public ro_tabla_Impu_Renta_Info get_info(int AnioFiscal, int Secuencia)
        {
            try
            {
                ro_tabla_Impu_Renta_Info info = new ro_tabla_Impu_Renta_Info();

                using (Entities_rrhh Context = new Entities_rrhh())
                {
                    ro_tabla_Impu_Renta Entity = Context.ro_tabla_Impu_Renta.FirstOrDefault(q => q.AnioFiscal == AnioFiscal && q.Secuencia == Secuencia);
                    if (Entity == null)
                    {
                        return(null);
                    }

                    info = new ro_tabla_Impu_Renta_Info
                    {
                        AnioFiscal           = Entity.AnioFiscal,
                        Secuencia            = Entity.Secuencia,
                        FraccionBasica       = Entity.FraccionBasica,
                        ExcesoHasta          = Entity.ExcesoHasta,
                        ImpFraccionBasica    = Entity.ImpFraccionBasica,
                        Por_ImpFraccion_Exce = Entity.Por_ImpFraccion_Exce
                    };
                }

                return(info);
            }
            catch (Exception)
            {
                throw;
            }
        }
コード例 #8
0
        public bool modificarDB(ro_tabla_Impu_Renta_Info info)
        {
            try
            {
                using (Entities_rrhh Context = new Entities_rrhh())
                {
                    ro_tabla_Impu_Renta Entity = Context.ro_tabla_Impu_Renta.FirstOrDefault(q => q.AnioFiscal == info.AnioFiscal && q.Secuencia == info.Secuencia);
                    if (Entity == null)
                    {
                        return(false);
                    }
                    Entity.FraccionBasica       = info.FraccionBasica;
                    Entity.ImpFraccionBasica    = info.ImpFraccionBasica;
                    Entity.Por_ImpFraccion_Exce = info.Por_ImpFraccion_Exce;
                    Entity.ExcesoHasta          = info.ExcesoHasta;
                    Context.SaveChanges();
                }

                return(true);
            }
            catch (Exception)
            {
                throw;
            }
        }
コード例 #9
0
 public bool guardarDB(ro_tabla_Impu_Renta_Info info)
 {
     try
     {
         using (Entities_rrhh Context = new Entities_rrhh())
         {
             ro_tabla_Impu_Renta Entity = new ro_tabla_Impu_Renta
             {
                 AnioFiscal           = info.AnioFiscal,
                 Secuencia            = info.Secuencia = get_id(info.AnioFiscal),
                 FraccionBasica       = info.FraccionBasica,
                 ExcesoHasta          = info.ExcesoHasta,
                 ImpFraccionBasica    = info.ImpFraccionBasica,
                 Por_ImpFraccion_Exce = info.Por_ImpFraccion_Exce
             };
             Context.ro_tabla_Impu_Renta.Add(Entity);
             Context.SaveChanges();
         }
         return(true);
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #10
0
 public bool anularDB(ro_tabla_Impu_Renta_Info info)
 {
     try
     {
         return(odata.anularDB(info));
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #11
0
 public ActionResult Nuevo()
 {
     try
     {
         ro_tabla_Impu_Renta_Info info = new ro_tabla_Impu_Renta_Info();
         return(View(info));
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #12
0
 private void gridViewTablaIR_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
 {
     try
     {
         IRInfo = new ro_tabla_Impu_Renta_Info();
         IRInfo = gridViewTablaIR.GetFocusedRow() as ro_tabla_Impu_Renta_Info;
     }
     catch (Exception ex)
     {
         Log_Error_bus.Log_Error(ex.ToString());
         MessageBox.Show(ex.ToString());
     }
 }
コード例 #13
0
 public Boolean GrabarTablaImpu(ro_tabla_Impu_Renta_Info info)
 {
     try
     {
         return(data.GrabarDB(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("", "GrabarTablaImpu", ex.Message), ex)
               {
                   EntityType = typeof(ro_Tabla_Impu_Renta_Bus)
               };
     }
 }
コード例 #14
0
 public ActionResult Anular(ro_tabla_Impu_Renta_Info info)
 {
     try
     {
         if (!bus_imp_renta.anularDB(info))
         {
             return(View(info));
         }
         else
         {
             return(RedirectToAction("Index"));
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
コード例 #15
0
        // GET: RRHH/Division
        public ActionResult Index()
        {
            #region Validar Session
            if (string.IsNullOrEmpty(SessionFixed.IdTransaccionSession))
            {
                return(RedirectToAction("Login", new { Area = "", Controller = "Account" }));
            }
            SessionFixed.IdTransaccionSession       = (Convert.ToDecimal(SessionFixed.IdTransaccionSession) + 1).ToString();
            SessionFixed.IdTransaccionSessionActual = SessionFixed.IdTransaccionSession;
            #endregion

            ro_tabla_Impu_Renta_Info model = new ro_tabla_Impu_Renta_Info
            {
                IdTransaccionSession = Convert.ToDecimal(SessionFixed.IdTransaccionSession)
            };

            List <ro_tabla_Impu_Renta_Info> lista = bus_imp_renta.get_list();
            Lista_ImpRenta.set_list(lista, Convert.ToDecimal(SessionFixed.IdTransaccionSession));
            return(View(model));
        }
コード例 #16
0
 public Boolean GETINFO()
 {
     try
     {
         IRinfo                      = new ro_tabla_Impu_Renta_Info();
         IRinfo.AnioFiscal           = Convert.ToInt32(cmbAnioFiscal.EditValue);
         IRinfo.Secuencia            = (SETINFO_ == null)?IRBus.GETSECUENCIA():SETINFO_.Secuencia;
         IRinfo.FraccionBasica       = Convert.ToDouble(txtFraccion.EditValue);
         IRinfo.ExcesoHasta          = Convert.ToDouble(txtExceso.EditValue);
         IRinfo.ImpFraccionBasica    = Convert.ToDouble(txtImpuesto.EditValue);
         IRinfo.Por_ImpFraccion_Exce = Convert.ToDouble(txtPorcentaje.EditValue);
         return(true);
     }
     catch (Exception ex)
     {
         Log_Error_bus.Log_Error(ex.ToString());
         MessageBox.Show(ex.ToString());
         return(false);
     }
 }
コード例 #17
0
        public bool anularDB(ro_tabla_Impu_Renta_Info info)
        {
            try
            {
                using (Entities_rrhh Context = new Entities_rrhh())
                {
                    ro_tabla_Impu_Renta Entity = Context.ro_tabla_Impu_Renta.FirstOrDefault(q => q.AnioFiscal == info.AnioFiscal && q.Secuencia == info.Secuencia);
                    if (Entity == null)
                    {
                        return(false);
                    }
                    Context.ro_tabla_Impu_Renta.Remove(Entity);
                    Context.SaveChanges();
                }

                return(true);
            }
            catch (Exception)
            {
                throw;
            }
        }