public JsonResult ShowSo(int id)
{
HeThongSoViewModels hs = new HeThongSoViewModels();
hs.ManHinhID = id;
var xp = Mapper.Map <HeThongSoViewModels, HeThongSo>(hs);
HeThongSo heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID && !x.Goi).OrderBy(x => x.STT).FirstOrDefault();
if (heThongSo == null)
{
heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID).OrderByDescending(x => x.STT).FirstOrDefault();
}
else
{
heThongSo.Goi = true;
db.Entry(heThongSo).State = EntityState.Modified;
db.SaveChanges();
heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID && !x.Goi).OrderBy(x => x.STT).FirstOrDefault();
}
if (heThongSo == null)
{
heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID).OrderByDescending(x => x.STT).FirstOrDefault();
}
return(Json(heThongSo, JsonRequestBehavior.AllowGet));
}
public async Task <IHttpActionResult> PutHeThongSo(int id, HeThongSo heThongSo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != heThongSo.ID)
{
return(BadRequest());
}
db.Entry(heThongSo).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!HeThongSoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
HeThongSo heThongSo = db.HeThongSos.Find(id);
db.HeThongSos.Remove(heThongSo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public HeThongSo GetAllStocks(int id)
{
HeThongSoViewModels hs = new HeThongSoViewModels();
hs.ManHinhID = id;
var xp = Mapper.Map <HeThongSoViewModels, HeThongSo>(hs);
HeThongSo heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID && !x.Goi).OrderBy(x => x.STT).FirstOrDefault();
return(heThongSo);
}
public ActionResult Edit([Bind(Include = "ID,STT,Goi,DateCreated,ManHinhID")] HeThongSo heThongSo)
{
ViewBag.ManHinh = db.ManHinhs.ToList();
if (ModelState.IsValid)
{
db.Entry(heThongSo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(heThongSo));
}
public async Task <IHttpActionResult> GetHeThongSo(int id)
{
HeThongSo heThongSo = await db.HeThongSos.FindAsync(id);
if (heThongSo == null)
{
return(NotFound());
}
return(Ok(heThongSo));
}
public async Task <IHttpActionResult> PostHeThongSo(HeThongSo heThongSo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.HeThongSos.Add(heThongSo);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = heThongSo.ID }, heThongSo));
}
// GET: HeThongSoes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HeThongSo heThongSo = db.HeThongSos.Find(id);
if (heThongSo == null)
{
return(HttpNotFound());
}
return(View(heThongSo));
}
// GET: HeThongSoes/Details/5
public ActionResult ViewDetails(int id)
{
HeThongSoViewModels hs = new HeThongSoViewModels();
hs.ManHinhID = id;
var xp = Mapper.Map <HeThongSoViewModels, HeThongSo>(hs);
HeThongSo heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID && !x.Goi).OrderBy(x => x.STT).FirstOrDefault();
if (heThongSo == null)
{
heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID).OrderByDescending(x => x.STT).FirstOrDefault();
}
return(View(heThongSo));
}
public JsonResult Show(int id)
{
HeThongSoViewModels hs = new HeThongSoViewModels();
hs.ManHinhID = id;
var xp = Mapper.Map <HeThongSoViewModels, HeThongSo>(hs);
HeThongSo heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID && !x.Goi).OrderBy(x => x.STT).FirstOrDefault();
if (heThongSo == null)
{
heThongSo = db.HeThongSos.Where(x => x.ManHinhID == xp.ManHinhID).OrderByDescending(x => x.STT).FirstOrDefault();
}
return(Json(heThongSo, JsonRequestBehavior.AllowGet));
}
public async Task <IHttpActionResult> DeleteHeThongSo(int id)
{
HeThongSo heThongSo = await db.HeThongSos.FindAsync(id);
if (heThongSo == null)
{
return(NotFound());
}
db.HeThongSos.Remove(heThongSo);
await db.SaveChangesAsync();
return(Ok(heThongSo));
}
// GET: HeThongSoes/Edit/5
public ActionResult Edit(int?id)
{
ViewBag.ManHinh = db.ManHinhs.ToList();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HeThongSo heThongSo = db.HeThongSos.Find(id);
if (heThongSo == null)
{
return(HttpNotFound());
}
return(View(heThongSo));
}
public ActionResult Create([Bind(Include = "ID,STT,Goi,DateCreated,ManHinhID")] HeThongSo heThongSo)
{
ViewBag.ManHinh = db.ManHinhs.ToList();
if (ModelState.IsValid)
{
int lastid = db.HeThongSos.Where(x => x.ManHinhID == heThongSo.ManHinhID).Count();
lastid = lastid + 1;
heThongSo.STT = lastid;
heThongSo.DateCreated = DateTime.Now;
heThongSo.Timers = DateTime.Now;
heThongSo.STTConfirmed = true;
db.HeThongSos.Add(heThongSo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(heThongSo));
}
