public static List <PType> GetAll()
{
using (UyeKayitDbBaglan db = new UyeKayitDbBaglan())
{
return(db.PType.ToList());
}
}
public static List <User> GetAll()
{
using (UyeKayitDbBaglan db = new UyeKayitDbBaglan())
{
return(db.User.ToList());
}
}
public ActionResult Login(FormCollection frm)
{
int Num;
string ID;
string uname = frm.Get("userName");
string pass = frm.Get("password");
using (UyeKayitDbBaglan db = new UyeKayitDbBaglan())
{
Num = db.User.Count(w => w.UName == uname && w.Pass == pass);
ID = db.User.Where(w => w.UName == uname && w.Pass == pass).Select(w => w.UserTypeID).ToString();
}
if (Num > 0)
{
Session["name"] = uname;
Session["ID"] = ID;
return(RedirectToAction("UyeListesi", "Home"));
}
else
{
ViewBag.Mesaj = "Hatalı Bilgiler!";
return(View());
}
}
public static void Add(PType PType)
{
using (UyeKayitDbBaglan db = new UyeKayitDbBaglan())
{
db.PType.Add(PType);
db.SaveChanges();
}
}
public static void Add(User User)
{
using (UyeKayitDbBaglan db = new UyeKayitDbBaglan())
{
db.User.Add(User);
db.SaveChanges();
}
}
public static void Add(Person Person)
{
using (UyeKayitDbBaglan db = new UyeKayitDbBaglan())
{
db.Person.Add(Person);
db.SaveChanges();
}
}
public static List <UserVM> GetAllVM()
{
using (UyeKayitDbBaglan db = new UyeKayitDbBaglan())
{
return(db.User.Select(w => new UserVM
{
UName = w.UName,
Usname = w.Usname,
UserTypeName = w.UserType.UserTypeName,
Pass = w.Pass,
}).ToList());
}
}
public static List <PersonVM> GetAllVM()
{
using (UyeKayitDbBaglan db = new UyeKayitDbBaglan())
{
return(db.Person.Select(w => new PersonVM
{
Pname = w.Pname,
Lastname = w.Lastname,
Phone = w.Phone,
Email = w.Email,
TName = w.PType.TName,
}).ToList());
}
}
