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;
}
