//update method public int updateRadioStation(int id, radio_station radio_station) { try { radio_station.mcs_last_modified_date = DateTime.Now; radio_station.mcs_last_modified_by = HttpContext.Current.User.Identity.Name; return(RadioStationsService.updateRadioStationDB(id, radio_station)); } catch (Exception) { throw; } }
public ActionResult Delete(int id, radio_station radio_station) { try { if (ModelState.IsValid) { RadioStationsControllerManager.deleteRadioStation(id, radio_station); } return(RedirectToAction("Index")); } catch (Exception) { return(RedirectToAction("Error", "Home", new { error = "POST/RadioStations/Delete/int" })); } }
//select method public radio_station getRadioStationDB(int id) { radio_station radioStation = null; try { radioStation = db.radio_station.Where(r => r.mcs_id == id && r.mcs_status == 1).FirstOrDefault(); if (radioStation == null) { radioStation = new radio_station(); } } catch (Exception) { throw; } return(radioStation); }
public ActionResult Edit(int id, radio_station radio_station) { try { int flag = RadioStationsControllerManager.updateRadioStation(id, radio_station); if (flag == 1) { return(RedirectToAction("Index")); } else { return(View()); } } catch (Exception) { return(RedirectToAction("Error", "Home", new { error = "POST/RadioStations/Edit/int" })); } }
//insert method public int saveRadioStationDB(radio_station radio_station) { int flag = 0; try { var result = db.radio_station.Where(r => r.mcs_status == 1 && r.mcs_callsign.Equals(radio_station.mcs_callsign)).FirstOrDefault(); if (result == null) { db.radio_station.Add(radio_station); db.SaveChanges(); flag = 1; } } catch (Exception) { throw; } return(flag); }
//delete method public int deleteRadioStationDB(int id, radio_station radio_station) { int flag = 0; try { var result = db.radio_station.Where(r => r.mcs_id == id && r.mcs_status == 1).FirstOrDefault(); if (result != null) { db.Entry(result).State = EntityState.Detached; db.Entry(radio_station).State = EntityState.Modified; db.SaveChanges(); flag = 1; } } catch (Exception) { throw; } return(flag); }
public ActionResult Create(radio_station radio_station) { try { if (ModelState.IsValid) { int flag = RadioStationsControllerManager.saveRadioStation(radio_station); if (flag == 1) { return(RedirectToAction("Index")); } else { TempData["mcs_callsign"] = "This MCS Center Callsign is already taken"; } } return(View()); } catch (Exception) { return(RedirectToAction("Error", "Home", new { error = "POST/RadioStations/Create" })); } }