public IHttpActionResult PostSTATION(STATION sTATION) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.STATIONs.Add(sTATION); try { db.SaveChanges(); } catch (DbUpdateException) { if (STATIONExists(sTATION.STATION_ID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = sTATION.STATION_ID }, sTATION)); }
public IHttpActionResult PutSTATION(decimal id, STATION sTATION) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != sTATION.STATION_ID) { return(BadRequest()); } db.Entry(sTATION).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!STATIONExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.Accepted)); }
public ActionResult DeleteConfirmed(decimal id) { STATION sTATION = db.STATIONs.Find(id); db.STATIONs.Remove(sTATION); db.SaveChanges(); return(RedirectToAction("Index")); }
public static STATION GetSTATIONByID(int id) { STATION sTATION = new STATION(); SqlSTATIONProvider sqlSTATIONProvider = new SqlSTATIONProvider(); sTATION = sqlSTATIONProvider.GetSTATIONByID(id); return(sTATION); }
public ActionResult Edit([Bind(Include = "STATIONID,STATIONNAME,PLATFORMS")] STATION sTATION) { if (ModelState.IsValid) { db.Entry(sTATION).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sTATION)); }
public IHttpActionResult GetSTATION(decimal id) { STATION sTATION = db.STATIONs.Find(id); if (sTATION == null) { return(NotFound()); } return(Ok(sTATION)); }
public ActionResult Create([Bind(Include = "STATIONID,STATIONNAME,PLATFORMS")] STATION sTATION) { if (ModelState.IsValid) { db.STATIONs.Add(sTATION); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sTATION)); }
public Station StationToObject(STATION item) { Station newStation = new Station() { IdStation = item.IdStation, NameStation = item.NameStation, CodTypeStation = TypeStationToObject(item.TYPESTATION), CodZone = ZoneToObject(item.ZONE) }; return(newStation); }
public STATION StationToEntity(Station item) { STATION newStation = new STATION() { IdStation = item.IdStation, NameStation = item.NameStation, AbbreviationStation = null, Status = item.status, TYPESTATION = TypeStation(item.CodTypeStation), ZONE = ZoneToEntity(item.CodZone) }; return(newStation); }
public IHttpActionResult DeleteSTATION(decimal id) { STATION sTATION = db.STATIONs.Find(id); if (sTATION == null) { return(NotFound()); } db.STATIONs.Remove(sTATION); db.SaveChanges(); return(Ok(sTATION)); }
// GET: Stations/Edit/5 public ActionResult Edit(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } STATION sTATION = db.STATIONs.Find(id); if (sTATION == null) { return(HttpNotFound()); } return(View(sTATION)); }
public int InsertSTATION(STATION sTATION) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertSTATION", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@STATIONID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@STATIONNAME", SqlDbType.VarChar).Value = sTATION.STATIONNAME; cmd.Parameters.Add("@STATIONLOCATION", SqlDbType.VarChar).Value = sTATION.STATIONLOCATION; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@STATIONID"].Value); } }
public bool UpdateSTATION(STATION sTATION) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateSTATION", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@STATIONID", SqlDbType.Int).Value = sTATION.STATIONID; cmd.Parameters.Add("@STATIONNAME", SqlDbType.VarChar).Value = sTATION.STATIONNAME; cmd.Parameters.Add("@STATIONLOCATION", SqlDbType.VarChar).Value = sTATION.STATIONLOCATION; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public STATION GetSTATIONFromReader(IDataReader reader) { try { STATION sTATION = new STATION ( (int)reader["STATIONID"], reader["STATIONNAME"].ToString(), reader["STATIONLOCATION"].ToString() ); return(sTATION); } catch (Exception ex) { return(null); } }
// GET: Stations/Create public ActionResult Create() { STATION newStation = new STATION(); var lastStation = db.STATIONs.OrderByDescending(x => x.STATIONID).FirstOrDefault(); if (lastStation == null) { newStation.STATIONID = 4001; } else if (lastStation.STATIONID != 0) { newStation.STATIONID = lastStation.STATIONID + 1; } return(View(newStation)); }
public static bool UpdateSTATION(STATION sTATION) { SqlSTATIONProvider sqlSTATIONProvider = new SqlSTATIONProvider(); return(sqlSTATIONProvider.UpdateSTATION(sTATION)); }
public static int InsertSTATION(STATION sTATION) { SqlSTATIONProvider sqlSTATIONProvider = new SqlSTATIONProvider(); return(sqlSTATIONProvider.InsertSTATION(sTATION)); }