public localpersonel Login(string kulAdi, string parola)
{
localpersonel lp = new localpersonel();
using (SqlConnection conn = new SqlConnection(conStrig))
{
conn.Open();
SqlCommand cmdd = new SqlCommand("spLogin", conn);
cmdd.Parameters.Add(new SqlParameter("@kulAdi", kulAdi));
cmdd.Parameters.Add(new SqlParameter("@parola", parola));
cmdd.CommandTimeout = 600;
cmdd.CommandType = CommandType.StoredProcedure;
SqlDataReader rd = cmdd.ExecuteReader();
if (rd.HasRows == true)
{
rd.Read();
lp.personelAdi = rd["personelAdi"].ToString();
lp.yekiId = (int)rd["yetkiId"];
}
conn.Dispose();
conn.Close();
}
return(lp);
}
public List <localpersonel> PersonelListele()
{
List <localpersonel> lp = new List <localpersonel>();
using (SqlConnection conn = new SqlConnection(conStrig))
{
conn.Open();
SqlCommand cmdd = new SqlCommand("spPersonelListele", conn);
cmdd.CommandTimeout = 600;
cmdd.CommandType = CommandType.StoredProcedure;
SqlDataReader rd = cmdd.ExecuteReader();
if (rd.HasRows == true)
{
while (rd.Read())
{
localpersonel p = new localpersonel();
p.personelAdi = rd["personelAdi"].ToString();
lp.Add(p);
}
}
conn.Dispose();
conn.Close();
}
return(lp);
}
public localpersonel spOdayaGorePersonel(string odaAdi)
{
localpersonel lp = new localpersonel();
using (SqlConnection conn = new SqlConnection(conStrig))
{
conn.Open();
SqlCommand cmdd = new SqlCommand("spOdayaGorePersonel", conn);
cmdd.Parameters.Add(new SqlParameter("@odaAdi", odaAdi));
cmdd.CommandTimeout = 600;
cmdd.CommandType = CommandType.StoredProcedure;
SqlDataReader rd = cmdd.ExecuteReader();
if (rd.HasRows == true)
{
rd.Read();
lp.personelAdi = rd["personelAdi"].ToString();
}
conn.Dispose();
conn.Close();
}
return(lp);
}
