public ActionResult Rezervation() { FillTable(); using (TenisKortuUygulamaEntities Entities = new TenisKortuUygulamaEntities()) { if (Convert.ToBoolean(Session["isLogin"]) == true) { int id = Convert.ToInt32(Session["id"].ToString()); var check = Entities.Users.FirstOrDefault(x => x.id == id); mymodel.users = Entities.Users.FirstOrDefault(x => x.id == id); mymodel.hours = Entities.Hours.ToList(); mymodel.fields = Entities.Fields.ToList(); return(View(mymodel)); //asdaaa } else { mymodel.hours = Entities.Hours.ToList(); mymodel.fields = Entities.Fields.ToList(); return(View(mymodel)); } } }
public ActionResult GetProfile(int id) { if (Convert.ToBoolean(Session["isLogin"]) == true) { TenisKortuUygulamaEntities Entities = new TenisKortuUygulamaEntities(); var query = from rezervation in Entities.Rezervation join users in Entities.Users on rezervation.UsersId equals id join hours in Entities.Hours on rezervation.HoursId equals hours.id where users.id == id select new UsersProfile { UsersId = users.id, Name = users.Name, Surname = users.Surname, Phone = users.Phone, FieldsId = rezervation.FieldsId, Hour = hours.Hour }; return(View(query)); } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult Register(Users Users) { if (ModelState.IsValid) { using (TenisKortuUygulamaEntities Entities = new TenisKortuUygulamaEntities()) { var Check = Entities.Users.FirstOrDefault(x => x.Password == Users.Password || x.Phone == Users.Phone); if (Check != null && Check.isMember == true) { ModelState.Clear(); ViewBag.message = "Böyle bir kayıt bulunmaktadır."; } else if (Check != null && Check.isMember == false && Check.Password == null) { Check.isMember = true; Check.Name = Users.Name; Check.Surname = Users.Surname; Check.Password = Users.Password; Entities.SaveChanges(); return(RedirectToAction("Index", "Home")); } else { Users.isMember = true; Entities.Users.Add(Users); Entities.SaveChanges(); return(RedirectToAction("Index", "Home")); } } } return(View()); }
public void FillTable() { //ekrana bir adet tablo basılacak ve bu tabloda dolu olan günler ve saaatler gözükecek using ( TenisKortuUygulamaEntities Entities = new TenisKortuUygulamaEntities()) { Entities.Configuration.LazyLoadingEnabled = false; var Rezervations = Entities.Rezervation.Include("Hours").Where(x => x.IsComplated == false).OrderBy(s => s.Date).ToList(); ViewBag.rezervation = Rezervations; } }
public JsonResult AjaxQueue(string Phone, string Hour, string Field, string Date, string Name, string Surname) { try { using (TenisKortuUygulamaEntities Entities = new TenisKortuUygulamaEntities()) { Queue queue = new Queue(); DateTime date = new DateTime(); date = Convert.ToDateTime(Date); Users users = new Users(); var check = Entities.Users.FirstOrDefault(x => x.Phone == Phone); if (check == null) //Daha önce hiç rezervasyon yaptırmamışsa { users.Name = Name; users.Surname = Surname; //Users tablosuna kayıt kısmı users.Phone = Phone; users.isMember = false; Entities.Users.Add(users); Entities.SaveChanges(); queue.HoursId = Convert.ToInt32(Hour); queue.UsersId = users.id; queue.FieldsId = Convert.ToInt32(Field); queue.QueueDate = date; queue.IsComplated = false; Entities.Queue.Add(queue); Entities.SaveChanges(); TempData["msg"] = "<script>document.getElementById('isFinish').innerHTML='Sıraya girdiniz.';</script>"; } else { queue.HoursId = Convert.ToInt32(Hour);; queue.UsersId = check.id; queue.FieldsId = Convert.ToInt32(Field); queue.QueueDate = date; queue.IsComplated = false; Entities.Queue.Add(queue); Entities.SaveChanges(); TempData["msg"] = "<script>document.getElementById('isFinish').innerHTML='Sıraya girdiniz.';</script>"; } return(Json(new { Status = "OK", Message = "İşlem Başarılı!" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { Status = "Error", Message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult BillsQuery(string txPhone) { try { using (TenisKortuUygulamaEntities entities = new TenisKortuUygulamaEntities()) { entities.Configuration.LazyLoadingEnabled = false; var users = entities.Users.FirstOrDefault(x => x.Phone == txPhone); var rezervation = entities.Rezervation.Include("Bills").Where(x => x.UsersId == users.id && x.IsComplated == false).ToList(); ViewBag.Bills = rezervation; return(View()); } } catch (Exception ex) { return(View()); } }
[HttpPost] //post post public ActionResult Login(string Name, string Password) { using (TenisKortuUygulamaEntities Entities = new TenisKortuUygulamaEntities()) { var Check = Entities.Users.FirstOrDefault(x => x.Name == Name && x.Password == Password && x.isMember == true); if (Check != null) { Session["isLogin"] = true; Session["Name"] = Check.Name.ToString(); Session["Password"] = Check.Password.ToString(); Session["id"] = Check.id.ToString(); return(RedirectToAction("Index", "Home")); } else { Session["isLogin"] = false; Session["Error"] = "Kullanici adi veya şifresi hatalı"; TempData["loginError"] = "<script>document.getElementById('isFinish').innerHTML='Kullanici adi veya sifreniz yanlis.';</script>"; } return(View()); } }
public ActionResult Bills() { using (TenisKortuUygulamaEntities Entities = new TenisKortuUygulamaEntities()) { Entities.Configuration.LazyLoadingEnabled = false; var Bills = Entities.Bills.Include("Hours").Include("Rezervation1").Include("Fields").Where(x => x.isPaid == false).ToList(); foreach (var item in Bills) { BillModel bm = new BillModel(); bm.Date = Convert.ToDateTime(item.Rezervation1.Date); bm.Amounth = item.Amount; bm.FieldId = item.Rezervation1.FieldsId; bm.Hour = item.Rezervation1.Hours.Hour; bm.Id = item.Rezervation1.id; mymodel.BillLister.Add(bm); } ViewBag.Bills = Bills; return(View(mymodel)); } }
public JsonResult Rezervation(string Name, string Surname, string Phone, string Date, int Hour, int Field) { //mevcut tarih saatde rezervasyon varmı kontrol et! //yoksa rezervasyon basarılı //varsa sıraya al using (TenisKortuUygulamaEntities Entities = new TenisKortuUygulamaEntities()) { try { FillTable(); Rezervation rezervation = new Rezervation(); Users users = new Users(); DateTime date = new DateTime(); date = Convert.ToDateTime(Date); Convert.ToDateTime(Date); var IsRezervationAvaible = Entities.Rezervation.FirstOrDefault(x => x.HoursId == Hour && x.Date == date); if (IsRezervationAvaible != null) { TempData["msg"] = "<script>document.getElementById('BtnQueue').style.visibility = 'visible';document.getElementById('isFinish').innerHTML = 'Seçmeye çalıştığınız tarih ve saat doludur!'; </script>"; return(Json(new { Status = "Warning", Message = "İlgili tarih ve kort uygun değildir lütfen başka bir seçim yapınız yada sıraya giriniz!" }, JsonRequestBehavior.AllowGet)); } var check = Entities.Users.FirstOrDefault(x => x.Phone == Phone); if (check == null) //Daha önce hiç rezervasyon yaptırmamışsa { users.Name = Name; users.Surname = Surname; //Users tablosuna kayıt kısmı users.Phone = Phone; users.isMember = false; Entities.Users.Add(users); //Şimdilik veri tabanına kayıt yaptırmadım Entities.SaveChanges(); rezervation.HoursId = Hour; rezervation.UsersId = users.id; //Rezervasyon tablosuna kayıt kısmı rezervation.FieldsId = Field; rezervation.Date = Convert.ToDateTime(Date); rezervation.IsComplated = false; Entities.Rezervation.Add(rezervation); Entities.SaveChanges(); TempData["msg"] = "<script>document.getElementById('isFinish').innerHTML='Kaydiniz basarilidir.';</script>"; } else { rezervation.HoursId = Hour; rezervation.UsersId = check.id; //Rezervasyon tablosuna kayıt kısmı rezervation.FieldsId = Field; rezervation.Date = Convert.ToDateTime(Date); rezervation.IsComplated = false; Entities.Rezervation.Add(rezervation); Entities.SaveChanges(); TempData["msg"] = "<script>document.getElementById('isFinish').innerHTML='Kaydiniz basarilidir.';</script>"; } return(Json(new { Status = "OK", Message = "İşlem Başarılı!" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { Status = "Error", Message = ex.Message }, JsonRequestBehavior.AllowGet)); } } }