void LoadThongTin()
{
ChiTietMuonTra temp = MTBLL.LayThongTinChiTiet(MaMuonTra);
lbMaMuonTra.Text = temp.MaMuonTra + "";
lbNgayMuon.Text = temp.NgayMuon.ToString("dd/MM/yyyy");
txbHanMuon.Text = temp.HanMuon.ToString("dd/MM/yyyy");
lbTinhTrang.Text = temp.TinhTrang;
if (temp.NgayQuaHan < 0)
{
lbNgayQuaHan.Text = "Chưa quá hạn";
}
else
{
lbNgayQuaHan.Text = temp.NgayQuaHan + " ngày";
}
lbMaNV.Text = temp.MaNV + "";
lbMaDG.Text = temp.MaDocGia + "";
lbTenDG.Text = temp.TenDocGia;
lbDonVi.Text = temp.DonVi;
lbSoCuon.Text = temp.SoCuonDangMuon + "";
txbMaSach.Text = temp.MaSach;
lbTenSach.Text = temp.TenSach;
lbTap.Text = temp.Tap + "";
lbLanTB.Text = temp.LanTB + "";
}
public ChiTietMuonTra LayCTMT(string Ma)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAQUATRINHTRASACH, SqlDbType.Int),
new SqlParameter(PARM_MASACH, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_TINHTRANG, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_MASOCABIET, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_MUONHAYTRA, SqlDbType.Bit)
};
parm[0].Value = Ma;
SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblChiTietMuonTra_Lay1", parm);
ChiTietMuonTra CTMT = new ChiTietMuonTra();
if (d.Read())
{
CTMT.MaQuaTrinhTraSach = d[0].ToString();
CTMT.MaSach = d[1].ToString();
CTMT.TinhTrang = d[2].ToString();
CTMT.MaSoCaBiet = d[3].ToString();
CTMT.MuonHayTra = short.Parse(d[4].ToString());
CTMT.SoNgayMuon = int.Parse(d[5].ToString());
}
return(CTMT);
}
protected void grvSachMuon_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow gvr;
try
{
gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
}
catch { return; }
int index = gvr.RowIndex;
DataTable no = (DataTable)ViewState["SachNo"];
DataTable xoa = (DataTable)ViewState["Xoa"];
List <ChiTietMuonTra> tb = (List <ChiTietMuonTra>)ViewState["table"];
if (e.CommandName == "BaoMat" || e.CommandName == "Tra")
{
DataRow r = no.NewRow();
r = no.Rows[index];
short t = 1;
if (e.CommandName == "BaoMat")
{
t = 2;
}
ChiTietMuonTra ct = new ChiTietMuonTra("", r["MaSach"].ToString(), "", r["MaSoCaBiet"].ToString(), t, 0);
xoa.Rows.Add(r.ItemArray);
no.Rows.RemoveAt(index);
tb.Add(ct);
ViewState["SachNo"] = no;
ViewState["Xoa"] = xoa;
ViewState["table"] = tb;
loadsno();
}
}
public async Task <ActionResult> CreateOrUpdate(string userId, string[] array, DateTime ngayTra)
{
var muontra = new MuonTra();
var autoList = AutoCompleteTextHoSos(_taiLieuVanBanService.Gets(p => p.TrangThai == true, p => p.OrderBy(x => x.Ten)).ToList());
var users = await _userService.GetAllAsync();
var muonTras = new List <MuonTra>();
var model = Users(users, muonTras);
muontra.UserId = model.FirstOrDefault(m => m.UserName == userId).Id;
muontra.VanThu = User.Identity.GetUserName();
muontra.NgayMuon = DateTime.Now;
muontra.NgayKetThuc = ngayTra;
muontra.TinhTrang = EnumTinhTrang.DangMuon;
_muonTraService.Insert(muontra);
for (int i = 0; i < array.Length; i++)
{
var chitietmuontra = new ChiTietMuonTra();
var b = array[i];
var a = autoList.FirstOrDefault(p => p.Text == b).Id;
chitietmuontra.TaiLieuVanBanId = a;
chitietmuontra.MuonTraID = muontra.Id;
_chiTietMuonTraService.Insert(chitietmuontra);
var chiTietMuonTras = _chiTietMuonTraService.GetAll();
muontra.SoLuong = chiTietMuonTras.Count(m => m.MuonTraID == muontra.Id);
_muonTraService.Update(muontra);
var vanBan = _taiLieuVanBanService.Get(m => m.Id == a);
vanBan.TinhTrang = EnumTinhTrang.DangMuon;
_taiLieuVanBanService.Update(vanBan);
}
TempData["AlertMessage"] = "Tạo Mới Thành Công";
return(RedirectToAction("Index"));
}
public ChiTietMuonTra LayThongTinMuonTra(int MaMuonTra)
{
ChiTietMuonTra kq = new ChiTietMuonTra();
OpenConnection();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from dbo.ThongTinChiTietMuonTra(@mamuontra)";
command.Connection = conn;
command.Parameters.Add("@mamuontra", SqlDbType.Int).Value = MaMuonTra;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
kq.MaMuonTra = reader.GetInt32(0);
kq.MaSach = reader.GetString(1);
kq.TenSach = reader.GetString(2);
kq.Tap = reader.GetInt32(3);
kq.LanTB = reader.GetInt32(4);
kq.NgayMuon = reader.GetDateTime(5);
kq.HanMuon = reader.GetDateTime(6);
int datra = reader.GetInt32(7);
if (!reader.IsDBNull(9))
{
datra = reader.GetInt32(7);
kq.NgayQuaHan = reader.GetInt32(9);
if (kq.NgayQuaHan < 0)
{
kq.NgayQuaHan = 0;
}
if (datra == 0)
{
kq.TinhTrang = "Chưa trả";
}
else
{
kq.TinhTrang = "Đã trả";
}
}
else
{
kq.TinhTrang = "Chưa trả";
kq.NgayQuaHan = 0;
}
kq.MaNV = reader.GetInt32(8);
kq.MaDocGia = reader.GetInt32(10);
kq.TenDocGia = reader.GetString(11);
kq.DonVi = reader.GetString(12);
kq.SoCuonDangMuon = reader.GetInt32(13);
}
reader.Close();
return(kq);
}
public void GiveBackOneOrTwo(List <ChiTietMuonTraViewModel> chiTietMuons)
{
if (chiTietMuons.Count() <= 0)
{
return;
}
string muontraId = "";
var muontraNew = new MuonTra
{
Id = Guid.NewGuid().ToString(),
VanThu = User.Identity.GetUserName(),
};
var chiTietMuonTras = new List <ChiTietMuonTra>();
foreach (var item in chiTietMuons)
{
var ctmt = _chiTietMuonTraService.GetById(item.Id);
muontraId = item.MuonTraId;
if (item.Checkbox)
{
ctmt.TrangThai = false;
UpdateVanBan(ctmt.TaiLieuVanBanId);
var chtmtNew = new ChiTietMuonTra
{
Id = Guid.NewGuid().ToString(),
MuonTraID = muontraNew.Id,
TaiLieuVanBanId = item.TaiLieuVanBanId,
NgayTao = DateTime.Now,
TrangThai = true
};
chiTietMuonTras.Add(chtmtNew);
}
}
var muonTraOld = _muonTraService.GetById(muontraId);
_muonTraService.Update(muonTraOld);
muontraNew.UserId = muonTraOld.UserId;
muontraNew.NgayMuon = muonTraOld.NgayMuon;
muontraNew.NgayKetThuc = muonTraOld.NgayKetThuc;
muontraNew.SoLuong = chiTietMuons.Count(m => m.Checkbox == true);
_muonTraService.Insert(muontraNew);
_chiTietMuonTraService.Insert(chiTietMuonTras);
UpdateMuonTra(muontraNew.Id);
}
public List <ChiTietMuonTra> DSCTMT()
{
SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblChiTietMuonTra_LayDS", null);
List <ChiTietMuonTra> mylist = new List <ChiTietMuonTra>();
while (d.Read())
{
ChiTietMuonTra CTMT = new ChiTietMuonTra();
CTMT.MaQuaTrinhTraSach = d[0].ToString();
CTMT.MaSach = d[1].ToString();
CTMT.TinhTrang = d[2].ToString();
CTMT.MaSoCaBiet = d[3].ToString();
CTMT.MuonHayTra = short.Parse(d[4].ToString());
CTMT.SoNgayMuon = int.Parse(d[5].ToString());
mylist.Add(CTMT);
}
d.Dispose();
return(mylist);
}
public int Sua(ChiTietMuonTra CTMT)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAQUATRINHTRASACH, SqlDbType.Int),
new SqlParameter(PARM_MASACH, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_TINHTRANG, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_MASOCABIET, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_MUONHAYTRA, SqlDbType.Bit),
new SqlParameter(PARM_SONGAYMUON, SqlDbType.Int)
};
parm[0].Value = CTMT.MaQuaTrinhTraSach;
parm[1].Value = CTMT.MaSach;
parm[2].Value = CTMT.TinhTrang;
parm[3].Value = CTMT.MaSoCaBiet;
parm[4].Value = CTMT.MuonHayTra;
parm[5].Value = CTMT.SoNgayMuon;
return(DALHelper.ExecuteNonQuery(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblChiTietMuonTra_Sua", parm));
}
public int Sua(ChiTietMuonTra ctmt)
{
return(ctmtdal.Sua(ctmt));
}
public int Them(ChiTietMuonTra ctmt)
{
return(ctmtdal.Them(ctmt));
}
