Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Configuration;
- using System.Data.SqlClient;
- using System.Text;
- using System.Data;
- namespace Restauracja
- {
- public partial class Dodaj : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- //if (!Page.User.IsInRole("administratorzy")) {Visible = false;}
- m_delete.Attributes.Add("onclick", "return(confirm('Czy na pewno chcesz usunąć?'));");
- m_update.Attributes.Add("onclick", "return(alert('Zaktualizowano.'));");
- m_delete.Attributes.Add("onclick", "return(alert('Usunięto.'));");
- String strSearch = this.m_wpisz_id.Text;
- this.m_wpisz_id.Text = null;
- if (strSearch == null)
- {
- if (IsPostBack) return;
- }
- string cs = ConfigurationManager.AppSettings["DBConnectionString"];
- using (SqlConnection con = new SqlConnection(cs))
- {
- StringBuilder sb1 = new StringBuilder();
- sb1.Append("select ID_adresu,Ulica,Numer_domu,Numer_mieszkania,Kod_pocztowy,Miejscowosc from [2PUrban].[dbo].[Adresy] WHERE ID_adresu=@ID");
- SqlCommand cmd = new SqlCommand(sb1.ToString(), con);
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.Add(new SqlParameter("@ID", strSearch));
- con.Open();
- SqlDataReader rdr = cmd.ExecuteReader();
- while (rdr.Read())
- {
- m_id.Text = rdr["ID_adresu"].ToString().Trim();
- m_ulica.Text = rdr["Ulica"].ToString().Trim();
- m_numer_domu.Text = rdr["Numer_domu"].ToString().Trim();
- m__numer_mieszkania.Text = rdr["Numer_mieszkania"].ToString().Trim();
- m_kod_pocztowy.Text = rdr["Kod_pocztowy"].ToString().Trim();
- m_miasto.Text = rdr["Miejscowosc"].ToString().Trim();
- break;
- }
- con.Close();
- }
- }
- protected void m_update_Click(object sender, EventArgs e)
- {
- string cs = ConfigurationManager.AppSettings["DBConnectionString"];
- using (SqlConnection con = new SqlConnection(cs))
- {
- SqlCommand cmd = new SqlCommand("2PUrban.dbo.sp_aktualizuj_adres", con);
- cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter parameter1 = new SqlParameter("@Id", m_id.Text);
- cmd.Parameters.Add(parameter1);
- SqlParameter parameter2 = new SqlParameter("@Ulica", m_ulica.Text);
- cmd.Parameters.Add(parameter2);
- SqlParameter parameter3 = new SqlParameter("@Numer_domu", m_numer_domu.Text);
- cmd.Parameters.Add(parameter3);
- SqlParameter parameter4 = new SqlParameter("@Numer_mieszkania", m__numer_mieszkania.Text);
- cmd.Parameters.Add(parameter4);
- SqlParameter parameter5 = new SqlParameter("@Kod_pocztowy", m_kod_pocztowy.Text);
- cmd.Parameters.Add(parameter5);
- SqlParameter parameter6 = new SqlParameter("@Miejscowosc", m_miasto.Text);
- cmd.Parameters.Add(parameter6);
- con.Open();
- cmd.ExecuteNonQuery();
- }
- Response.Redirect("Edytuj_adres.aspx");
- }
- protected void m_cancel_Click(object sender, EventArgs e)
- {
- Response.Redirect("Edytuj_adres.aspx");
- }
- protected void m_delete_Click(object sender, EventArgs e)
- {
- string cs = ConfigurationManager.AppSettings["DBConnectionString"];
- using (SqlConnection con = new SqlConnection(cs))
- {
- SqlCommand cmd = new SqlCommand("2PUrban.dbo.sp_sp_usun_adres", con);
- cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter parameter1 = new SqlParameter("@Id", m_id.Text);
- cmd.Parameters.Add(parameter1);
- SqlParameter parameter2 = new SqlParameter("@Ulica", m_ulica.Text);
- cmd.Parameters.Add(parameter2);
- SqlParameter parameter3 = new SqlParameter("@Numer_domu", m_numer_domu.Text);
- cmd.Parameters.Add(parameter3);
- SqlParameter parameter4 = new SqlParameter("@Numer_mieszkania", m__numer_mieszkania.Text);
- cmd.Parameters.Add(parameter4);
- SqlParameter parameter5 = new SqlParameter("@Kod_pocztowy", m_kod_pocztowy.Text);
- cmd.Parameters.Add(parameter5);
- SqlParameter parameter6 = new SqlParameter("@Miejscowosc", m_miasto.Text);
- cmd.Parameters.Add(parameter6);
- con.Open();
- cmd.ExecuteNonQuery();
- }
- Response.Redirect("Edytuj_adres.aspx");
- }
- protected void m_wyslij_id_Click(object sender, EventArgs s)
- { }
- }
- }
- __________________________
- <%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Edytuj_adres.aspx.cs" Inherits="Restauracja.Dodaj" %>
- <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
- </asp:Content>
- <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
- <center>
- <hgroup class="title">
- <h2>- edycja adresów -</h2>
- </hgroup>
- <asp:TextBox ID="m_wpisz_id" runat="server"> </asp:TextBox>
- <asp:Button ID="m_wyslij_id" runat="server" Text="Szukaj"> </asp:Button>
- <asp:Repeater ID="m_rptID" runat="server"/>
- <br />
- Numer ID: <asp:Label ID="m_id" runat="server" Text=""></asp:Label>
- <br />
- Ulica: <asp:TextBox ID="m_ulica" runat="server"></asp:TextBox>
- <br />
- Numer domu: <asp:TextBox ID="m_numer_domu" runat="server"></asp:TextBox>
- <br />
- Numer mieszkania: <asp:TextBox ID="m__numer_mieszkania" runat="server"></asp:TextBox>
- <br />
- Kod pocztowy: <asp:TextBox ID="m_kod_pocztowy" runat="server"></asp:TextBox>
- <br />
- Miejscowość: <asp:TextBox ID="m_miasto" runat="server"></asp:TextBox>
- <br />
- <asp:Button ID="m_update" runat="server" Text="Aktualizuj" onclick="m_update_Click" />
- <br />
- <asp:Button ID="m_cancel" runat="server" Text="Anuluj" onclick="m_cancel_Click"/>
- <br />
- <asp:Button ID="m_delete" runat="server" Text="Usuń" onclick="m_delete_Click"/>
- </center>
- </asp:Content>
- USE [2PUrban]
- GO
- /****** Object: StoredProcedure [dbo].[sp_sp_usun_adres] Script Date: 2017-01-16 20:20:18 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE Procedure [dbo].[sp_sp_usun_adres](@Ulica char(30),@Numer_domu char(4),@Numer_mieszkania char(5),@Kod_pocztowy char(6),@Miejscowosc char(20),@ID int)
- as
- DELETE
- FROM [dbo].[Adresy]
- WHERE [ID_adresu] = @id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement