public IHttpActionResult PutMUONSACH(string id, MUONSACH mUONSACH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != mUONSACH.SoPhieu)
{
return(BadRequest());
}
db.Entry(mUONSACH).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!MUONSACHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostMUONSACH(MUONSACH mUONSACH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.MUONSACHes.Add(mUONSACH);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (MUONSACHExists(mUONSACH.SoPhieu))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = mUONSACH.SoPhieu }, mUONSACH));
}
//lay ma phieu muon lon nhat
public string GetMaPMMax()
{
try{
string mapm = ""; int maso;
SQLDataContext.SQLData.sp_getMaPMMax(ref mapm);
maso = int.Parse(mapm.Substring(2)) + 1;
if (maso.ToString().Length == 1)
{
mapm = "PM000" + maso.ToString();
}
else if (maso.ToString().Length == 2)
{
mapm = "PM00" + maso.ToString();
}
else if (maso.ToString().Length == 3)
{
mapm = "PM0" + maso.ToString();
}
else
{
mapm = "PM" + maso.ToString();
}
SQLDataContext.CreateDataContext();
muonsach = new MUONSACH();
muonsach.MAPHIEUMUON = mapm;
SQLDataContext.SQLData.MUONSACHes.InsertOnSubmit(muonsach);
SQLDataContext.SQLData.SubmitChanges();
return(mapm);
}
catch {
return("demo");
}
}
public ActionResult DeleteConfirmed(int id)
{
MUONSACH mUONSACH = db.mUONSACHes.Find(id);
db.mUONSACHes.Remove(mUONSACH);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "sophieumuonid,sophieumuon,msdocgia,msnhanvien,ngaymuon,ngaytra")] MUONSACH mUONSACH)
{
if (ModelState.IsValid)
{
db.Entry(mUONSACH).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mUONSACH));
}
public IHttpActionResult GetMUONSACH(string id)
{
MUONSACH mUONSACH = db.MUONSACHes.Find(id);
if (mUONSACH == null)
{
return(NotFound());
}
return(Ok(mUONSACH));
}
public ActionResult Create([Bind(Include = "sophieumuonid,sophieumuon,msdocgia,msnhanvien,ngaymuon,ngaytra")] MUONSACH mUONSACH)
{
if (ModelState.IsValid)
{
db.mUONSACHes.Add(mUONSACH);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mUONSACH));
}
//thêm dữ liệu mượn sách
public bool InsertDuLieuPhieuMuónach(MUONSACH muonsach)
{
try
{
UpdateDuLieuPhieuMuon(muonsach);
return(true);
}
catch
{
return(false);
}
}
public void DeleteMaPMMax()
{
try
{
muonsach = SQLDataContext.SQLData.MUONSACHes.Single(ms => ms.MASACH == null);
SQLDataContext.SQLData.MUONSACHes.DeleteOnSubmit(muonsach);
SQLDataContext.SQLData.SubmitChanges();
}
catch
{
}
}
//xóa dữ liệu phiếu mượn
public bool DeleteDuLieuPhieuMuon(MUONSACH muonsach)
{
try
{
SQLDataContext.SQLData.sp_DeleteDuLieuPhieuMuon(muonsach.MAPHIEUMUON);
return(true);
}
catch
{
return(false);
}
}
//sửa dữ liệu phiếu mượn
public bool UpdateDuLieuPhieuMuon(MUONSACH muonsach)
{
try
{
SQLDataContext.SQLData.sp_UpdateDuLieuPhieuMuon(muonsach.MAPHIEUMUON, muonsach.MADG, muonsach.MASACH, muonsach.NGAYMUON, muonsach.NGAYTRA, muonsach.GHICHU);
return(true);
}
catch
{
return(false);
}
}
public IHttpActionResult DeleteMUONSACH(string id)
{
MUONSACH mUONSACH = db.MUONSACHes.Find(id);
if (mUONSACH == null)
{
return(NotFound());
}
db.MUONSACHes.Remove(mUONSACH);
db.SaveChanges();
return(Ok(mUONSACH));
}
// GET: MUONSACHes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MUONSACH mUONSACH = db.mUONSACHes.Find(id);
if (mUONSACH == null)
{
return(HttpNotFound());
}
return(View(mUONSACH));
}
//kiểm tra mã phiếu mượn
public bool CheckMaPhieuMuon(MUONSACH muonsach)
{
try
{
int a = SQLDataContext.SQLData.sp_CheckMaPhieuMuon(muonsach.MAPHIEUMUON);
if (a == 1)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
//tìm kiếm phiếu mượn theo đọc giả
public DataTable TimKiemPhieuMuonTheoMaDG(MUONSACH muonsach, DateTime tungay, DateTime denngay)
{
DataTable dt = new DataTable();
dt.Columns.Add("STT", typeof(int));
dt.Columns.Add("MAPHIEUMUON", typeof(string));
dt.Columns.Add("MADG", typeof(int));
dt.Columns.Add("TENDG", typeof(string));
dt.Columns.Add("MASACH", typeof(string));
dt.Columns.Add("TENSACH", typeof(string));
dt.Columns.Add("NGAYMUON", typeof(string));
dt.Columns.Add("NGAYTRA", typeof(string));
dt.Columns.Add("GHICHU", typeof(string));
var phieumuon = SQLDataContext.SQLData.sp_TimKiemPhieuMuonTheoMDG(muonsach.MADG, tungay, denngay);
int c = 1;
foreach (var i in phieumuon)
{
DataRow r = dt.NewRow();
r["STT"] = c++;
r["MAPHIEUMUON"] = i.MAPHIEUMUON;
r["MADG"] = i.MADG;
r["TENDG"] = i.TENDG;
r["MASACH"] = i.MASACH;
r["TENSACH"] = i.TENSACH;
r["NGAYMUON"] = i.NGAYMUON;
r["NGAYTRA"] = i.NGAYTRA;
r["GHICHU"] = i.GHICHU;
dt.Rows.Add(r);
}
if (dt.Rows.Count == 0)
{
return(null);
}
return(dt);
}
