protected void rdcbTaxType_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
 {
     // load tax percentage 
     if (rdcbTaxType.SelectedValue != "")
     {
         taxTypeId = Int32.Parse(rdcbTaxType.SelectedValue);
         taxt = CntAriCli.GetTaxType(taxTypeId, ctx);
         txtTaxPercentage.Text = String.Format("{0:##0.00}", taxt.Percentage);
     }
 }
 protected void LoadTicketData(Ticket tck)
 {
     taxt = tck.InsuranceService.Service.TaxType;
     LoadTaxTypeCombo(taxt);
     txtDescription.Text = tck.Description;
     txtTaxPercentage.Text = taxt.Percentage.ToString();
     txtAmount.Text = tck.Amount.ToString();
 }
 protected void LoadTaxTypeCombo(TaxType taxt)
 {
     // clear previous items 
     rdcbTaxType.Items.Clear();
     foreach (TaxType t in ctx.TaxTypes)
     {
         rdcbTaxType.Items.Add(new RadComboBoxItem(t.Name, t.TaxTypeId.ToString()));
     }
     if (taxt != null)
     {
         rdcbTaxType.SelectedValue = taxt.TaxTypeId.ToString();
     }
     else
     {
         rdcbTaxType.Items.Add(new RadComboBoxItem(" ", ""));
         rdcbTaxType.SelectedValue = "";
     }
 }
 protected void LoadData(ProfessionalInvoiceLine invl)
 {
     txtInvoiceLineId.Text = invl.InvoiceLineId.ToString();
     inv = invl.ProfessionalInvoice;
     taxt = invl.TaxType;
     LoadInvoiceData();
     //tck = invl.Ticket;
     //if (tck != null)
     //{
     //    txtTicketId.Text = tck.TicketId.ToString();
     //    txtTicketData.Text = String.Format("{0} ({1}: {2:###,##0.00})"
     //        , tck.Policy.Customer.FullName
     //        , tck.Description
     //        , tck.Amount);
     //}
     LoadTaxTypeCombo(taxt);
     txtDescription.Text = invl.Description;
     txtTaxPercentage.Text = String.Format("{0:##0.00}", invl.TaxPercentage);
     txtAmount.Text = String.Format("{0:###,##0.00}", invl.Amount);
 }
Пример #5
0
        /// <summary>
        /// Importa los tipos de IVA
        /// </summary>
        /// <param name="con"></param>
        /// <param name="ctx"></param>
        public static void ImportTaxTypes(OleDbConnection con, AriClinicContext ctx)
        {
            // (0) Borra tipos previos
            ctx.Delete(ctx.TaxTypes);
            ctx.SaveChanges();

            // (1) Dar de alta los tipos de IVA importados.
            string sql = "SELECT * FROM TiposIva";
            cmd = new OleDbCommand(sql, con);
            da = new OleDbDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "ConTiposIVA");
            int nreg = ds.Tables["ConTiposIVA"].Rows.Count;
            int reg = 0;
            TaxType tt = null;
            foreach (DataRow dr in ds.Tables["ConTiposIVA"].Rows)
            {
                DataRow localDr = dr;
                reg++;
                Console.WriteLine("Tipos IVA {0:#####0} de {1:#####0} {2}", reg, nreg, (string)localDr["NomTipoIva"]);
                tt = (from ti in ctx.TaxTypes
                      where ti.OftId == (int)localDr["IdTipoIVA"]
                      select ti).FirstOrDefault<TaxType>();
                if (tt == null)
                {
                    tt = new TaxType();
                    ctx.Add(tt);
                }
                tt.Name = (string)localDr["NomTipoIva"];
                Single p = (Single)localDr["Porcentaje"];
                tt.Percentage = decimal.Parse(p.ToString());
                tt.OftId = (int)localDr["IdTipoIva"];
            }
            ctx.SaveChanges();
        }
Пример #6
0
        /// <summary>
        /// Importa los tipos de IVA
        /// </summary>
        /// <param name="con"></param>
        /// <param name="ctx"></param>
        public static void ImportTaxTypes(OleDbConnection con, AriClinicContext ctx)
        {
            // (0) Borra tipos previos
            ctx.Delete(ctx.TaxTypes);

            // (1) Dar de alta los tipos de IVA importados.
            string sql = "SELECT * FROM TiposIva";
            cmd = new OleDbCommand(sql, con);
            da = new OleDbDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "ConTiposIVA");
            int nreg = ds.Tables["ConTiposIVA"].Rows.Count;
            int reg = 0;
            foreach (DataRow dr in ds.Tables["ConTiposIVA"].Rows)
            {
                reg++;

                TaxType tt = new TaxType();
                tt.Name = (string)dr["NomTipoIva"];
                Single p = (Single)dr["Porcentaje"];
                tt.Percentage = decimal.Parse(p.ToString());
                tt.OftId = (int)dr["IdTipoIva"];
                ctx.Add(tt);
            }
            ctx.SaveChanges();
        }