protected void btnGuncelle_Click(object sender, EventArgs e)
{
if (txtTCNo.Text.Length == 11)
{
if (!string.IsNullOrEmpty(txtTCNo.Text) & !string.IsNullOrEmpty(txtAdi.Text) & !string.IsNullOrEmpty(txtSoyadi.Text) & !string.IsNullOrEmpty(txtCepNo.Text) & !string.IsNullOrEmpty(txtAdres.Text))
{
EMembers guncellenecek = new EMembers();
guncellenecek.ID = int.Parse(Request.QueryString["memberID"]);
guncellenecek.TCNo = txtTCNo.Text;
guncellenecek.FirstName = txtAdi.Text;
guncellenecek.LastName = txtSoyadi.Text;
guncellenecek.Phone = txtCepNo.Text;
guncellenecek.Address = txtAdres.Text;
bool sonuc = BLLMembers.Update(guncellenecek);
if (sonuc)
{
Response.Write("<script>alert('Harika! Güncellendi!');</script>");
Response.Redirect("Uyeler.aspx?scs=1");
}
else
{
Response.Write("<script>alert('Hay Aksi! Hata Oluştu!')</script>");
}
}
else
{
Response.Write("<script>alert('Eksik bilgi girdiniz. Lütfen kontrol ediniz!')</script>");
}
}
else
{
Response.Write("<script>alert('TC kimlik numarası 11 hane olmalıdır!')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (Request.QueryString["ID"] != null)
{
EMembers member = new EMembers();
member.ID = int.Parse(Request.QueryString["ID"]);
bool sonuc = BLLMembers.Delete(member);
if (sonuc)
{
Response.Write("<script>alert('Harika! Silindi!')</script>");
}
else
{
Response.Write("<script>alert('Hay Aksi! Silinemedi!')</script>");
}
}
rptUyeler.DataSource = BLLMembers.GetAll();
rptUyeler.DataBind();
if (Request.QueryString["scs"] != null)
{
int scsID = Convert.ToInt32(Request.QueryString["scs"].ToString());
if (scsID == 1)
{
Response.Write("<script>alert('Harika! Güncellendi!');</script>");
}
}
}
private void btnSil_Click(object sender, EventArgs e)
{
EMembers silinecekMember = (EMembers)dataGridView1.SelectedRows[0].DataBoundItem;
if (silinecekMember != null)
{
DialogResult result = MessageBox.Show("Silmek istediğinize emin misiniz ?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
EMembers member = new EMembers();
member.ID = silinecekMember.ID;
bool sonuc = BLLMembers.Delete(member);
if (sonuc)
{
MessageBox.Show("Silme işleminiz başarıyla tamamlanmıştır.");
dataGridView1.DataSource = BLLMembers.GetAll();
}
else
{
MessageBox.Show("Bir hata oluştu!");
}
}
}
else
{
MessageBox.Show("Lütfen silmek istediğiniz üyeyi seçiniz!");
}
}
public static void Delete(EMembers member)
{
SqlCommand cmd = new SqlCommand("spMembers_Delete", Baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("memberID", member.ID);
Baglanti.conn.Open();
cmd.ExecuteNonQuery();
Baglanti.conn.Close();
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
seciliuye = (EMembers)dataGridView1.SelectedRows[0].DataBoundItem;
txtTCNo.Text = seciliuye.TCNo;
txtAd.Text = seciliuye.FirstName;
txtSoyad.Text = seciliuye.LastName;
txtCepNo.Text = seciliuye.Phone;
txtAdres.Text = seciliuye.Address;
}
public static bool InsertNewMember(EMembers member)
{
if (member.TCNo == "" || member.FirstName == "" || member.LastName == "" || member.Phone == "")
{
return(false);
}
else
{
DALMembers.InsertNewMember(member);
return(true);
}
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtTCNo.Text) & !string.IsNullOrEmpty(txtAdi.Text) & !string.IsNullOrEmpty(txtSoyadi.Text) & !string.IsNullOrEmpty(txtCepNo.Text) & !string.IsNullOrEmpty(txtAdres.Text))
{
if (txtTCNo.Text.Length == 11)
{
List <EMembers> memberList = BLLMembers.GetAll();
memberList = (from l in memberList
where l.TCNo.Trim().ToLower().Equals(txtTCNo.Text.Trim().ToLower())
select l).ToList();
if (memberList.Count == 0)
{
EMembers member = new EMembers();
member.TCNo = txtTCNo.Text;
member.FirstName = txtAdi.Text;
member.LastName = txtSoyadi.Text;
member.Phone = txtCepNo.Text;
member.Address = txtAdres.Text;
if (BLLMembers.InsertNewMember(member))
{
Response.Write("<script>alert('Üye kayıt işleminiz başarıyla gerçekleşmiştir.')</script>");
}
else
{
Response.Write("<script>alert('Hata Oluştu!')</script>");
}
}
else
{
Response.Write("<script>alert('Kaydetmek istediğiniz üye zaten kayıtlı!')</script>");
}
txtTCNo.Text = String.Empty;
txtAdi.Text = String.Empty;
txtSoyadi.Text = String.Empty;
txtCepNo.Text = String.Empty;
txtAdres.Text = String.Empty;
txtTCNo.Focus();
}
else
{
Response.Write("<script>alert('TC Kimlik Numarası 11 hane olmalıdır!')</script>");
}
}
else
{
Response.Write("<script>alert('Eksik bilgi girdiniz. Lütfen kontrol ediniz!')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int memberID = Convert.ToInt32(Request.QueryString["memberID"].ToString());
EMembers member = new EMembers();
member = BLLMembers.GetIdOnly(memberID);
txtAdi.Text = member.FirstName;
txtSoyadi.Text = member.LastName;
txtTCNo.Text = member.TCNo;
txtCepNo.Text = member.Phone;
txtAdres.Text = member.Address;
}
}
public static void Update(EMembers member)
{
SqlCommand cmd = new SqlCommand("spMembers_Update", Baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TCNo", member.TCNo);
cmd.Parameters.AddWithValue("@FirstName", member.FirstName);
cmd.Parameters.AddWithValue("@LastName", member.LastName);
cmd.Parameters.AddWithValue("Phone", member.Phone);
cmd.Parameters.AddWithValue("Adres", member.Address);
cmd.Parameters.AddWithValue("@MemberID", member.ID);
Baglanti.conn.Open();
cmd.ExecuteNonQuery();
Baglanti.conn.Close();
}
private void btnKaydet_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtAd.Text) & !string.IsNullOrEmpty(txtSoyad.Text) & !string.IsNullOrEmpty(txtTCNo.Text) & !string.IsNullOrEmpty(txtCepNo.Text) & !string.IsNullOrEmpty(txtAdres.Text))
{
if (txtTCNo.Text.Length == 11)
{
List <EMembers> memberList = BLLMembers.GetAll();
memberList = (from l in memberList
where l.TCNo.Trim().ToLower().Equals(txtTCNo.Text.Trim().ToLower())
select l).ToList();
if (memberList.Count == 0)
{
EMembers member = new EMembers();
member.TCNo = txtTCNo.Text;
member.FirstName = txtAd.Text;
member.LastName = txtSoyad.Text;
member.Phone = txtCepNo.Text;
member.Address = txtAdres.Text;
bool sonuc = BLLMembers.InsertNewMember(member);
if (sonuc)
{
MessageBox.Show("Yeni üye kaydı başarıyla tamamlanmıştır!");
dataGridView1.DataSource = BLLMembers.GetAll();
Clear();
}
else
{
MessageBox.Show("Bir hata oluştu!");
}
}
else
{
MessageBox.Show("Aynı TC kimlik numarasına sahip personel zaten kayıtlıdır!");
}
}
else
{
MessageBox.Show("TC kimlik numarası 11 haneli olmalıdır!");
}
}
else
{
MessageBox.Show("Eksik bilgi girdiniz. Lütfen kontrol ediniz!");
}
}
public static List <EMembers> GetMemberNames()
{
SqlCommand cmd = new SqlCommand("spMembers_GetNames", Baglanti.conn);
Baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
List <EMembers> mliste = new List <EMembers>();
while (dr.Read())
{
EMembers m = new EMembers();
m.ID = Convert.ToInt32(dr["ID"]);
m.FullName = dr["FullName"].ToString();
mliste.Add(m);
}
dr.Close();
Baglanti.conn.Close();
return(mliste);
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
if (seciliuye != null)
{
if (!string.IsNullOrEmpty(txtAd.Text) & !string.IsNullOrEmpty(txtSoyad.Text) & !string.IsNullOrEmpty(txtTCNo.Text) & !string.IsNullOrEmpty(txtCepNo.Text) & !string.IsNullOrEmpty(txtAdres.Text))
{
if (txtTCNo.Text.Length == 11)
{
EMembers member = new EMembers();
member.ID = seciliuye.ID;
member.TCNo = txtTCNo.Text;
member.FirstName = txtAd.Text;
member.LastName = txtSoyad.Text;
member.Phone = txtCepNo.Text;
member.Address = txtAdres.Text;
bool sonuc = BLLMembers.Update(member);
if (sonuc)
{
MessageBox.Show("Güncelleme başarılı!");
dataGridView1.DataSource = BLLMembers.GetAll();
Clear();
}
else
{
MessageBox.Show("Güncelleme başarısız oldu!");
}
}
else
{
MessageBox.Show("TC kimlik numarası 11 haneli olmalıdır!");
}
}
else
{
MessageBox.Show("Eksik bilgi girdiniz. Lütfen kontrol ediniz!");
}
}
else
{
MessageBox.Show("Güncelleme işlemini yapmak istidiğiniz yazarı seçiniz.");
}
}
public static EMembers GetIdOnly(int memberID)
{
SqlCommand cmd = new SqlCommand("spMembers_GetIdOnly", Baglanti.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MemberID", memberID);
Baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
EMembers member = new EMembers();
while (dr.Read())
{
member.ID = Convert.ToInt32(dr["ID"]);
member.TCNo = dr["TC No"].ToString();
member.FirstName = dr["FirstName"].ToString();
member.LastName = dr["LastName"].ToString();
member.Phone = dr["Phone"].ToString();
member.Address = dr["Adres"].ToString();
}
dr.Close();
Baglanti.conn.Close();
return(member);
}
public static List <EMembers> GetAll()
{
SqlCommand cmd = new SqlCommand("spMembers_GetAll", Baglanti.conn);
Baglanti.conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
List <EMembers> eliste = new List <EMembers>();
while (dr.Read())
{
EMembers e = new EMembers();
e.ID = Convert.ToInt32(dr["ID"]);
e.TCNo = dr["TC No"].ToString();
e.FirstName = dr["FirstName"].ToString();
e.LastName = dr["LastName"].ToString();
e.Phone = dr["Phone"].ToString();
e.Address = dr["Adres"].ToString();
eliste.Add(e);
}
dr.Close();
Baglanti.conn.Close();
return(eliste);
}
public static bool Delete(EMembers member)
{
DALMembers.Delete(member);
return(true);
}
public static bool Update(EMembers member)
{
DALMembers.Update(member);
return(true);
}
