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());
}
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);
}
}
}
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();
}
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();
}
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);*/
}
}