public IHttpActionResult PostCHITIETPHIEUMUON(CHITIETPHIEUMUON cHITIETPHIEUMUON)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CHITIETPHIEUMUONs.Add(cHITIETPHIEUMUON);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (CHITIETPHIEUMUONExists(cHITIETPHIEUMUON.SoPhieu))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = cHITIETPHIEUMUON.SoPhieu }, cHITIETPHIEUMUON));
}
public void DeleteChitietPhieuMuon(int idSach, int idPhieuMuon)
{
CHITIETPHIEUMUON ct = QLThuVienDC.CHITIETPHIEUMUONs.FirstOrDefault(s => s.MaSach.Equals(idSach) && s.MaPhieuMuon.Equals(idPhieuMuon));
QLThuVienDC.CHITIETPHIEUMUONs.DeleteOnSubmit(ct);
QLThuVienDC.SubmitChanges();
}
public IHttpActionResult PutCHITIETPHIEUMUON(string id, CHITIETPHIEUMUON cHITIETPHIEUMUON)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != cHITIETPHIEUMUON.SoPhieu)
{
return(BadRequest());
}
db.Entry(cHITIETPHIEUMUON).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CHITIETPHIEUMUONExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void AddChiTietPhieuMuon(int idPhieuMuon, int idSach)
{
if (this.QLThuVienDC.Connection.State == System.Data.ConnectionState.Closed)
{
this.QLThuVienDC.Connection.Open();
}
QLThuVienDC.Transaction = QLThuVienDC.Connection.BeginTransaction();
try
{
CHITIETPHIEUMUON e = new CHITIETPHIEUMUON();
e.MaPhieuMuon = idPhieuMuon;
e.MaSach = idSach;
QLThuVienDC.CHITIETPHIEUMUONs.InsertOnSubmit(e);
QLThuVienDC.SubmitChanges();
QLThuVienDC.Transaction.Commit();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
QLThuVienDC.Transaction.Rollback();
}
catch (Exception ex1)
{
MessageBox.Show(ex1.Message);
QLThuVienDC.Transaction.Rollback();
}
}
public ActionResult DeleteConfirmed(int id)
{
CHITIETPHIEUMUON cHITIETPHIEUMUON = db.cHITIETPHIEUMUONs.Find(id);
db.cHITIETPHIEUMUONs.Remove(cHITIETPHIEUMUON);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "sophieumuonid,msdocgia,sophieumuon,mssach,hantra")] CHITIETPHIEUMUON cHITIETPHIEUMUON)
{
if (ModelState.IsValid)
{
db.Entry(cHITIETPHIEUMUON).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cHITIETPHIEUMUON));
}
public void UpdateNgayTraSach(int idPhieuMuon, int idSach, string ngayTra)
{
CHITIETPHIEUMUON e = QLThuVienDC.CHITIETPHIEUMUONs.FirstOrDefault(s =>
s.MaPhieuMuon.Equals(idPhieuMuon) &&
s.MaSach.Equals(idSach)
);
e.NgayTra = DateTime.Parse(ngayTra);
QLThuVienDC.SubmitChanges();
}
public IHttpActionResult GetCHITIETPHIEUMUON(string id)
{
CHITIETPHIEUMUON cHITIETPHIEUMUON = db.CHITIETPHIEUMUONs.Find(id);
if (cHITIETPHIEUMUON == null)
{
return(NotFound());
}
return(Ok(cHITIETPHIEUMUON));
}
public ActionResult Create([Bind(Include = "sophieumuonid,msdocgia,sophieumuon,mssach,hantra")] CHITIETPHIEUMUON cHITIETPHIEUMUON)
{
if (ModelState.IsValid)
{
db.cHITIETPHIEUMUONs.Add(cHITIETPHIEUMUON);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cHITIETPHIEUMUON));
}
public ActionResult Delete(int id)
{
CHITIETPHIEUMUON ctpm = db.CHITIETPHIEUMUONs.SingleOrDefault(n => n.SoPhieuMuon == id);
//if (ctpm == null)
//{
// Response.StatusCode = 404;
// return null;
//}
return(View(ctpm));
}
public IHttpActionResult PostCHITIETPHIEUMUON(CHITIETPHIEUMUON cHITIETPHIEUMUON)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CHITIETPHIEUMUONs.Add(cHITIETPHIEUMUON);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = cHITIETPHIEUMUON.SoPhieuMuon }, cHITIETPHIEUMUON));
}
public ActionResult XacNhanXoa(int id)
{
CHITIETPHIEUMUON ctpm = db.CHITIETPHIEUMUONs.SingleOrDefault(n => n.SoPhieuMuon == id);
//if (ctpm == null)
//{
// Response.StatusCode = 404;
// return null;
//}
HttpResponseMessage response = GlobalVariables.WebApiClient.DeleteAsync("CHITIETPHIEUMUON/" + id.ToString()).Result;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult DeleteCHITIETPHIEUMUON(string id)
{
CHITIETPHIEUMUON cHITIETPHIEUMUON = db.CHITIETPHIEUMUONs.Find(id);
if (cHITIETPHIEUMUON == null)
{
return(NotFound());
}
db.CHITIETPHIEUMUONs.Remove(cHITIETPHIEUMUON);
db.SaveChanges();
return(Ok(cHITIETPHIEUMUON));
}
// GET: CHITIETPHIEUMUONs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CHITIETPHIEUMUON cHITIETPHIEUMUON = db.cHITIETPHIEUMUONs.Find(id);
if (cHITIETPHIEUMUON == null)
{
return(HttpNotFound());
}
return(View(cHITIETPHIEUMUON));
}
