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