public static List <ENTITYSATIS> SATISLISTELE()
{
List <ENTITYSATIS> degerler = new List <ENTITYSATIS>();
SqlCommand komut = new SqlCommand("SATISLAR", SQLBAGLANTISI.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.Musteriad = dr["MUSTERI"].ToString();
ent.Satisid = Convert.ToInt32(dr["SATISID"]);
ent.Urunad = dr["URUNAD"].ToString();
ent.Personelad = dr["PERSONEL"].ToString();
// ent.Personelsoyad = dr["PERSONELSOYAD"].ToString();
ent.Musteriad = dr["MUSTERI"].ToString();
ent.TUTAR = Convert.ToDecimal(dr["TUTAR"]);
//ent.Musterisoyad = dr["MUSTERISOYAD"].ToString();
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
ENTITYURUN ent = new ENTITYURUN();
ENTITYPERSONEL ent1 = new ENTITYPERSONEL();
ENTITYMUSTERI ent2 = new ENTITYMUSTERI();
ENTITYSATIS ent3 = new ENTITYSATIS();
DropDownList1.DataValueField = "URUNID";
ent.Urunid = Convert.ToInt32(DropDownList1.SelectedIndex);
ent1.Personelid = Convert.ToInt32(DropDownList2.SelectedIndex);
ent2.Musteriid = Convert.ToInt32(DropDownList3.SelectedIndex);
ent3.TUTAR = Convert.ToDecimal(TextBox1.Text);
BALSATIS.SATISYAP(ent2, ent, ent1, ent3);
}
public static int SATISYAP(ENTITYMUSTERI mus, ENTITYURUN ur, ENTITYPERSONEL per, ENTITYSATIS sat)
{
SqlCommand komut = new SqlCommand("INSERT INTO TBlSATIS(URUN,PERSONEL,TUTAR,MUSTERI) values(@p1,@p2,@p3,@p4)", SQLBAGLANTISI.bgl);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
komut.Parameters.AddWithValue("@p1", mus.Musteriid);
komut.Parameters.AddWithValue("@p2", ur.Urunid);
komut.Parameters.AddWithValue("@p3", sat.TUTAR);
komut.Parameters.AddWithValue("@p4", mus.Musteriid);
return(komut.ExecuteNonQuery());
}
public static int SATISYAP(ENTITYMUSTERI MUS, ENTITYURUN UR, ENTITYPERSONEL PER, ENTITYSATIS SAT)
{
return(DALSATIS.SATISYAP(MUS, UR, PER, SAT));
}
