Exemplo n.º 1
0
        public static MTaxe GetTaxeXProduct(this BoTaxe pTaxe, int pIdProduct)
        {
            var lTaxe = new MTaxe
            {
                LObject = new MObject
                {
                    LIdObject   = pTaxe.LObject.LIdObject,
                    LNameObject = pTaxe.LObject.LNameObject
                },
                LStatus = new MStatus
                {
                    LIdStatus = pTaxe.LStatus.LIdStatus,
                    LDsEstado = pTaxe.LStatus.LDsEstado
                },
                LCreationDate     = pTaxe.LCreationDate,
                LIdProduct        = pIdProduct,
                LIdTaxe           = pTaxe.LIdTaxe,
                LIsPercent        = pTaxe.LIsPercent,
                LMessageException = pTaxe.LMessageDao,
                LNameTaxe         = pTaxe.LNameTaxe,
                LValueTaxe        = pTaxe.LValueTaxe
            };

            return(lTaxe);
        }
Exemplo n.º 2
0
        public BoTaxe Dao_getTaxeById(int pIdTaxe)
        {
            SqlConnection lConex = new SqlConnection();

            using (lConex = Dao_SqlConnection(lConex))
            {
                var lTaxe = new BoTaxe();
                try
                {
                    var lCommand = new SqlCommand
                    {
                        CommandText    = "spr_GetTaxeById",
                        CommandTimeout = 30,
                        CommandType    = CommandType.StoredProcedure,
                        Connection     = lConex
                    };
                    lCommand.Parameters.Add(new SqlParameter("IdTaxe", pIdTaxe));
                    var lReader = lCommand.ExecuteReader();

                    if (lReader.HasRows)
                    {
                        while (lReader.Read())
                        {
                            lTaxe.LIdTaxe       = Convert.ToInt32(lReader["IdTax"].ToString());
                            lTaxe.LNameTaxe     = lReader["NameTax"].ToString();
                            lTaxe.LCreationDate = Convert.ToDateTime(lReader["CreationDate"].ToString());
                            lTaxe.LValueTaxe    = Convert.ToDecimal(lReader["ValueTax"].ToString());
                            lTaxe.LIsPercent    = Convert.ToBoolean(lReader["IsPercent"].ToString());
                            lTaxe.LStatus       = new BoStatus {
                                LIdStatus = lReader["IdStatus"].ToString()
                            };
                            lTaxe.LObject = new BoObject {
                                LIdObject = Convert.ToInt32(lReader["IdObject"].ToString())
                            };
                        }
                    }
                    Dao_CloseSqlconnection(lConex);
                    return(lTaxe);
                }
                catch (Exception e)
                {
                    lTaxe = new BoTaxe
                    {
                        LException  = e.Message,
                        LMessageDao = BoErrors.MsgErrorGetSql
                    };
                    if (e.InnerException != null)
                    {
                        lTaxe.LInnerException = e.InnerException.ToString();
                    }

                    Dao_CloseSqlconnection(lConex);
                    return(lTaxe);
                }
            }
        }
Exemplo n.º 3
0
        public List <BoTaxe> Dao_getLisAllTaxesXProduct(int idProduct)
        {
            SqlConnection lConex = new SqlConnection();

            using (lConex = Dao_SqlConnection(lConex))
            {
                var lListTaxe = new List <BoTaxe>();
                try
                {
                    var lCommand = new SqlCommand
                    {
                        CommandText    = "spr_GetListAllTaxesXProduct",
                        CommandTimeout = 30,
                        CommandType    = CommandType.StoredProcedure,
                        Connection     = lConex
                    };
                    lCommand.Parameters.Add("idProduct", SqlDbType.Int).Value = idProduct;
                    var lReader = lCommand.ExecuteReader();
                    if (lReader.HasRows)
                    {
                        while (lReader.Read())
                        {
                            var lTaxe = new BoTaxe
                            {
                                LStatus = new BoStatus
                                {
                                    LIdStatus = lReader["IdStatus"].ToString(),
                                    LDsEstado = lReader["DsEstado"].ToString()
                                },
                                LObject = new BoObject
                                {
                                    LIdObject   = Convert.ToInt32(lReader["IdObject"].ToString()),
                                    LNameObject = lReader["NameObject"].ToString()
                                },
                                LIdTaxe       = Convert.ToInt32(lReader["IdTax"].ToString()),
                                LNameTaxe     = lReader["NameTax"].ToString(),
                                LIsPercent    = Convert.ToBoolean(lReader["IsPercent"].ToString()),
                                LCreationDate = Convert.ToDateTime(lReader["CreationDate"].ToString()),
                                LValueTaxe    = Convert.ToDecimal(lReader["ValueTax"].ToString())
                            };
                            lListTaxe.Add(lTaxe);
                        }
                    }
                    Dao_CloseSqlconnection(lConex);
                    return(lListTaxe);
                }
                catch (Exception e)
                {
                    lListTaxe = new List <BoTaxe>();
                    var lTaxe = new BoTaxe
                    {
                        LException  = e.Message,
                        LMessageDao = BoErrors.MsgErrorGetSql
                    };
                    if (e.InnerException != null)
                    {
                        lTaxe.LInnerException = e.InnerException.ToString();
                    }
                    Dao_CloseSqlconnection(lConex);
                    lListTaxe.Add(lTaxe);
                    return(lListTaxe);
                }
            }
        }