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));
}
}
}
