protected void btnSave_Click(object sender, EventArgs e) { var address = new Address(); address.Name = txtName.Text; address.SurName = txtSurname.Text; address.Nick = txtNick.Text; address.BirthDate = calBirth.SelectedDate; if (ddlGender.SelectedValue != "Seçiniz") { address.Gender = ddlGender.SelectedValue == "Bay"; } address.MobileNumber = txtMobile.Text; address.HomeNumber = txtHome.Text; address.Fax = txtFax.Text; address.Email = txtEmail.Text; address.UserAddress = txtAddress.Text; address.Note = txtNote.Text; var rowCount = _helper.AddAddress(address); if (rowCount > 0) { ClearAddressForm(); } }
public int AddAddress(Address address) { var conn = GetConnection(); var command = new SqlCommand(); command.Connection = conn; command.CommandText = @"INSERT INTO [dbo].[Kisiler] ([Ad] ,[Soyad] ,[TakmaAd] ,[DogumTarihi] ,[Cinsiyet] ,[Telefon1] ,[Telefon2] ,[Faks] ,[Eposta] ,[Adres] ,[Not]) VALUES (@Ad ,@Soyad ,@TakmaAd ,@DogumTarihi ,@Cinsiyet ,@Telefon1 ,@Telefon2 ,@Faks ,@Eposta ,@Adres ,@Not)"; command.Parameters.Add(new SqlParameter("@Ad", address.Name)); command.Parameters.Add(new SqlParameter("@Soyad", address.SurName)); command.Parameters.Add(new SqlParameter("@TakmaAd", address.Nick)); command.Parameters.Add(new SqlParameter("@DogumTarihi", address.BirthDate)); command.Parameters.Add(new SqlParameter("@Cinsiyet", address.Gender)); command.Parameters.Add(new SqlParameter("@Telefon1", address.MobileNumber)); command.Parameters.Add(new SqlParameter("@Telefon2", address.HomeNumber)); command.Parameters.Add(new SqlParameter("@Faks", address.Fax)); command.Parameters.Add(new SqlParameter("@Eposta", address.Email)); command.Parameters.Add(new SqlParameter("@Adres", address.UserAddress)); command.Parameters.Add(new SqlParameter("@Not", address.Note)); conn.Open(); var retVal = command.ExecuteNonQuery(); conn.Close(); conn.Dispose(); return retVal; }
protected void btnSave_Click(object sender, EventArgs e) { int id; if (!int.TryParse(Request.QueryString["id"], out id)) { return; } var address = new Address(); address.Id = id; address.Name = txtName.Text; address.SurName = txtSurname.Text; address.Nick = txtNick.Text; address.BirthDate = calBirth.SelectedDate; if (ddlGender.SelectedValue != "Seçiniz") { address.Gender = ddlGender.SelectedValue == "Bay"; } address.MobileNumber = txtMobile.Text; address.HomeNumber = txtHome.Text; address.Fax = txtFax.Text; address.Email = txtEmail.Text; address.UserAddress = txtAddress.Text; address.Note = txtNote.Text; var res = _helper.UpdateAddress(address); if (res > 0) { lblInfo.Visible = true; } }
public Address GetAddress(int id) { var retVal = new Address(); var conn = GetConnection(); var command = new SqlCommand("SELECT * FROM Kisiler WHERE Id = @Id", conn); command.Parameters.Add(new SqlParameter("@Id", id)); conn.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { retVal = new Address { Id = Convert.ToInt32(reader["Id"]), Name = reader["Ad"].ToString(), SurName = reader["Soyad"].ToString(), Nick = reader["TakmaAd"].ToString(), BirthDate = Convert.ToDateTime(reader["DogumTarihi"]), Gender = Convert.ToBoolean(reader["Cinsiyet"]), MobileNumber = reader["Telefon1"].ToString(), Fax = reader["Faks"].ToString(), UserAddress = reader["Adres"].ToString(), Email = reader["Eposta"].ToString(), Note = reader["Not"].ToString(), HomeNumber = reader["Telefon2"].ToString() }; } conn.Close(); conn.Dispose(); return retVal; }
public int UpdateAddress(Address address) { if (address.Id <= 0) { return 0; } var conn = GetConnection(); var command = new SqlCommand(); command.Connection = conn; command.CommandText = @"UPDATE [dbo].[Kisiler] SET [Ad] = @Ad ,[Soyad] = @Soyad ,[TakmaAd] = @TakmaAd ,[DogumTarihi] = @DogumTarihi ,[Cinsiyet] = @Cinsiyet ,[Telefon1] = @Telefon1 ,[Telefon2] = @Telefon2 ,[Faks] = @Faks ,[Eposta] = @Eposta ,[Adres] = @Adres ,[Not] = @Not WHERE Id = @Id"; command.Parameters.Add(new SqlParameter("@Id", address.Id)); command.Parameters.Add(new SqlParameter("@Ad", address.Name)); command.Parameters.Add(new SqlParameter("@Soyad", address.SurName)); command.Parameters.Add(new SqlParameter("@TakmaAd", address.Nick)); command.Parameters.Add(new SqlParameter("@DogumTarihi", address.BirthDate)); command.Parameters.Add(new SqlParameter("@Cinsiyet", address.Gender)); command.Parameters.Add(new SqlParameter("@Telefon1", address.MobileNumber)); command.Parameters.Add(new SqlParameter("@Telefon2", address.HomeNumber)); command.Parameters.Add(new SqlParameter("@Faks", address.Fax)); command.Parameters.Add(new SqlParameter("@Eposta", address.Email)); command.Parameters.Add(new SqlParameter("@Adres", address.UserAddress)); command.Parameters.Add(new SqlParameter("@Not", address.Note)); conn.Open(); var retVal = command.ExecuteNonQuery(); conn.Close(); conn.Dispose(); return retVal; }