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