public JsonResult thongtinsach(int madl, int masach)
{
SACHDAILIModel sach = new SACHDAILIModel();
var list = laysach_tuphieuxuat_daili_damua(madl);
sach = (from l in list
where l.MASACH == masach
select l).SingleOrDefault();
return(Json(sach, JsonRequestBehavior.AllowGet));
}
public List <SACHDAILIModel> laysach_tuphieuxuat_daili_damua(int madl)
{
SACHDAILIModel model = new SACHDAILIModel();
model.SOLUONG = 0;
List <SACHDAILIModel> ds_sach_sachconlai = null;
object madailimua = new SqlParameter("@MADL", madl);
object madailitra = new SqlParameter("@MADL", madl);
List <SACHDAILIModel> ds_sach_daili_damua = db.Database.SqlQuery <SACHDAILIModel>("splaydanhsachdamuacuamotdaili @MADL", madailimua).ToList();
List <SACHDAILIModel> ds_sach_daili_datra = db.Database.SqlQuery <SACHDAILIModel>("splaydanhsachsachdatracuamotdaili @MADL", madailitra).ToList();
ds_sach_sachconlai = (from mua in ds_sach_daili_damua
join tra in ds_sach_daili_datra
on mua.MASACH equals tra.MASACH into leftjoin
from l in leftjoin.DefaultIfEmpty(model)
select new SACHDAILIModel()
{
MASACH = mua.MASACH,
TENSACH = mua.TENSACH,
GIABAN = mua.GIABAN,
SOLUONG = mua.SOLUONG - l.SOLUONG //
}).ToList();
return(ds_sach_sachconlai);
}