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