示例#1
0
        protected void Button4_Click(object sender, EventArgs e)
        {
            DAL.DALClientes  aDALClientes  = new DAL.DALClientes();
            DAL.DALHistorico aDALHistorico = new DAL.DALHistorico();

            int    id    = Convert.ToInt32(Session["idlogin"]);
            double preco = Convert.ToDouble(TextBox1.Text);

            aDALClientes.UpdateDinheiro(id, preco);
            double saldo = aDALClientes.Select1(id).ElementAt(0).Saldo;

            Modelo.Historico aH = new Modelo.Historico(0, DateTime.Now, preco, saldo, id, 0);

            aDALHistorico.InsertSaldo(aH);

            Response.Redirect(Request.Url.ToString());
        }
示例#2
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            DAL.DALTransacaoPacote aDALTPacote;
            Modelo.TransacaoPacote aTP;
            DAL.DALClientes        aDALClientes  = new DAL.DALClientes();
            DAL.DALPacote          aDALPacote    = new DAL.DALPacote();
            DAL.DALHistorico       aDALHistorico = new DAL.DALHistorico();
            Modelo.Historico       aH;
            int i, u;

            i = Convert.ToInt32(Session["idpacote"]);
            u = Convert.ToInt32(Session["idlogin"]);
            string error = " ";

            aDALTPacote = new DAL.DALTransacaoPacote();

            if (aDALTPacote.VerificarT(i, u))
            {
                aDALTPacote.Delete(i, u);
                Response.Redirect("~\\WebFormPacotesC.aspx");
            }
            else
            {
                double preco = aDALPacote.Select(i).ElementAt(0).Preco;
                aTP = new Modelo.TransacaoPacote(0, i, u);
                if (aDALPacote.Select(i).ElementAt(0).Preco < aDALClientes.Select1(u).ElementAt(0).Saldo)
                {
                    aDALTPacote.Insert(aTP);
                    aDALClientes.UpdateComprar(aDALPacote.Select(i).ElementAt(0).Preco, aDALClientes.Select1(u).ElementAt(0).Saldo, u);

                    aH = new Modelo.Historico(0, DateTime.Now, aDALPacote.Select(i).ElementAt(0).Preco, aDALClientes.Select1(u).ElementAt(0).Saldo, u, i);
                    aDALHistorico.InsertPacote(aH);


                    Response.Redirect("~\\WebFormPacotesListar.aspx");
                }
                else
                {
                    error = "Saldo insuficiente para realizar a transação";
                    Error(error);
                }
            }
        }
示例#3
0
        public void Delete(Modelo.Pacote obj)
        {
            SqlConnection conn = new SqlConnection(connectionString);

            DAL.DALAvaliacao       DA  = new DALAvaliacao();
            DAL.DALTransacaoPacote DT  = new DALTransacaoPacote();
            DAL.DALPacote_Refeicao DPR = new DALPacote_Refeicao();
            DAL.DALHistorico       DH  = new DALHistorico();

            DA.DeletePacote(obj.id);
            DT.DeletePacote(obj.id);
            DPR.DeletePacote(obj.id);
            DH.DeletePacote(obj.id);

            conn.Open();
            SqlCommand com = conn.CreateCommand();
            SqlCommand cmd = new SqlCommand("DELETE FROM Pacote WHERE id = @Pacote_id", conn);

            cmd.Parameters.AddWithValue("@Pacote_id", obj.id);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
示例#4
0
        public void Delete(Modelo.Clientes obj)
        {
            DAL.DALHistorico       AH = new DALHistorico();
            DAL.DALAvaliacao       DA = new DALAvaliacao();
            DAL.DALEndereco        DE = new DALEndereco();
            DAL.DALTransacaoPacote DT = new DALTransacaoPacote();

            DT.DeleteCliente(obj.id);
            DE.DeleteUsuario(obj.id);
            DA.DeleteCliente(obj.id);
            AH.DeleteUsuario(obj.id);

            SqlConnection conn = new SqlConnection(connectionString);

            conn.Open();
            SqlCommand com = conn.CreateCommand();
            SqlCommand cmd = new SqlCommand("DELETE FROM Clientes WHERE id = @Clientes_id", conn);

            cmd.Parameters.AddWithValue("@Clientes_id", obj.id);

            cmd.ExecuteNonQuery();
            conn.Close();
        }
示例#5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Convert.ToInt32(Session["Nivel"]) == 1)
            {
                int id = Convert.ToInt32(Session["idlogin"]);
                if (!IsPostBack)
                {
                    DAL.DALClientes aDALClientes = new DAL.DALClientes();

                    Image1.ImageUrl      = aDALClientes.Select1(id).ElementAt(0).Url_Imagem;
                    LabelNome.Text       = aDALClientes.Select1(id).ElementAt(0).Nome;
                    TextBoxNome.Text     = aDALClientes.Select1(id).ElementAt(0).Nome;
                    LabelCPF.Text        = aDALClientes.Select1(id).ElementAt(0).CPF;
                    TextBoxCPF.Text      = aDALClientes.Select1(id).ElementAt(0).CPF;
                    LabelTelefone.Text   = aDALClientes.Select1(id).ElementAt(0).Telefone;
                    TextBoxTelefone.Text = aDALClientes.Select1(id).ElementAt(0).Telefone;
                    LabelEmail.Text      = aDALClientes.Select1(id).ElementAt(0).Email;
                    TextBoxEmail.Text    = aDALClientes.Select1(id).ElementAt(0).Email;
                    rua.Text             = "";
                    numero.Text          = "";
                    cep.Text             = "";
                    bairro.Text          = "";
                    cidade.Text          = "";
                    uf.Text = "AC";
                }
                if (Convert.ToInt32(Session["Edit"]) == 1)
                {
                    CPF.Attributes["class"]       = "display";
                    CPFEdit.Attributes["class"]   = "";
                    Tel.Attributes["class"]       = "display";
                    TelEdit.Attributes["class"]   = "";
                    Email.Attributes["class"]     = "display";
                    EmailEdit.Attributes["class"] = "";
                    Nome.Attributes["class"]      = "display";
                    NomeEdit.Attributes["class"]  = "";
                    btn2.Attributes["class"]      = "";
                    btn1.Attributes["class"]      = "display";
                    EmailL.Attributes["class"]    = "";
                }

                DAL.DALHistorico aDALHistorico = new DAL.DALHistorico();
                DAL.DALPacote    aDALPacote    = new DAL.DALPacote();
                DAL.DALEndereco  aDALEndereco  = new DAL.DALEndereco();
                Metodos_Gerais   Metodos       = new Metodos_Gerais();
                int count  = aDALHistorico.Count(id);
                int countE = aDALEndereco.Count(id);

                if (countE > 0)
                {
                    Table     t1;
                    TableRow  tr1;
                    TableCell tc1;
                    Button    b1, b2;
                    t1           = new Table();
                    tr1          = new TableRow();
                    tc1          = new TableCell();
                    countE       = countE - 1;
                    tc1.Text     = "Logradouro";
                    tc1.CssClass = "txt16";
                    tr1.Controls.Add(tc1);
                    tc1          = new TableCell();
                    tc1.Text     = "Numero";
                    tc1.CssClass = "txt16";
                    tr1.Controls.Add(tc1);
                    tc1          = new TableCell();
                    tc1.Text     = "CEP";
                    tc1.CssClass = "txt16";
                    tr1.Controls.Add(tc1);
                    tc1          = new TableCell();
                    tc1.Text     = "Bairro";
                    tc1.CssClass = "txt16";
                    tr1.Controls.Add(tc1);
                    tc1          = new TableCell();
                    tc1.Text     = "Cidade";
                    tc1.CssClass = "txt16";
                    tr1.Controls.Add(tc1);
                    tc1          = new TableCell();
                    tc1.Text     = "Unidade da Federação";
                    tc1.CssClass = "txt16";
                    tr1.Controls.Add(tc1);
                    tc1          = new TableCell();
                    tc1.Text     = "Editar";
                    tc1.CssClass = "txt16";
                    tr1.Controls.Add(tc1); tc1 = new TableCell();
                    tc1.Text     = "Excluir";
                    tc1.CssClass = "txt16";
                    tr1.Controls.Add(tc1);
                    t1.Controls.Add(tr1);
                    for (int i = countE; i >= 0; i--)
                    {
                        tr1 = new TableRow();
                        tc1 = new TableCell();

                        tc1.Text     = aDALEndereco.Select(id).ElementAt(i).Rua;
                        tc1.CssClass = "txt17";
                        tr1.Controls.Add(tc1);
                        tc1          = new TableCell();
                        tc1.Text     = aDALEndereco.Select(id).ElementAt(i).Numero;
                        tc1.CssClass = "txt17";
                        tr1.Controls.Add(tc1);
                        tc1          = new TableCell();
                        tc1.Text     = aDALEndereco.Select(id).ElementAt(i).CEP;
                        tc1.CssClass = "txt17";
                        tr1.Controls.Add(tc1);
                        tc1          = new TableCell();
                        tc1.Text     = aDALEndereco.Select(id).ElementAt(i).Bairro;
                        tc1.CssClass = "txt17";
                        tr1.Controls.Add(tc1);
                        tc1          = new TableCell();
                        tc1.Text     = aDALEndereco.Select(id).ElementAt(i).Cidade;
                        tc1.CssClass = "txt17";
                        tr1.Controls.Add(tc1);
                        tc1          = new TableCell();
                        tc1.Text     = aDALEndereco.Select(id).ElementAt(i).UF;
                        tc1.CssClass = "txt17";
                        tr1.Controls.Add(tc1);
                        t1.Controls.Add(tr1);

                        b1 = new Button();
                        b2 = new Button();

                        tc1 = new TableCell();

                        b1.Text = "Editar";
                        b2.Text = "Excluir";

                        b1.ID = aDALEndereco.Select(id).ElementAt(i).id.ToString();
                        b2.ID = " " + aDALEndereco.Select(id).ElementAt(i).id.ToString();

                        b1.Click += new EventHandler(EditarE);
                        b2.Click += new EventHandler(ExcluirE);

                        b1.CssClass = "login20-form-btn";
                        b2.CssClass = "login20-form-btn";


                        tc1.Controls.Add(b1);
                        tr1.Controls.Add(tc1);
                        tc1 = new TableCell();
                        tc1.Controls.Add(b2);
                        tr1.Controls.Add(tc1);
                    }
                    t1.CssClass = "tablel table table-striped";
                    PlaceHolder2.Controls.Add(t1);
                }

                if (count > 0)
                {
                    Table     t;
                    TableRow  tr;
                    TableCell tc;
                    t           = new Table();
                    tr          = new TableRow();
                    tc          = new TableCell();
                    count       = count - 1;
                    tc.Text     = "Data da Compra";
                    tc.CssClass = "txt16";
                    tr.Controls.Add(tc);
                    tc          = new TableCell();
                    tc.Text     = "Nome do Pacote";
                    tc.CssClass = "txt16";
                    tr.Controls.Add(tc);
                    tc          = new TableCell();
                    tc.Text     = "Saldo pós-compra";
                    tc.CssClass = "txt16";
                    tr.Controls.Add(tc);
                    tc          = new TableCell();
                    tc.Text     = "Preço";
                    tc.CssClass = "txt16";
                    tr.Controls.Add(tc);
                    t.Controls.Add(tr);
                    for (int i = count; i >= 0; i--)
                    {
                        tr = new TableRow();
                        tc = new TableCell();
                        int pacote = aDALHistorico.Select(id).ElementAt(i).id_Pacote;

                        tc.Text     = aDALHistorico.Select(id).ElementAt(i).Data_Compra.ToString();
                        tc.CssClass = "txt17";
                        tr.Controls.Add(tc);
                        tc = new TableCell();
                        try
                        {
                            tc.Text     = aDALPacote.Select(pacote).ElementAt(0).Nome;
                            tc.CssClass = "txt17";
                            tr.Controls.Add(tc);
                            tc          = new TableCell();
                            tc.Text     = Metodos.VerificarDouble(aDALHistorico.Select(id).ElementAt(i).Saldo);
                            tc.CssClass = "txt17";
                            tr.Controls.Add(tc);
                            tc          = new TableCell();
                            tc.Text     = "- " + Metodos.VerificarDouble(aDALHistorico.Select(id).ElementAt(i).Preco);
                            tc.CssClass = "txt19";
                            tr.Controls.Add(tc);
                        }
                        catch
                        {
                            tc.Text     = " - ";
                            tc.CssClass = "txt17";
                            tr.Controls.Add(tc);
                            tc          = new TableCell();
                            tc.Text     = Metodos.VerificarDouble(aDALHistorico.Select(id).ElementAt(i).Saldo);
                            tc.CssClass = "txt17";
                            tr.Controls.Add(tc);
                            tc          = new TableCell();
                            tc.Text     = "+ " + Metodos.VerificarDouble(aDALHistorico.Select(id).ElementAt(i).Preco);
                            tc.CssClass = "txt18";
                            tr.Controls.Add(tc);
                        }


                        t.Controls.Add(tr);
                    }
                    t.CssClass = "tablel table table-striped";
                    PlaceHolder1.Controls.Add(t);
                }
            }

            if (Convert.ToInt32(Session["Nivel"]) == 2)
            {
                int id = Convert.ToInt32(Session["idlogin"]);
                DAL.DALNutricionista aDALNutricionista = new DAL.DALNutricionista();

                LabelNome.Text = aDALNutricionista.Select(id).ElementAt(0).Nome;


                /*Table tb;
                 * TableRow tr;
                 * TableCell tc1, tc2;
                 * Image img;
                 * Label Nome, RG, Telefone, Email, a;
                 * HtmlGenericControl h1, h3, h4;
                 *
                 * img = new Image();
                 * img.ImageUrl = "~/Imagens/user.jpg";
                 * img.CssClass = "img-responsive img-circle";
                 *
                 * Nome = new Label();
                 * Nome.Text = aDALNutricionista.Select(id).ElementAt(0).Nome;
                 *
                 * //RG = new Label();
                 * //RG.Text = aDALNutricionista.Select(id).ElementAt(0).RG;
                 *
                 * Telefone = new Label();
                 * Telefone.Text = aDALNutricionista.Select(id).ElementAt(0).Telefone;
                 *
                 * Email = new Label();
                 * Email.Text = aDALNutricionista.Select(id).ElementAt(0).Email;
                 *
                 * h1 = new HtmlGenericControl("h1");
                 *
                 * tb = new Table();
                 *
                 * tr = new TableRow();
                 *
                 * tc1 = new TableCell();
                 *
                 * a = new Label();
                 * a.Text = "Nome :";
                 * a.ForeColor = System.Drawing.Color.FromArgb(34, 139, 34);
                 *
                 * tc2 = new TableCell();
                 * tc2.RowSpan = 7;
                 *
                 * tc2.Controls.Add(img);
                 * h1.Controls.Add(Nome);
                 * tc1.Controls.Add(h1);
                 * tr.Controls.Add(tc2);
                 * tr.Controls.Add(tc1);
                 * tb.Controls.Add(tr);
                 *
                 * tr = new TableRow();
                 *
                 * tc1 = new TableCell();
                 *
                 * h3 = new HtmlGenericControl("h3");
                 *
                 * a = new Label();
                 * a.Text = "RG :";
                 * a.ForeColor = System.Drawing.Color.FromArgb(34, 139, 34);
                 *
                 * h3.Controls.Add(a);
                 * tc1.Controls.Add(h3);
                 * tr.Controls.Add(tc1);
                 * tb.Controls.Add(tr);
                 *
                 * //tr = new TableRow();
                 *
                 * //tc1 = new TableCell();
                 *
                 * //h4 = new HtmlGenericControl("h4");
                 *
                 * //h4.Controls.Add(RG);
                 * //tc1.Controls.Add(h4);
                 * //tr.Controls.Add(tc1);
                 * //tb.Controls.Add(tr);
                 *
                 * tr = new TableRow();
                 *
                 * tc1 = new TableCell();
                 *
                 * h3 = new HtmlGenericControl("h3");
                 *
                 * a = new Label();
                 * a.Text = "Telefone :";
                 * a.ForeColor = System.Drawing.Color.FromArgb(34, 139, 34);
                 *
                 * h3.Controls.Add(a);
                 * tc1.Controls.Add(h3);
                 * tr.Controls.Add(tc1);
                 * tb.Controls.Add(tr);
                 *
                 * tr = new TableRow();
                 *
                 * tc1 = new TableCell();
                 *
                 * h4 = new HtmlGenericControl("h4");
                 *
                 *
                 * h4.Controls.Add(Telefone);
                 * tc1.Controls.Add(h4);
                 * tr.Controls.Add(tc1);
                 * tb.Controls.Add(tr);
                 *
                 * tr = new TableRow();
                 *
                 * tc1 = new TableCell();
                 *
                 * h3 = new HtmlGenericControl("h3");
                 *
                 * a = new Label();
                 * a.Text = "Email :";
                 * a.ForeColor = System.Drawing.Color.FromArgb(34, 139, 34);
                 *
                 * h3.Controls.Add(a);
                 * tc1.Controls.Add(h3);
                 * tr.Controls.Add(tc1);
                 * tb.Controls.Add(tr);
                 *
                 * tr = new TableRow();
                 *
                 * tc1 = new TableCell();
                 *
                 * h4 = new HtmlGenericControl("h4");
                 *
                 * h4.Controls.Add(Email);
                 * tc1.Controls.Add(h4);
                 * tr.Controls.Add(tc1);
                 * tb.Controls.Add(tr);
                 *
                 * PlaceHolder1.Controls.Add(tb);*/
            }
        }