public static int TalepEkleBLL(EntityBasvuruForm p)
{
if (p.BASDERSID != null && p.BASOGRID != null)
{
return(DALDers.TalepEkle(p));
}
return(-1);
}
protected void Button1_Click(object sender, EventArgs e)
{
EntityBasvuruForm ent = new EntityBasvuruForm();
ent.Basvuruogrid = int.Parse(TextBox1.Text);
ent.Basvurudersid = int.Parse(DropDownList1.SelectedValue.ToString());
BLLDers.talepEkleBLL(ent);
}
public static int TalepEkleBLL(EntityBasvuruForm p)
{
if (p.Basogrid > 0 && p.Basdersid > 0)
{
return(DALDers.TalepEkle(p));
}
return(-1);
}
protected void Button1_Click(object sender, EventArgs e)
{
EntityBasvuruForm ent = new EntityBasvuruForm();
ent.BASDERSID = int.Parse(DropDownList1.SelectedValue.ToString());
ent.BASOGRID = int.Parse(TextBox1.Text);
BLLDers.BllTalepEkle(ent);
}
public static int TalepEkle(EntityBasvuruForm p)
{
if (Convert.ToInt32(p.BASOGRID).ToString() != null && Convert.ToInt32(p.BASDERSID).ToString() != null)
{
return(DALDers.TalepEkle(p));
}
return(-1);
}
public static int TalepEkleBll(EntityBasvuruForm p)
{
if (p.Basvuruid != null && p.Dersid != null)
{
return(DALDers.TalepEkle(p));
}
return(-1);
}
public static int TalepEkle(EntityBasvuruForm parametre)
{
SqlCommand komut = new SqlCommand("insert into TBLBASVURUFORM(OGRENCIID,DERSIS) values(@p1,@p2)");
komut.Parameters.AddWithValue("@p1", parametre.BASOGRID);
komut.Parameters.AddWithValue("@p2", parametre.BASDERSID);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
return(komut.ExecuteNonQuery());
}
public static int TalepEkle(EntityBasvuruForm parametre)
{
SqlCommand komut = new SqlCommand("insert into Tbl_BasvuruForm (Ogrid,Dersid) values(@p1,@p2)", Baglanti.bgl);
komut.Parameters.AddWithValue("@p1", parametre.BASOGRID);
komut.Parameters.AddWithValue("@p2", parametre.BASDERSID);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
return(komut.ExecuteNonQuery());
}
public static int TalepEkle(EntityBasvuruForm parametre)
{
SqlCommand komut = new SqlCommand("insert into tbl_basvuruform (OgrenciId,DersId) values (@p1,@p2)", Baglanti.bgl);
komut.Parameters.AddWithValue("@p1", parametre.Basvuruid);
komut.Parameters.AddWithValue("@p2", parametre.Dersid);
if (komut.Connection.State == ConnectionState.Closed)
{
komut.Connection.Open();
}
return(komut.ExecuteNonQuery());
}
public static int TalepEkle(EntityBasvuruForm parametre)
{
SqlCommand komut = new SqlCommand("insert into TBLBASVURUFORM (OGRENCIID,DERSID) values (@P1,@P2)", Baglanti.bgl);
komut.Parameters.AddWithValue("@P1", parametre.Basogrid);
komut.Parameters.AddWithValue("@P2", parametre.Basdersid);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
return(komut.ExecuteNonQuery());
}
public static List <EntityBasvuruForm> TalepListesi()
{
List <EntityBasvuruForm> degerler = new List <EntityBasvuruForm>();
SqlCommand komut = new SqlCommand("select * from TBLBASVURU", Baglanti.bgl);
if (komut.Connection.State != ConnectionState.Open)
{
komut.Connection.Open();
}
SqlDataReader dr = komut.ExecuteReader();
while (dr.Read())
{
EntityBasvuruForm ent = new EntityBasvuruForm();
ent.BASVURUID = int.Parse(dr["BASVURUID"].ToString());
ent.BASOGRID = int.Parse(dr["OGRID"].ToString());
ent.BASDERSİD = int.Parse(dr["DERSID"].ToString());
degerler.Add(ent);
}
dr.Close();
return(degerler);
}
