public static int MusteriEkle(EntityMusteri musteriDeger)
{
SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceMusteri.InsertMusteriSorgu, Baglanti.connection);
command.Parameters.AddWithValue(ResourceMusteri.Parameter1, musteriDeger.MusteriAd);
command.Parameters.AddWithValue(ResourceMusteri.Parameter2, musteriDeger.MusteriSoyad);
return(command.ExecuteNonQuery());
}
public static int BLLMusteriEkle(EntityMusteri musteri)
{
if (musteri.MusteriSoyad != null && musteri.MusteriSoyad != " " && musteri.MusteriAd != "")
{
return(DALMusteri.MusteriEkle(musteri));
}
return(-1);
}
protected void kaydet_Click(object sender, EventArgs e)
{
EntityMusteri ekle = new EntityMusteri();
ekle.MusteriAd = TextBox1.Text;
ekle.MusteriSoyad = TextBox2.Text;
BLLMusteri.BLLMusteriEkle(ekle);
}
public static bool MusteriGuncelle(EntityMusteri musteri)
{
if (musteri.MusteriAd != " " && musteri.MusteriSoyad != " ")
{
return(DALMusteri.MusteriGuncelle(musteri));
}
return(false);
}
public static bool BLLMusteriGuncelle(EntityMusteri p)
{
if (p.Musteriad != "" && p.Musterisoyad != "")
{
return(DALMusteri.MusteriGuncelle(p));
}
return(false);
}
protected void Button1_Click(object sender, EventArgs e)
{
EntityMusteri ent = new EntityMusteri();
ent.Musteriad = TextBox1.Text;
ent.Musterisoyad = TextBox2.Text;
BLLMusteri.BLLMusteriEkle(ent);
}
protected void Page_Load(object sender, EventArgs e)
{
int x = Convert.ToInt32(Request.QueryString["MUSTERIID"]);
EntityMusteri ent = new EntityMusteri();
ent.Musteriid = x;
BLLMusteri.MusteriSil(ent.Musteriid);
Response.Redirect("Musteriler.aspx");
}
public static bool MuseriSil(EntityMusteri musterisil)
{
if (musterisil.MusteriId != 0)
{
return(DALMusteri.MusteriSil(musterisil));
}
return(false);
}
public static int BLLMusteriGuncelle(EntityMusteri entityMusteri)
{
if (entityMusteri.MusteriAd != "" && entityMusteri.MusteriSoyad != "")
{
return(DALMusteri.MusteriGuncelle(entityMusteri));
}
return(-1);
}
public static int MusteriGuncelle(EntityMusteri musteriDeger)
{
SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceMusteri.UpdateMusteriSorgu, Baglanti.connection);
command.Parameters.AddWithValue(ResourceMusteri.AdParam, musteriDeger.MusteriAd);
command.Parameters.AddWithValue(ResourceMusteri.SoyadParam, musteriDeger.MusteriSoyad);
command.Parameters.AddWithValue(ResourceDepartman.IdParameter, musteriDeger.MusteriId);
return(command.ExecuteNonQuery());
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
EntityMusteri entityMusteri = new EntityMusteri();
entityMusteri.MusteriAd = txtMusteriAd.Text;
entityMusteri.MusteriSoyad = txtMusteriSoyad.Text;
int sonuc = BLLMusteri.BLLMusteriEkle(entityMusteri);
MyPresentationExtensions.ShowErrorMessageOrRedirect(sonuc, ResourceMusteri.MusterilerSayfasi, ResourceMusteri.MusteriEkleError);
}
protected void Button1_Click(object sender, EventArgs e)
{
EntityMusteri ent = new EntityMusteri();
ent.Musteriad = TextBox1.Text;
ent.Musterisoyad = TextBox2.Text;
ent.Musteriid = Convert.ToInt32(TextBox3.Text);
BLLMusteri.BLLMusteriGuncelle(ent);
Response.Redirect("Musteriler.aspx");
}
protected void kaydet_Click(object sender, EventArgs e)
{
EntityMusteri guncelle = new EntityMusteri();
guncelle.MusteriAd = TextBox1.Text;
guncelle.MusteriSoyad = TextBox2.Text;
guncelle.MusteriId = Convert.ToInt32(TextBox3.Text);
BLLMusteri.MusteriGuncelle(guncelle);
Response.Redirect("Musteriler.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
EntityMusteri entityMusteri = BLLMusteri.BLLMusteriGetirById(Convert.ToByte(Request.QueryString["id"]));
if (Page.IsPostBack == false)
{
txtMusteriId.Text = entityMusteri.MusteriId.ToString();
txtMusteriAd.Text = entityMusteri.MusteriAd;
txtMusteriSoyad.Text = entityMusteri.MusteriSoyad;
}
}
public static int BLLMusteriEkle(EntityMusteri p)
{
if (p.Musteriad != "" && p.Musterisoyad != "" && p.Musteriad.Length <= 15)
{
return(DALMusteri.MusteriEkle(p));
}
else
{
return(-1);
}
}
public static bool MusteriSil(EntityMusteri musterisil)
{
SqlCommand sil = new SqlCommand("Delete from TBLMUSTERI where MUSTERIID=@p1", Baglanti.baglanti);
if (sil.Connection.State != ConnectionState.Open)
{
sil.Connection.Open();
}
sil.Parameters.AddWithValue("@p1", musterisil.MusteriId);
return(sil.ExecuteNonQuery() > 0);
}
public static int BLLMusteriEkle(EntityMusteri m)
{
if (m.Musteriad != "" && m.Musterisoyad != "" & m.Musteriad.Length <= 50 & m.Musterisoyad.Length <= 50)
{
return(DALMusteri.MusteriEkle(m));
}
else
{
return(-1);
}
}
public static int MusteriEkle(EntityMusteri p)
{
SqlCommand komut2 = new SqlCommand("insert into TBLMUSTERI(MUSTERIAD,MUSTERISOYAD) values (@P1,@P2)", Baglanti.bgl);
if (komut2.Connection.State != ConnectionState.Open)
{
komut2.Connection.Open();
}
komut2.Parameters.AddWithValue("@P1", p.Musteriad);
komut2.Parameters.AddWithValue("@P2", p.Musterisoyad);
return(komut2.ExecuteNonQuery());
}
public static int MusteriEkle(EntityMusteri musteri)
{
SqlCommand ekle = new SqlCommand("insert into TBLMUSTERI (MUSTERIAD,MUSTERISOYAD) values (@MUSTERIAD,@MUSTERISOYAD)", Baglanti.baglanti);
if (ekle.Connection.State != ConnectionState.Open)
{
ekle.Connection.Open();
}
ekle.Parameters.AddWithValue("@MUSTERIAD", musteri.MusteriAd);
ekle.Parameters.AddWithValue("@MUSTERISOYAD", musteri.MusteriSoyad);
return(ekle.ExecuteNonQuery());
}
public static bool MusteriGuncelle(EntityMusteri p)
{
SqlCommand komut5 = new SqlCommand("UPDATE TBLMUSTERI SET MUSTERIAD = @P1, MUSTERISOYAD = @P2 WHERE MUSTERIID = @P3", Baglanti.bgl);
if (komut5.Connection.State != ConnectionState.Open)
{
komut5.Connection.Open();
}
komut5.Parameters.AddWithValue("@P1", p.Musteriad);
komut5.Parameters.AddWithValue("@P2", p.Musterisoyad);
komut5.Parameters.AddWithValue("@P3", p.Musteriid);
return(komut5.ExecuteNonQuery() > 0);
}
protected void Page_Load(object sender, EventArgs e)
{
int x = Convert.ToInt32(Request.QueryString["MUSTERIID"]);
TextBox3.Text = x.ToString();
EntityMusteri ent = new EntityMusteri();
if (Page.IsPostBack == false)
{
List <EntityMusteri> MusList = BLLMusteri.BLLMusteriGetir(x);
TextBox1.Text = MusList[0].Musteriad.ToString();
TextBox2.Text = MusList[0].Musterisoyad.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
int x = Convert.ToInt32(Request.QueryString["MUSTERIID"]);
TextBox3.Text = x.ToString();
EntityMusteri ent = new EntityMusteri();
if (Page.IsPostBack == false)
{
List <EntityMusteri> musterilistesi = BLLMusteri.GuncellemeSayfasiMusteriListele(x);
TextBox1.Text = musterilistesi[0].MusteriAd.ToString();
TextBox2.Text = musterilistesi[0].MusteriSoyad.ToString();
}
}
public static bool MusteriGuncelle(EntityMusteri musteri)
{
SqlCommand guncelle = new SqlCommand("update TBLMUSTERI set MUSTERIAD=@p1, MUSTERISOYAD=@p2 where MUSTERIID=@p3", Baglanti.baglanti);
if (guncelle.Connection.State != ConnectionState.Open)
{
guncelle.Connection.Open();
}
guncelle.Parameters.AddWithValue("@p1", musteri.MusteriAd);
guncelle.Parameters.AddWithValue("@p2", musteri.MusteriSoyad);
guncelle.Parameters.AddWithValue("@p3", musteri.MusteriId);
return(guncelle.ExecuteNonQuery() > 0);
}
public static EntityMusteri MusteriGetirById(int?id)
{
EntityMusteri entityMusteri = new EntityMusteri();
SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceMusteri.SelectMusteriByIdSorgu, Baglanti.connection);
command.Parameters.AddWithValue(ResourceMusteri.IdParameter, id);
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
entityMusteri.MusteriId = Convert.ToInt32(dr[ResourceMusteri.MUSTERIID]);
entityMusteri.MusteriAd = dr[ResourceMusteri.MUSTERIAD].ToString();
entityMusteri.MusteriSoyad = dr[ResourceMusteri.MUSTERISOYAD].ToString();
}
dr.Close();
return(entityMusteri);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int x = Convert.ToInt32(Request.QueryString["MUSTERIID"]);
TextBox3.Text = x.ToString();
EntityMusteri ent = new EntityMusteri();
if (Page.IsPostBack == false)
{
List <EntityMusteri> MusList = BLLMusteri.BLLMusteriGetir(x);
TextBox1.Text = MusList[0].Musteriad.ToString();
TextBox2.Text = MusList[0].Musterisoyad.ToString();
}
}
catch (Exception ex)
{
string script = "<script>alert('" + ex.Message + "');</script>";
}
}
public static List <EntityMusteri> MusteriListesi()
{
List <EntityMusteri> degerler = new List <EntityMusteri>();
SqlCommand komut = new SqlCommand("SELECT * FROM TBLMUSTERI", Baglanti.bgl);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityMusteri ent = new EntityMusteri();
ent.Musteriid = int.Parse(dr["MUSTERIID"].ToString());
ent.Musteriad = dr["MUSTERIAD"].ToString();
ent.Musterisoyad = dr["MUSTERISOYAD"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityMusteri> GuncellemeSayfasinaMusteriListele(int id)
{
List <EntityMusteri> degerler = new List <EntityMusteri>();
SqlCommand komut = new SqlCommand("Select * from TBLMUSTERI where MUSTERIID=@p1", Baglanti.baglanti);
komut.Parameters.AddWithValue("@p1", id);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityMusteri ent = new EntityMusteri();
ent.MusteriAd = dr["MUSTERIAD"].ToString();
ent.MusteriSoyad = dr["MUSTERISOYAD"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static List <EntityMusteri> MusteriGetir(int id)
{
List <EntityMusteri> degerler = new List <EntityMusteri>();
SqlCommand komut4 = new SqlCommand("SELECT *FROM TBLMUSTERI WHERE MUSTERIID = @P1", Baglanti.bgl);
komut4.Parameters.AddWithValue("@P1", id);
if (komut4.Connection.State != ConnectionState.Open)
{
komut4.Connection.Open();
}
SqlDataReader dr = komut4.ExecuteReader();
while (dr.Read())
{
EntityMusteri ent = new EntityMusteri();
// ent.Musteriid = Convert.ToInt32(dr["MUSTERIID"].ToString());
ent.Musteriad = dr["MUSTERIAD"].ToString();
ent.Musterisoyad = dr["MUSTERISOYAD"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
