//InsertTheBusNumber
public List<string> InsertTheBusNumber(int Bus_Selection)
{
MassTransitGuide_EfeEntities db = new MassTransitGuide_EfeEntities();
BusNumbers busNumbers = new BusNumbers();
busNumbers.Bus_Selection = Bus_Selection;
busNumbers.Status = 1;
DateTime now = DateTime.Now;
busNumbers.Date = now.ToString("dd-MM-yy HH:mm:ss");
// plaka ve tablo aynı anda kontrol edilecek
bool check = db.BusNumbers.Any(b => b.Bus_Selection != Bus_Selection);
bool numaraTablodaVarMi = db.BusNumbers.Any(b => b.Bus_Selection == Bus_Selection && b.Status == 1);
error = new List<string>();
if (!numaraTablodaVarMi || check)
{
db.BusNumbers.Add(busNumbers);
try
{
db.SaveChanges();
}
catch (Exception e)
{
e.StackTrace.ToString();
}
error.Add("Otobüs numarası sisteme başarıyla kaydedilmiştir");
}
else
{
error.Add("Bu numara zaten kullanılıyor\n");
}
return error;
}
public JsonResult OtobusNumarasiSil(int Id)
{
MassTransitGuide_EfeEntities db = new MassTransitGuide_EfeEntities();
BusNumbers bus = new BusNumbers();
bus = db.BusNumbers.Where(b => b.Id == Id).First();
if (bus != null)
{
bus.Status = 0;
db.SaveChanges();
}
return(Json(new { islem = 1 }, JsonRequestBehavior.AllowGet));
}
