コード例 #1
0
        public Boolean GuardarBD(ro_rol_individual_Info info, ref string msg)
        {
            try
            {
                Boolean valorRetornar = false;

                //MODIFICA DETALLE
                if (oData.GetExiste(info, ref mensaje))
                {
                    valorRetornar = oData.ModificarBD(info, ref mensaje);
                }
                else
                {//ACTUALIZA DETALLE
                    valorRetornar = oData.GuardarBD(info, ref mensaje);
                }
                return(valorRetornar);
            }
            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("", "GuardarBD", ex.Message), ex)
                      {
                          EntityType = typeof(ro_rol_individual_Bus)
                      };
            }
        }
コード例 #2
0
 public Boolean GuardarBD(ro_rol_individual_Info info, ref string msg)
 {
     try
     {
         using (EntitiesRoles db = new EntitiesRoles())
         {
             ro_rol_individual item = new ro_rol_individual();
             item.IdEmpresa         = info.IdEmpresa;
             item.IdNominaTipo      = info.IdNominaTipo;
             item.IdNominaTipoLiqui = info.IdNominaTipoLiqui;
             item.IdPeriodo         = info.IdPeriodo;
             item.IdEmpleado        = info.IdEmpleado;
             item.IdRubro           = info.IdRubro;
             item.Orden             = info.Orden;
             item.Ingreso           = info.Ingreso;
             item.Egreso            = info.Egreso;
             item.FechaPago         = info.FechaPago;
             db.ro_rol_individual.Add(item);
             db.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());
     }
 }
コード例 #3
0
        public Boolean ModificarBD(ro_rol_individual_Info info, ref string msg)
        {
            try
            {
                using (EntitiesRoles db = new EntitiesRoles())
                {
                    ro_rol_individual item = (from a in db.ro_rol_individual
                                              where a.IdEmpresa == info.IdEmpresa && a.IdNominaTipo == info.IdNominaTipo &&
                                              a.IdNominaTipoLiqui == info.IdNominaTipoLiqui && a.IdPeriodo == info.IdPeriodo &&
                                              a.IdEmpleado == info.IdEmpleado && a.IdRubro == info.IdRubro
                                              select a).FirstOrDefault();

                    item.Orden   = info.Orden;
                    item.Egreso  = info.Egreso;
                    item.Ingreso = info.Ingreso;

                    db.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());
            }
        }
コード例 #4
0
        public Boolean GetExiste(ro_rol_individual_Info info, ref string msg)
        {
            try
            {
                Boolean valorRetornar = false;
                using (EntitiesRoles db = new EntitiesRoles())
                {
                    int cont = (from a in db.ro_rol_individual
                                where a.IdEmpresa == info.IdEmpresa && a.IdNominaTipo == info.IdNominaTipo &&
                                a.IdNominaTipoLiqui == info.IdNominaTipoLiqui && a.IdPeriodo == info.IdPeriodo &&
                                a.IdEmpleado == info.IdEmpleado && a.IdRubro == info.IdRubro && a.IdPeriodo == info.IdPeriodo
                                select a).Count();

                    if (cont > 0)
                    {
                        valorRetornar = true;
                    }
                    else
                    {
                        valorRetornar = false;
                    }
                }
                return(valorRetornar);
            }
            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());
            }
        }
コード例 #5
0
        public List <ro_rol_individual_Info> GetListConsultaGeneral(int idEmpresa, int idNominaTipo, int idNominaTipoLiqui, int idPeriodo, ref string msg)
        {
            try
            {
                List <ro_rol_individual_Info> oListado = new List <ro_rol_individual_Info>();

                using (EntitiesRoles db = new EntitiesRoles())
                {
                    var datos = (from a in db.ro_rol_individual
                                 where a.IdEmpresa == idEmpresa && a.IdNominaTipo == idNominaTipo &&
                                 a.IdNominaTipoLiqui == idNominaTipoLiqui && a.IdPeriodo == idPeriodo
                                 select a);

                    foreach (var info in datos)
                    {
                        ro_rol_individual_Info item = new ro_rol_individual_Info();
                        item.IdEmpresa         = info.IdEmpresa;
                        item.IdNominaTipo      = info.IdNominaTipo;
                        item.IdNominaTipoLiqui = info.IdNominaTipoLiqui;
                        item.IdPeriodo         = info.IdPeriodo;
                        item.IdEmpleado        = info.IdEmpleado;
                        item.IdRubro           = info.IdRubro;
                        item.Orden             = info.Orden;
                        item.Ingreso           = info.Ingreso;
                        item.Egreso            = info.Egreso;

                        oListado.Add(item);
                    }
                }
                return(oListado);
            }
            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());
            }
        }