public Tuple <string, string, long> bilgigetir(string dısardanemail)
{
using (var ctx = new KargaASP())
{
//Get student name of string type
string ad = ctx.Database.SqlQuery <string>("Select ad from Kullanicis where email=@id", new SqlParameter("@id", dısardanemail)).FirstOrDefault();
string soyad = ctx.Database.SqlQuery <string>("Select soyad from Kullanicis where email=@id", new SqlParameter("@id", dısardanemail)).FirstOrDefault();
long tel = 0123456789; //Convert.ToInt64(ctx.Database.SqlQuery<string>("Select tel from Kullanicis where email=@id", new SqlParameter("@id", dısardanemail)).FirstOrDefault());
return(Tuple.Create(ad, soyad, tel));
}
}
public string sifremiUnuttum(string email)
{
using (var ctx = new KargaASP())
{
string studentName = ctx.Database.SqlQuery <string>("Select ad from Kullanicis where email=@id", new SqlParameter("@id", email)).FirstOrDefault();
if (studentName == null)
{
return("Kayıtlı değilsiniz");
}
else
{
return(studentName);
}
}
}
public string giris(string email, string sifre)
{
using (var ctx = new KargaASP())
{
//Get student name of string type
string studentName = ctx.Database.SqlQuery <string>("Select ad from Kullanicis where email=@id", new SqlParameter("@id", email)).FirstOrDefault();
if (studentName == null)
{
return("mailiniz sistemde yok");
}
string mailsifreuygun = ctx.Database.SqlQuery <string>("select ad from Kullanicis where email=@mail and sifre=@sifre ", new SqlParameter("@mail", email), new SqlParameter("@sifre", sifre)).FirstOrDefault();
if (mailsifreuygun == null)
{
return("sifre hatali");
}
giris_durumu = 1;
gorunmezyap(sidenavsag);
mevut_kullanıcı_mail = mailsifreuygun;
return("Giriş işlemi başarılı");
}
return("E-mail veya şifre yanlış");
}