public bool Return(borrowbook SachMuon, bookDTO book, ReaderDTO reader) { string query2 = string.Empty; query2 += "IF NOT EXISTS(SELECT TOP 1 MaThe FROM THEDOCGIA WHERE MaThe= @MaThe) " + Environment.NewLine; query2 += "INSERT INTO MUONSACH (MaThe, MaSach) " + Environment.NewLine; query2 += "VALUES (@MaThe, @MaSach) "; query2 += "else " + Environment.NewLine; query2 += "begin " + Environment.NewLine; query2 += "DECLARE @dk INT " + Environment.NewLine; query2 += "DECLARE cursorProduct CURSOR FOR " + Environment.NewLine; query2 += "select DaMuon from SACH where MaSach = @MaSach " + Environment.NewLine; query2 += "Open cursorProduct FETCH NEXT FROM cursorProduct INTO @dk " + Environment.NewLine; query2 += "if @dk = 1 " + Environment.NewLine; query2 += "begin" + Environment.NewLine; query2 += "update SACH set DaMuon = 0 where MaSach = @MaSach " + Environment.NewLine; query2 += "UPDATE MUONSACH SET "; query2 += "NgayTraThucTe = @NgayTraThucTe "; query2 += "WHERE MaThe=@MaThe and MaSach = @MaSach " + Environment.NewLine; query2 += "end " + Environment.NewLine; query2 += "else " + Environment.NewLine; query2 += "INSERT INTO MUONSACH (MaThe, MaSach, NgayTraThucTe,MaMuonSach) " + Environment.NewLine; query2 += "VALUES (@MaThe, @MaSach, @NgayTraThucTe,@MaMuonSach) "; query2 += "end " + Environment.NewLine; using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;")) //Init connection to host { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query2; cmd.Parameters.AddWithValue("@MaSach", book.MaSach); cmd.Parameters.AddWithValue("@MaThe", reader.IdReader); cmd.Parameters.AddWithValue("@MaMuonSach", SachMuon.Idborrowbook); cmd.Parameters.AddWithValue("@NgayTraThucTe", SachMuon.NgayTraSachThuc); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public bool Tra(borrowbook SachMuon, bookDTO book, ReaderDTO reader) { bool re = br.Return(SachMuon, book, reader); return(re); }
public bool add(borrowbook SachMuon, bookDTO book, ReaderDTO reader) { bool re = br.Add(SachMuon, book, reader); return(re); }