コード例 #1
0
        public Boolean ModificarDB(List <fa_guia_remision_det_Info> listDetalle_Guia_Info)
        {
            try
            {
                foreach (var item in listDetalle_Guia_Info)
                {
                    using (EntitiesFacturacion Context = new EntitiesFacturacion())
                    {
                        if (item.Secuencia != 0)
                        {
                            var Contact = Context.fa_guia_remision_det.FirstOrDefault(var => var.IdEmpresa == item.IdEmpresa && var.IdSucursal == item.IdSucursal && var.IdBodega == item.IdBodega && var.IdGuiaRemision == item.IdGuiaRemision && var.IdProducto == item.IdProducto && var.Secuencia == item.Secuencia);
                            if (Contact != null)
                            {
                                Contact.gi_cantidad = item.gi_cantidad;

                                Contact.gi_detallexItems = item.gi_detallexItems;


                                Context.SaveChanges();
                                Context.Dispose();
                            }
                        }
                        else
                        {
                            item.Secuencia = listDetalle_Guia_Info.Where(var => var.IdEmpresa == item.IdEmpresa && var.IdGuiaRemision == item.IdGuiaRemision && var.IdBodega == item.IdBodega && var.IdSucursal == item.IdSucursal).Count();
                            var Address = new fa_guia_remision_det();
                            Address.IdEmpresa      = item.IdEmpresa;
                            Address.IdSucursal     = item.IdSucursal;
                            Address.IdBodega       = item.IdBodega;
                            Address.IdGuiaRemision = item.IdGuiaRemision;
                            Address.Secuencia      = item.Secuencia;
                            Address.IdProducto     = item.IdProducto;
                            Address.gi_cantidad    = item.gi_cantidad;

                            Address.gi_detallexItems = (item.gi_detallexItems == null) ? "" : item.gi_detallexItems;

                            Context.fa_guia_remision_det.Add(Address);
                            Context.SaveChanges();
                            Context.Dispose();
                        }
                    }
                }
                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);
                mensaje = ex.ToString();
                oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
                throw new Exception(ex.ToString());
            }
        }
コード例 #2
0
        public Boolean GuardarDB(List <fa_guia_remision_det_Info> listDetalle_Guia_Info)
        {
            try
            {
                int c = 1;
                listDetalle_Guia_Info.ForEach(var => { var.Secuencia = c; c++; });

                foreach (var item in listDetalle_Guia_Info)
                {
                    using (EntitiesFacturacion Context = new EntitiesFacturacion())
                    {
                        var Address = new fa_guia_remision_det();

                        Address.IdEmpresa          = item.IdEmpresa;
                        Address.IdSucursal         = item.IdSucursal;
                        Address.IdBodega           = item.IdBodega;
                        Address.IdGuiaRemision     = item.IdGuiaRemision;
                        Address.Secuencia          = item.Secuencia;
                        Address.IdProducto         = item.IdProducto;
                        Address.gi_peso            = (item.gi_peso == null) ? 0 : item.gi_peso;
                        Address.gi_cantidad        = item.gi_cantidad;
                        Address.gi_Precio          = item.gi_Precio;
                        Address.gi_PorDescUnitario = item.gi_PorDescUnitario;
                        Address.gi_DescUnitario    = item.gi_DescUnitario;
                        Address.gi_PrecioFinal     = item.gi_Precio - item.gi_DescUnitario;
                        Address.gi_Subtotal        = item.Subtotal;
                        Address.gi_iva             = item.gi_iva;
                        Address.gi_total           = item.gi_total;
                        Address.gi_costo           = item.gi_costo;
                        Address.gi_tieneIVA        = item.gi_tieneIVA;
                        Address.gi_detallexItems   = (item.gi_detallexItems == null) ? "" : item.gi_detallexItems;

                        Context.fa_guia_remision_det.Add(Address);
                        Context.SaveChanges();
                        Context.Dispose();
                    }
                }
                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);
                mensaje = ex.ToString();
                oDataLog.Guardar_Log_Error(Log_Error_sis, ref mensaje);
                throw new Exception(ex.ToString());
            }
        }