public static List <EntitySatis> SatisListesi()
{
List <EntitySatis> degerler = new List <EntitySatis>();
SqlCommand komut = new SqlCommand("SATISLAR", Baglanti.bgl);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntitySatis ent = new EntitySatis();
ent.Satisid = int.Parse(dr["SATISID"].ToString());
ent.Urunad = dr["URUNAD"].ToString();
ent.Personelad = dr["PERSONEL"].ToString();
ent.Musteriad = dr["MUSTERI"].ToString();
ent.Fiyat = decimal.Parse(dr["TUTAR"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
public static EntitySatis SatisGetirById(int?id)
{
EntitySatis entitySatis = new EntitySatis();
SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceSatis.spSatislarById, Baglanti.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@p1", id);
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
entitySatis.SatisId = Convert.ToInt32(dr[ResourceSatis.SATISID]);
entitySatis.Urun = dr[ResourceSatis.URUNAD].ToString();
entitySatis.Personel = dr[ResourceSatis.PERSONEL].ToString();
entitySatis.Musteri = dr[ResourceSatis.MUSTERI].ToString();
entitySatis.Tutar = Convert.ToDecimal(dr[ResourceSatis.TUTAR]);
entitySatis.MusteriId = Convert.ToInt32(dr[ResourceSatis.MUSTERIID]);
entitySatis.UrunId = Convert.ToInt32(dr[ResourceSatis.URUNID]);
entitySatis.PersonelId = Convert.ToInt32(dr[ResourceSatis.PERID]);
}
dr.Close();
return(entitySatis);
}
public static List <EntitySatis> SatisListesi()
{
List <EntitySatis> degerler = new List <EntitySatis>();
SqlCommand komut = new SqlCommand("SATISLAR", Baglanti.baglanti);
komut.CommandType = CommandType.StoredProcedure;
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntitySatis ent = new EntitySatis();
ent.SatisId = int.Parse(dr["SATISID"].ToString());
ent.UrunAd = dr["URUNAD"].ToString();
ent.PersonelAd = dr["PERSONEL"].ToString(); //PROSEDÜRÜ YAZARKEN PERSONEL OLARAK ETİKETLEDİK. O YÜZDEN BURADA TEK TEK AT SOYAD YAZMAK YERİNE O TAGİ YAZARSAN İKİSİNİ DE YAZDIRIR
// ent.PersonelSoyad = dr["PERSONELSOYAD"].ToString();
ent.MusteriAd = dr["MUSTERIM"].ToString();
// ent.MusteriSoyad = dr["MUSTERISOYAD"].ToString();
// ent.Fiyat = decimal.Parse(dr["TUTAR"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
protected void Button1_Click(object sender, EventArgs e)
{
EntitySatis ent = new EntitySatis();
ent.Fiyat = decimal.Parse(TextBox3.Text);
ent.Urun = byte.Parse(DropDownUrun.SelectedValue);
ent.Personel = byte.Parse(DropDownPersonel.SelectedValue);
ent.Musteri = byte.Parse(DropDownMusteri.SelectedValue);
BLLSatis.BLLSatisEkle(ent);
}
protected void Page_Load(object sender, EventArgs e)
{
EntitySatis entitySatis = BLLSatis.SatisGetirById(Convert.ToByte(Request.QueryString["id"]));
txtSatisId.Text = entitySatis.SatisId.ToString();
txtSatisTutar.Text = entitySatis.Tutar.ToString();
SetUrunlerToDropdown(entitySatis);
SetPersonellerToDropdown(entitySatis);
SetMusterilerToDropdown(entitySatis);
}
public static int BLLSatisEkle(EntitySatis m)
{
if (m.Personel != 0 & m.Urun != 0 & m.Musteri != 0)
{
return(DALSatis.SatisEkle(m));
}
else
{
return(-1);
}
}
public static int SatisEkle(EntitySatis satisDeger)
{
SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceSatis.InsertSatisSorgu, Baglanti.connection);
command.Parameters.AddWithValue(ResourceSatis.Parameter1, satisDeger.UrunId);
command.Parameters.AddWithValue(ResourceSatis.Parameter2, satisDeger.PersonelId);
command.Parameters.AddWithValue(ResourceSatis.Parameter3, satisDeger.MusteriId);
command.Parameters.AddWithValue(ResourceSatis.Parameter4, satisDeger.Tutar);
return(command.ExecuteNonQuery());
}
public static int SatisGuncelle(EntitySatis entitySatis)
{
if (entitySatis.UrunId > 0 &&
entitySatis.PersonelId > 0 &&
entitySatis.MusteriId > 0 &&
entitySatis.Tutar > 0)
{
return(DALSatis.SatisGuncelle(entitySatis));
}
return(-1);
}
public static int SatisGuncelle(EntitySatis satisDeger)
{
SqlCommand command = MyExtensions.CreateCommandAndOpenConnection(ResourceSatis.UpdateSatisSorgu, Baglanti.connection);
command.Parameters.AddWithValue(ResourceSatis.IdParameter, satisDeger.SatisId);
command.Parameters.AddWithValue(ResourceSatis.PersonelParam, satisDeger.PersonelId);
command.Parameters.AddWithValue(ResourceSatis.MusteriParam, satisDeger.MusteriId);
command.Parameters.AddWithValue(ResourceSatis.UrunParam, satisDeger.UrunId);
command.Parameters.AddWithValue(ResourceSatis.TutarParam, satisDeger.Tutar);
return(command.ExecuteNonQuery());
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
EntitySatis entitySatis = new EntitySatis();
entitySatis.UrunId = Convert.ToByte(cmbUrun.SelectedValue);
entitySatis.PersonelId = Convert.ToByte(cmbPersonel.SelectedValue);
entitySatis.MusteriId = Convert.ToByte(cmbMusteri.SelectedValue);
entitySatis.Tutar = Convert.ToDecimal(txtSatisTutar.Text);
int sonuc = BLLSatis.SatisEkle(entitySatis);
MyPresentationExtensions.ShowErrorMessageOrRedirect(sonuc, ResourceSatis.SatislarSayfasi, ResourceSatis.SatisEkleError);
}
private void SetMusterilerToDropdown(EntitySatis entitySatis)
{
if (cmbMusteri.Items.Count == 0)
{
List <EntityMusteri> musteriList = BLLMusteri.BLLMusteriListele();
foreach (var item in musteriList)
{
cmbMusteri.Items.Add(new ListItem(item.MusteriAd + ' ' + item.MusteriSoyad, item.MusteriId.ToString()));
}
cmbMusteri.SelectedValue = entitySatis.MusteriId.ToString();
}
}
private void SetPersonellerToDropdown(EntitySatis entitySatis)
{
if (cmbPersonel.Items.Count == 0)
{
List <EntityPersonel> personelList = BLLPersonel.PersonelListele();
foreach (var item in personelList)
{
cmbPersonel.Items.Add(new ListItem(item.PersonelAd + ' ' + item.PersonelSoyad, item.PersonelId.ToString()));
}
cmbPersonel.SelectedValue = entitySatis.PersonelId.ToString();
}
}
private void SetUrunlerToDropdown(EntitySatis entitySatis)
{
if (cmbUrun.Items.Count == 0)
{
List <EntityUrun> urunList = BLLUrun.UrunListele();
foreach (var item in urunList)
{
cmbUrun.Items.Add(new ListItem(item.UrunAd, item.UrunId.ToString()));
}
cmbUrun.SelectedValue = entitySatis.UrunId.ToString();
}
}
public static int SatisEkle(EntitySatis u)
{
SqlCommand komut1 = new SqlCommand("insert into TBLSATIS (URUN,PERSONEL,TUTAR,MUSTERI) values (@U1,@U2,@U3,@U4)", Baglanti.bgl);
if (komut1.Connection.State != ConnectionState.Open)
{
komut1.Connection.Open();
}
komut1.Parameters.AddWithValue("@U1", u.Urun);
komut1.Parameters.AddWithValue("@U2", u.Personel);
komut1.Parameters.AddWithValue("@U3", u.Fiyat);
komut1.Parameters.AddWithValue("@U4", u.Musteri);
return(komut1.ExecuteNonQuery());
}
