public IHttpActionResult PutDMTRAM(int id, DMTRAM dMTRAM)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != dMTRAM.ID)
{
return(BadRequest());
}
db.Entry(dMTRAM).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DMTRAMExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult GetTram(string Id)
{
var listTram = new List <DMTRAM>();
var dataListTram = db.DMTUYENCHITIETTRAMs.Where(x => x.IDTUYEN == db.DMTUYENs.FirstOrDefault(y => y.IDTUYEN == Id).MATUYEN).ToList();
var tram = db.DMTRAMs.ToList();
foreach (var item in dataListTram)
{
var listT = new DMTRAM();
listT.MATRAM = item.MATRAM;
listT.TENTRAM = db.DMTRAMs.FirstOrDefault(x => x.MATRAM == item.MATRAM).TENTRAM;
listT.LatLng = db.DMTRAMs.FirstOrDefault(x => x.MATRAM == item.MATRAM).LatLng;
listTram.Add(listT);
}
var dataAll = new AllModel
{
TblDMTUYEN = db.DMTUYENs.FirstOrDefault(x => x.IDTUYEN == Id),
ListDMTUYENCHITIETTRAM = db.DMTUYENCHITIETTRAMs.Where(x => x.IDTUYEN == db.DMTUYENs.FirstOrDefault(y => y.IDTUYEN == Id).MATUYEN).ToList(),
ListDMTRAM = listTram
};
return(Json(new { result = dataAll }));
}
public ActionResult DeleteConfirmed(int id)
{
DMTRAM dMTRAM = db.DMTRAMs.Find(id);
db.DMTRAMs.Remove(dMTRAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(DMTRAM dMTRAM)
{
if (ModelState.IsValid)
{
db.Entry(dMTRAM).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dMTRAM));
}
public IHttpActionResult GetDMTRAM(int id)
{
DMTRAM dMTRAM = db.DMTRAMs.Find(id);
if (dMTRAM == null)
{
return(NotFound());
}
return(Ok(dMTRAM));
}
public IHttpActionResult PostDMTRAM(DMTRAM dMTRAM)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DMTRAMs.Add(dMTRAM);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = dMTRAM.ID }, dMTRAM));
}
// GET: DmTram/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DMTRAM dMTRAM = db.DMTRAMs.Find(id);
db.DMTRAMs.Remove(dMTRAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult DeleteDMTRAM(int id)
{
DMTRAM dMTRAM = db.DMTRAMs.Find(id);
if (dMTRAM == null)
{
return(NotFound());
}
db.DMTRAMs.Remove(dMTRAM);
db.SaveChanges();
return(Ok(dMTRAM));
}
// GET: DmTram/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DMTRAM dMTRAM = db.DMTRAMs.Find(id);
if (dMTRAM == null)
{
return(HttpNotFound());
}
return(View(dMTRAM));
}
public IHttpActionResult PostTuyenXeTram(AllModel model)
{
DMTUYEN account = JsonConvert.DeserializeObject <DMTUYEN>(model.StringJson);
var CreateTuyen = new DMTUYEN();
var idTuye_ = "";
if (account != null)
{
var dataTuyen = db.DMTUYENs.Count(x => x.IDTUYEN == account.IDTUYEN);
if (dataTuyen > 0)
{
//Update
var UpdateTuyen = db.DMTUYENs.Find(account.IDTUYEN);
UpdateTuyen.CAMVE1 = account.CAMVE1;
UpdateTuyen.CAMVE2 = account.CAMVE2;
UpdateTuyen.CAMVE3 = account.CAMVE3;
UpdateTuyen.CAMVE4 = account.CAMVE4;
UpdateTuyen.CAMVE5 = account.CAMVE5;
UpdateTuyen.CAMVE6 = account.CAMVE6;
UpdateTuyen.DIENGIAIVE1 = account.DIENGIAIVE1;
UpdateTuyen.DIENGIAIVE2 = account.DIENGIAIVE2;
UpdateTuyen.DIENGIAIVE3 = account.DIENGIAIVE3;
UpdateTuyen.DIENGIAIVE4 = account.DIENGIAIVE4;
UpdateTuyen.DIENGIAIVE5 = account.DIENGIAIVE5;
UpdateTuyen.DIENGIAIVE6 = account.DIENGIAIVE6;
UpdateTuyen.GIAVE1 = account.GIAVE1;
UpdateTuyen.GIAVE2 = account.GIAVE2;
UpdateTuyen.GIAVE3 = account.GIAVE3;
UpdateTuyen.GIAVE4 = account.GIAVE4;
UpdateTuyen.GIAVE5 = account.GIAVE5;
UpdateTuyen.GIAVE6 = account.GIAVE6;
UpdateTuyen.IDVE1IDHOADON = account.IDVE1IDHOADON;
UpdateTuyen.IDVE2IDHOADON = account.IDVE2IDHOADON;
UpdateTuyen.IDVE3IDHOADON = account.IDVE3IDHOADON;
UpdateTuyen.IDVE4IDHOADON = account.IDVE4IDHOADON;
UpdateTuyen.IDVE5IDHOADON = account.IDVE5IDHOADON;
UpdateTuyen.IDVE6IDHOADON = account.IDVE6IDHOADON;
UpdateTuyen.MATRAMCUOI = account.MATRAMCUOI;
UpdateTuyen.MATRAMDAU = account.MATRAMDAU;
UpdateTuyen.MATRAMGIUA = account.MATRAMGIUA;
UpdateTuyen.MATUYEN = account.MATUYEN;
UpdateTuyen.MUCDO = account.MUCDO;
UpdateTuyen.TENTUYENENG = account.TENTUYENENG;
UpdateTuyen.TENTUYENVN = account.TENTUYENVN;
idTuye_ = account.IDTUYEN;
db.Entry(UpdateTuyen).State = EntityState.Modified;
db.SaveChanges();
}
else
{
var idTuyen = db.DMTUYENs.OrderByDescending(x => x.IDTUYEN).FirstOrDefault();
if (idTuyen != null)
{
idTuye_ = idTuyen.IDTUYEN;
}
else
{
idTuye_ = "0";
}
CreateTuyen.CAMVE1 = account.CAMVE1;
CreateTuyen.CAMVE2 = account.CAMVE2;
CreateTuyen.CAMVE3 = account.CAMVE3;
CreateTuyen.CAMVE4 = account.CAMVE4;
CreateTuyen.CAMVE5 = account.CAMVE5;
CreateTuyen.CAMVE6 = account.CAMVE6;
CreateTuyen.DIENGIAIVE1 = account.DIENGIAIVE1;
CreateTuyen.DIENGIAIVE2 = account.DIENGIAIVE2;
CreateTuyen.DIENGIAIVE3 = account.DIENGIAIVE3;
CreateTuyen.DIENGIAIVE4 = account.DIENGIAIVE4;
CreateTuyen.DIENGIAIVE5 = account.DIENGIAIVE5;
CreateTuyen.DIENGIAIVE6 = account.DIENGIAIVE6;
CreateTuyen.GIAVE1 = account.GIAVE1;
CreateTuyen.GIAVE2 = account.GIAVE2;
CreateTuyen.GIAVE3 = account.GIAVE3;
CreateTuyen.GIAVE4 = account.GIAVE4;
CreateTuyen.GIAVE5 = account.GIAVE5;
CreateTuyen.GIAVE6 = account.GIAVE6;
CreateTuyen.IDVE1IDHOADON = account.IDVE1IDHOADON;
CreateTuyen.IDVE2IDHOADON = account.IDVE2IDHOADON;
CreateTuyen.IDVE3IDHOADON = account.IDVE3IDHOADON;
CreateTuyen.IDVE4IDHOADON = account.IDVE4IDHOADON;
CreateTuyen.IDVE5IDHOADON = account.IDVE5IDHOADON;
CreateTuyen.IDVE6IDHOADON = account.IDVE6IDHOADON;
CreateTuyen.MATRAMCUOI = account.MATRAMCUOI;
CreateTuyen.MATRAMDAU = account.MATRAMDAU;
CreateTuyen.MATRAMGIUA = account.MATRAMGIUA;
CreateTuyen.MATUYEN = account.MATUYEN;
CreateTuyen.MUCDO = account.MUCDO;
CreateTuyen.TENTUYENENG = account.TENTUYENENG;
CreateTuyen.TENTUYENVN = account.TENTUYENVN;
CreateTuyen.THOIGIANTOANTRAM = account.THOIGIANTOANTRAM;
CreateTuyen.TONGTRAM = account.TONGTRAM;
CreateTuyen.IDTUYEN = (int.Parse(idTuye_) + 1).ToString();
db.DMTUYENs.Add(CreateTuyen);
db.SaveChanges();
idTuye_ = CreateTuyen.IDTUYEN;
//Create
}
var Id = db.DMTUYENCHITIETTRAMs.Where(x => x.IDTUYEN == account.MATUYEN);
if (Id.Any())
{
foreach (var itemDetail in Id)
{
var dMTUYENCHITIETTRAM = db.DMTUYENCHITIETTRAMs.Find(itemDetail.ID);
db.DMTUYENCHITIETTRAMs.Remove(dMTUYENCHITIETTRAM);
}
db.SaveChanges();
}
var StringJson1 = model.StringJson1.Split(new string[] { "[||]" }, StringSplitOptions.None);
foreach (var itemJS in StringJson1)
{
var tram = JsonConvert.DeserializeObject <DMTRAM>(itemJS);
if (tram != null)
{
if (tram.ID != 0)
{
var dataTram = db.DMTRAMs.Where(x => x.MATRAM == tram.MATRAM);
if (dataTram.Any())
{
var UpdateTram = db.DMTRAMs.Find(dataTram.FirstOrDefault().ID);
UpdateTram.TENTRAM = tram.TENTRAM;
UpdateTram.FileTram = tram.FileTram;
UpdateTram.MATRAM = tram.MATRAM;
UpdateTram.LatLng = tram.LatLng;
db.Entry(UpdateTram).State = EntityState.Modified;
}
else
{
var CreateTram = new DMTRAM();
CreateTram.TENTRAM = tram.TENTRAM;
CreateTram.FileTram = tram.FileTram;
CreateTram.MATRAM = tram.MATRAM;
CreateTram.LatLng = tram.LatLng;
db.DMTRAMs.Add(CreateTram);
}
}
else
{
var CreateTram = new DMTRAM();
CreateTram.TENTRAM = tram.TENTRAM;
CreateTram.FileTram = tram.FileTram;
CreateTram.MATRAM = tram.MATRAM;
CreateTram.LatLng = tram.LatLng;
db.DMTRAMs.Add(CreateTram);
}
var DetailTuyenTram = new DMTUYENCHITIETTRAM();
DetailTuyenTram.IDTUYEN = account.MATUYEN;
DetailTuyenTram.MATRAM = tram.MATRAM;
db.DMTUYENCHITIETTRAMs.Add(DetailTuyenTram);
}
}
db.SaveChanges();
}
return(CreatedAtRoute("DefaultApi", new { id = model.StringJson }, model));
}
public ActionResult Create(DMTRAM dMTRAM)
{
db.DMTRAMs.Add(dMTRAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
