public ActionResult Appoinment()
{
if (Session["firstName"] != "" && Session["lastName"] != "" && Session["number"] != "")
{
kuafor_randevuEntities1 db = new kuafor_randevuEntities1();
List <SelectListItem> services = new List <SelectListItem>();
List <SelectListItem> personel = new List <SelectListItem>();
foreach (var item in db.hizmet_turleri.ToList())
{
services.Add(
new SelectListItem
{
Text = item.hizmet_tur,
Value = item.hizmet_tur
});
}
foreach (var item in db.calisanlar.ToList())
{
personel.Add(
new SelectListItem
{
Text = item.calisan_adi,
Value = item.calisan_adi
});
}
ViewBag.services = services;
ViewBag.personel = personel;
return(View());
}
return(RedirectToAction("Index"));
}
public ActionResult ProcessTimes()
{
kuafor_randevuEntities1 db = new kuafor_randevuEntities1();
var model = db.fiyat_listesi;
return(View(model));
}
public ActionResult List()
{
kuafor_randevuEntities1 db = new kuafor_randevuEntities1();
var model = db.randevu;
return(View(model));
}
public ActionResult GetPriceData()
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
List <fiyat_listesi> fiyatList = db.fiyat_listesi.ToList <fiyat_listesi>();
return(Json(new { data = fiyatList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetPersonnelData()
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
List <calisanlar> calisanlarList = db.calisanlar.ToList <calisanlar>();
return(Json(new { data = calisanlarList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetAppoinmentData()
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
List <randevu> randevuList = db.randevu.ToList <randevu>();
return(Json(new { data = randevuList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Appoinment(string TransDate, string hour, string services, string personel)
{
var isValid = "false";
using (kuafor_randevuEntities1 entity = new kuafor_randevuEntities1())
{
if (entity.randevu.Any(x => x.randevu_tarih == TransDate.Replace("/", ".") + " " + hour))
{
isValid = "true";
kuafor_randevuEntities1 db = new kuafor_randevuEntities1();
List <SelectListItem> _services = new List <SelectListItem>();
List <SelectListItem> _personel = new List <SelectListItem>();
foreach (var item in db.hizmet_turleri.ToList())
{
_services.Add(
new SelectListItem
{
Text = item.hizmet_tur,
Value = item.hizmet_tur
});
}
foreach (var item in db.calisanlar.ToList())
{
_personel.Add(
new SelectListItem
{
Text = item.calisan_adi,
Value = item.calisan_adi
});
}
ViewBag.services = _services;
ViewBag.personel = _personel;
ViewBag.IsValid = "Bu tarih ve saat uygun değil, lütfen tekrar deneyiniz..";
return(View());
}
}
randevu _randevu = new randevu();
_randevu.ad_soyad = Session["firstName"].ToString() + " " + Session["lastName"].ToString();
_randevu.email = Session["email"].ToString();
_randevu.tel = Session["number"].ToString();
_randevu.randevu_tarih = TransDate + " " + hour;
_randevu.hizmet_turu = services;
_randevu.personel = personel;
using (kuafor_randevuEntities1 entities = new kuafor_randevuEntities1())
{
entities.randevu.Add(_randevu);
entities.SaveChanges();
}
return(RedirectToAction("AppoinmentSuccess"));
}
public ActionResult DeletePersonnel(int id)
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
calisanlar icerik = db.calisanlar.Where(x => x.id == id).FirstOrDefault <calisanlar>();
db.calisanlar.Remove(icerik);
db.SaveChanges();
return(Json(new { success = true, message = "Personel Silindi" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteAppoinment(int id)
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
randevu icerik = db.randevu.Where(x => x.id == id).FirstOrDefault <randevu>();
db.randevu.Remove(icerik);
db.SaveChanges();
return(Json(new { success = true, message = "Randevu Kaydı Silindi" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeletePrice(int id)
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
fiyat_listesi icerik = db.fiyat_listesi.Where(x => x.id == id).FirstOrDefault <fiyat_listesi>();
db.fiyat_listesi.Remove(icerik);
db.SaveChanges();
return(Json(new { success = true, message = "Fiyat Kaydı Silindi" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEditPersonnel(int id = 0)
{
if (id == 0)
{
return(View(new calisanlar()));
}
else
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
return(View(db.calisanlar.Where(x => x.id == id).FirstOrDefault <calisanlar>()));
}
}
}
public ActionResult AddOrEditPrice(int id = 0)
{
if (id == 0)
{
return(View(new fiyat_listesi()));
}
else
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
return(View(db.fiyat_listesi.Where(x => x.id == id).FirstOrDefault <fiyat_listesi>()));
}
}
}
public ActionResult AddOrEditAppoinment(int id = 0)
{
if (id == 0)
{
return(View(new randevu()));
}
else
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
return(View(db.randevu.Where(x => x.id == id).FirstOrDefault <randevu>()));
}
}
}
public ActionResult AddOrEditPersonnel(calisanlar calisanlar)
{
using (kuafor_randevuEntities1 db = new kuafor_randevuEntities1())
{
if (calisanlar.id == 0)
{
db.calisanlar.Add(calisanlar);
db.SaveChanges();
return(Json(new { success = true, message = "Kayıt Başarılı" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(calisanlar).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Güncelleme Başarılı" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Index(string username, string password)
{
if (username != "" && password != "")
{
var isValid = "false";
using (kuafor_randevuEntities1 entity = new kuafor_randevuEntities1())
{
if (entity.admin.Any(x => x.kullanici_adi == username && x.sifre == password))
{
Session["user"] = username;
return(RedirectToAction("Appoinments"));
}
else
{
isValid = "true";
ViewBag.IsValid = "Kullanıcı adı veya şifre hatalı!";
return(View());
}
}
}
return(RedirectToAction("Index"));
}
